Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The ERC1155 Token Transfers table records all transfers from the event log TransferSingle and TransferBatch.

Table Columns

Unique Key: unique_id
Column NameData TypeDescription
event_typeVARCHARType of transfer event for ERC1155 tokens. This can either be single_transfer or batch_transfer.
operatorVARCHARAddress of the ERC1155 operator.
from_addressVARCHARAddress where the token is being transferred from.
to_addressVARCHARAddress where the token is being transferred to.
token_addressVARCHARToken address of the asset transferred.
token_nameVARCHARToken name.
token_symbolVARCHARToken symbol.
token_idVARCHARThe token ID of the token.
raw_amount_strVARCHARAmount of token transferred, unnormalized, in string (to retain precision).
raw_amountFLOATAmount of tokens transferred, unnormalized.
amount_strVARCHARAmount of token transferred, normalized, in string (to retain precision).
amountFLOATAmount of token transferred, normalized.
transaction_from_addressVARCHARThe address of the sending party of this transaction.
transaction_to_addressVARCHARThe address of the receiving party of this transaction (could be a contract address).
transaction_hashVARCHARThe transaction hash that this transfer belongs to.
transaction_indexBIGINTThe position of this transaction in the block. The first transaction of a block has index 0.
log_indexBIGINTThe position of this log within the block. The first log of a block has index 0.
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this transaction was included on the blockchain.
block_numberBIGINTThe block number that the corresponding transaction of this transfer belongs to.
block_hashVARCHARThe block hash that the corresponding transaction of this transfer belongs to.
unique_idVARCHARUnique ID generated for each transfer.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh.