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:

MarketplaceProtocols
mooarseaport 1.5
aavegotchiERC1155ExecutedListing, ERC721ExecutedListing, PurchaseTransferItemsWithGhst
bitkeepseaport, wyvern
dew.ggdew.gg, seaport 1.5
tofutofu
elementelement
magic eden0x
nftkeynftkey
nfttradenifty
oneplanetseaport
openseaseaport
playdappwyvern
rariblerarible_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 NameDescriptionExample
aggregator_nameName of the aggregator use for the trade. Will be empty is the trade did not involve the use of aggregators.
aggregator_addressContract address of the aggregator used for the trade.
marketplaceMarketplace of the nft trade. The list of marketplaces supported can be found at the end of this table.magic eden
protocolThe protocol of the marketplace determined by the smart contract used.0x
order_match_typeType of sales. Registered as BUY for direct purchase and ACCEPT_BID for bids accepted.BUY
trade_typeType of trade. SINGLE_TRADE for single token sales or BUNDLE_TRADE when more than 1 token is sold in a transaction.BUNDLE_TRADE
buyer_addressAddress of the buyer.0xafe9098a15fed021e6db6222089d316a4aed8356
seller_addressAddress of the seller.0x77ad5b4eb88f03dd305fb014455d670b844b92ea
token_standardType of token traded in the transaction. Either an ERC721 or ERC1155 token.ERC721
token_addressToken contract of the NFT in the trade.0x670fd103b1a08628e9557cd66b87ded841115190
token_nameName of the token traded.y00ts
token_symbolSymbol of the token traded.
token_idToken id of the NFT traded.3172
item_quantityQuantity of the item traded. For ERC721 tokens, the value is null. While for ERC1155 tokens, the value can be more than 1.1
currency_addressToken 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_symbolToken symbol of the currency used for the trade.WETH
raw_priceRaw price of the NFT trade. (Unnormalised)1.98E+18
pricePrice of the NFT.1.98
usd_priceUSD 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_feesSum 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_feesFees 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_feesFees 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_hashTransaction hash that this trade.0xa3901104cbd5cc83fdb082ed810ff2c5e9593c74126aecdd20effa6b05ddb31f
block_timestampThe timestamp of the block that the corresponding transaction of this trade.2023-06-27 20:10:09
block_numberThe block number that the corresponding transaction of this trade belongs to.44,411,027
block_hashThe block hash that the corresponding transaction of this trade belongs to.0xb46e912aecf7b493fc64bbc1950c1ab5ec9cd15f944e932a6c9a2f288cdb5e62
unique_idUnique id generated for this trade.magic_eden-trace_id-call_0xa3901104cbd5cc83fdb082ed810ff2c5e9593c74126aecdd20effa6b05ddb31f_0_order_nonce-100131415900000000000000000000000000000109459298721043083430762525216577041832_token_id-3172
_updated_atTimestamp of entry update.2023-06-28 03:45:57.193 +0000
_helper_nft_tokens__updated_atTimestamp of token info update.2023-04-15 15:39:04
_changed_since_full_refreshFlag for change since full refresh.TRUE