flow.core_evm Table: ez_token_transfers Type: Base Table
Description
A curated and enriched table containing token transfer events across EVM-compatible blockchains. This table consolidates token transfer data from event logs, providing a comprehensive view of all token movements including ERC-20, ERC-721, and other token standards. The table includes enriched metadata such as token names, symbols, decimals, and USD values, making it the primary source for token transfer analysis. Each record represents a single token transfer with complete context and enriched data.Key Use Cases
- Token Transfer Analysis: Tracking token movements and transfer patterns across EVM chains
- Portfolio Tracking: Monitoring token holdings and transfer activities for specific addresses
- Token Economics: Analyzing token distribution, circulation, and economic activity
- DeFi Analysis: Understanding token flows in DeFi protocols and yield farming activities
- Cross-Chain Token Analysis: Comparing token transfer patterns across different EVM-compatible blockchains
- Token Performance: Monitoring token usage, adoption, and transfer volume trends
Important Relationships
- core_evm__fact_event_logs: Links to underlying event logs that generated these transfers
- core_evm__fact_transactions: Links to transactions that triggered these transfers
- core_evm__dim_contracts: Links to token contract metadata for transfer analysis
- core_evm__dim_labels: Links to address labels for user and contract identification
- price__ez_prices_hourly: Links to token prices for USD value calculations
- core__ez_token_transfers: May provide comparison data with native Flow token transfers
Commonly-used Fields
- FROM_ADDRESS/TO_ADDRESS: Essential for transfer flow analysis and user behavior studies
- CONTRACT_ADDRESS: Critical for token identification and contract-specific analysis
- AMOUNT/AMOUNT_USD: Important for transfer value analysis and economic activity tracking
- TOKEN_STANDARD: Key for token type categorization and standard-specific analysis
- SYMBOL/NAME: Critical for token identification and user interface display
- BLOCK_TIMESTAMP: Essential for time-series analysis and temporal transfer tracking
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| TX_POSITION | NUMBER | The position of the transaction within the block. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| FROM_ADDRESS | TEXT | The sending address of this transfer. |
| TO_ADDRESS | TEXT | The receiving address of this transfer. This can be a contract address. |
| CONTRACT_ADDRESS | TEXT | The address of the contract that the event log was emitted from. |
| TOKEN_STANDARD | TEXT | The type of token transferred in this event, for example erc721, erc1155, or erc20. |
| TOKEN_IS_VERIFIED | BOOLEAN | |
| NAME | TEXT | The name of the deployed contract. Please note this is not necessarily unique. |
| SYMBOL | TEXT | The symbol used to represent this contract. Please note this is not necessarily unique. |
| DECIMALS | NUMBER | The decimals for the token contract. |
| RAW_AMOUNT_PRECISE | TEXT | The amount of tokens transferred returned as a string to preserve precision. This value is not decimal adjusted. |
| RAW_AMOUNT | FLOAT | The amount of tokens transferred. This value is not decimal adjusted. |
| AMOUNT_PRECISE | TEXT | The decimal transformed amount for this token returned as a string to preserve precision. Tokens without a decimal adjustment will be nulled out here. |
| AMOUNT | FLOAT | The decimal transformed amount for this token. Tokens without a decimal adjustment will be nulled out here. |
| AMOUNT_USD | FLOAT | The amount in US dollars for this transfer at the time of the transfer. Tokens without a decimal adjustment or price will be nulled out here. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of the call that triggered this transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address at the transaction level. |
| ORIGIN_TO_ADDRESS | TEXT | The to address at the transaction level. |
| EZ_TOKEN_TRANSFERS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was last modified. |