Skip to main content
Schema: 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
Important Relationships:
  • Base table: core__ez_token_transfers
  • Label data: core__dim_labels (filtered for label_type = ‘cex’)
Commonly-used Fields:
  • direction: Classification as ‘deposit’, ‘withdrawal’, ‘internal_transfer’, or ‘inter_exchange_transfer’
  • exchange_name: Name of the CEX involved in the transfer
  • amount_usd: USD value of the flow
  • sender/receiver: Party IDs for detailed flow tracking
Direction Logic:
  • 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
Important Notes:
  • 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 NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update
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
OUTPUT_INDEXNUMBERIndex of this output within the transfer
SENDERTEXTParty sending the tokens
PROVIDERTEXTValidator/provider facilitating the transfer
RECEIVERTEXTParty receiving the tokens
AMOUNT_RAWNUMBERRaw transfer amount before decimal adjustment
AMOUNTNUMBERHuman-readable transfer amount
AMOUNT_USDFLOATUSD value of the transfer
PRICEFLOATToken price in USD at time of transfer
SYMBOLTEXTToken symbol
DECIMALSNUMBERToken decimal places
TOKEN_IS_VERIFIEDBOOLEANToken verification status
RECEIVER_FEE_RATIONUMBERFee ratio for the receiver
LOCKVARIANTLock details if applicable
TX_KINDTEXTTransaction kind metadata
EZ_TOKEN_TRANSFERS_IDTEXTSurrogate key from base table
INSERTED_TIMESTAMPTIMESTAMP_NTZRecord insertion timestamp
MODIFIED_TIMESTAMPTIMESTAMP_NTZRecord modification timestamp
EXCHANGE_NAMETEXTName of the CEX involved (from label project_name)
DIRECTIONTEXTFlow 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_EXCHANGETEXTName 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).