The NFT 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.Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Coverage:
| Protocol | Marketplace |
|---|---|
| payment_processor_v2 | unlabeled, magiceden |
| sudoswap_v2 | sudoswap |
| zonic | zonic |
| element | element |
| seaport | magiceden, alienswap, unlabeled, okx, opensea |
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 |