The Market Data diagram represents data structures that store historical and real-time data. The diagram includes several areas that correspond to different financial instruments; each area includes one or more tables that store historical or real-time (intraday) data.
The diagram contains these data structures:
Stock History (STOCK_HISTORY) stores historical data (one record per trading date), including open/close price, high/low price, and trading volume.
Stock Quote (STOCK_QUOTE) stores intraday quote data, including bid/ask price and size.
Stock Trade (STOCK_TRADE) stores intraday trade data, including trade price and size.
Split Event (SPLIT_EVENT) stores data on stock splits (event date and split factor).
Dividend Event (DIVIDEND_EVENT) stores data on dividend payment events (event date and dividend amount).
The stock-related tables listed above also store exchange-traded funds (ETF) data.
Separate tables with a similar structure store historical and intraday data related to bonds and options. The Mutual Fund History (MUTL_FUND_HIST) table contains only historical mutual funds data.
Index History (INDEX_HISTORY) and Index Intraday (INDEX_INTRADAY) tables store historical and intraday data on market indexes.