Table Details
| Property | Value |
|---|---|
| Table Name | ethereum.nfts.nfttrader_trades |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| swap_id | FLOAT | Swap ID of the NFT trade. |
| maker_address | VARCHAR(16777216) | Address of the maker. I.e. users who add liquidity to the order books for NFT trades. |
| taker_address | VARCHAR(16777216) | Address of the taker. I.e. users who execute orders. |
| maker_received_token_addresses | ARRAY | The token address of the NFT(s) received by the maker in an array. |
| maker_received_token_ids | ARRAY | The token ID of the NFT(s) received by the maker in an array. |
| taker_received_token_addresses | ARRAY | The token address of the NFT(s) received by the taker in an array. |
| taker_received_token_ids | ARRAY | The token ID of the NFT(s) received by the taker in an array. |
| maker_received_eth | FLOAT | The amount of ETH received by the maker in the trade. |
| maker_received_usd | FLOAT | The USD value of ETH received by the maker in the trade. |
| taker_received_eth | FLOAT | The amount of ETH received by the taker in the trade. |
| taker_received_usd | FLOAT | The USD value of ETH received by the taker in the trade. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |