The ERC721 Token Transfers table records all transactions made with unique, non-fungible tokens that adhere to the ERC721 standard.

This table provides details on the type of transfer, the sending and receiving wallet addresses, the specific ERC721 token ID involved in the transfer, and the amount (if applicable) of the transfer.

Sample Query

Get the total number of address that ever received a BoredApe.

select count(distinct to_address) 

from ethereum.assets.erc721_token_transfers 

where token_address ='0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' --BoredApe

Table Columns

Column NameDescriptionExample
from_addressAddress where the token is being transferred from.0x9b50d9ca924997415dd1bc8d62efc1c9fd36074e
to_addressAddress where the token is being transferred to.0x9839c3d781bee5401a34e1820cd6613a235a9e49
token_addressToken address of the asset transferred.0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d
token_nameToken name.BoredApeYachtClub
token_symbolToken symbol.BAYC
token_idUnique ID of the ERC token.3341
raw_amount_strAmount of tokens moved unnormalized, in string (to retain precision).1
raw_amountAmount of tokens moved, unnormalized.1
amount_strAmount of token moved, normalized, in string (to retain precision).1
amountAmount of token moved, normalized.1
transaction_from_addressThe address of the sending party of this transaction.0x9b50d9ca924997415dd1bc8d62efc1c9fd36074e
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).0x7be8076f4ea4a4ad08075c2508e481d6c946d12b
transaction_hashTransaction hash that this transfer belongs to.0xb7850d48090f3cfcce9f3def76883ffc8f723a8dd99a4d2e8451ca70998437a8
log_indexThe log index that corresponds to this transfer.21
block_timestampThe time when the block that contains this transaction was included on the blockchain.2021-11-14 00:40:03
block_numberThe block number that the corresponding transaction of this transfer belongs to.13,610,892
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0x3e157f6155b28d47e151f270f42cb26e066ec7009dd9d3aeeaa8c21d890ce591
unique_idUnique id generated to each transfer.txn-0xb7850d48090f3cfcce9f3def76883ffc8f723a8dd99a4d2e8451ca70998437a8_log_index-21