flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Number of mints per Month
alfredfx10
Number of mints per Month
Updated 2024-05-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
COUNT
(
DISTINCT
NFT_ADDRESS
)
Number_of_mint
,
DATE_TRUNC
(
'month'
,
BLOCK_TIMESTAMP
)
AS
Month
FROM
ethereum
.
nft
.
ez_nft_mints
WHERE
DATE
(
BLOCK_TIMESTAMP
)
>=
'2024-01-01'
AND
DATE
(
BLOCK_TIMESTAMP
)
<=
'2024-04-30'
GROUP
BY
2
ORDER
BY
2
ASC
Results
QueryRunArchived: QueryRun has been archived