ERC1155 credit debit table allows you to easily track the inflows and outflows of every ERC1155 token belonging to all addresses.

Sample Query

Getting the ERC1155 Credit Debit history of an address.

select * from ethereum.assets.erc721_credit_debit

where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

order by block_number desc  

Table Columns

Column NameDescriptionExampleColumn Name
event_typeTransfer event type specific to ERC1155 tokens. Either transfer_single or batch_transfer.transfer_single
addressAddress of the account that was credited or debited value amount of ERC1155 token.0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
counterparty_addressThe address of counter party of this credit or debit transfer.0x92acc22c7e154d8164decb901f9cdf0cad93ac6a
token_addressToken address of the ERC1155 token.0xd07dc4262bcdbf85190c01c996b4c06a461d2430
token_nameName of the ERC1155 token.Rarible
token_symbolToken symbol of this token.RARI
token_idUnique ID of the ERC1155 token.583230
amount_rawBalance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved. 1
amount_raw_strBalance of tokens (unnormalized) in string.1
amountAmount of tokens moved. 1
amount_strAmount of tokens moved in string.1
usd_valueThe amount of tokens moved, in USD.</td><td></td><td></td></tr><tr><td>usdexchangerate</td><td>Thisisthepriceofasingletoken,inUSD.</td><td></td><td></td></tr><tr><td>usd_exchange_rate</td><td>This is the price of a single token, in USD.

Refer to Hourly Token Prices for more information.
operatorThe operator is defined as the addresses authorized (or approved) by a NFT owner to spend all of his token Ids.0x92acc22c7e154d8164decb901f9cdf0cad93ac6a
transaction_hashTransaction hash that this transfer belongs to.0xdfd40caed2ac0cdd89a79b5728a965cda73bc5a56088f1b1d086b3f23fd5df53
log_indexThe log index that corresponds to this transfer.395
block_timestampThe timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred.2022-09-18T09:43:59
block_numberThe block number that the corresponding transaction of this transfer belongs to.15559619
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0x2437b0e92b011094a3e60e6bd9d0cd781cba7237f8fc2d59b8b85e94ef9c2137
unique_idUnique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type. txn-0xdfd40caed2ac0cdd89a79b5728a965cda73bc5a56088f1b1d086b3f23fd5df53_log_index-395_debit