Table Details
| Property | Value |
|---|---|
| Table Name | dydx.raw.trades |
| Table Status | Production-Ready |
| Clustering Key(s) | to_date("created_at") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| trade_id | VARCHAR(16777216) | Identifier of the trade. |
| ticker | VARCHAR(16777216) | Market ticker symbol identifying the traded instrument. |
| side | VARCHAR(16777216) | Side of the trade (buy or sell). |
| size | VARCHAR(16777216) | Size of the trade in the base asset. |
| price | VARCHAR(16777216) | Execution price of the trade. |
| type | VARCHAR(16777216) | Type of the trade (e.g. limit, market, liquidation). |
| created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the trade was created. |
| _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. |