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 native token alone), which constitute most of the current NFT trades.
Table Columns
aggregator_name
Name of the aggregator used for the trade. Will be empty if the trade did not involve the use of aggregators.
aggregator_address
Contract address of the aggregator used for the trade.
marketplace
Marketplace of the NFT trade. The list of marketplaces supported can be found at the end of this table.
protocol
The protocol of the marketplace determined by the smart contract used.
order_match_type
Type of sales. Registered as BUY for direct purchase and ACCEPT_BID for bids accepted.
trade_type
Type of trade. SINGLE_TRADE for single token sales or BUNDLE_TRADE when more than 1 token is sold in a transaction.
buyer_address
Address of the buyer.
seller_address
Address of the seller.
token_standard
Type of token traded in the transaction. Either an ERC721 or ERC1155 token.
token_address
Token contract of the NFT in the trade.
token_name
Name of the token traded.
token_symbol
Symbol of the token traded.
token_id
Token ID of the NFT traded.
item_quantity
Quantity of the item traded. For ERC721 tokens, the value is null. While for ERC1155 tokens, the value can be more than 1.
currency_address
Token address of the currency used for this trade. Native ETH is represented as 0x0000000000000000000000000000000000000000. Note: Multi-currency trades will be represented as 'MULTI'. These constitute a small fraction of all trades in seaport protocol. It is also associated with phishing transactions. Prices of such trades are represented as NULL. For more details refer to our write-up on multi-currency trades.
currency_symbol
Token symbol of the currency used for the trade.
raw_price
Raw price of the NFT trade. (Unnormalized)
price
Price of the NFT.
usd_price
USD value of the trade. The USD value of the trade is calculated by multiplying the hourly exchange rate of the currency (e.g. ETH) with the price oracle data source from exchanges.
agg_fees
Sum of the fees paid by the NFT buyer and the seller.
buyer_fees
Fees paid by the NFT buyer. It might be "unimplemented" if we haven't parsed the fees for that protocol yet. Otherwise, it will be a JSON with 9 columns. "creator" fees are the ones paid to the NFT creator (royalties); "platform" fees are paid to the marketplace; "total" fees are the sum of both fees. Use this syntax to access a specific fee: buyer_fees['usd_total']::double. And don't worry about the unimplemented ones, they will become null.
seller_fees
Fees paid by the NFT seller. Note: usually no fees are paid by the seller.
transaction_hash
Transaction hash of where this trade occurred.
block_timestamp
The timestamp of the block that the corresponding transaction of this trade.
block_number
The block number that the corresponding transaction of this trade belongs to.
block_hash
The block hash that the corresponding transaction of this trade belongs to.
unique_id
Unique ID generated for this trade.
_updated_at
Timestamp of entry update.
_helper_nft_tokens__updated_at
Timestamp of token info update.
_changed_since_full_refresh
Flag for change since full refresh.
Last updated