Changes in token owners for ERC721 contracts

Chains supported: Ethereum, Base, Arbitrum (post Nitro)

🟦

Block-level table

For efficiency, we only emit one record per block for each (token_address, token_id) 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
ownerstring

Source

This table was built in sim's ERC721 Owner Changes Block canvas.

Sample queries

getERC721ContractsForOwner

getERC721TokensForOwner

getOwnerForERC721Token

getOwnersForERC721Contract

isHolderOfERC721Contract