This is a cross-chain table but can be filtered for sophon transactions.
Table Description
The `nft.trades` table on Dune Analytics 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.Table Coverage
The following table shows which projects and versions of those projects are covered in thedex.trades table on sophon. Column Descriptions
| Column | Type | Description |
|---|---|---|
blockchain | varchar | Blockchain network (e.g., ethereum, polygon) |
project | varchar | NFT marketplace name (e.g., opensea, blur) |
version | varchar | Version of the marketplace protocol |
block_date | date | Date of the block (UTC) |
block_month | date | Month of the block (for partitioning) |
block_time | timestamp | Timestamp of the block containing this trade |
token_id | uint256 | Token ID of the NFT traded |
collection | varchar | Name of the NFT collection |
amount_usd | double | Trade value in USD |
token_standard | varchar | Token standard (ERC-721, ERC-1155) |
trade_type | varchar | Type of trade (buy, sell, offer accepted) |
number_of_items | uint256 | Number of items in the trade |
trade_category | varchar | Category of the trade |
evt_type | varchar | Event type |
seller | varbinary | Address of the seller |
buyer | varbinary | Address of the buyer |
amount_original | double | Trade amount in the payment currency |
amount_raw | uint256 | Raw trade amount (no decimal adjustment) |
currency_symbol | varchar | Symbol of the payment currency |
currency_contract | varbinary | Contract address of the payment currency |
nft_contract_address | varbinary | Contract address of the NFT collection |
project_contract_address | varbinary | Address of the marketplace contract |
aggregator_name | varchar | Name of the aggregator (if trade was via aggregator) |
aggregator_address | varbinary | Address of the aggregator contract |
tx_hash | varbinary | Hash of the transaction containing this trade |
block_number | bigint | Block number containing this trade |
tx_from | varbinary | Address that initiated the transaction |
tx_to | varbinary | Address the transaction was sent to |
platform_fee_amount_raw | uint256 | Raw platform fee amount |
platform_fee_amount | double | Decimal-adjusted platform fee amount |
platform_fee_amount_usd | double | Platform fee in USD |
platform_fee_percentage | double | Platform fee as a percentage of the trade |
royalty_fee_receive_address | varbinary | Address receiving the royalty fee |
royalty_fee_currency_symbol | varchar | Symbol of the royalty fee currency |
royalty_fee_amount_raw | uint256 | Raw royalty fee amount |
royalty_fee_amount | double | Decimal-adjusted royalty fee amount |
royalty_fee_amount_usd | double | Royalty fee in USD |
royalty_fee_percentage | double | Royalty fee as a percentage of the trade |
unique_trade_id | varchar | Unique identifier for the trade |