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
- Base table:
core__fact_transfers - Price data:
price__ez_prices_hourly - Used by:
core__ez_cex_flows
sender/receiver: Party IDs involved in the transferamount: Human-readable transfer amount (adjusted for decimals)amount_usd: USD value at time of transfereffective_at: Transfer timestamp
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | Unique identifier for the Canton update containing this event |
| MIGRATION_ID | NUMBER | Canton migration identifier |
| RECORD_TIME | TIMESTAMP_NTZ | Node record timestamp |
| EFFECTIVE_AT | TIMESTAMP_NTZ | Effective timestamp of the transfer |
| EVENT_ID | TEXT | Unique identifier for the transfer event |
| EVENT_INDEX | NUMBER | Index of this event within the update |
| CHOICE | TEXT | Transfer choice type (always AmuletRules_Transfer) |
| OUTPUT_INDEX | NUMBER | Index of this output within the transfer outputs array |
| SENDER | TEXT | Party sending the tokens |
| PROVIDER | TEXT | Validator/provider facilitating the transfer |
| RECEIVER | TEXT | Party receiving this output |
| AMOUNT_RAW | NUMBER | Raw transfer amount before decimal adjustment |
| AMOUNT | NUMBER | Human-readable transfer amount (adjusted for token decimals) |
| AMOUNT_USD | FLOAT | USD value of the transfer at the time of execution |
| PRICE | FLOAT | Token price in USD at the hour of transfer |
| SYMBOL | TEXT | Token symbol (e.g., CNS for Canton native token) |
| DECIMALS | NUMBER | Number of decimal places for the token |
| TOKEN_IS_VERIFIED | BOOLEAN | Boolean indicating if the token is verified |
| RECEIVER_FEE_RATIO | NUMBER | Fee ratio for this receiver output |
| LOCK | VARIANT | Lock details if this output creates a locked amulet |
| TX_KIND | TEXT | Transaction kind from transfer metadata |
| EZ_TOKEN_TRANSFERS_ID | TEXT | Surrogate key for this transfer output |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when record was inserted |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when record was last modified |