Trades
Last updated
Last updated
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.
Protocol | Marketplace |
---|---|
Unique Key: unique_id
Column Name | Data Type | Description |
---|---|---|
payment_processor_v2
unlabeled, magiceden
sudoswap_v2
sudoswap
zonic
zonic
element
element
seaport
magiceden, alienswap, unlabeled, okx, opensea
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