> ## 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.

# Oracle Updates

### 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. |