Table Details
| Property | Value |
|---|---|
| Table Name | kinto.prices.hourly |
| Table Status | Deprecated ◽ |
| Unique Key | timestamp, address |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(134217728) | The blockchain network name. |
| id | VARCHAR(134217728) | The unique identifier of the token (e.g., CoinGecko ID). |
| symbol | VARCHAR(134217728) | The ticker symbol of the token. |
| address | VARCHAR(134217728) | The contract address of the token. |
| decimals | NUMBER(38,0) | The number of decimal places for the token. |
| timestamp | TIMESTAMP_NTZ(9) | The hourly timestamp for the price data point. |
| price | VARCHAR(134217728) | The token price in USD at the given timestamp. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |