Skip to main content
The ERC1155 credit debit model combines ERC1155 transfers, allowing you to easily track the inflows and outflows of every ERC1155 token belonging to all addresses.

Table Columns

Unique Key: unique_id
Column NameData TypeDescription
event_typeVARCHARTransfer event type specific to ERC1155 tokens. Either ‘transfer_single’ or ‘batch_transfer’.
array_indexNUMBERIndex position within a batch transfer array. For single transfers, this value is 0.
addressVARCHARAddress of the account that was credited or debited amount of ERC1155 token
counterparty_addressVARCHARThe address of counter party of this credit or debit transfer
token_addressVARCHARToken address of the ERC1155 token
token_nameVARCHARName of the ERC1155 token
token_symbolVARCHARToken symbol of this token
token_idVARCHARUnique ID of the ERC1155 token
raw_amountFLOATBalance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved
raw_amount_strVARCHARBalance of tokens (unnormalized) in string
amountFLOATAmount of tokens moved
amount_strVARCHARAmount of tokens moved in string
usd_amountVARCHARThe amount of tokens moved, in USD.
usd_exchange_rateVARCHARExchange rate used to calculate the USD amount.
operatorVARCHARThe operator address authorized by the NFT owner to transfer tokens on their behalf.
transaction_from_addressVARCHARThe address of the sending party of this transaction.
transaction_to_addressVARCHARThe address of the receiving party of this transaction.
transaction_hashVARCHARTransaction hash that this transfer belongs to
transaction_indexBIGINTThe position of this transaction in the block. The first transaction has index 0.
log_indexBIGINTThe position of this log within the block. The first log has index 0.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred
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 to each transfer. Includes transaction hash, log index and credit and debit transaction type
_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