NFTs
Transfers
NFTs
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. |