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

# Market Updates

### Table Details

| Property          | Value                     |
| ----------------- | ------------------------- |
| Table Name        | `dydx.raw.market_updates` |
| Table Status      | Production-Ready          |
| Clustering Key(s) | `to_date("ingested_at")`  |

### Table Columns

| Column Name                   | Data Type         | Description                                                                                               |
| ----------------------------- | ----------------- | --------------------------------------------------------------------------------------------------------- |
| ticker                        | VARCHAR(16777216) | Market ticker symbol identifying the traded instrument.                                                   |
| clob\_pair\_id                | VARCHAR(16777216) | Identifier of the central limit order book (CLOB) pair for this market.                                   |
| atomic\_resolution            | NUMBER(38,0)      | Number of decimal places used to convert the market's atomic (integer) quantities to human-readable size. |
| status                        | VARCHAR(16777216) | Current status of the market (e.g. active, paused).                                                       |
| price\_change\_24h            | VARCHAR(16777216) | Price change over the trailing 24 hours.                                                                  |
| volume\_24h                   | VARCHAR(16777216) | Trading volume over the trailing 24 hours.                                                                |
| trades\_24h                   | NUMBER(38,0)      | Number of trades over the trailing 24 hours.                                                              |
| next\_funding\_rate           | VARCHAR(16777216) | Funding rate to be applied at the next funding interval.                                                  |
| initial\_margin\_fraction     | VARCHAR(16777216) | Initial margin fraction required to open a position in this market.                                       |
| maintenance\_margin\_fraction | VARCHAR(16777216) | Maintenance margin fraction required to keep a position open in this market.                              |
| open\_interest                | VARCHAR(16777216) | Total open interest in this market.                                                                       |
| base\_open\_interest          | VARCHAR(16777216) | Open interest expressed in the base asset.                                                                |
| quantum\_conversion\_exponent | NUMBER(38,0)      | Exponent used to convert quote quantums to full quote units.                                              |
| step\_base\_quantums          | NUMBER(38,0)      | Minimum increment of order size, in base quantums.                                                        |
| subticks\_per\_tick           | NUMBER(38,0)      | Number of subticks per tick, defining price granularity.                                                  |
| base\_asset                   | VARCHAR(16777216) | Base asset of the perpetual market.                                                                       |
| quote\_asset                  | VARCHAR(16777216) | Quote asset of the perpetual market.                                                                      |
| id                            | VARCHAR(16777216) | Identifier of this market update record.                                                                  |
| market\_id                    | NUMBER(38,0)      | Identifier of the market this record pertains to.                                                         |
| base\_position\_size          | VARCHAR(16777216) | Aggregate position size expressed in the base asset.                                                      |
| incremental\_position\_size   | VARCHAR(16777216) | Change in aggregate position size in this update.                                                         |
| max\_position\_size           | VARCHAR(16777216) | Maximum allowed position size in this market.                                                             |
| ingested\_at                  | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when this record was ingested into the Allium platform.                                   |
| \_created\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                  |
| \_updated\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                             |