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

Column Name	Description
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.