Changes in token owners for ERC721 contracts on Ethereum

When to use

For most use cases, consider using the log-based ethereum_erc721_transfers instead of this table.

This storage-based table tracks changes to ownership variables in storage for ERC721 contracts. Our ERC721 classification is permissive, in that it will also include contracts that include extensions. However, some extensions like ERC721A and ERC721Enumerable include differences in how ownership is tracked in storage, and this table doesn't currently include those changes.

You may want to use this table if any of the following are true:

  1. You're working on a fixed set of contracts and find that all of those contracts are covered by this table.
  2. You're interested in non-standard ERC721s where ownership can change without a Transfer event being emitted.

Schema

Column NameData Type
txn_hashstring
block_numberbigDecimal
block_timestampbigDecimal
token_addressstring
token_namestring
token_symbolstring
token_idbigDecimal
owner_beforestring
owner_afterstring

Source

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