RTD Database Configuration Tables
Overview
The RTD Database contains preconfigured tables in different time frames for several real-time providers.
You can check or restore configurations using the tables below.
Click on the required table to go to the table description.
Only Microsoft SQL Server Compact database tables are activated by default.
Change the IS_DISABLED field to activate the required tables.
You can modify the LOAD_CODE field to load tickers and option codes from desired tables.
- RealTimeTables Table for Microsoft SQL Server and SQL Server Compact
- real_time_tables Table for MySQL, MariaDB, and PostgreSQL
- REAL_TIME_TABLES Table for Oracle Database, IBM DB2, and NuoDB
RealTimeTables Table for Microsoft SQL Server and SQL Server Compact
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY | IS_DISABLED |
|---|---|---|---|---|
rtd | FundamentalsYahoo | SELECT Code AS Symbol FROM rtd.QuoteListStocks | 1 | |
rtd | FundamentalsDayHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListStocks | ||
rtd | StocksYahoo | SELECT Code AS Symbol FROM rtd.QuoteListStocks | 1 | |
rtd | QuotesYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | ||
rtd | QuoteDayHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | 1 | |
rtd | QuoteTimeHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | 1 | |
rtd | QuoteTickHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | 1 | 1 |
rtd | QuotesMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | 1 | |
rtd | QuoteDayHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | 1 | |
rtd | QuoteTimeHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | 1 | |
rtd | QuoteTickHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | 1 | 1 |
rtd | OptionsYahoo | SELECT Code FROM rtd.OptionListYahoo | 1 | |
rtd | OptionDayHistoryYahoo | SELECT Code FROM rtd.OptionListYahoo | ||
rtd | OptionTickHistoryYahoo | SELECT Code FROM rtd.OptionListYahoo | 1 | 1 |
rtd | OptionsGoogle | SELECT Code FROM rtd.OptionListGoogle | 1 | |
rtd | OptionDayHistoryGoogle | SELECT Code FROM rtd.OptionListGoogle | 1 | |
rtd | OptionTickHistoryGoogle | SELECT Code FROM rtd.OptionListGoogle | 1 | 1 |
rtd | OptionsMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | 1 | |
rtd | OptionDayHistoryMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | 1 | |
rtd | OptionTickHistoryMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | 1 | 1 |
rtd | QuotesES | SELECT Code FROM rtd.QuoteListES | 1 | |
rtd | QuoteDayHistoryES | SELECT Code FROM rtd.QuoteListES | 1 | |
rtd | QuoteTimeHistoryES | SELECT Code FROM rtd.QuoteListES | 1 | |
rtd | QuoteTickHistoryES | SELECT Code FROM rtd.QuoteListES | 1 | 1 |
rtd | QuotesTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | 1 | |
rtd | QuoteDayHistoryTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | 1 | |
rtd | QuoteTickHistoryTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | 1 | 1 |
rtd | OptionsTOS | SELECT Code FROM rtd.OptionListTOS | 1 | |
rtd | OptionDayHistoryTOS | SELECT Code FROM rtd.OptionListTOS | 1 | |
rtd | OptionTickHistoryTOS | SELECT Code FROM rtd.OptionListTOS | 1 | 1 |
rtd | QuotesTWS | SELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%' | 1 | |
rtd | QuoteDayHistoryTWS | SELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%' | 1 | |
rtd | QuoteTickHistoryTWS | SELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%' | 1 | 1 |
rtd | OptionsTWS | SELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%' | 1 | |
rtd | OptionDayHistoryTWS | SELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%' | 1 | |
rtd | OptionTickHistoryTWS | SELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%' | 1 | 1 |
rtd | QuotesVFX | SELECT Code FROM rtd.QuoteListVFX | 1 | |
rtd | QuoteDayHistoryVFX | SELECT Code FROM rtd.QuoteListVFX | 1 | |
rtd | QuoteTimeHistoryVFX | SELECT Code FROM rtd.QuoteListVFX | 1 | |
rtd | QuoteTickHistoryVFX | SELECT Code FROM rtd.QuoteListVFX | 1 | 1 |
rtd | CurrenciesYahoo | SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo | 1 | |
rtd | CurrenciesDayHistoryYahoo | SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo | 1 | |
rtd | CurrenciesTimeHistoryYahoo | SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo | ||
rtd | CurrenciesTickHistoryYahoo | SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo | 1 | 1 |
rtd | CurrenciesMsnMoney | SELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney | 1 | |
rtd | CurrenciesDayHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney | 1 | |
rtd | CurrenciesTimeHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney | 1 | |
rtd | CurrenciesTickHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney | 1 | 1 |
real_time_tables Table for MySQL, MariaDB, and PostgreSQL
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY | IS_DISABLED |
|---|---|---|---|---|
rtd | fundamentals_day_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_stocks | 1 | |
rtd | fundamentals_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_stocks | ||
rtd | stocks_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_stocks | 1 | |
rtd | quotes_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | 1 | |
rtd | quote_day_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | ||
rtd | quote_time_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | 1 | |
rtd | quote_tick_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | 1 | 1 |
rtd | quotes_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | 1 | |
rtd | quote_day_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | 1 | |
rtd | quote_time_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | 1 | |
rtd | quote_tick_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | 1 | 1 |
rtd | options_yahoo | SELECT CODE FROM rtd.option_list_yahoo | 1 | |
rtd | option_day_history_yahoo | SELECT CODE FROM rtd.option_list_yahoo | ||
rtd | option_tick_history_yahoo | SELECT CODE FROM rtd.option_list_yahoo | 1 | 1 |
rtd | options_google | SELECT CODE FROM rtd.option_list_google | 1 | |
rtd | option_day_history_google | SELECT CODE FROM rtd.option_list_google | 1 | |
rtd | option_tick_history_google | SELECT CODE FROM rtd.option_list_google | 1 | 1 |
rtd | options_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | 1 | |
rtd | option_day_history_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | 1 | |
rtd | option_tick_history_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | 1 | 1 |
rtd | quotes_es | SELECT CODE FROM rtd.quote_list_es | 1 | |
rtd | quote_day_history_es | SELECT CODE FROM rtd.quote_list_es | 1 | |
rtd | quote_time_history_es | SELECT CODE FROM rtd.quote_list_es | 1 | |
rtd | quote_tick_history_es | SELECT CODE FROM rtd.quote_list_es | 1 | 1 |
rtd | quotes_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | 1 | |
rtd | quote_day_history_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | 1 | |
rtd | quote_tick_history_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | 1 | 1 |
rtd | options_tos | SELECT CODE FROM rtd.option_list_tos | 1 | |
rtd | option_day_history_tos | SELECT CODE FROM rtd.option_list_tos | 1 | |
rtd | option_tick_history_tos | SELECT CODE FROM rtd.option_list_tos | 1 | 1 |
rtd | quotes_tws | SELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%' | 1 | |
rtd | quote_day_history_tws | SELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%' | 1 | |
rtd | quote_tick_history_tws | SELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%' | 1 | 1 |
rtd | options_tws | SELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%' | 1 | |
rtd | option_day_history_tws | SELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%' | 1 | |
rtd | option_tick_history_tws | SELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%' | 1 | 1 |
rtd | quotes_vfx | SELECT CODE FROM rtd.quote_list_vfx | 1 | |
rtd | quote_day_history_vfx | SELECT CODE FROM rtd.quote_list_vfx | 1 | |
rtd | quote_time_history_vfx | SELECT CODE FROM rtd.quote_list_vfx | 1 | |
rtd | quote_tick_history_vfx | SELECT CODE FROM rtd.quote_list_vfx | 1 | 1 |
rtd | currencies_yahoo | SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo | 1 | |
rtd | currencies_day_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo | 1 | |
rtd | currencies_time_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo | ||
rtd | currencies_tick_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo | 1 | 1 |
rtd | currencies_msnmoney | SELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney | 1 | |
rtd | currencies_day_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney | 1 | |
rtd | currencies_time_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney | 1 | |
rtd | currencies_tick_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney | 1 | 1 |
REAL_TIME_TABLES Table for Oracle Database, IBM DB2, and NuoDB
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY | IS_DISABLED |
|---|---|---|---|---|
RTD | FUNDAMENTALS_DAY_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS | 1 | |
RTD | FUNDAMENTALS_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS | ||
RTD | STOCKS_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS | 1 | |
RTD | QUOTES_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | 1 | |
RTD | QUOTE_DAY_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | ||
RTD | QUOTE_TIME_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | 1 | |
RTD | QUOTE_TICK_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | 1 | 1 |
RTD | QUOTES_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | 1 | |
RTD | QUOTE_DAY_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | 1 | |
RTD | QUOTE_TIME_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | 1 | |
RTD | QUOTE_TICK_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | 1 | 1 |
RTD | OPTIONS_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | 1 | |
RTD | OPTION_DAY_HISTORY_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | ||
RTD | OPTION_TICK_HISTORY_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | 1 | 1 |
RTD | OPTIONS_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | 1 | |
RTD | OPTION_DAY_HISTORY_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | 1 | |
RTD | OPTION_TICK_HISTORY_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | 1 | 1 |
RTD | OPTIONS_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | 1 | |
RTD | OPTION_DAY_HISTORY_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | 1 | |
RTD | OPTION_TICK_HISTORY_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | 1 | 1 |
RTD | QUOTES_ES | SELECT CODE FROM RTD.QUOTE_LIST_ES | 1 | |
RTD | QUOTE_DAY_HISTORY_ES | SELECT CODE FROM RTD.QUOTE_LIST_ES | 1 | |
RTD | QUOTE_TIME_HISTORY_ES | SELECT CODE FROM RTD.QUOTE_LIST_ES | 1 | |
RTD | QUOTE_TICK_HISTORY_ES | SELECT CODE FROM RTD.QUOTE_LIST_ES | 1 | 1 |
RTD | QUOTES_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | 1 | |
RTD | QUOTE_DAY_HISTORY_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | 1 | |
RTD | QUOTE_TICK_HISTORY_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | 1 | 1 |
RTD | OPTIONS_TOS | SELECT CODE FROM RTD.OPTION_LIST_TOS | 1 | |
RTD | OPTION_DAY_HISTORY_TOS | SELECT CODE FROM RTD.OPTION_LIST_TOS | 1 | |
RTD | OPTION_TICK_HISTORY_TOS | SELECT CODE FROM RTD.OPTION_LIST_TOS | 1 | 1 |
RTD | QUOTES_TWS | SELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%' | 1 | |
RTD | QUOTE_DAY_HISTORY_TWS | SELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%' | 1 | |
RTD | QUOTE_TICK_HISTORY_TWS | SELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%' | 1 | 1 |
RTD | OPTIONS_TWS | SELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%' | 1 | |
RTD | OPTION_DAY_HISTORY_TWS | SELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%' | 1 | |
RTD | OPTION_TICK_HISTORY_TWS | SELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%' | 1 | 1 |
RTD | QUOTES_VFX | SELECT CODE FROM RTD.QUOTE_LIST_VFX | 1 | |
RTD | QUOTE_DAY_HISTORY_VFX | SELECT CODE FROM RTD.QUOTE_LIST_VFX | 1 | |
RTD | QUOTE_TIME_HISTORY_VFX | SELECT CODE FROM RTD.QUOTE_LIST_VFX | 1 | |
RTD | QUOTE_TICK_HISTORY_VFX | SELECT CODE FROM RTD.QUOTE_LIST_VFX | 1 | 1 |
RTD | CURRENCIES_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY | 1 | |
RTD | CURRENCIES_DAY_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY | 1 | |
RTD | CURRENCIES_TIME_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY | 1 | |
RTD | CURRENCIES_TICK_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY | 1 | 1 |
RTD | CURRENCIES_YAHOO | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO | 1 | |
RTD | CURRENCIES_DAY_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO | 1 | |
RTD | CURRENCIES_TIME_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO | ||
RTD | CURRENCIES_TICK_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO | 1 | 1 |