Skip to main content
Schema: sei.core_evm Table: ez_token_transfers Type: Base Table This table contains events on the Avalanche Blockchain with an event name of ‘Transfer’. The contract address is the token transferred, and the raw amount field is the amount of tokens transferred. Please note this amount is not decimal adjusted. Decimal adjustments for a token address can be found in dim_contracts. This table will not contain transfers of native ETH.

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.
TX_POSITIONNUMBER
EVENT_INDEXNUMBEREvent number within a transaction.
FROM_ADDRESSTEXTThe sending address of this transfer.
TO_ADDRESSTEXTThe receiving address of this transfer. This can be a contract address.
CONTRACT_ADDRESSTEXTContract address of the token being transferred.
TOKEN_STANDARDTEXT
TOKEN_IS_VERIFIEDBOOLEAN
NAMETEXT
SYMBOLTEXTThe symbol belonging to the address of the token
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.
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_USDFLOAT
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe from address of this transaction.
ORIGIN_TO_ADDRESSTEXTThe to address of this transaction.
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.