Trades

The NFT Trades table aggregates ERC721 and ERC1155 token sales from popular NFT marketplaces and protocols on Polygon such as Opensea, Magic Eden and Rarible.

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.

Washing Trading filtered NFT trades on Polygon are also available.

Marketplace and Protocol Coverage:

Marketplace	Protocols
mooar	seaport 1.5
aavegotchi	ERC1155ExecutedListing, ERC721ExecutedListing, PurchaseTransferItemsWithGhst
bitkeep	seaport, wyvern
dew.gg	dew.gg, seaport 1.5
tofu	tofu
element	element
magic eden	0x
nftkey	nftkey
nfttrade	nifty
oneplanet	seaport
opensea	seaport
playdapp	wyvern
rarible	rarible_v2_post_2022-10-03
unlabeled marketplaces*	0x, wyvern

*Unlabeled marketplaces are marketplaces that uses a marketplace protocol .e.g. 0x / wyvern but cannot be attributed to any marketplace.

Sample Query

Query daily marketplace volume and unique buyers on Polygon in the last 30 days.

 select
    date(block_timestamp) as date, 
    marketplace,
    count(distinct buyer_address) as buyers,
    sum(usd_price) as usd_volume
from polygon.nfts.trades 
where current_date - date(block_timestamp) < 30
group by 1,2 
order by 1 desc 

Table Columns

Column Name	Description	Example
aggregator_name	Name of the aggregator use for the trade. Will be empty is 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.	magic eden
protocol	The protocol of the marketplace determined by the smart contract used.	0x
order_match_type	Type of sales. Registered as BUY for direct purchase and ACCEPT_BID for bids accepted.	BUY
trade_type	Type of trade. SINGLE_TRADE for single token sales or BUNDLE_TRADE when more than 1 token is sold in a transaction.	BUNDLE_TRADE
buyer_address	Address of the buyer.	0xafe9098a15fed021e6db6222089d316a4aed8356
seller_address	Address of the seller.	0x77ad5b4eb88f03dd305fb014455d670b844b92ea
token_standard	Type of token traded in the transaction. Either an ERC721 or ERC1155 token.	ERC721
token_address	Token contract of the NFT in the trade.	0x670fd103b1a08628e9557cd66b87ded841115190
token_name	Name of the token traded.	y00ts
token_symbol	Symbol of the token traded.
token_id	Token id of the NFT traded.	3172
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.	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.	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619
currency_symbol	Token symbol of the currency used for the trade.	WETH
raw_price	Raw price of the NFT trade. (Unnormalised)	1.98E+18
price	Price of the NFT.	1.98
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.	3,750.91
agg_fees	Sum of the fees paid by the NFT buyer and the seller.	{ "creator": 0.065934, "platform": 0, "raw_creator": "65934000000000000", "raw_platform": "0", "raw_total": "65934000000000000", "total": 0.06593, "usd_creator": 124.9053696, "usd_platform": 0, "usd_total": 124.9053696 }
buyer_fees	Fees paid by the NFT buyer. It might be "unimplemented" if we haven't parse 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	{ "creator": 0.065934, "platform": 0, "raw_creator": "65934000000000000", "raw_platform": "0", "raw_total": "65934000000000000", "total": 0.06593, "usd_creator": 124.9053696, "usd_platform": 0, "usd_total": 124.9053696 }
seller_fees	Fees paid by the NFT seller. Note: usually no fees are paid by the seller.	{ "creator": null, "platform": null, "raw_creator": null, "raw_platform": null, "raw_total": null, "total": null, "usd_creator": null, "usd_platform": null, "usd_total": null }
transaction_hash	Transaction hash that this trade.	0xa3901104cbd5cc83fdb082ed810ff2c5e9593c74126aecdd20effa6b05ddb31f
block_timestamp	The timestamp of the block that the corresponding transaction of this trade.	2023-06-27 20:10:09
block_number	The block number that the corresponding transaction of this trade belongs to.	44,411,027
block_hash	The block hash that the corresponding transaction of this trade belongs to.	0xb46e912aecf7b493fc64bbc1950c1ab5ec9cd15f944e932a6c9a2f288cdb5e62
unique_id	Unique id generated for this trade.	magic_eden-trace_id-call_0xa3901104cbd5cc83fdb082ed810ff2c5e9593c74126aecdd20effa6b05ddb31f_0_order_nonce-100131415900000000000000000000000000000109459298721043083430762525216577041832_token_id-3172
_updated_at	Timestamp of entry update.	2023-06-28 03:45:57.193 +0000
_helper_nft_tokens__updated_at	Timestamp of token info update.	2023-04-15 15:39:04
_changed_since_full_refresh	Flag for change since full refresh.	TRUE