RTD Database Configuration Tables

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

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORYIS_DISABLED
rtdFundamentalsYahooSELECT Code AS Symbol FROM rtd.QuoteListStocks1
rtdFundamentalsDayHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListStocks 
rtdStocksYahooSELECT Code AS Symbol FROM rtd.QuoteListStocks1
rtdQuotesYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo 
rtdQuoteDayHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo1
rtdQuoteTimeHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo1
rtdQuoteTickHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo11
rtdQuotesMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney1
rtdQuoteDayHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney1
rtdQuoteTimeHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney1
rtdQuoteTickHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney11
rtdOptionsYahooSELECT Code FROM rtd.OptionListYahoo1
rtdOptionDayHistoryYahooSELECT Code FROM rtd.OptionListYahoo 
rtdOptionTickHistoryYahooSELECT Code FROM rtd.OptionListYahoo11
rtdOptionsGoogleSELECT Code FROM rtd.OptionListGoogle1
rtdOptionDayHistoryGoogleSELECT Code FROM rtd.OptionListGoogle1
rtdOptionTickHistoryGoogleSELECT Code FROM rtd.OptionListGoogle11
rtdOptionsMsnMoneySELECT Code FROM rtd.OptionListMsnMoney1
rtdOptionDayHistoryMsnMoneySELECT Code FROM rtd.OptionListMsnMoney1
rtdOptionTickHistoryMsnMoneySELECT Code FROM rtd.OptionListMsnMoney11
rtdQuotesESSELECT Code FROM rtd.QuoteListES1
rtdQuoteDayHistoryESSELECT Code FROM rtd.QuoteListES1
rtdQuoteTimeHistoryESSELECT Code FROM rtd.QuoteListES1
rtdQuoteTickHistoryESSELECT Code FROM rtd.QuoteListES11
rtdQuotesTOSSELECT Code AS Symbol FROM rtd.QuoteListTOS1
rtdQuoteDayHistoryTOSSELECT Code AS Symbol FROM rtd.QuoteListTOS1
rtdQuoteTickHistoryTOSSELECT Code AS Symbol FROM rtd.QuoteListTOS11
rtdOptionsTOSSELECT Code FROM rtd.OptionListTOS1
rtdOptionDayHistoryTOSSELECT Code FROM rtd.OptionListTOS1
rtdOptionTickHistoryTOSSELECT Code FROM rtd.OptionListTOS11
rtdQuotesTWSSELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%'1
rtdQuoteDayHistoryTWSSELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%'1
rtdQuoteTickHistoryTWSSELECT TickId, Code AS Symbol FROM rtd.QuoteListTWS WHERE Code NOT LIKE '%_OPT_20%'11
rtdOptionsTWSSELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%'1
rtdOptionDayHistoryTWSSELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%'1
rtdOptionTickHistoryTWSSELECT TickId, Code FROM rtd.QuoteListTWS WHERE Code LIKE '%_OPT_20%'11
rtdQuotesVFXSELECT Code FROM rtd.QuoteListVFX1
rtdQuoteDayHistoryVFXSELECT Code FROM rtd.QuoteListVFX1
rtdQuoteTimeHistoryVFXSELECT Code FROM rtd.QuoteListVFX1
rtdQuoteTickHistoryVFXSELECT Code FROM rtd.QuoteListVFX11
rtdCurrenciesYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo1
rtdCurrenciesDayHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo1
rtdCurrenciesTimeHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo 
rtdCurrenciesTickHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo11
rtdCurrenciesMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney1
rtdCurrenciesDayHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney1
rtdCurrenciesTimeHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney1
rtdCurrenciesTickHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney11

real_time_tables Table for MySQL, MariaDB, and PostgreSQL

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORYIS_DISABLED
rtdfundamentals_day_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_stocks1
rtdfundamentals_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_stocks 
rtdstocks_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_stocks1
rtdquotes_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo1
rtdquote_day_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo 
rtdquote_time_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo1
rtdquote_tick_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo11
rtdquotes_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney1
rtdquote_day_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney1
rtdquote_time_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney1
rtdquote_tick_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney11
rtdoptions_yahooSELECT CODE FROM rtd.option_list_yahoo1
rtdoption_day_history_yahooSELECT CODE FROM rtd.option_list_yahoo 
rtdoption_tick_history_yahooSELECT CODE FROM rtd.option_list_yahoo11
rtdoptions_googleSELECT CODE FROM rtd.option_list_google1
rtdoption_day_history_googleSELECT CODE FROM rtd.option_list_google1
rtdoption_tick_history_googleSELECT CODE FROM rtd.option_list_google11
rtdoptions_msnmoneySELECT CODE FROM rtd.option_list_msnmoney1
rtdoption_day_history_msnmoneySELECT CODE FROM rtd.option_list_msnmoney1
rtdoption_tick_history_msnmoneySELECT CODE FROM rtd.option_list_msnmoney11
rtdquotes_esSELECT CODE FROM rtd.quote_list_es1
rtdquote_day_history_esSELECT CODE FROM rtd.quote_list_es1
rtdquote_time_history_esSELECT CODE FROM rtd.quote_list_es1
rtdquote_tick_history_esSELECT CODE FROM rtd.quote_list_es11
rtdquotes_tosSELECT CODE AS SYMBOL FROM rtd.quote_list_tos1
rtdquote_day_history_tosSELECT CODE AS SYMBOL FROM rtd.quote_list_tos1
rtdquote_tick_history_tosSELECT CODE AS SYMBOL FROM rtd.quote_list_tos11
rtdoptions_tosSELECT CODE FROM rtd.option_list_tos1
rtdoption_day_history_tosSELECT CODE FROM rtd.option_list_tos1
rtdoption_tick_history_tosSELECT CODE FROM rtd.option_list_tos11
rtdquotes_twsSELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%'1
rtdquote_day_history_twsSELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%'1
rtdquote_tick_history_twsSELECT TICK_ID, CODE AS SYMBOL FROM rtd.quote_list_tws WHERE CODE NOT LIKE '%_OPT_20%'11
rtdoptions_twsSELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%'1
rtdoption_day_history_twsSELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%'1
rtdoption_tick_history_twsSELECT TICK_ID, CODE FROM rtd.quote_list_tws WHERE CODE LIKE '%_OPT_20%'11
rtdquotes_vfxSELECT CODE FROM rtd.quote_list_vfx1
rtdquote_day_history_vfxSELECT CODE FROM rtd.quote_list_vfx1
rtdquote_time_history_vfxSELECT CODE FROM rtd.quote_list_vfx1
rtdquote_tick_history_vfxSELECT CODE FROM rtd.quote_list_vfx11
rtdcurrencies_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo1
rtdcurrencies_day_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo1
rtdcurrencies_time_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo 
rtdcurrencies_tick_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo11
rtdcurrencies_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney1
rtdcurrencies_day_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney1
rtdcurrencies_time_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney1
rtdcurrencies_tick_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney11

REAL_TIME_TABLES Table for Oracle Database, IBM DB2, and NuoDB

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORYIS_DISABLED
RTDFUNDAMENTALS_DAY_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS1
RTDFUNDAMENTALS_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS 
RTDSTOCKS_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS1
RTDQUOTES_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO1
RTDQUOTE_DAY_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO 
RTDQUOTE_TIME_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO1
RTDQUOTE_TICK_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO11
RTDQUOTES_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY1
RTDQUOTE_DAY_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY1
RTDQUOTE_TIME_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY1
RTDQUOTE_TICK_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY11
RTDOPTIONS_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO1
RTDOPTION_DAY_HISTORY_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO 
RTDOPTION_TICK_HISTORY_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO11
RTDOPTIONS_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE1
RTDOPTION_DAY_HISTORY_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE1
RTDOPTION_TICK_HISTORY_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE11
RTDOPTIONS_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY1
RTDOPTION_DAY_HISTORY_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY1
RTDOPTION_TICK_HISTORY_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY11
RTDQUOTES_ESSELECT CODE FROM RTD.QUOTE_LIST_ES1
RTDQUOTE_DAY_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES1
RTDQUOTE_TIME_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES1
RTDQUOTE_TICK_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES11
RTDQUOTES_TOSSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS1
RTDQUOTE_DAY_HISTORY_TOSSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS1
RTDQUOTE_TICK_HISTORY_TOSSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS11
RTDOPTIONS_TOSSELECT CODE FROM RTD.OPTION_LIST_TOS1
RTDOPTION_DAY_HISTORY_TOSSELECT CODE FROM RTD.OPTION_LIST_TOS1
RTDOPTION_TICK_HISTORY_TOSSELECT CODE FROM RTD.OPTION_LIST_TOS11
RTDQUOTES_TWSSELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%'1
RTDQUOTE_DAY_HISTORY_TWSSELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%'1
RTDQUOTE_TICK_HISTORY_TWSSELECT TICK_ID, CODE AS SYMBOL FROM RTD.QUOTE_LIST_TWS WHERE CODE NOT LIKE '%_OPT_20%'11
RTDOPTIONS_TWSSELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%'1
RTDOPTION_DAY_HISTORY_TWSSELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%'1
RTDOPTION_TICK_HISTORY_TWSSELECT TICK_ID, CODE FROM RTD.QUOTE_LIST_TWS WHERE CODE LIKE '%_OPT_20%'11
RTDQUOTES_VFXSELECT CODE FROM RTD.QUOTE_LIST_VFX1
RTDQUOTE_DAY_HISTORY_VFXSELECT CODE FROM RTD.QUOTE_LIST_VFX1
RTDQUOTE_TIME_HISTORY_VFXSELECT CODE FROM RTD.QUOTE_LIST_VFX1
RTDQUOTE_TICK_HISTORY_VFXSELECT CODE FROM RTD.QUOTE_LIST_VFX11
RTDCURRENCIES_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY1
RTDCURRENCIES_DAY_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY1
RTDCURRENCIES_TIME_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY1
RTDCURRENCIES_TICK_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY11
RTDCURRENCIES_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO1
RTDCURRENCIES_DAY_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO1
RTDCURRENCIES_TIME_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO 
RTDCURRENCIES_TICK_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO11