Table Details
| Property | Value |
|---|---|
| Table Name | dydx.raw.order_books |
| Table Status | Production-Ready |
| Clustering Key(s) | to_date("flushed_at") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| ticker | VARCHAR(16777216) | Market ticker symbol identifying the traded instrument. |
| flushed_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this order book state was flushed. |
| is_snapshot | BOOLEAN | Whether this row is a full snapshot (true) or an incremental update (false). |
| bids | VARIANT | Bid side of the order book snapshot. |
| asks | VARIANT | Ask side of the order book snapshot. |
| _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. |