nft.tradesis 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.
seller. They exchange an item which is uniquely identified by the combination of
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_amountthat 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
evt_indexetc. Additionally, we also provide metadata about the traded NFT.
erc_standardwill help you in analysing your dataset more easily.
nft_project_namedata gets pulled from the
nft.tokenstable, if your NFT is missing in that table, you are welcome to make a PR to add it.
token_id. Unfortunately, in these trades there is not a clear way to determine a corresponding
usd_amountfor 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
erc_standardwill be null if tokens with different tokens IDs or erc type are transfered within the same transaction.
trade_typewill be indicated as
Aggregator Trade, and platform names and address can be found in the
nft.aggregatorstable. 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.