MINT_DATE | DAILY_MINTS | MINTERS | |
|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 16 | 3 |
2 | 2025-04-22 00:00:00.000 | 20 | 3 |
3 | 2025-04-23 00:00:00.000 | 38 | 5 |
4 | 2025-04-24 00:00:00.000 | 166 | 6 |
5 | 2025-04-25 00:00:00.000 | 86 | 6 |
6 | 2025-04-26 00:00:00.000 | 61 | 4 |
7 | 2025-04-27 00:00:00.000 | 24 | 5 |
8 | 2025-04-28 00:00:00.000 | 214 | 2 |
aureasarsanedesdeliberate-bronze
Updated 8 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS mint_date,
COUNT(*) AS daily_mints,
count(distinct nft_to_address) as minters
FROM
aptos.nft.ez_nft_mints
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_DATE)
GROUP BY
mint_date
ORDER BY
mint_date;
Last run: about 8 hours ago
8
267B
2s