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.