Table Details
| Property | Value |
|---|---|
| Table Name | b3.nfts.transfers |
| Table Status | Production-Ready |
| Unique Key | transaction_hash, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| token_standard | VARCHAR(7) | The standard of the token, e.g., ERC721 or ERC1155. |
| from_address | VARCHAR(42) | The address of the sender. |
| to_address | VARCHAR(42) | The address of the recipient. |
| token_address | VARCHAR(42) | The contract address of the token. |
| token_name | VARCHAR(16777216) | The name of the token. |
| token_symbol | VARCHAR(16777216) | The symbol of the token. |
| token_id | VARCHAR(16777216) | The unique identifier of the token. |
| amount | FLOAT | The amount of tokens transferred. |
| transaction_from_address | VARCHAR(42) | The address of the sender in the transaction. |
| transaction_to_address | VARCHAR(42) | The address of the recipient in the transaction. |
| transaction_hash | VARCHAR(66) | The unique identifier of the transaction. |
| transaction_index | NUMBER(38,0) | The position of the transaction within the block. |
| log_index | NUMBER(38,0) | The position of the log within the block. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block containing the transaction. |
| block_number | NUMBER(38,0) | The number of the block containing the transaction. |
| block_hash | VARCHAR(66) | The unique identifier of the block containing the transaction. |
| event_type | VARCHAR(16777216) | The type of event, e.g., erc1155_transfer_single, erc721_transfer. |
| unique_id | VARCHAR(16777216) | A unique identifier for the transfer event. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _helper_nft_tokens__updated_at | TIMESTAMP_NTZ(9) | The timestamp of the last update to the token information. |