Search
⌃K

Trades

The NFT Trades table aggregates ERC721 and ERC1155 token sales from popular NFT marketplaces and protocols on Ethereum such as Opensea, Blur, LooksRare, x2y2 & 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.
Marketplace-specific and Washing Trading filtered NFT trades on Ethereum are also available.

Marketplace and Protocol 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-Specific Tables
Sudoswap and NFT Trader 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

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
Output of the query above. Ethereum NFT trade volume by marketplace.

Table Columns

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
​