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 Name | Data Type |
|---|---|
| chain_id | long |
| txn_hash | string |
| block_number | long |
| block_timestamp | long |
| token_address | string |
| token_id | bigDecimal |
| token_name | string |
| token_symbol | string |
| account_address | string |
| balance | bigDecimal |
Source
This table was built in sim's ERC1155 Balance Changes - Block canvas.