Table Details
| Property | Value |
|---|---|
| Table Name | canton.prices.hourly |
| Table Status | Production-Ready |
| Unique Key | timestamp, address |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | The hourly timestamp for the price data point. |
| chain | VARCHAR(16777216) | The blockchain network name. |
| address | VARCHAR(16777216) | The contract address of the token. |
| symbol | VARCHAR(16777216) | The ticker symbol of the token. |
| price | VARCHAR(16777216) | The token price in USD at the given timestamp. |
| decimals | NUMBER(38,0) | The number of decimal places for the token. |
| _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. |