fidt-dw-docs.pages.dev
Open in
urlscan Pro
2606:4700:310c::ac42:2ced
Public Scan
URL:
https://fidt-dw-docs.pages.dev/
Submission: On August 18 via api from US — Scanned from US
Submission: On August 18 via api from US — Scanned from US
Form analysis 1 forms found in the DOM
<form class="fields fields-flush launcher-hide-sidebar ng-pristine ng-valid" ng-class="{visible: filters_visible}" ng-submit="onUpdateSelector()">
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('resource_types')}" data-form-type="resource_types">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('resource_types')" ng-blur="onSelectBlur('resource_types')">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('resource_types')">
<li ng-click="onSelectAll('resource_types', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Models <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Seeds <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Snapshots <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Sources <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Tests <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Analyses <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Exposures <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Metrics <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
</ul>
<div class="field-label">resources</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('packages')}" data-form-type="packages">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('packages')" ng-blur="onSelectBlur('packages')">
<option selected="" disabled="" hidden="" class="ng-binding"> data_warehouse </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('packages')">
<li ng-click="onSelectAll('packages', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.packages -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.packages" ng-click="onItemSelect('packages', item, $event)"> data_warehouse <span ng-show="isSelected('packages', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.packages -->
</ul>
<div class="field-label">packages</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('tags')}" data-form-type="tags">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('tags')" ng-blur="onSelectBlur('tags', $event)">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('tags')">
<li ng-click="onSelectAll('tags', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">cache</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null --><span ng-if="item == null" class="ng-scope">untagged</span><!-- end ngIf: item == null -->
<!-- ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">private</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">public</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
</ul>
<div class="field-label">tags</div>
</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.include" placeholder="...">
<div class="field-label">--select</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.exclude" placeholder="...">
<div class="field-label">--exclude</div>
</label>
<label class="field" style="flex: 0 0 80px">
<input type="submit" id="submit-graph-selection" class="field-input form-control input-dark" ng-class="{'dirty-submit': selectorService.isDirty()}" value="Update Graph">
<div class="field-label text-center" style="width: 100%"></div>
</label>
<label class="field" style="flex: 0 0 80px">
<button type="button" ng-click="closeGraph()" class="field-input form-control input-dark text-center"><svg class="icn icn-md">
<use xlink:href="#icn-close"></use>
</svg>
</button>
</label>
</form>Text Content
icons
LINEAGE GRAPH
All selected
* Select All
* Models
* Seeds
* Snapshots
* Sources
* Tests
* Analyses
* Exposures
* Metrics
resources
data_warehouse
* Select All
* data_warehouse
packages
All selected
* Select All
* cache
* untagged
* private
* public
tags
--select
--exclude
* Overview
* Project
Database
Group
* Sources
* fiinX
* IndexStatistics ByInvestorDaily
* Pr oprieataryDaily
* intrad ay_sector_index
* intrada y_ticker_orders
* fiinpro
* st x_cpa_Ownership
* stx_c pf_Organization
* stx_f sc_BalanceSheet
* s tx_fsc_CashFlow
* stx_fsc_ IncomeStatement
* s tx_mrk_HnxIndex
* s tx_mrk_HnxStock
* st x_mrk_HoseIndex
* st x_mrk_HoseStock
* stx_ mrk_IcbIndustry
* stx _mrk_UpcomIndex
* stx _mrk_UpcomStock
* stx_ mst_IcbIndustry
* stx_rto_R atioIcbIndustry
* stx _rto_RatioIndex
* s tx_rto_RatioTTM
* stx_rt o_RatioTTMDaily
* st x_rto_RatioYear
* stx_rto _RatioYearDaily
* vcsc
* intraday_o hlc_transaction
* vcsc-crawl
* archive _active_trading
* intraday _active_trading
* intraday_ma tch_price_index
* intraday_ma tch_price_stock
* snapshots _active_trading
* stoc ks_index_basket
Exposures
Metrics
Projects
* data_warehouse
* macros
* co lumn_dictionary
* dremio
* m aterializations
* drop_refle ction_if_exists
* materialization_re flection_dremio
* test_exists
* models
* common
* __cache
* _ _cache_d_ticker
* d_date
* d_ticker
* fina ncial_statement
* __cache
* __cache_f_fina ncial_statement
* f_fina ncial_statement
* metrics
* __cache
* __cache_f_da ily_metrics_icb
* __cache_f_dail y_metrics_index
* __cache_f_dail y_metrics_stock
* f_da ily_metrics_icb
* f_dail y_metrics_index
* f_dail y_metrics_stock
* trading
* transaction
* __cache
* __cache__f_daily_ transaction_icb
* __cache__f_daily_tr ansaction_index
* __cache__f_daily_tr ansaction_stock
* __cache__f_intra day_transaction
* __cache_f_da ily_transaction
* f_da ily_transaction
* seeds
* compa ny_type_mapping
* e xchange_mapping
* fs _column_mapping
* fs _period_mapping
* metrics _column_mapping
* tests
* d_ticker
* test_d_ticker_not_less_th an_3_characters
* f_daily_metrics
* test_f_daily_metrics_ic b_no_duplicates
* test_f_daily_metrics_inde x_no_duplicates
* test_f_daily_metrics_stoc k_no_duplicates
* f_fina ncial_statement
* test_f_financial_statemen t_no_duplicates
* test_f_financial_statement_valid_ report_duration
* test_pri ce_not_negative
* Tables and Views
* DW
* common
* _ _cache_d_ticker
* d_date
* d_ticker
* fina ncial_statement
* __cache_f_fina ncial_statement
* f_fina ncial_statement
* metrics
* __cache_f_da ily_metrics_icb
* __cache_f_dail y_metrics_index
* __cache_f_dail y_metrics_stock
* f_da ily_metrics_icb
* f_dail y_metrics_index
* f_dail y_metrics_stock
* trad ing.transaction
* __cache__f_daily_ transaction_icb
* __cache__f_daily_tr ansaction_index
* __cache__f_daily_tr ansaction_stock
* __cache__f_intra day_transaction
* __cache_f_da ily_transaction
* f_da ily_transaction
* fdata
* vcsc
* active_ trading_archive
* active_t rading_intraday
* active_tr ading_snapshots
* match_price _index_intraday
* match_price _stock_intraday
* stock_ list_vs_indexes
* fidtdatalake
* staging.fiinX
* G etLatestSectors
* Index OrderStatistics
* IndexStatistics ByInvestorDaily
* Pr oprieataryDaily
* vcsc
* prod.fiin
* st x_cpa_Ownership
* stx_c pf_Organization
* stx_f sc_BalanceSheet
* s tx_fsc_CashFlow
* stx_fsc_ IncomeStatement
* s tx_mrk_HnxIndex
* s tx_mrk_HnxStock
* st x_mrk_HoseIndex
* st x_mrk_HoseStock
* stx_ mrk_IcbIndustry
* stx _mrk_UpcomIndex
* stx _mrk_UpcomStock
* stx_ mst_IcbIndustry
* stx_rto_R atioIcbIndustry
* stx _rto_RatioIndex
* s tx_rto_RatioTTM
* stx_rt o_RatioTTMDaily
* st x_rto_RatioYear
* stx_rto _RatioYearDaily
* prod.price_data
* 1D_no ne_gap_intraday
* Public Models
*
* __cache__f_daily_transaction_ icb (protected)
* __cache__f_daily_transaction_in dex (protected)
* __cache__f_daily_transaction_st ock (protected)
* __cache__f_intraday_transact ion (protected)
* __cache_d_tic ker (protected)
* __cache_f_daily_metrics_ icb (protected)
* __cache_f_daily_metrics_in dex (protected)
* __cache_f_daily_metrics_st ock (protected)
* __cache_f_daily_transact ion (protected)
* __cache_f_financial_statem ent (protected)
* compa ny_type_mapping
* d_d ate (protected)
* d_tic ker (protected)
* e xchange_mapping
* f_daily_metrics_ icb (protected)
* f_daily_metrics_in dex (protected)
* f_daily_metrics_st ock (protected)
* f_daily_transact ion (protected)
* f_financial_statem ent (protected)
* fs _column_mapping
* fs _period_mapping
* metrics _column_mapping
* test_d_ticker_not_less_th an_3_characters
* test_f_daily_metrics_ic b_no_duplicates
* test_f_daily_metrics_inde x_no_duplicates
* test_f_daily_metrics_stoc k_no_duplicates
* test_f_financial_statemen t_no_duplicates
* test_f_financial_statement_valid_ report_duration
* test_pri ce_not_negative
*
* IndexStatistics ByInvestorDaily
* Pr oprieataryDaily
* archive _active_trading
* intraday _active_trading
* intraday_ma tch_price_index
* intraday_ma tch_price_stock
* intraday_o hlc_transaction
* intrad ay_sector_index
* intrada y_ticker_orders
* snapshots _active_trading
* stoc ks_index_basket
* st x_cpa_Ownership
* stx_c pf_Organization
* stx_f sc_BalanceSheet
* s tx_fsc_CashFlow
* stx_fsc_ IncomeStatement
* s tx_mrk_HnxIndex
* s tx_mrk_HnxStock
* st x_mrk_HoseIndex
* st x_mrk_HoseStock
* stx_ mrk_IcbIndustry
* stx _mrk_UpcomIndex
* stx _mrk_UpcomStock
* stx_ mst_IcbIndustry
* stx_rto_R atioIcbIndustry
* stx _rto_RatioIndex
* s tx_rto_RatioTTM
* stx_rt o_RatioTTMDaily
* st x_rto_RatioYear
* stx_rto _RatioYearDaily
WELCOME!
Welcome to the auto-generated documentation for your dbt project!
NAVIGATION
You can use the Project and Database navigation tabs on the left side of the
window to explore the models in your project.
PROJECT TAB
The Project tab mirrors the directory structure of your dbt project. In this
tab, you can see all of the models defined in your dbt project, as well as
models imported from dbt packages.
DATABASE TAB
The Database tab also exposes your models, but in a format that looks more like
a database explorer. This view shows relations (tables and views) grouped into
database schemas. Note that ephemeral models are not shown in this interface, as
they do not exist in the database.
GRAPH EXPLORATION
You can click the blue icon on the bottom-right corner of the page to view the
lineage graph of your models.
On model pages, you'll see the immediate parents and children of the model
you're exploring. By clicking the Expand button at the top-right of this lineage
pane, you'll be able to see all of the models that are used to build, or are
built from, the model you're exploring.
Once expanded, you'll be able to use the --select and --exclude model selection
syntax to filter the models in the graph. For more information on model
selection, check out the dbt docs.
Note that you can also right-click on models to interactively filter and explore
the graph.
--------------------------------------------------------------------------------
MORE INFORMATION
* What is dbt?
* Read the dbt viewpoint
* Installation
* Join the dbt Community for questions and discussion
56 SEARCH RESULTS
Name Description Column Column Description SQL Tags
VCSC-CRAWL.INTRADAY_MATCH_PRICE_STOCK SOURCE
columns: code, code columns: symbol, symbol columns: ceiling, ceiling Show 49
more
VCSC-CRAWL.INTRADAY_MATCH_PRICE_INDEX SOURCE
columns: code, code columns: symbol, symbol columns: price, price Show 22 more
VCSC-CRAWL.SNAPSHOTS_ACTIVE_TRADING SOURCE
columns: symbol, symbol columns: trading_time, trading_time columns:
active_buy_match_volume, active_buy_match_volume Show 3 more
VCSC-CRAWL.ARCHIVE_ACTIVE_TRADING SOURCE
columns: ticker, ticker columns: trading_date, trading_date columns:
previous_price, previous_price Show 6 more
FIINX.PROPRIEATARYDAILY SOURCE
columns: tradingDate, tradingDate columns: ticker, ticker columns:
totalBuyVolume, totalBuyVolume Show 13 more
FIINX.INDEXSTATISTICSBYINVESTORDAILY SOURCE
columns: tradingDate, tradingDate columns: ticker, ticker columns:
localIndividualBuyVolume, localIndividualBuyVolume Show 55 more
FIINX.INTRADAY_TICKER_ORDERS SOURCE
columns: tradingDate, tradingDate columns: groupCode, groupCode columns: ticker,
ticker Show 9 more
FIINX.INTRADAY_SECTOR_INDEX SOURCE
columns: id, id columns: code, code columns: name, name Show 23 more
F_DAILY_TRANSACTION MODEL
Lịch sử giá và giao dịch hằng ngày của cổ phiếu và chỉ số sàn
columns: ticker, ticker columns: trading_date, trading_date columns: open_price,
open_price Show 57 more
{{ config(tags=["public"]) }} select distinct transactions.ticker,
cast(transactions.trading_date as timestamp) as trading_date,
coalesce(open_price, 0) as open_price, coalesce(high_price, 0) as high_price,
coalesce(low_price, 0) as low_price, coalesce(close_price, 0) as close_price,
coalesce(reference_price, 0) as reference_price, coalesce(ceiling_price, 0) as
ceiling_price, coalesce(floor_price, 0) as floor_price, coalesce(match_price, 0)
as match_price, coalesce(match_volume, 0) as match_volume, coalesce(match_value,
0) as match_value, coalesce(cumulative_rate_adjusted, 0) as
cumulative_rate_adjusted, coalesce(adjusted_open_price, 0) as
adjusted_open_price, coalesce(adjusted_high_price, 0) as adjusted_high_price,
coalesce(adjusted_low_price, 0) as adjusted_low_price,
coalesce(adjusted_close_price, 0) as adjusted_close_price,
coalesce(adjusted_reference_price, 0) as adjusted_reference_price,
coalesce(adjusted_ceiling_price, 0) as adjusted_ceiling_price,
coalesce(adjusted_floor_price, 0) as adjusted_floor_price,
coalesce(adjusted_match_price, 0) as adjusted_match_price,
coalesce(adjusted_match_volume, 0) as adjusted_match_volume,
cast(coalesce(buy_trade_orders, 0) as bigint) as buy_trade_orders,
cast(coalesce(buy_trade_volume, 0) as bigint) as buy_trade_volume,
cast(coalesce(sell_trade_orders, 0) as bigint) as sell_trade_orders,
cast(coalesce(sell_trade_volume, 0) as bigint) as sell_trade_volume,
coalesce(local_individual_buy_match_volume, 0) as
local_individual_buy_match_volume, coalesce(local_individual_sell_match_volume,
0) as local_individual_sell_match_volume,
coalesce(local_individual_net_match_volume, 0) as
local_individual_net_match_volume,
coalesce(local_institutional_buy_match_volume, 0) as
local_institutional_buy_match_volume,
coalesce(local_institutional_sell_match_volume, 0) as
local_institutional_sell_match_volume,
coalesce(local_institutional_net_match_volume, 0) as
local_institutional_net_match_volume,
coalesce(foreign_individual_buy_match_volume, 0) as
foreign_individual_buy_match_volume,
coalesce(foreign_individual_sell_match_volume, 0) as
foreign_individual_sell_match_volume,
coalesce(foreign_individual_net_match_volume, 0) as
foreign_individual_net_match_volume,
coalesce(foreign_institutional_buy_match_volume, 0) as
foreign_institutional_buy_match_volume,
coalesce(foreign_institutional_sell_match_volume, 0) as
foreign_institutional_sell_match_volume,
coalesce(foreign_institutional_net_match_volume, 0) as
foreign_institutional_net_match_volume, coalesce(proprieatary_buy_match_volume,
0) as proprieatary_buy_match_volume, coalesce(proprieatary_sell_match_volume, 0)
as proprieatary_sell_match_volume, coalesce(proprieatary_net_match_volume, 0) as
proprieatary_net_match_volume, coalesce(local_individual_buy_match_value, 0) as
local_individual_buy_match_value, coalesce(local_individual_sell_match_value, 0)
as local_individual_sell_match_value, coalesce(local_individual_net_match_value,
0) as local_individual_net_match_value,
coalesce(local_institutional_buy_match_value, 0) as
local_institutional_buy_match_value,
coalesce(local_institutional_sell_match_value, 0) as
local_institutional_sell_match_value,
coalesce(local_institutional_net_match_value, 0) as
local_institutional_net_match_value,
coalesce(foreign_individual_buy_match_value, 0) as
foreign_individual_buy_match_value,
coalesce(foreign_individual_sell_match_value, 0) as
foreign_individual_sell_match_value,
coalesce(foreign_individual_net_match_value, 0) as
foreign_individual_net_match_value,
coalesce(foreign_institutional_buy_match_value, 0) as
foreign_institutional_buy_match_value,
coalesce(foreign_institutional_sell_match_value, 0) as
foreign_institutional_sell_match_value,
coalesce(foreign_institutional_net_match_value, 0) as
foreign_institutional_net_match_value, coalesce(proprieatary_buy_match_value, 0)
as proprieatary_buy_match_value, coalesce(proprieatary_sell_match_value, 0) as
proprieatary_sell_match_value, coalesce(proprieatary_net_match_value, 0) as
proprieatary_net_match_value, cast(coalesce(act.active_buy_volume, 0) as bigint)
as active_buy_volume, cast(coalesce(act.active_sell_volume, 0) as bigint) as
active_sell_volume, cast(coalesce(act.active_buy_volume -
act.active_sell_volume, 0) as bigint) as active_net_volume, coalesce(1.0 *
act.active_buy_volume / nullif(act.active_buy_volume + act.active_sell_volume,
0), 0) as active_buy_volume_percentage from ( select * from {{
ref("__f_daily_transaction_stock") }} union all select * from {{
ref("__f_daily_transaction_index") }} union all select * from {{
ref("__f_daily_transaction_icb") }} union all select * from {{
ref("__f_intraday_transaction") }} ) as transactions join {{ ref("d_ticker") }}
as tickers on transactions.ticker = tickers.ticker left join {{
ref("__f_daily_transaction_investor_statistics") }} as stat on
upper(transactions.ticker) = upper(stat.ticker) and transactions.trading_date =
stat.trading_date left join {{ ref("__f_daily_active_trading") }} as act on
transactions.trading_date = act.trading_date and upper(transactions.ticker) =
upper(act.ticker)
tags: public, public
__CACHE_F_DAILY_TRANSACTION MODEL
columns: ticker, ticker columns: trading_date, trading_date columns: open_price,
open_price Show 57 more
{{ config( materialized = 'reflection', anchor = 'f_daily_transaction',
localsort_by = [ 'ticker' ], partition_by = 'trading_date' ) }} -- depends_on:
{{ ref('f_daily_transaction') }} select * from {{ ref('f_daily_transaction') }}
F_FINANCIAL_STATEMENT MODEL
Các chỉ số trong báo cáo tài chính bao gồm: Bảng cân đối kế toán, Báo cáo Lãi &
Lỗ, Lưu chuyển tiền tệ
columns: ticker, ticker columns: fiscal_year, fiscal_year columns:
fiscal_period, fiscal_period Show 690 more
{{ config(tags=["public"]) }} {% set query %} select column_name from {{
ref('fs_column_mapping') }} where lower(left(code, 2)) in ('bs','cf','is') {%
endset %} {% set results = run_query(query) %} {% if execute %} {% set fields =
results.columns[0].values() %} {% else %} {% set fields = [] %} {% endif %}
select bs.ticker, bs.fiscal_year, pm.fiscal_period, case when
bs.fiscal_period_id <> 5 then cast(concat_ws('-', bs.fiscal_year,
pm.start_month_day) as timestamp) -- không phải full năm else case when
extract(day from bs.report_start_date) = 1 and -- ngày đầu của tháng
bs.report_end_date + cast(1 as interval day) = date_trunc('month',
bs.report_end_date + cast(1 as interval day)) and -- ngày cuối của tháng
round(months_between(bs.report_end_date, bs.report_start_date)) = 12 -- cách
nhau 12 tháng then bs.report_start_date else cast(concat_ws('-', bs.fiscal_year,
pm.start_month_day) as timestamp) end end as report_start_date, case when
bs.fiscal_period_id <> 5 then cast(concat_ws('-', bs.fiscal_year,
pm.end_month_day) as timestamp) -- không phải full năm else case when
extract(day from bs.report_start_date) = 1 and -- ngày đầu của tháng
bs.report_end_date + cast(1 as interval day) = date_trunc('month',
bs.report_end_date + cast(1 as interval day)) and -- ngày cuối của tháng
round(months_between(bs.report_end_date, bs.report_start_date)) = 12 -- cách
nhau 12 tháng then bs.report_end_date else cast(concat_ws('-', bs.fiscal_year,
pm.end_month_day) as timestamp) end end as report_end_date, bs.is_auditted {%
for field in fields %} ,coalesce({{ field }}, 0) as {{ field }} {% endfor %}
from {{ ref('__f_financial_statement_bs') }} as bs join {{
ref('fs_period_mapping') }} as pm on bs.fiscal_period_id = pm.fiscal_period_id
join {{ ref('__f_financial_statement_cf') }} as cf on bs.ticker = cf.ticker and
bs.fiscal_year = cf.fiscal_year and bs.fiscal_period_id = cf.fiscal_period_id
and bs.is_auditted = cf.is_auditted join {{ ref('__f_financial_statement_is') }}
as pl on bs.ticker = pl.ticker and bs.fiscal_year = pl.fiscal_year and
bs.fiscal_period_id = pl.fiscal_period_id and bs.is_auditted = pl.is_auditted
join {{ ref('d_ticker') }} as t on bs.ticker = t.ticker
tags: public, public
__CACHE_F_FINANCIAL_STATEMENT MODEL
columns: ticker, ticker columns: fiscal_year, fiscal_year columns:
fiscal_period, fiscal_period Show 690 more
{{ config( materialized = 'reflection', anchor = 'f_financial_statement',
localsort_by = ['ticker', 'fiscal_year', 'report_end_date'], tags=["cache"] ) }}
-- depends_on: {{ ref('f_financial_statement') }} select * from {{
ref('f_financial_statement') }}
tags: cache, cache
D_TICKER MODEL
Danh sách các mã cổ phiếu & chỉ số sàn & chỉ số ngành
columns: ticker, ticker columns: ticker_type, ticker_type columns:
organization_code, organization_code Show 19 more
{{ config(tags=["public"]) }} select ticker, tickers.ticker_type,
tickers.organization_code, tickers.vi_organization_name,
tickers.vi_organization_short_name, tickers.en_organization_name,
tickers.en_organization_short_name, tickers.company_type_name, tickers.exchange,
tickers.icb_level, icb_list.icb_code as icb_code_lv4, icb_list.vi_icb_name as
vi_icb_name_lv4, icb_list.en_icb_name as en_icb_name_lv4, icb_code_lv3,
vi_icb_name_lv3, en_icb_name_lv3, icb_code_lv2, vi_icb_name_lv2,
en_icb_name_lv2, icb_code_lv1, vi_icb_name_lv1, en_icb_name_lv1 from ( select *,
null as icb_level from {{ ref("stock") }} union all select *, null as icb_level
from {{ ref("index") }} union all select icb_code as ticker, 'ICB_INDEX' as
ticker_type, null as organization_code, null as vi_organization_name, null as
vi_organization_short_name, null as en_organization_name, null as
en_organization_short_name, null as company_type_name, null as exchange,
icb_code as icb_code, icb_level from {{ ref("icb") }} ) as tickers left join {{
ref("icb") }} icb_list on tickers.icb_code = icb_list.icb_code
tags: public, public
D_DATE MODEL
Danh sách ngày tháng năm có giao dịch
columns: trading_date, trading_date columns: trading_year, trading_year columns:
quarter, quarter Show 17 more
{{ config(tags=["public"]) }} with distinct_dates as ( select distinct
trading_date from {{ ref("f_daily_transaction") }} union all select distinct
trading_date from {{ ref("__f_intraday_transaction_ohlc") }} ), custom_week as (
select distinct trading_date, year(trading_date) as trading_year,
quarter(trading_date) as "quarter", year(trading_date)*100 +
quarter(trading_date) as "year_quarter", concat('Q',quarter(trading_date),'
',year(trading_date)) "year_quarter_name", month(trading_date) as trading_month,
concat('T', to_char(trading_date, 'mm')) as "vi_month_name",
to_char(trading_date, 'month') as "en_month_name", cast(to_char(trading_date,
'yyyymm') as int) as "year_month", concat('T', to_char(trading_date, 'mm yyyy'))
as "vi_year_month_name", to_char(trading_date, 'mon yyyy') as
"en_year_month_name", last_day(trading_date) as "end_of_month", extract(day from
trading_date) as "trading_day", case to_char(trading_date, 'd') when '1' then
'CN' else concat('T', to_char(trading_date, 'd')) end as "vi_day_name",
to_char(trading_date, 'day') as "en_day_name", case when trading_date <
date_add(date_trunc('year',trading_date), extract(week from trading_date)) then
1 else extract(week from trading_date) + 1 end as "week" from distinct_dates ),
week_info as ( select *, min(trading_date) over(partition by trading_year,
"week") as start_of_week, max(trading_date) over(partition by trading_year,
"week") as end_of_week, trading_year*100 + "week" as "year_week", concat('T',
lpad("week", 2, '0'), ' ', trading_year) as year_week_name from custom_week )
select * from week_info
tags: public, public
__CACHE_D_TICKER MODEL
columns: ticker, ticker columns: ticker_type, ticker_type columns:
organization_code, organization_code Show 19 more
{{ config( materialized = 'reflection', anchor = 'd_ticker', localsort_by =
'ticker', tags=["cache"] ) }} -- depends_on: {{ ref('d_ticker') }} select * from
{{ ref('d_ticker') }}
tags: cache, cache
METRICS_COLUMN_MAPPING SEED
columns: ratio_code, ratio_code columns: vi_ratio_name, vi_ratio_name columns:
en_ratio_name, en_ratio_name Show 0 more
FS_PERIOD_MAPPING SEED
columns: fiscal_period_id, fiscal_period_id columns: fiscal_period,
fiscal_period columns: start_month_day, start_month_day Show 2 more
FS_COLUMN_MAPPING SEED
columns: code, code columns: type1, type1 columns: type2, type2 Show 3 more
EXCHANGE_MAPPING SEED
columns: ComGroupCode, ComGroupCode columns: exchange, exchange Show -1 more
COMPANY_TYPE_MAPPING SEED
columns: ComTypeCode, ComTypeCode columns: ComTypeName, ComTypeName Show -1 more
Show 36 more
Refocus on NodeView documentationHide this and parentsHide this and
childrenExport PNG