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.

Table Details

Property	Value
Table Name	`polygon.nfts.trades`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `unique_id`
Clustering Key(s)	`block_timestamp::date, marketplace, protocol, token_address`
Search Optimization	`transaction_hash`, `buyer_address`, `seller_address`, `token_name`, `currency_address`, `currency_symbol`, `token_address`

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

Table Columns

Column Name	Data Type	Description
marketplace	VARCHAR(134217728)	Marketplace where the trade occurred (e.g., opensea, aavegotchi, magiceden, oneplanet, nftkey)
protocol	VARCHAR(134217728)	Protocol used for the trade (e.g., x2y2, seaport)
order_match_type	VARCHAR(134217728)	Type of order match: ‘ACCEPT_BID’ or ‘BUY’
trade_type	VARCHAR(134217728)	Type of trade: ‘SINGLE_TRADE’ or ‘BUNDLE_TRADE’
buyer_address	VARCHAR(42)	Address of the buyer
seller_address	VARCHAR(42)	Address of the seller
token_standard	VARCHAR(134217728)	Token standard of the NFT (e.g., ERC721, ERC1155)
token_address	VARCHAR(42)	Contract address of the NFT collection
token_name	VARCHAR(134217728)	Name of the NFT collection
token_symbol	VARCHAR(134217728)	Symbol of the NFT collection
token_id	VARCHAR(134217728)	ID of the NFT traded
item_quantity	VARCHAR(134217728)	Number of NFTs bought
currency_address	VARCHAR(42)	Address of the currency used in the trade (zero address for native tokens)
currency_symbol	VARCHAR(134217728)	Symbol of the currency used in the trade
raw_price	VARCHAR(134217728)	Price of the NFT in the original currency (not divided by decimals)
price	FLOAT	’raw_price’ divided by the number of decimals of the currency
usd_price	FLOAT	USD price of the NFTs in this trade
agg_fees	VARIANT	Aggregated fees information including creator, platform, and total fees
buyer_fees	VARIANT	Fees paid by the buyer
seller_fees	VARIANT	Fees paid by the seller
aggregator_name	VARCHAR(134217728)	Name of the aggregator used for the trade (if applicable)
aggregator_address	VARCHAR(134217728)	Contract address of the aggregator used for the trade (if applicable)
extra_fields	VARIANT	Additional information specific to the trade or protocol
transaction_hash	VARCHAR(66)	Transaction hash of this trade
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block when the trade occurred
block_number	NUMBER(38,0)	Number of the block when the trade occurred
block_hash	VARCHAR(66)	Hash of the block when the trade occurred
unique_id	VARCHAR(134217728)	Unique identifier for each trade
_updated_at	TIMESTAMP_LTZ(9)	Timestamp of when the entry was last updated in the database.
_helper_nft_tokens__updated_at	TIMESTAMP_NTZ(9)	Timestamp when the NFT token metadata used for enrichment was last updated.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

*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 

EVM NFTs Trades

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Marketplace and Protocol Coverage

Table Columns

Sample Query

​Table Details

​Marketplace and Protocol Coverage

​Table Columns

​Sample Query

​Related Docs

Table Details

Marketplace and Protocol Coverage

Table Columns

Sample Query

Related Docs