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-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.
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 |
Last updated