blast.core Table: fact_token_transfers Type: View
This table is being deprecated for standardization purposes. Please update your queries to use
ez_token_transfers instead by March 10, 2025.
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. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| 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. |
| CONTRACT_ADDRESS | TEXT | Contract address of the token being transferred. |
| FROM_ADDRESS | TEXT | The sending address of this transfer. |
| TO_ADDRESS | TEXT | The receiving address of this transfer. This can be a contract address. |
| RAW_AMOUNT | FLOAT | The amount of tokens transferred. This value is not decimal adjusted. |
| RAW_AMOUNT_PRECISE | TEXT | The amount of tokens transferred returned as a string to preserve precision. This value is not decimal adjusted. |
| FACT_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. |