Changes in balances in ERC1155 contracts

🟦

Block-level table

For efficiency, we only emit one record per block for each (token_address, account_address) pair. If there are 2+ changes for the same pair in a given block, we emit the last one. This more efficiently serves queries where you want to know state after a given block, but precludes queries that need intra-block (i.e., transaction-level) state.

Schema

Column NameData Type
chain_idlong
txn_hashstring
block_numberlong
block_timestamplong
token_addressstring
token_idbigDecimal
token_namestring
token_symbolstring
account_addressstring
balancebigDecimal

Source

This table was built in sim's ERC1155 Balance Changes - Block canvas.

Sample queries

getAddressesForERC1155Contract

getERC1155Balances