flow.core_evm Table: ez_native_transfers Type: Base Table
Description
A curated and enriched table containing native token transfer events across EVM-compatible blockchains. This table consolidates native token (e.g., ETH, BNB, AVAX) transfer data from execution traces, providing a comprehensive view of all native token movements. The table includes enriched metadata such as USD values and transfer context, making it the primary source for native token transfer analysis. Each record represents a single native token transfer with complete context and enriched data.Key Use Cases
- Native Token Analysis: Tracking native token movements and transfer patterns across EVM chains
- Value Flow Analysis: Understanding how native tokens flow through the ecosystem
- Gas Economics: Analyzing gas fee payments and native token usage for transaction costs
- Cross-Chain Native Analysis: Comparing native token transfer patterns across different EVM-compatible blockchains
- User Behavior Analysis: Understanding how users transfer native tokens for various purposes
- Network Economics: Monitoring native token distribution and economic activity
Important Relationships
- core_evm__fact_traces: Links to underlying execution traces that generated these transfers
- core_evm__fact_transactions: Links to transactions that triggered these transfers
- core_evm__dim_labels: Links to address labels for user and contract identification
- price__ez_prices_hourly: Links to native token prices for USD value calculations
- core_evm__ez_token_transfers: May provide comparison data with token transfers
- core__ez_token_transfers: May provide comparison data with native Flow transfers
Commonly-used Fields
- FROM_ADDRESS/TO_ADDRESS: Essential for transfer flow analysis and user behavior studies
- AMOUNT/AMOUNT_USD: Important for transfer value analysis and economic activity tracking
- TYPE: Critical for transfer type categorization and analysis
- TRACE_INDEX: Key for transfer ordering and execution sequence analysis
- TX_HASH: Essential for transaction linking and blockchain verification
- BLOCK_TIMESTAMP: Critical 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. |
| TRACE_INDEX | NUMBER | The index of the trace within the transaction. |
| TRACE_ADDRESS | TEXT | The trace address for this trace. |
| TYPE | TEXT | The type of internal transaction. Common trace types are CALL, DELEGATECALL, and STATICCALL. |
| FROM_ADDRESS | TEXT | The sending address of this transfer. |
| TO_ADDRESS | TEXT | The receiving address of this transfer. This can be a contract address. |
| AMOUNT | FLOAT | The decimal transformed amount for this token. Tokens without a decimal adjustment will be nulled out here. |
| AMOUNT_PRECISE_RAW | TEXT | The amount of tokens transferred returned as a string to preserve precision. 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_USD | FLOAT | Native asset value transferred, in USD. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address at the transaction level. |
| ORIGIN_TO_ADDRESS | TEXT | The to address at the transaction level. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of the call that triggered this transaction. |
| EZ_NATIVE_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. |