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

Marketplace

Protocols

mooar

seaport 1.5

aavegotchi

ERC1155ExecutedListing, ERC721ExecutedListing, PurchaseTransferItemsWithGhst

bitkeep

seaport, wyvern

dew.gg

dew.gg, seaport 1.5

tofu

element

magic eden

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

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.

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.

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

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 1 month ago