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_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`rtd`	QuoteListES
`rtd`	QuotesES	`SELECT Code FROM rtd.QuoteListES`
`rtd`	QuoteDayHistoryES	`SELECT Code FROM rtd.QuoteListES`
`rtd`	QuoteTimeHistoryES	`SELECT Code FROM rtd.QuoteListES`
`rtd`	QuoteTickHistoryES	`SELECT Code FROM rtd.QuoteListES`	1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`rtd`	quote_list_es
`rtd`	quotes_es	`SELECT CODE FROM rtd.quote_list_es`
`rtd`	quote_day_history_es	`SELECT CODE FROM rtd.quote_list_es`
`rtd`	quote_time_history_es	`SELECT CODE FROM rtd.quote_list_es`
`rtd`	quote_tick_history_es	`SELECT CODE FROM rtd.quote_list_es`	1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`RTD`	QUOTE_LIST_ES
`RTD`	QUOTES_ES	`SELECT CODE FROM RTD.QUOTE_LIST_ES`
`RTD`	QUOTE_DAY_HISTORY_ES	`SELECT CODE FROM RTD.QUOTE_LIST_ES`
`RTD`	QUOTE_TIME_HISTORY_ES	`SELECT CODE FROM RTD.QUOTE_LIST_ES`
`RTD`	QUOTE_TICK_HISTORY_ES	`SELECT CODE FROM RTD.QUOTE_LIST_ES`	1

* 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_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`rtd`	QuotesES	Code		`Formula`
`rtd`	QuotesES	Symbol	`=RTD("esrtd",,[Code],"Symbol")`	`PK`
`rtd`	QuoteDayHistoryES	Code		`Formula`
`rtd`	QuoteDayHistoryES	Symbol	`=RTD("esrtd",,[Code],"Symbol")`	`PK`
`rtd`	QuoteDayHistoryES	Date	`=Date()`	`PK`
`rtd`	QuoteTimeHistoryES	Code		`Formula`
`rtd`	QuoteTimeHistoryES	Symbol	`=RTD("esrtd",,[Code],"Symbol")`	`PK`
`rtd`	QuoteTimeHistoryES	Date	`=Date()`	`PK`
`rtd`	QuoteTimeHistoryES	Time	`=RTD("esrtd",,[Code],"Time")`	`PK`
`rtd`	QuoteTickHistoryES	Code		`Formula`
`rtd`	QuoteTickHistoryES	ID		`PK, IDENTITY`

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`rtd`	quotes_es	CODE		`Formula`
`rtd`	quotes_es	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`rtd`	quote_day_history_es	CODE		`Formula`
`rtd`	quote_day_history_es	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`rtd`	quote_day_history_es	DATE	`=Date()`	`PK`
`rtd`	quote_time_history_es	CODE		`Formula`
`rtd`	quote_time_history_es	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`rtd`	quote_time_history_es	DATE	`=Date()`	`PK`
`rtd`	quote_time_history_es	TIME	`=RTD("esrtd",,[CODE],"Time")`	`PK`
`rtd`	quote_tick_history_es	CODE		`Formula`
`rtd`	quote_tick_history_es	ID		`PK, IDENTITY`

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`RTD`	QUOTES_ES	CODE		`Formula`
`RTD`	QUOTES_ES	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`RTD`	QUOTE_DAY_HISTORY_ES	CODE		`Formula`
`RTD`	QUOTE_DAY_HISTORY_ES	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`RTD`	QUOTE_DAY_HISTORY_ES	DATE	`=Date()`	`PK`
`RTD`	QUOTE_TICK_HISTORY_ES	CODE		`Formula`
`RTD`	QUOTE_TICK_HISTORY_ES	ID		`PK, IDENTITY`
`RTD`	QUOTE_TIME_HISTORY_ES	CODE		`Formula`
`RTD`	QUOTE_TIME_HISTORY_ES	SYMBOL	`=RTD("esrtd",,[CODE],"Symbol")`	`PK`
`RTD`	QUOTE_TIME_HISTORY_ES	DATE	`=Date()`	`PK`
`RTD`	QUOTE_TIME_HISTORY_ES	TIME	`=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_NAME	RTD_FORMULA	COMMENT
Code		`Formula`
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_NAME	RTD_FORMULA	COMMENT
Code		`Formula`
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_NAME	RTD_FORMULA	COMMENT
Code		`Formula`
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_NAME	RTD_FORMULA	COMMENT
Code		`Formula`
ID		`PK, 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_NAME	RTD_FORMULA	COMMENT
CODE		`Formula`
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_NAME	RTD_FORMULA	COMMENT
CODE		`Formula`
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_NAME	RTD_FORMULA	COMMENT
CODE		`Formula`
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_NAME	RTD_FORMULA	COMMENT
CODE		`Formula`
ID		`PK, 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")`