Skip to main content
Schema: canton.core Table: ez_token_transfers Type: Base Table

What

Analytics-ready token transfers with price enrichment for Canton blockchain. This table extends the base transfers fact table by adding human-readable amounts, USD values, and token metadata for easy analysis. Key Use Cases:
  • Transfer value analysis in both native units and USD
  • Historical transfer tracking with consistent decimal handling
  • Foundation for CEX flow analysis and other enriched views
Important Relationships:
  • Base table: core__fact_transfers
  • Price data: price__ez_prices_hourly
  • Used by: core__ez_cex_flows
Commonly-used Fields:
  • sender/receiver: Party IDs involved in the transfer
  • amount: Human-readable transfer amount (adjusted for decimals)
  • amount_usd: USD value at time of transfer
  • effective_at: Transfer timestamp

Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update containing this event
MIGRATION_IDNUMBERCanton migration identifier
RECORD_TIMETIMESTAMP_NTZNode record timestamp
EFFECTIVE_ATTIMESTAMP_NTZEffective timestamp of the transfer
EVENT_IDTEXTUnique identifier for the transfer event
EVENT_INDEXNUMBERIndex of this event within the update
CHOICETEXTTransfer choice type (always AmuletRules_Transfer)
OUTPUT_INDEXNUMBERIndex of this output within the transfer outputs array
SENDERTEXTParty sending the tokens
PROVIDERTEXTValidator/provider facilitating the transfer
RECEIVERTEXTParty receiving this output
AMOUNT_RAWNUMBERRaw transfer amount before decimal adjustment
AMOUNTNUMBERHuman-readable transfer amount (adjusted for token decimals)
AMOUNT_USDFLOATUSD value of the transfer at the time of execution
PRICEFLOATToken price in USD at the hour of transfer
SYMBOLTEXTToken symbol (e.g., CNS for Canton native token)
DECIMALSNUMBERNumber of decimal places for the token
TOKEN_IS_VERIFIEDBOOLEANBoolean indicating if the token is verified
RECEIVER_FEE_RATIONUMBERFee ratio for this receiver output
LOCKVARIANTLock details if this output creates a locked amulet
TX_KINDTEXTTransaction kind from transfer metadata
EZ_TOKEN_TRANSFERS_IDTEXTSurrogate key for this transfer output
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when record was inserted
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when record was last modified