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 a 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 to each transfer.