Skip to main content
Schema: 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 NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
TX_POSITIONNUMBERThe position of the transaction within the block.
TRACE_INDEXNUMBERThe index of the trace within the transaction.
TRACE_ADDRESSTEXTThe trace address for this trace.
TYPETEXTThe type of internal transaction. Common trace types are CALL, DELEGATECALL, and STATICCALL.
FROM_ADDRESSTEXTThe sending address of this transfer.
TO_ADDRESSTEXTThe receiving address of this transfer. This can be a contract address.
AMOUNTFLOATThe decimal transformed amount for this token. Tokens without a decimal adjustment will be nulled out here.
AMOUNT_PRECISE_RAWTEXTThe amount of tokens transferred returned as a string to preserve precision. This value is not decimal adjusted.
AMOUNT_PRECISETEXTThe decimal transformed amount for this token returned as a string to preserve precision. Tokens without a decimal adjustment will be nulled out here.
AMOUNT_USDFLOATNative asset value transferred, in USD.
ORIGIN_FROM_ADDRESSTEXTThe from address at the transaction level.
ORIGIN_TO_ADDRESSTEXTThe to address at the transaction level.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of the call that triggered this transaction.
EZ_NATIVE_TRANSFERS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.