Appendix 3
Here’s an analysis column by column of the Dune Analytics nft.trade
table with additional comments to those of the documentation connected with the sale of Bored Ape #6633 analyzed in Chapter 4. (source: https://dune.com/docs/data-tables/spellbook/top-tables/nft.trades/#column-data and https://dune.com/queries/3268989):
block_time
: The timestamp of the block where the transaction was added.nft_token_id
: The ID of the token that is being transferred. In the case we analyzed in the notebook, the number would be6633
.erc_standard
: The standard followed by the smart contract, denoting how the project was structured. This can be ERC 20, ERC 721, or ERC 1155. The table also shows a SuperRare standard.platform
: The column will show the marketplace where the trade was made.platform_version
: Some marketplaces evolved with time and changed their smart contracts. The way to query information and the functions may vary depending on the version of the...