Table Details
| Property | Value |
|---|---|
| Table Name | dydx.raw.markets |
| 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. |
| tick_size | VARCHAR(16777216) | Minimum increment allowed for order price in this market. |
| step_size | VARCHAR(16777216) | Minimum increment allowed for order size in this market. |
| market_type | VARCHAR(16777216) | Type of market (e.g. perpetual). |
| open_interest_lower_cap | VARCHAR(16777216) | Lower cap on open interest for the market. |
| open_interest_upper_cap | VARCHAR(16777216) | Upper cap on open interest for the market. |
| default_funding_rate_1h | VARCHAR(16777216) | Default hourly funding rate for the 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. |