Search
K

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 ETH, 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 eth_mint_volume
from ethereum.nfts.mints
where current_date - date(block_timestamp) < 7
and currency_address = '0x0000000000000000000000000000000000000000'
group by date

Table Columns

Column
Description
Example
platform
Minting platform if relevant. Currently includes: fair.xyz, zora, opensea. Mints not associated with a platform will be null.
minting_protocol
Minting protocol used (if relevant). Currently includes standard_mint protocol(s) from opensea, zora and fair.xyz
standard_mint
order_match_type
MINT order type.
MINT
protcol
Minting protocol used (if relevant). Currently includes standard_mint protocol(s) from opensea, zora and fair.xyz
trade_type
SINGLE_TRADE or BUNDLE_TRADE
SINGLE_TRADE
total_mint_quantity
Number of NFTs minted. This is transaction level aggregated value.
1
token_to_address
Recipient address of the NFTs minted.
0xea5eaedf116dbbe5a8f0a1d304f101764c667155
event_type
Type of event transferred involved in the mint. erc1155_transfer_single, erc1155_transfer_batch, erc721_transfer
erc721_transfer
token_standard
Token standard e.g. erc721 or erc1155
ERC721
token_address
Address of the NFT collection.
0xed5af388653567af2f388e6224dc7c4b3241c544
token_name
Name of the NFT collection.
Azuki
token_symbol
Symbol of the NFT collection.
AZUKI
token_id
Token ID of the NFT minted.
9987
item_quantity
Number of NFTs bought.
1
currency_address
Address of the currency used in the mint.
0x0000000000000000000000000000000000000000
currency_symbol
Symbol of the currency used in the mint.
ETH
raw_price
The price of the NFT in the currency used to mint (not divided by the number of decimals)
5.00E+17
price
\'raw_price\' divided by the number of decimals of the currency.
0.5
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.
1.55E+03
log_index
Log index of this mint.
339
transaction_hash
Transaction hash of where this mint occurred.
0xec962755ca047e66c497a8e7a882ef31e2161bd90ca7c8d9d5bd3135cd10da5c
block_timestamp
Block timestamp of the mint.
2022-01-19 17:18:52
block_number
Block number of the mint.
14,037,262
block_hash
Block hash of the mint.
0xac1f0e6aa79c51b40f4083a764caf1d2be53ac3255229e1e3eb2af6dfe7ace91
defi_mint
Whether this mint is associated with a defi transaction, such as minting an NFT position for Uniswap v3.
FALSE
unique_id
Unique ID of this mint.
transaction_hash-0xec962755ca047e66c497a8e7a882ef31e2161bd90ca7c8d9d5bd3135cd10da5c_log_index-339
_updated_at
Timestamp of the entry update.
2023-06-18 23:13:20.417 +0000
Last modified 20d ago