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

Last updated