Skip to main content
Schema: canton.price Table: ez_asset_metadata Type: Base Table

​
What

Analytics-ready token asset metadata for Canton blockchain. This table provides reference data for all tokens available on Canton, including token symbols, names, decimals, and verification status. Key Use Cases:
  • Token lookup and identification
  • Decimal conversion for raw amounts
  • Token verification status checks
  • Native token (Amulet/CNS) identification
Important Relationships:
  • Join to price__ez_prices_hourly on token_address for price data
  • Join to core transfer/balance tables for token amount conversions
Commonly-used Fields:
  • token_address: Primary identifier for joining with other tables
  • symbol: Human-readable token symbol
  • decimals: Required for converting raw amounts to human-readable values
  • is_native: Flag for identifying Canton’s native token (Amulet/CNS)

​
Columns

Column NameData TypeDescription
TOKEN_ADDRESSTEXTToken address identifier for the asset on Canton
ASSET_IDTEXTUnique identifier for the asset across the crosschain database
SYMBOLTEXTToken symbol (e.g., CNS, USDC)
NAMETEXTFull name of the token
DECIMALSNUMBERNumber of decimal places for the token
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
TOKEN_IS_VERIFIEDBOOLEANBoolean indicating if this token has been verified
EZ_ASSET_METADATA_IDTEXTSurrogate key generated from completetokenassetmetadataid
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted into this table
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified