Table Description
The nft.mints table on Dune is essential for capturing and analyzing Non-Fungible Token (NFT) minting events across various blockchain networks. It serves as a crucial resource for understanding the creation and initial distribution of NFTs, providing insights into project launches, artist activity, and the growth of NFT collections.
This table is not well maintained and misses coverage on chains and projects.
Usage
The nft.mints table is a valuable tool for examining the NFT creation process. It offers detailed information about each NFT minting event, including data points such as the minting timestamp, the address of the minter, the contract address, and specifics about the minted NFT. This table enables analysts to explore trends in NFT creation, track the launch of new collections, and analyze patterns in minting behavior across different projects and blockchain networks.
Coverage
Table Schema
| Column | Type | Description |
|---|
blockchain | VARCHAR | Blockchain on which the mint occurred |
project | VARCHAR | NFT marketplace/project name |
version | VARCHAR | Contract version |
block_date | DATE | UTC event block date |
block_month | DATE | UTC event block month (partition key) |
block_time | TIMESTAMP | UTC event block time |
token_id | UINT256 | NFT token ID |
collection | VARCHAR | NFT collection name |
amount_usd | DOUBLE | USD value at time of mint |
token_standard | VARCHAR | Token standard (ERC721, ERC1155) |
trade_type | VARCHAR | Single or multiple NFTs minted |
number_of_items | UINT256 | Number of items minted |
trade_category | VARCHAR | Mint category (direct, auction, etc.) |
evt_type | VARCHAR | Event type (Mint) |
seller | VARBINARY | Seller/creator address |
buyer | VARBINARY | Minter/buyer address |
amount_original | DOUBLE | Amount in original currency |
amount_raw | UINT256 | Raw amount before decimal adjustment |
currency_symbol | VARCHAR | Symbol of currency used for payment |
currency_contract | VARBINARY | Contract address of payment token |
nft_contract_address | VARBINARY | NFT contract address |
project_contract_address | VARBINARY | Marketplace contract address |
aggregator_name | VARCHAR | Aggregator name if applicable |
aggregator_address | VARBINARY | Aggregator contract address |
tx_hash | VARBINARY | Transaction hash |
block_number | BIGINT | Block number |
tx_from | VARBINARY | Address that initiated the transaction |
tx_to | VARBINARY | Address that received the transaction |
evt_index | INTEGER | Event index |
Table Sample
