Skip to main content
Schema: monad.core Table: ez_token_transfers Type: View

​
What

This convenience table provides a comprehensive view of all ERC-20 token transfers with enriched metadata including decimal adjustments, USD values, and token information. It simplifies token flow analysis by joining transfer events with contract details and price data.

​
Key Use Cases

​
Columns

Column NameData TypeDescription
AMOUNTFLOATDecimal-adjusted token amount for human-readable values.
…
AMOUNT_PRECISEFLOATString representation of decimal-adjusted amount preservi…
AMOUNT_USDFLOATUSD value of the token transfer at transaction time.
Exa… | | BLOCK_NUMBER | NUMBER | Sequential counter representing the position of a block i… | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the block was produced by validators/m… | | CONTRACT_ADDRESS | TEXT | The contract address for the token transfer. Example: ‘0… | | DECIMALS | TEXT | Number of decimal places for token amounts, read directly… | | EVENT_INDEX | NUMBER | Zero-based sequential position of the event within a tran… | | EZ_TOKEN_TRANSFERS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | FROM_ADDRESS | TEXT | The from address for the token transfer. This may or may … | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | NAME | TEXT | Human-readable contract name from the name() function. E… | | ORIGIN_FROM_ADDRESS | TEXT | The externally-owned account (EOA) or contract address th… | | ORIGIN_FUNCTION_SIGNATURE | TEXT | Function signature (first 4 bytes) of the called method. … | | ORIGIN_TO_ADDRESS | TEXT | The destination address for the transaction - either an E… | | RAW_AMOUNT | NUMBER | Original token amount without decimal adjustment. Exampl… | | RAW_AMOUNT_PRECISE | NUMBER | String representation of raw amount for precision preserv… | | SYMBOL | TEXT | Token/contract symbol from the symbol() function. Exampl… | | TOKEN_IS_VERIFIED | TEXT | Boolean flag indicating if the token is verified by the F… | | TOKEN_STANDARD | TEXT | The token standard for the transfer, in this case always … | | TO_ADDRESS | TEXT | The to address for the token transfer. This may or may no… | | TX_HASH | TEXT | Unique 66-character identifier for the transaction. **Fo… | | TX_POSITION | TEXT | Zero-indexed position of transaction within its block. *… |