Skip to main content
Schema: 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
Important Notes:
  • 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 NameData TypeDescription
HOURTIMESTAMP_NTZHourly timestamp for the price snapshot
TOKEN_ADDRESSTEXTToken address identifier for the asset on Canton
SYMBOLTEXTToken symbol (e.g., CNS, USDC)
NAMETEXTFull name of the token
DECIMALSNUMBERNumber of decimal places for the token
PRICEFLOATUSD price of the token at the given hour
BLOCKCHAINTEXTBlockchain identifier (always ‘canton’ for this model)
IS_NATIVEBOOLEANBoolean flag indicating if this is the native Canton token (Amulet/CNS)
IS_DEPRECATEDBOOLEANBoolean indicating if this token is deprecated
IS_IMPUTEDBOOLEANBoolean indicating if this price was imputed/estimated
TOKEN_IS_VERIFIEDBOOLEANBoolean indicating if this token has been verified
EZ_PRICES_HOURLY_IDTEXTSurrogate key generated from token_address and hour
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted into this table
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified