The ERC721 Token Transfers table records all transfers made with unique, non-fungible tokens from the Transfer event logs with tokenId.

Table Columns

Unique Key: unique_id

Column NameData TypeDescription
from_addressVARCHARAddress where the token is being transferred from.
to_addressVARCHARAddress where the token is being transferred to.
token_addressVARCHARToken address of the asset transferred.
token_nameVARCHARToken name.
token_symbolVARCHARToken symbol.
token_idVARCHARUnique ID of the ERC token.
raw_amountFLOATAmount of tokens transferred (unnormalized).
raw_amount_strVARCHARAmount of tokens transferred (unnormalized) in string to retain precision.
amountFLOATAmount of token transferred, normalized.
amount_strVARCHARAmount of token transferred, normalized in string to retain precision.
transaction_from_addressVARCHARThe address of the sending party of this transaction.
transaction_to_addressVARCHARThe address of the receiving party of this transaction (could be a contract address).
transaction_hashVARCHARTransaction hash that this transfer belongs to.
transaction_indexBIGINTThe position of this transaction in the block. The first transaction of a block has index 0.
log_indexBIGINTThe position of this log within the block. The first log of a block has index 0
block_timestampTIMESTAMP_NTZ(9)The timestamp when the block that contains this transaction was included on the blockchain.
block_numberBIGINTThe block number that the corresponding transaction of this transfer belongs to.
block_hashVARCHARThe block hash that the corresponding transaction of this transfer belongs to.
unique_idVARCHARUnique id generated to each transfer.