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 ETHTIC 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 base.nfts.mints 
  where current_date - date(block_timestamp) < 7
  and currency_address = '0x0000000000000000000000000000000000000000' 
group by date

Table Columns

Column Name	Description	Example
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
trade_type	SINGLE_TRADE or BUNDLE_TRADE	BUNDLE_TRADE
total_mint_quantity	Number of NFTs minted. This is transaction level aggregated value.	6
token_to_address	Recipient address of the NFTs minted.	0xa4f289bc1e86f2f22f8101a4930d20d92d71a295
event_type	Type of event transferred involved in the mint. erc1155_transfer_single, erc1155_transfer_batch, erc721_transfer	erc721_transfer
token_standard	TOKEN_ADDRESS	ERC721
token_address	Address of the NFT collection.	0x1a1807239f3ce2646cf9f8b972403edb7b41965a
token_name	Name of the NFT collection.	Base Symbiosis Genesis
token_symbol	Symbol of the NFT collection.	Symbiosis Genesis
token_id	Token ID of the NFT minted.	746
item_quantity	Number of NFTs bought.	1.00
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+16	1500000000000
price	\'raw_price\' divided by the number of decimals of the currency. 0.05	0.0000015
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. 0.04787	0.00267483
log_index	Log index of this mint. 16	25
transaction_hash	Transaction hash of where this mint occurred.	0x2f360e792f8400c39f4bf7923ccf14543e8c0c2050390a942e3fd826e4241946
block_timestamp	Block timestamp of the mint.	2023-10-25 06:55:21
block_number	Block number of the mint.	5,713,787
block_hash	Block hash of the mint.	0xed53e978f796794dbb955db322e96bc3fd6520b58493d2bbe3996f6a6bb4cc77
defi_mint	Whether this mint is associated with a defi transaction, such as minting an NFT position for Uniswap v3. FALSE	FALSE
unique_id	Unique ID of this mint.	txn-0x2f360e792f8400c39f4bf7923ccf14543e8c0c2050390a942e3fd826e4241946_log_index-25
_updated_at	Timestamp of the entry update.	2023-10-25 08:12:31.312 +0000
_helper_nft_tokens__updated_at	Token info last update.

Column Name

Description

Example

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

trade_type

SINGLE_TRADE or BUNDLE_TRADE

BUNDLE_TRADE

total_mint_quantity

Number of NFTs minted. This is transaction level aggregated value.

token_to_address

Recipient address of the NFTs minted.

0xa4f289bc1e86f2f22f8101a4930d20d92d71a295

event_type

Type of event transferred involved in the mint. erc1155_transfer_single, erc1155_transfer_batch, erc721_transfer

erc721_transfer

token_standard

TOKEN_ADDRESS

ERC721

token_address

Address of the NFT collection.

0x1a1807239f3ce2646cf9f8b972403edb7b41965a

token_name

Name of the NFT collection.

Base Symbiosis Genesis

token_symbol

Symbol of the NFT collection.

Symbiosis Genesis

token_id

Token ID of the NFT minted.

746

item_quantity

Number of NFTs bought.

1.00

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+16

1500000000000

price

\'raw_price\' divided by the number of decimals of the currency. 0.05

0.0000015

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. 0.04787

0.00267483

log_index

Log index of this mint. 16

transaction_hash

Transaction hash of where this mint occurred.

0x2f360e792f8400c39f4bf7923ccf14543e8c0c2050390a942e3fd826e4241946

block_timestamp

Block timestamp of the mint.

2023-10-25 06:55:21

block_number

Block number of the mint.

5,713,787

block_hash

Block hash of the mint.

0xed53e978f796794dbb955db322e96bc3fd6520b58493d2bbe3996f6a6bb4cc77

defi_mint

Whether this mint is associated with a defi transaction, such as minting an NFT position for Uniswap v3. FALSE

FALSE

unique_id

Unique ID of this mint.

txn-0x2f360e792f8400c39f4bf7923ccf14543e8c0c2050390a942e3fd826e4241946_log_index-25

_updated_at

Timestamp of the entry update.

2023-10-25 08:12:31.312 +0000

_helper_nft_tokens__updated_at

Token info last update.

Last updated 1 month ago