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:

MarketplaceProtocol(s)In nfts.trades
openseawyvern, seaport✅
blur.ioblurexchange, blurexchangev2✅
x2y2x2y2✅
looksrarelooksrare exchange, looksrare protocol✅
raribleexchangev2✅
larvalabscryptopunksmarket✅
sudoswaplssvmpair, lssvmpairfactory
nfttradernfttraderswap

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 NameDescriptionExample
marketplaceMarketplace of the nft trade. The list of marketplaces supported can be found at the end of this table.opensea
protocolThe protocol of the marketplace determined by the smart contract used.wyvern
order_match_typeType of sales. Registered as BUY for direct purchase and ACCEPT_BID for bids accepted.BUY
trade_typeType of trade. SINGLE_TRADE for single token sales or BUNDLE_TRADE when more than 1 token is sold in a transaction.SINGLE_TRADE
buyer_addressAddress of the buyer.0xf2cf7378e44be078732c215fad97af709379ca1d
seller_addressAddress of the seller.0x8349e15d8bf536f164a82a95daa9bd8ccdb917c2
token_standardType of token traded in the transaction. Either an ERC721 or ERC1155 token.ERC721
token_addressToken contract of the NFT in the trade.0xed5af388653567af2f388e6224dc7c4b3241c544
token_nameName of the token traded.Azuki
token_symbolSymbol of the token traded.AZUKI
token_idToken id of the NFT traded.1220
item_quantityQuantity of the item traded. For ERC721 tokens, the value is null. While for ERC1155 tokens, the value can be more than 1.1
currency_addressToken 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_symbolToken symbol of the currency used for the trade.ETH
raw_priceRaw price of the NFT trade. (Unnormalised)1.1E+19
pricePrice of the NFT.11
usd_priceUSD 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_feesSum of the fees paid by the NFT buyer and the seller.unimplemented
buyer_feesFees 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 nullunimplemented
seller_feesFees paid by the NFT seller. Note: usually no fees are paid by the seller.unimplemented
aggregator_nameName of the aggregator use for the trade. Will be empty is the trade did not involve the use of aggregators.
aggregator_addressContract address of the aggregator used for the trade.
transaction_hashTransaction hash that this trade.0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e
block_timestampThe timestamp of the block that the corresponding transaction of this trade.2022-06-13 11:25:53
block_numberThe block number that the corresponding transaction of this trade belongs to.14,955,742
block_hashThe block hash that the corresponding transaction of this trade belongs to.0x014b75aa476fe71538ae89d3b529c6e7c17d14fd781b205d28add93b08931be8
unique_idUnique id generated for this trade.wyvern-tx_hash-0x3ec77b76736d14f2f964eaf753df3a01cdae516034f26ffcf6c467f33fd6c26e_order_log_index-165_nft_log_index-164_token_address-0xed5af388653567af2f388e6224dc7c4b3241c544_token_id-1220
_updated_atTimestamp of entry update.2023-06-03 14:01:12.342 +0000
_helper_nft_tokens__updated_atTimestamp of token info update.2022-01-10 05:19:57
_changed_since_full_refreshFlag for change since full refresh.FALSE