Transfers

The nfts.transfers table contains transfers of both ERC721 and ERC1155 tokens. For ERC1155, batch transfers are flattened into individual entries.

This model can be used identify the transfer patterns of NFTs across users.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
token_standard	VARCHAR	The standard of the token, e.g., ERC721 or ERC1155.
from_address	VARCHAR	The address of the sender.
to_address	VARCHAR	The address of the recipient.
token_address	VARCHAR	The contract address of the token.
token_name	VARCHAR	The name of the token.
token_symbol	VARCHAR	The symbol of the token.
token_id	VARCHAR	The unique identifier of the token.
amount	FLOAT	The amount of tokens transferred.
transaction_from_address	VARCHAR	The address of the sender in the transaction.
transaction_to_address	VARCHAR	The address of the recipient in the transaction.
transaction_hash	VARCHAR	The unique identifier of the transaction.
transaction_index	BIGINT	The position of the transaction within the block.
log_index	BIGINT	The position of the log within the block.
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block containing the transaction.
block_number	BIGINT	The number of the block containing the transaction.
block_hash	VARCHAR	The unique identifier of the block containing the transaction.
event_type	VARCHAR	The type of event, e.g., erc1155_transfer_single, erc721_transfer.
unique_id	VARCHAR	A unique identifier for the transfer event.
_helper_nft_tokens__updated_at	TIMESTAMP_NTZ(9)	The timestamp of the last update to the token information.