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