Table Description
The nft.trades table on Dune is central to capturing and analyzing Non-Fungible Token (NFT) transactions across various marketplaces. It is a pivotal resource for dissecting the intricacies of NFT trade execution, market behavior, and collector activity within the NFT space.Usage
The nft.trades table serves as an essential tool for delving into the NFT market’s complexities. It offers a detailed snapshot of each NFT transaction, encompassing data points such as sale price, transaction timestamp, buyer and seller addresses, and the specific NFT assets involved. This table allows analysts to explore trends in NFT valuation, trading volumes, and marketplace dynamics, providing insights into the evolving landscape of digital collectibles and art.Coverage
Thenft.trades table is maintained by Dune and covers the following marketplaces and versions:
Table Schema
| Column | Type | Description |
|---|---|---|
blockchain | VARCHAR | Blockchain on which the trade occurred |
project | VARCHAR | NFT marketplace name |
version | VARCHAR | Marketplace contract version |
block_date | DATE | UTC event block date |
block_month | DATE | UTC event block month (partition key) |
block_time | TIMESTAMP | UTC event block time |
token_id | DOUBLE | NFT token ID |
collection | VARCHAR | NFT collection name |
amount_usd | DOUBLE | USD value of the trade at time of execution |
token_standard | VARCHAR | Token standard (ERC721, ERC1155) |
trade_type | VARCHAR | Single or multiple NFTs traded |
number_of_items | UINT256 | Number of items traded |
trade_category | VARCHAR | How the NFT was traded (direct buy, auction, etc.) |
evt_type | VARCHAR | Event type (Trade, Mint, Burn) |
seller | VARBINARY | Seller wallet address |
buyer | VARBINARY | Buyer wallet address |
amount_original | DOUBLE | Traded amount in original currency |
amount_raw | UINT256 | Traded amount before decimals correction |
currency_symbol | VARCHAR | Symbol of currency used for payment |
currency_contract | VARBINARY | Contract address of payment token |
nft_contract_address | VARBINARY | NFT contract address |
project_contract_address | VARBINARY | Marketplace contract address |
aggregator_name | VARCHAR | Aggregator name if trade went through an aggregator |
aggregator_address | VARBINARY | Aggregator contract address |
tx_hash | VARBINARY | Transaction hash |
block_number | BIGINT | Block number |
tx_from | VARBINARY | Address that initiated the transaction |
tx_to | VARBINARY | Address that received the transaction |
platform_fee_amount_raw | UINT256 | Raw platform fee amount |
platform_fee_amount | DOUBLE | Platform fee in original currency |
platform_fee_amount_usd | DOUBLE | Platform fee in USD |
platform_fee_percentage | DOUBLE | Platform fee as percentage of trade amount |
royalty_fee_receive_address | VARBINARY | Address receiving royalty fees |
royalty_fee_currency_symbol | VARCHAR | Symbol of the royalty fee currency |
royalty_fee_amount_raw | UINT256 | Raw royalty fee amount |
royalty_fee_amount | DOUBLE | Royalty fee in original currency |
royalty_fee_amount_usd | DOUBLE | Royalty fee in USD |
royalty_fee_percentage | DOUBLE | Royalty fee as percentage of trade amount |
unique_trade_id | VARCHAR | Unique trade identifier |