Trades
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.
Coverage:
payment_processor_v2
unlabeled, magiceden
sudoswap_v2
sudoswap
zonic
zonic
element
element
seaport
magiceden, alienswap, unlabeled, okx, opensea
Table Columns
Unique Key: unique_id
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
Last updated