Inputs & Outputs
Same tables, every consumer
Only the format and the delivery change. Apps never write to the curated layer, except through a logged correction.
Inputs
What the DMS downloads
| Source | Data | Frequency | Main users |
|---|---|---|---|
| HOSE, HNX, UPCoM | Prices, volumes, shares outstanding, free float | Daily | IMS, FUNDMS, CCPR |
| Yahoo Finance and APIs | Global equities, ETFs, indexes, futures, FX, crypto | Daily | INDOBS, VTP, CCPS |
| Announcements | Dividends, splits, rights issues, mergers, delistings | Event | IMS, FUNDMS |
| Index providers | Levels, constituents, classifications | Daily, quarterly | INDOBS, CCPR |
| Central banks, IMF, WB, GSO | Rates, inflation, GDP, money supply | Monthly, quarterly | CCPR, CCPS |
| Company reports | Financial statements, ratios | Quarterly | CCPR, CCPS |
| ESG and alternative | ESG scores, women CEO lists, sentiment, news | Monthly, daily | CCPR, CCPS |
| Internal | Fund transactions, VTP markets, corrections | Event | FUNDMS, VTP, CCPE |
Outputs
What each consumer receives
| Consumer | What it receives | Format and delivery |
|---|---|---|
| IMS (CCPI) | Clean and adjusted prices, corporate actions with factors, shares and free float, FX | Daily RDS or Parquet on SFTP before the run, plus API |
| FUNDMS (CCPI) | Prices and FX for NAV, corporate actions for holdings | Daily file and API |
| INDOBS | External index levels, constituents, classifications, ranking inputs | Daily and monthly files |
| CCPR research | Full histories and research datasets | Parquet extracts, SQL view, CSV with data dictionary |
| CCPS strategies | Point-in-time panels, returns, factor, sentiment and prediction inputs | Parquet panels by date, API |
| VTP and CCPE | Daily and intraday market files, teaching datasets | VTP_MARKETS files, CSV packs per course |
| NXW Monitor, website | Status, last values and charts | Small JSON or RDS summaries |
| Data team | Quality report, issues, corrections to approve | DMS dashboard and a daily email |
How is it checked?
Blocking and warning rules, and an audit trail for every correction.