| marketplace | VARCHAR(16777216) | Marketplace where the trade occurred (e.g., opensea, aavegotchi, magiceden, oneplanet, nftkey) |
| protocol | VARCHAR(16777216) | Protocol used for the trade (e.g., x2y2, seaport) |
| order_match_type | VARCHAR(16777216) | Type of order match: ‘ACCEPT_BID’ or ‘BUY’ |
| trade_type | VARCHAR(16777216) | Type of trade: ‘SINGLE_TRADE’ or ‘BUNDLE_TRADE’ |
| buyer_address | VARCHAR(42) | Address of the buyer |
| seller_address | VARCHAR(42) | Address of the seller |
| token_standard | VARCHAR(16777216) | Token standard of the NFT (e.g., ERC721, ERC1155) |
| token_address | VARCHAR(42) | Contract address of the NFT collection |
| token_id | VARCHAR(16777216) | ID of the NFT traded |
| token_name | VARCHAR(16777216) | Name of the NFT collection |
| token_symbol | VARCHAR(16777216) | Symbol of the NFT collection |
| item_quantity | VARCHAR(16777216) | Number of NFTs bought |
| currency_address | VARCHAR(42) | Address of the currency used in the trade (zero address for native tokens) |
| currency_symbol | VARCHAR(16777216) | Symbol of the currency used in the trade |
| raw_price | VARCHAR(16777216) | Price of the NFT in the original currency (not divided by decimals) |
| price | FLOAT | ’raw_price’ divided by the number of decimals of the currency |
| usd_price | FLOAT | USD price of the NFTs in this trade |
| agg_fees | VARIANT | Aggregated fees information including creator, platform, and total fees |
| buyer_fees | VARIANT | Fees paid by the buyer |
| seller_fees | VARIANT | Fees paid by the seller |
| aggregator_name | VARCHAR(16777216) | Name of the aggregator used for the trade (if applicable) |
| aggregator_address | VARCHAR(42) | Contract address of the aggregator used for the trade (if applicable) |
| extra_fields | VARIANT | Additional information specific to the trade or protocol |
| transaction_hash | VARCHAR(66) | Transaction hash of this trade |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block when the trade occurred |
| block_number | NUMBER(38,0) | Number of the block when the trade occurred |
| block_hash | VARCHAR(66) | Hash of the block when the trade occurred |
| unique_id | VARCHAR(16777216) | Unique identifier for each trade |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of entry update. |
| _helper_nft_tokens__updated_at | TIMESTAMP_NTZ(9) | Timestamp when the NFT token metadata used for enrichment was last updated. |
| _changed_since_full_refresh | BOOLEAN | Flag for change since full refresh. |
