nft.trades is an effort to make NFT trading data easily available to everyone on Dune Analytics. This table aggregates and standardizes the data between different data platforms and provides auxiliary information and metadata all in one table.buyerand a seller.
They exchange an item which is uniquely identified by the combination of nft_contract_address and token_id. The Buyer will pay the Seller a given original_amountof tokens in any given original_currency. To make it easier, we have calculated the usd_amount that this was worth at the time of the trade for you. Most trades will be done in ETH or WETH, but especially non OpenSea trades often contain other currencies.
The trade is committed on any of the indexed platformsand will be facilitated through a smart contract of those platform's exchange_contract_address. Each trade will have metadata like block_time, tx_hash, block_number, platform version, evt_index etc.
Additionally, we also provide metadata about the traded NFT. nft_project_name and erc_standard will help you in analysing your dataset more easily. nft_project_name data gets pulled from the nft.tokens table, if your NFT is missing in that table, you are welcome to make a PR to add it.nft_contract_address and token_id. Unfortunately, in these trades there is not a clear way to determine a corresponding usd_amount for each of the items. A possible workaround is to divide the number of items by the payment made for the bundle, but this logic very quickly falls apart when Items that are not one in kind/value get sold in a bundle. We recommend removing bundle transfers from the dataset that you are working with since it can heavily influence the results in either direction. Note that token_id and 'erc_standard will be null if tokens with different tokens IDs or erc type are transfered within the same transaction.trade_type will be indicated as Aggregator Trade, and platform names and address can be found in the nft.aggregators table. If your aggregator platform is missing in that table, you are welcome to make a PR to add it.nft.trades, information about the amount and percent of royalty fees in the original amount and in USD is available when this information was able to be retrieved. Royalty fees are going to the creator, and Platform fees are collected by the NFT platform. Note that royalty fees cannot always be retrieved, and are set to null by default.