Quotes from eSignal FutureSource

Quotes from eSignal FutureSource

Overview

The RTD database contains preconfigured tables for getting real-time data from eSignal FutureSource.

Quote tables are designed for getting data for stocks and futures.

The data are updated from the FutureSource RTD server.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdQuoteListES
rtdQuotesESSELECT Code FROM rtd.QuoteListES
rtdQuoteDayHistoryESSELECT Code FROM rtd.QuoteListES
rtdQuoteTimeHistoryESSELECT Code FROM rtd.QuoteListES
rtdQuoteTickHistoryESSELECT Code FROM rtd.QuoteListES1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdquote_list_es
rtdquotes_esSELECT CODE FROM rtd.quote_list_es
rtdquote_day_history_esSELECT CODE FROM rtd.quote_list_es
rtdquote_time_history_esSELECT CODE FROM rtd.quote_list_es
rtdquote_tick_history_esSELECT CODE FROM rtd.quote_list_es1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDQUOTE_LIST_ES
RTDQUOTES_ESSELECT CODE FROM RTD.QUOTE_LIST_ES
RTDQUOTE_DAY_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES
RTDQUOTE_TIME_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES
RTDQUOTE_TICK_HISTORY_ESSELECT CODE FROM RTD.QUOTE_LIST_ES1

* Click on the table name to go to the table description.

Task Table Examples

rtd.QuoteListES for Microsoft SQL Server and Microsoft SQL Server Compact:

Code
AAPL
GOOG

rtd.quote_list_es for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:

CODE
AAPL
GOOG

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdQuotesESCodeFormula
rtdQuotesESSymbol=RTD("esrtd",,[Code],"Symbol")PK
rtdQuoteDayHistoryESCodeFormula
rtdQuoteDayHistoryESSymbol=RTD("esrtd",,[Code],"Symbol")PK
rtdQuoteDayHistoryESDate=Date()PK
rtdQuoteTimeHistoryESCodeFormula
rtdQuoteTimeHistoryESSymbol=RTD("esrtd",,[Code],"Symbol")PK
rtdQuoteTimeHistoryESDate=Date()PK
rtdQuoteTimeHistoryESTime=RTD("esrtd",,[Code],"Time")PK
rtdQuoteTickHistoryESCodeFormula
rtdQuoteTickHistoryESIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdquotes_esCODEFormula
rtdquotes_esSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
rtdquote_day_history_esCODEFormula
rtdquote_day_history_esSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
rtdquote_day_history_esDATE=Date()PK
rtdquote_time_history_esCODEFormula
rtdquote_time_history_esSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
rtdquote_time_history_esDATE=Date()PK
rtdquote_time_history_esTIME=RTD("esrtd",,[CODE],"Time")PK
rtdquote_tick_history_esCODEFormula
rtdquote_tick_history_esIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDQUOTES_ESCODEFormula
RTDQUOTES_ESSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
RTDQUOTE_DAY_HISTORY_ESCODEFormula
RTDQUOTE_DAY_HISTORY_ESSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
RTDQUOTE_DAY_HISTORY_ESDATE=Date()PK
RTDQUOTE_TICK_HISTORY_ESCODEFormula
RTDQUOTE_TICK_HISTORY_ESIDPK, IDENTITY
RTDQUOTE_TIME_HISTORY_ESCODEFormula
RTDQUOTE_TIME_HISTORY_ESSYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
RTDQUOTE_TIME_HISTORY_ESDATE=Date()PK
RTDQUOTE_TIME_HISTORY_ESTIME=RTD("esrtd",,[CODE],"Time")PK

Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact

rtd.QuotesES

The table contains the last data values of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CodeFormula
Symbol=RTD("esrtd",,[Code],"Symbol")PK
Date=Date()
Time=RTD("esrtd",,[Code],"Time")
Last=RTD("esrtd",,[Code],"Last")
Change=RTD("esrtd",,[Code],"Change")
PercentChange=RTD("esrtd",,[Code],"% Change")
Bid=RTD("esrtd",,[Code],"Bid")
Ask=RTD("esrtd",,[Code],"Ask")
BidSize=RTD("esrtd",,[Code],"Bid Size")
AskSize=RTD("esrtd",,[Code],"Ask Size")
Open=RTD("esrtd",,[Code],"Open")
High=RTD("esrtd",,[Code],"High")
Low=RTD("esrtd",,[Code],"Low")
Volume=RTD("esrtd",,[Code],"Volume")
OpenInt=RTD("esrtd",,[Code],"OpenInt")
TradePrice=RTD("esrtd",,[Code],"TradePrice")
LastUpdateTimeStamp

rtd.QuoteDayHistoryES

The table contains day data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CodeFormula
Symbol=RTD("esrtd",,[Code],"Symbol")PK
Date=Date()PK
Time=RTD("esrtd",,[Code],"Time")
Last=RTD("esrtd",,[Code],"Last")
Change=RTD("esrtd",,[Code],"Change")
PercentChange=RTD("esrtd",,[Code],"% Change")
Bid=RTD("esrtd",,[Code],"Bid")
Ask=RTD("esrtd",,[Code],"Ask")
BidSize=RTD("esrtd",,[Code],"Bid Size")
AskSize=RTD("esrtd",,[Code],"Ask Size")
Open=RTD("esrtd",,[Code],"Open")
High=RTD("esrtd",,[Code],"High")
Low=RTD("esrtd",,[Code],"Low")
Volume=RTD("esrtd",,[Code],"Volume")
OpenInt=RTD("esrtd",,[Code],"OpenInt")
TradePrice=RTD("esrtd",,[Code],"TradePrice")
LastUpdateTimeStamp

rtd.QuoteTimeHistoryES

The table contains time data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CodeFormula
Symbol=RTD("esrtd",,[Code],"Symbol")PK
Date=Date()PK
Time=RTD("esrtd",,[Code],"Time")PK
Last=RTD("esrtd",,[Code],"Last")
Change=RTD("esrtd",,[Code],"Change")
PercentChange=RTD("esrtd",,[Code],"% Change")
Bid=RTD("esrtd",,[Code],"Bid")
Ask=RTD("esrtd",,[Code],"Ask")
BidSize=RTD("esrtd",,[Code],"Bid Size")
AskSize=RTD("esrtd",,[Code],"Ask Size")
Open=RTD("esrtd",,[Code],"Open")
High=RTD("esrtd",,[Code],"High")
Low=RTD("esrtd",,[Code],"Low")
Volume=RTD("esrtd",,[Code],"Volume")
OpenInt=RTD("esrtd",,[Code],"OpenInt")
TradePrice=RTD("esrtd",,[Code],"TradePrice")
LastUpdateTimeStamp

rtd.QuoteTickHistoryES

The table contains tick data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CodeFormula
IDPK, IDENTITY
Symbol=RTD("esrtd",,[Code],"Symbol")
Date=Date()
Time=RTD("esrtd",,[Code],"Time")
Last=RTD("esrtd",,[Code],"Last")
Change=RTD("esrtd",,[Code],"Change")
PercentChange=RTD("esrtd",,[Code],"% Change")
Bid=RTD("esrtd",,[Code],"Bid")
Ask=RTD("esrtd",,[Code],"Ask")
BidSize=RTD("esrtd",,[Code],"Bid Size")
AskSize=RTD("esrtd",,[Code],"Ask Size")
Open=RTD("esrtd",,[Code],"Open")
High=RTD("esrtd",,[Code],"High")
Low=RTD("esrtd",,[Code],"Low")
Volume=RTD("esrtd",,[Code],"Volume")
OpenInt=RTD("esrtd",,[Code],"OpenInt")
TradePrice=RTD("esrtd",,[Code],"TradePrice")

Real-Time Formulas for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL

The table contains the last data values of stocks and futures from eSignal FutureSource.

rtd.quotes_es

COLUMN_NAMERTD_FORMULACOMMENT
CODEFormula
SYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
DATE=Date()
TIME=RTD("esrtd",,[CODE],"Time")
LAST=RTD("esrtd",,[CODE],"Last")
CHANGE=RTD("esrtd",,[CODE],"Change")
PERCENT_CHANGE=RTD("esrtd",,[CODE],"% Change")
BID=RTD("esrtd",,[CODE],"Bid")
ASK=RTD("esrtd",,[CODE],"Ask")
BID_SIZE=RTD("esrtd",,[CODE],"Bid Size")
ASK_SIZE=RTD("esrtd",,[CODE],"Ask Size")
OPEN=RTD("esrtd",,[CODE],"Open")
HIGH=RTD("esrtd",,[CODE],"High")
LOW=RTD("esrtd",,[CODE],"Low")
VOLUME=RTD("esrtd",,[CODE],"Volume")
OPEN_INT=RTD("esrtd",,[CODE],"OpenInt")
TRADE_PRICE=RTD("esrtd",,[CODE],"TradePrice")
LAST_UPDATE_TIMESTAMP

rtd.quote_day_history_es

The table contains day data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CODEFormula
SYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
DATE=Date()PK
TIME=RTD("esrtd",,[CODE],"Time")
LAST=RTD("esrtd",,[CODE],"Last")
CHANGE=RTD("esrtd",,[CODE],"Change")
PERCENT_CHANGE=RTD("esrtd",,[CODE],"% Change")
BID=RTD("esrtd",,[CODE],"Bid")
ASK=RTD("esrtd",,[CODE],"Ask")
BID_SIZE=RTD("esrtd",,[CODE],"Bid Size")
ASK_SIZE=RTD("esrtd",,[CODE],"Ask Size")
OPEN=RTD("esrtd",,[CODE],"Open")
HIGH=RTD("esrtd",,[CODE],"High")
LOW=RTD("esrtd",,[CODE],"Low")
VOLUME=RTD("esrtd",,[CODE],"Volume")
OPEN_INT=RTD("esrtd",,[CODE],"OpenInt")
TRADE_PRICE=RTD("esrtd",,[CODE],"TradePrice")
LAST_UPDATE_TIMESTAMP

rtd.quote_time_history_es

The table contains time data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CODEFormula
SYMBOL=RTD("esrtd",,[CODE],"Symbol")PK
DATE=Date()PK
TIME=RTD("esrtd",,[CODE],"Time")PK
LAST=RTD("esrtd",,[CODE],"Last")
CHANGE=RTD("esrtd",,[CODE],"Change")
PERCENT_CHANGE=RTD("esrtd",,[CODE],"% Change")
BID=RTD("esrtd",,[CODE],"Bid")
ASK=RTD("esrtd",,[CODE],"Ask")
BID_SIZE=RTD("esrtd",,[CODE],"Bid Size")
ASK_SIZE=RTD("esrtd",,[CODE],"Ask Size")
OPEN=RTD("esrtd",,[CODE],"Open")
HIGH=RTD("esrtd",,[CODE],"High")
LOW=RTD("esrtd",,[CODE],"Low")
VOLUME=RTD("esrtd",,[CODE],"Volume")
OPEN_INT=RTD("esrtd",,[CODE],"OpenInt")
TRADE_PRICE=RTD("esrtd",,[CODE],"TradePrice")
LAST_UPDATE_TIMESTAMP

rtd.quote_tick_history_es

The table contains tick data history of stocks and futures from eSignal FutureSource.

COLUMN_NAMERTD_FORMULACOMMENT
CODEFormula
IDPK, IDENTITY
SYMBOL=RTD("esrtd",,[CODE],"Symbol")
DATE=Date()
TIME=RTD("esrtd",,[CODE],"Time")
LAST=RTD("esrtd",,[CODE],"Last")
CHANGE=RTD("esrtd",,[CODE],"Change")
PERCENT_CHANGE=RTD("esrtd",,[CODE],"% Change")
BID=RTD("esrtd",,[CODE],"Bid")
ASK=RTD("esrtd",,[CODE],"Ask")
BID_SIZE=RTD("esrtd",,[CODE],"Bid Size")
ASK_SIZE=RTD("esrtd",,[CODE],"Ask Size")
OPEN=RTD("esrtd",,[CODE],"Open")
HIGH=RTD("esrtd",,[CODE],"High")
LOW=RTD("esrtd",,[CODE],"Low")
VOLUME=RTD("esrtd",,[CODE],"Volume")
OPEN_INT=RTD("esrtd",,[CODE],"OpenInt")
TRADE_PRICE=RTD("esrtd",,[CODE],"TradePrice")