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 NameDescription
platformPlatform where the mint occurred
minting_protocolMinting protocol used (if relevant).
order_match_typeMINT order type.
trade_typeSINGLE_TRADE or BUNDLE_TRADE
total_mint_quantityNumber of NFTs minted. This is transaction level aggregated value.
token_to_addressRecipient address of the NFTs minted.
event_typeType of event transferred involved in the mint. erc1155_transfer_single, erc1155_transfer_batch, erc721_transfer
token_standardTOKEN_ADDRESS
token_addressAddress of the NFT collection.
token_nameName of the NFT collection.
token_symbolSymbol of the NFT collection.
token_idToken ID of the NFT minted.
item_quantityNumber of NFTs bought.
currency_addressAddress of the currency used in the mint.
currency_symbolSymbol of the currency used in the mint.
raw_priceThe 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_priceUSD 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_nameName of the aggregator used for the mint (if applicable)
aggregator_addressContract address of the aggregator used for the mint (if applicable)
transaction_hashTransaction hash of where this mint occurred.
log_indexLog index of this mint
block_timestampBlock timestamp of the mint.
block_numberBlock number of the mint.
block_hashBlock hash of the mint.
defi_mintWhether this mint is associated with a defi transaction, such as minting an NFT position for Uniswap v3.
unique_idUnique ID of this mint.
_created_atTimestamp of the entry creation.
_updated_atTimestamp of the entry update.
_changed_since_full_refreshWhether this row has changed since the last full refresh.
_helper_nft_tokens__updated_atToken info last update.