blast.core Table: ez_native_transfers Type: View
This convenience table contains all transfers for the chain’s native asset, sourced from internal
traces (core.fact_traces), and includes decimal adjusted and USD values where available. The
origin addresses correspond to the to and from addresses in the core.fact_transactions table.
Note, this table does not contain ERC-721 and ERC-1155 token transfers, instead please use
nft.ez_nft_transfers.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. This will not be unique in this table as a transaction could include multiple transfer events. |
| 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_POSITION | NUMBER | The position of the transaction within the block. |
| TRACE_INDEX | NUMBER | The index of the trace within the transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address of this transaction. |
| ORIGIN_TO_ADDRESS | TEXT | The to address of this transaction. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of this 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. |
| AMOUNT | FLOAT | ETH value transferred. |
| AMOUNT_PRECISE_RAW | TEXT | The precise, unadjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| AMOUNT_PRECISE | TEXT | The precise, adjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| AMOUNT_USD | FLOAT | ETH value transferred, in USD. |
| 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. |
| IDENTIFIER | TEXT | This column is being deprecated for standardization purposes. Please update your queries to use the trace_address column instead by March 10, 2025. |