Table Details
| Property | Value |
|---|---|
| Table Name | dydx.raw.oracle_updates |
| Table Status | Production-Ready |
| Clustering Key(s) | to_date("effective_at") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| ticker | VARCHAR(16777216) | Market ticker symbol identifying the traded instrument. |
| oracle_price | VARCHAR(16777216) | Oracle-reported price for the market. |
| effective_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) at which the oracle price became effective. |
| effective_at_height | NUMBER(38,0) | Block height at which the oracle price became effective. |
| market_id | NUMBER(38,0) | Identifier of the market this record pertains to. |
| _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. |