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 Name | Data Type | Description |
|---|---|---|
| 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_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. |
| TX_POSITION | NUMBER | |
| EVENT_INDEX | NUMBER | Event number within a 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. |
| CONTRACT_ADDRESS | TEXT | Contract address of the token being transferred. |
| TOKEN_STANDARD | TEXT | |
| TOKEN_IS_VERIFIED | BOOLEAN | |
| NAME | TEXT | |
| SYMBOL | TEXT | The symbol belonging to the address of the token |
| DECIMALS | NUMBER | The 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_PRECISE | TEXT | The amount of tokens transferred returned as a string to preserve precision. This value is not decimal adjusted. |
| RAW_AMOUNT | FLOAT | The amount of tokens transferred. This value is not decimal adjusted. |
| AMOUNT_PRECISE | TEXT | The decimal transformed amount for this token returned as a string to preserve precision. Tokens without a decimal adjustment will be nulled out here. |
| AMOUNT | FLOAT | The decimal transformed amount for this token. Tokens without a decimal adjustment will be nulled out here. |
| AMOUNT_USD | FLOAT | |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of this transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address of this transaction. |
| ORIGIN_TO_ADDRESS | TEXT | The to address of this transaction. |
| EZ_TOKEN_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. |