If the instrument is a stock, data in the FIX message maps into a Stock Quote RDS message, and is stored in the STOCK_QUOTE table.
STOCK_QUOTE conditions
|
FIX message field
|
Table column
|
|
SecurityID/Symbol
|
INSTRUMENT_ID
|
|
TransactTime
|
QUOTE_DATE
|
|
QuoteID
|
QUOTE_SEQ_NBR
|
|
SecurityID/Symbol
|
TRADING_SYMBOL
|
|
TransactTime
|
QUOTE_TIME
|
|
OfferPx
|
ASK_PRICE
|
|
OfferSize
|
ASK_SIZE
|
|
BidPx
|
BID_PRICE
|
|
BidSize
|
BID_SIZE
|