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 MATIC, ERC20, or no currency. Free mints will be included by an empty currency address field and 0 value in price.

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

Sample Query

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

A total number of collections minted daily, total minters, and total MATIC 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 matic_mint_volume
from polygon.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

platform

Minting platform if relevant. Currently includes: fair.xyz, zora, opensea. Mints not associated with a platform will be null.

Magic Eden Launchpad

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

SINGLE_TRADE

total_mint_quantity

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

token_to_address

Recipient address of the NFTs minted.

0xe7fdb8c96eb9f95b58b3db281cb4f8fee06405e4

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.

0x670fd103b1a08628e9557cd66b87ded841115190

token_name

Name of the NFT collection.

y00ts

token_symbol

Symbol of the NFT collection.

token_id

Token ID of the NFT minted.

1604

fungible_amount

Amount of token transferred.

item_quantity

Number of NFTs bought.

currency_address

Address of the currency used in the mint.

0x0000000000000000000000000000000000000000

currency_symbol

Symbol of the currency used in the mint.

MATIC

raw_price

The price of the NFT in the currency used to mint (not divided by the number of decimals)

5.00E+16

price

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

0.05

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

log_index

Log index of this mint.

transaction_hash

Transaction hash of where this mint occurred.

0x599e03726ec78eb8a60ab73e71770e223b4670d98b36c9a77533dfc0a8abf316

block_timestamp

Block timestamp of the mint.

2023-05-02 03:32:24

block_number

Block number of the mint.

42,200,963

block_hash

Block hash of the mint.

0x83d2b4aca927463a47aa5597198e5d7678a52b6798f032fc31265a6ecce7eed9

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.

txn-0x599e03726ec78eb8a60ab73e71770e223b4670d98b36c9a77533dfc0a8abf316_log_index-16

_updated_at

Timestamp of the entry update.

2023-06-19 19:53:33.889 +0000

_helper_nft_tokens__updated_at

Token info last update.

2023-04-15 15:39:04

Last updated 1 year ago