Skip to main content
Schema: blast.core Table: ez_token_transfers Type: View This convenience table contains emitted event logs for ERC-20 Token Transfers (e.g. Transfer: topic_0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef), including decimal adjusted values, USD values, and other helpful token metadata where available for each transfer event. The contract address is the token transferred, and the raw amount field is the amount of tokens transferred. Note, this table does not contain ERC-721 and ERC-1155 token transfers, instead please use nft.ez_nft_transfers. Additionally, this table does not contain transfers of the chain’s native asset, instead please use core.ez_native_transfers.

​
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. This will not be unique in this table as a transaction could include multiple transfer events.
EVENT_INDEXNUMBEREvent number within a transaction.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe from address at the transaction level.
ORIGIN_TO_ADDRESSTEXTThe to address at the transaction level.
CONTRACT_ADDRESSTEXTContract address of the token being transferred.
FROM_ADDRESSTEXTThe sending address of this transfer.
TO_ADDRESSTEXTThe receiving address of this transfer. This can be a contract address.
RAW_AMOUNT_PRECISETEXTThe amount of tokens transferred returned as a string to preserve precision. This value is not decimal adjusted.
RAW_AMOUNTFLOATThe amount of tokens transferred. 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.
AMOUNTFLOATThe decimal transformed amount for this token. Tokens without a decimal adjustment will be nulled out here.
AMOUNT_USDFLOATThe 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.
DECIMALSNUMBERThe number of decimal places this contract needs adjusted where token values exist. For example, use the decimal field to correctly transform raw amounts in fact_token_transfers.
SYMBOLTEXTThe symbol belonging to the address of the token
EZ_TOKEN_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.
_INSERTED_TIMESTAMPTIMESTAMP_LTZThis column is being removed for standardization purposes. Please update your queries to use the modified_timestamp column instead by March 10, 2025.
TOKEN_PRICEFLOATThis column is being deprecated for standardization purposes. Please remove from your queries by March 10, 2025.