Skip to main content
The SPOT_MARKET_DATA table contains spot price market data. It is an isolated table and not part of any cube facts.
Column NameTypeNot NullDefault Value1Description
AS_OF_DATEDATEYTimestamp (at close of business) for the data.
MARKET_DATA_SETSTRINGYString defining the market data set, for example “Trader marks” or “Official EOD”.
INSTRUMENT_IDSTRINGYThe ID of the instrument to which the market data relates.
QUOTEDOUBLEYThe quote for the market data.

Unique Key

Columns
AS_OF_DATE
MARKET_DATA_SET
INSTRUMENT_ID

  1. If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields.  ↩︎