TheDocumentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
nfts.trades table aggregates ERC721 and ERC1155 token sales from popular NFT marketplaces and protocols.
Our current NFT trades model supports single-currency trades (trades involving either one ERC20 token or ETH alone), which constitute most of the current NFT trades.
Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| marketplace | VARCHAR | Marketplace where the trade occurred (e.g., opensea, aavegotchi, magiceden, oneplanet, nftkey) |
| protocol | VARCHAR | Protocol used for the trade (e.g., x2y2, seaport) |
| order_match_type | VARCHAR | Type of order match: ‘ACCEPT_BID’ or ‘BUY’ |
| trade_type | VARCHAR | Type of trade: ‘SINGLE_TRADE’ or ‘BUNDLE_TRADE’ |
| buyer_address | VARCHAR | Address of the buyer |
| seller_address | VARCHAR | Address of the seller |
| token_standard | VARCHAR | Token standard of the NFT (e.g., ERC721, ERC1155) |
| token_address | VARCHAR | Contract address of the NFT collection |
| token_id | VARCHAR | ID of the NFT traded |
| token_name | VARCHAR | Name of the NFT collection |
| token_symbol | VARCHAR | Symbol of the NFT collection |
| item_quantity | BIGINT | Number of NFTs bought |
| currency_address | VARCHAR | Address of the currency used in the trade (zero address for native tokens) |
| currency_symbol | VARCHAR | Symbol of the currency used in the trade |
| raw_price | FLOAT | 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 | Name of the aggregator used for the trade (if applicable) |
| aggregator_address | VARCHAR | 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 | Transaction hash of this trade |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block when the trade occurred |
| block_number | BIGINT | Number of the block when the trade occurred |
| block_hash | VARCHAR | Hash of the block when the trade occurred |
| unique_id | VARCHAR | Unique identifier for each trade |
| _helper_nft_tokens__updated_at | TIMESTAMP_NTZ(9) | Timestamp when the NFT token metadata used for enrichment was last updated. |