Mints

The NFT mints tables contain all ERC721 and ERC1155 mints and their respective prices in one consolidated table. The current coverage includes mints from standard mints and protocol mints such as Seadrop.

Minting Currency

NFT minting may involve NATIVE, ERC20, or no currency. Free mints will be included by an empty currency address field and 0 value in price.

To identify native ETH-specific minting volume, currency_address filters will need to be applied as shown in the example below.

Sample Query

Example: NFT Minting volume (ETH) in the last 7 days

A total number of collections minted daily, total minters, and total ETH volume minted.

select 
  date(block_timestamp) as date,
  count(distinct token_address) as collections,
  count(distinct token_to_address) as total_minters,
  sum(price) as native_mint_volume
from b3.nfts.mints 
  where current_date - date(block_timestamp) < 7
  and currency_address = '0x0000000000000000000000000000000000000000' 
group by date

Table Columns

Column Name	Description
platform	Platform where the mint occurred
minting_protocol	Minting protocol used (if relevant).
order_match_type	MINT order type.
trade_type	SINGLE_TRADE or BUNDLE_TRADE
total_mint_quantity	Number of NFTs minted. This is transaction level aggregated value.
token_to_address	Recipient address of the NFTs minted.
event_type	Type of event transferred involved in the mint. erc1155_transfer_single, erc1155_transfer_batch, erc721_transfer
token_standard	TOKEN_ADDRESS
token_address	Address of the NFT collection.
token_name	Name of the NFT collection.
token_symbol	Symbol of the NFT collection.
token_id	Token ID of the NFT minted.
item_quantity	Number of NFTs bought.
currency_address	Address of the currency used in the mint.
currency_symbol	Symbol of the currency used in the mint.
raw_price	The price of the NFT in the currency used to mint (not divided by the number of decimals)
price	\'raw_price\' divided by the number of decimals of the currency.
usd_price	USD price paid for the NFTs in this mint. The USD value of the mint is calculated by multiplying the hourly exchange rate of the currency (e.g. ETH) with the price oracle data source from exchanges.
aggregator_name	Name of the aggregator used for the mint (if applicable)
aggregator_address	Contract address of the aggregator used for the mint (if applicable)
transaction_hash	Transaction hash of where this mint occurred.
log_index	Log index of this mint
block_timestamp	Block timestamp of the mint.
block_number	Block number of the mint.
block_hash	Block hash of the mint.
defi_mint	Whether this mint is associated with a defi transaction, such as minting an NFT position for Uniswap v3.
unique_id	Unique ID of this mint.
_created_at	Timestamp of the entry creation.
_updated_at	Timestamp of the entry update.
_changed_since_full_refresh	Whether this row has changed since the last full refresh.
_helper_nft_tokens__updated_at	Token info last update.