CURVE_MARKET_DATA

The CURVE_MARKET_DATA table contains market data defined along a tenor axis. It is an isolated table and not part of any cube facts.

Column Name Type Not Null Default Value1 Description
AS_OF_DATE DATE Y Timestamp (at close of business) for the data.
MARKET_DATA_SET STRING Y String defining the market data set, for example “Trader marks” or “Official EOD”.
CURVE_ID STRING Y The ID of the curve to which the market data relates.
TENOR STRING Y Tenor labels, such as 3M, 5Y and so on.
QUOTE DOUBLE Y The quote for the tenor.

Unique Key

Columns
AS_OF_DATE
MARKET_DATA_SET
INSTRUMENT_ID
TENOR

  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.  ↩︎