canton.core Table: ez_cex_flows Type: View
What
Centralized exchange (CEX) deposit, withdrawal, and internal transfer flows for Canton. This view filters token transfers to show only those involving CEX addresses, with directional classification and exchange identification. Key Use Cases:- Track CEX deposit and withdrawal volumes
- Identify CEX-to-CEX internal transfers
- Monitor exchange activity and liquidity flows
- Analyze specific exchange behavior on Canton
- Base table:
core__ez_token_transfers - Label data:
core__dim_labels(filtered for label_type = ‘cex’)
direction: Classification as ‘deposit’, ‘withdrawal’, ‘internal_transfer’, or ‘inter_exchange_transfer’exchange_name: Name of the CEX involved in the transferamount_usd: USD value of the flowsender/receiver: Party IDs for detailed flow tracking
- deposit: Tokens flowing TO a CEX address (receiver is CEX)
- withdrawal: Tokens flowing FROM a CEX address (sender is CEX)
- internal_transfer: Both sender and receiver are the same CEX
- inter_exchange_transfer: Transfer between two different CEXs
- Only includes transfers where at least one party is labeled as a CEX
- Requires CEX addresses to be properly labeled in
core__dim_labels - View materialization provides real-time filtering on base transfers table
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | Unique identifier for the Canton update |
| 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 |
| OUTPUT_INDEX | NUMBER | Index of this output within the transfer |
| SENDER | TEXT | Party sending the tokens |
| PROVIDER | TEXT | Validator/provider facilitating the transfer |
| RECEIVER | TEXT | Party receiving the tokens |
| AMOUNT_RAW | NUMBER | Raw transfer amount before decimal adjustment |
| AMOUNT | NUMBER | Human-readable transfer amount |
| AMOUNT_USD | FLOAT | USD value of the transfer |
| PRICE | FLOAT | Token price in USD at time of transfer |
| SYMBOL | TEXT | Token symbol |
| DECIMALS | NUMBER | Token decimal places |
| TOKEN_IS_VERIFIED | BOOLEAN | Token verification status |
| RECEIVER_FEE_RATIO | NUMBER | Fee ratio for the receiver |
| LOCK | VARIANT | Lock details if applicable |
| TX_KIND | TEXT | Transaction kind metadata |
| EZ_TOKEN_TRANSFERS_ID | TEXT | Surrogate key from base table |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Record insertion timestamp |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Record modification timestamp |
| EXCHANGE_NAME | TEXT | Name of the CEX involved (from label project_name) |
| DIRECTION | TEXT | Flow direction relative to CEX: ‘deposit’ (to CEX), ‘withdrawal’ (from CEX), ‘internaltransfer’ (same CEX to same CEX), or ‘interexchange_transfer’ (CEX to different CEX) |
| INTER_EXCHANGE_TRANSFER_RECEIVING_EXCHANGE | TEXT | Name of the receiving exchange for inter-exchange transfers. Only populated when direction = ‘interexchangetransfer’ (transfer between two different CEXs). NULL for all other transfer types (deposits, withdrawals, internal transfers). |