Trades

The NFT Trades table aggregates ERC721 and ERC1155 token sales from popular NFT marketplaces and protocols.

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.

Coverage:

Marketplace	Protocol(s)	In nfts.trades
opensea	wyvern, seaport	✅
blur.io	blurexchange, blurexchangev2	✅
x2y2	x2y2	✅
looksrare	looksrare exchange, looksrare protocol	✅
rarible	exchangev2	✅
larvalabs	cryptopunksmarket	✅
sudoswap	lssvmpair, lssvmpairfactory
nfttrader	nfttraderswap

Marketplace

Protocol(s)

In nfts.trades

opensea

wyvern, seaport

✅

blur.io

blurexchange, blurexchangev2

✅

x2y2

✅

looksrare

looksrare exchange, looksrare protocol

✅

rarible

exchangev2

✅

larvalabs

cryptopunksmarket

✅

sudoswap

lssvmpair, lssvmpairfactory

nfttrader

nfttraderswap

Marketplace-Models Sudoswap and NFTTrader trades are not aggregated in the ethereum.nfts.trades table as they involve swaps (AMM, OTC swaps) rather than the sale of NFTs. Swaps on these platforms can be queried from the marketplace-specific tables.

sudoswap_trades
nfttrader_trades

Sample Query

Aggregating NFT volumes on Ethereum since 2023.

select 
  date(block_timestamp) as date,
  marketplace,
  sum(usd_price) as usd_volume
from ethereum.nfts.trades 
  where block_timestamp > '2023-01-01'
group by date, marketplace

Table Columns

Unique Key: unique_id

Column Name	Description	Example
marketplace	Marketplace of the nft trade. The list of marketplaces supported can be found at the end of this table.	opensea
protocol	The protocol of the marketplace determined by the smart contract used.	wyvern
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.	SINGLE_TRADE
buyer_address	Address of the buyer.	0xf2cf7378e44be078732c215fad97af709379ca1d
seller_address	Address of the seller.	0x8349e15d8bf536f164a82a95daa9bd8ccdb917c2
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.	0xed5af388653567af2f388e6224dc7c4b3241c544
token_name	Name of the token traded.	Azuki
token_symbol	Symbol of the token traded.	AZUKI
token_id	Token id of the NFT traded.	1220
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.	0x0000000000000000000000000000000000000000
currency_symbol	Token symbol of the currency used for the trade.	ETH
raw_price	Raw price of the NFT trade. (Unnormalised)	1.1E+19
price	Price of the NFT.	11
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.	13,440.35
agg_fees	Sum of the fees paid by the NFT buyer and the seller.	unimplemented
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	unimplemented
seller_fees	Fees paid by the NFT seller. Note: usually no fees are paid by the seller.	unimplemented
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.
transaction_hash	Transaction hash that this trade.	0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e
block_timestamp	The timestamp of the block that the corresponding transaction of this trade.	2022-06-13 11:25:53
block_number	The block number that the corresponding transaction of this trade belongs to.	14,955,742
block_hash	The block hash that the corresponding transaction of this trade belongs to.	0x014b75aa476fe71538ae89d3b529c6e7c17d14fd781b205d28add93b08931be8
unique_id	Unique id generated for this trade.	wyvern-tx_hash-0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e_order_log_index-165_nft_log_index-164_token_address-0xed5af388653567af2f388e6224dc7c4b3241c544_token_id-1220
_updated_at	Timestamp of entry update.	2023-06-03 14:01:12.342 +0000
_helper_nft_tokens__updated_at	Timestamp of token info update.	2022-01-10 05:19:57
_changed_since_full_refresh	Flag for change since full refresh.	FALSE

Column Name

Description

Example

marketplace

Marketplace of the nft trade. The list of marketplaces supported can be found at the end of this table.

opensea

protocol

The protocol of the marketplace determined by the smart contract used.

wyvern

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.

SINGLE_TRADE

buyer_address

Address of the buyer.

0xf2cf7378e44be078732c215fad97af709379ca1d

seller_address

Address of the seller.

0x8349e15d8bf536f164a82a95daa9bd8ccdb917c2

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.

0xed5af388653567af2f388e6224dc7c4b3241c544

token_name

Name of the token traded.

Azuki

token_symbol

Symbol of the token traded.

AZUKI

token_id

Token id of the NFT traded.

1220

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.

0x0000000000000000000000000000000000000000

currency_symbol

Token symbol of the currency used for the trade.

ETH

raw_price

Raw price of the NFT trade. (Unnormalised)

1.1E+19

price

Price of the NFT.

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.

13,440.35

agg_fees

Sum of the fees paid by the NFT buyer and the seller.

unimplemented

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

unimplemented

seller_fees

Fees paid by the NFT seller. Note: usually no fees are paid by the seller.

unimplemented

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.

transaction_hash

Transaction hash that this trade.

0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e

block_timestamp

The timestamp of the block that the corresponding transaction of this trade.

2022-06-13 11:25:53

block_number

The block number that the corresponding transaction of this trade belongs to.

14,955,742

block_hash

The block hash that the corresponding transaction of this trade belongs to.

0x014b75aa476fe71538ae89d3b529c6e7c17d14fd781b205d28add93b08931be8

unique_id

Unique id generated for this trade.

wyvern-tx_hash-0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e_order_log_index-165_nft_log_index-164_token_address-0xed5af388653567af2f388e6224dc7c4b3241c544_token_id-1220

_updated_at

Timestamp of entry update.

2023-06-03 14:01:12.342 +0000

_helper_nft_tokens__updated_at

Timestamp of token info update.

2022-01-10 05:19:57

_changed_since_full_refresh

Flag for change since full refresh.

FALSE

Last updated 6 days ago