> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CUBE_MARKET_DATA

The CUBE\_MARKET\_DATA table contains market data defined along three axes (tenors, moneyness, and underlying maturities).
It is an isolated table and not part of any cube facts.

<table><thead><tr><th>Column Name</th><th>Type</th><th>Not Null</th><th>Default Value<sup id="fnref:1"><a class="footnote-ref" href="#fn:1" role="doc-noteref">1</a></sup></th><th>Description</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td><td>DATE</td><td>Y</td><td /><td>Timestamp (at close of business) for the data.</td></tr><tr><td>MARKET\_DATA\_SET</td><td>STRING</td><td>Y</td><td /><td>String defining the market data set, for example “Trader marks” or “Official EOD”.</td></tr><tr><td>CUBE\_ID</td><td>STRING</td><td>Y</td><td /><td>The ID of the cube to which the market data relates.</td></tr><tr><td>TENOR</td><td>STRING</td><td>Y</td><td /><td>Tenor labels, such as 3M, 5Y and so on.</td></tr><tr><td>MONEYNESS</td><td>STRING</td><td>Y</td><td /><td>Moneyness labels.</td></tr><tr><td>UNDERLYING\_MATURITY</td><td>STRING</td><td>Y</td><td /><td>Moneyness, such as 3M, 5Y and so on.</td></tr><tr><td>QUOTE</td><td>DOUBLE</td><td>Y</td><td /><td>The quote for the tenor.</td></tr></tbody></table>

## Unique Key

<table><thead><tr><th>Columns</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td></tr><tr><td>MARKET\_DATA\_SET</td></tr><tr><td>CUBE\_ID</td></tr><tr><td>TENOR</td></tr><tr><td>MONEYNESS</td></tr><tr><td>UNDERLYING\_MATURITY</td></tr></tbody></table>

***

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.
    [↩︎](#fnref:1)