Token Transfers
ERC1155 Transfers
Token Transfers
ERC1155 Transfers
Track movement of ERC1155 token transfers.
The ERC1155 Token Transfers table records all transfers from the event log TransferSingle and TransferBatch.
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| event_type | VARCHAR | Type of transfer event for ERC1155 tokens. This can either be single_transfer or batch_transfer. |
| operator | VARCHAR | Address of the ERC1155 operator. |
| from_address | VARCHAR | Address where the token is being transferred from. |
| to_address | VARCHAR | Address where the token is being transferred to. |
| token_address | VARCHAR | Token address of the asset transferred. |
| token_name | VARCHAR | Token name. |
| token_symbol | VARCHAR | Token symbol. |
| token_id | VARCHAR | The token ID of the token. |
| raw_amount_str | VARCHAR | Amount of token transferred, unnormalized, in string (to retain precision). |
| raw_amount | FLOAT | Amount of tokens transferred, unnormalized. |
| amount_str | VARCHAR | Amount of token transferred, normalized, in string (to retain precision). |
| amount | FLOAT | Amount of token transferred, normalized. |
| transaction_from_address | VARCHAR | The address of the sending party of this transaction. |
| transaction_to_address | VARCHAR | The address of the receiving party of this transaction (could be a contract address). |
| transaction_hash | VARCHAR | The transaction hash that this transfer belongs to. |
| transaction_index | BIGINT | The position of this transaction in the block. The first transaction of a block has index 0. |
| log_index | BIGINT | The position of this log within the block. The first log of a block has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| block_number | BIGINT | The block number that the corresponding transaction of this transfer belongs to. |
| block_hash | VARCHAR | The block hash that the corresponding transaction of this transfer belongs to. |
| unique_id | VARCHAR | Unique ID generated for each transfer. |