canton.price Table: ez_prices_hourly Type: Base Table
What
Analytics-ready hourly token prices for Canton blockchain. This table provides clean, deduplicated price data with additional metadata flags including native token identification (Amulet/CNS) and verification status. Key Use Cases:- Historical price analysis for Canton tokens
- USD value calculations for transfer amounts
- Native token (Amulet) price tracking
- Token verification and deprecation monitoring
- Prices are in USD and represent the close price rolled forward 1 hour
- Deduplicated by token_address and hour using most recent modified_timestamp
- Includes both native Canton tokens and other assets on the network
- Native token (Amulet/CNS) is flagged with is_native = TRUE
Columns
| Column Name | Data Type | Description |
|---|---|---|
| HOUR | TIMESTAMP_NTZ | Hourly timestamp for the price snapshot |
| TOKEN_ADDRESS | TEXT | Token address identifier for the asset on Canton |
| SYMBOL | TEXT | Token symbol (e.g., CNS, USDC) |
| NAME | TEXT | Full name of the token |
| DECIMALS | NUMBER | Number of decimal places for the token |
| PRICE | FLOAT | USD price of the token at the given hour |
| BLOCKCHAIN | TEXT | Blockchain identifier (always ‘canton’ for this model) |
| IS_NATIVE | BOOLEAN | Boolean flag indicating if this is the native Canton token (Amulet/CNS) |
| IS_DEPRECATED | BOOLEAN | Boolean indicating if this token is deprecated |
| IS_IMPUTED | BOOLEAN | Boolean indicating if this price was imputed/estimated |
| TOKEN_IS_VERIFIED | BOOLEAN | Boolean indicating if this token has been verified |
| EZ_PRICES_HOURLY_ID | TEXT | Surrogate key generated from token_address and hour |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted into this table |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified |