DATE_MINTED | DAILY_MINT_COUNT | |
|---|---|---|
1 | 2024-03-12 00:00:00.000 | 22 |
2 | 2024-03-22 00:00:00.000 | 12 |
3 | 2024-03-23 00:00:00.000 | 19 |
4 | 2024-03-24 00:00:00.000 | 3 |
5 | 2024-03-27 00:00:00.000 | 2 |
6 | 2024-03-28 00:00:00.000 | 16 |
7 | 2024-03-29 00:00:00.000 | 2 |
8 | 2024-04-01 00:00:00.000 | 1 |
9 | 2024-04-02 00:00:00.000 | 1 |
10 | 2024-04-03 00:00:00.000 | 1 |
11 | 2024-04-04 00:00:00.000 | 1 |
12 | 2024-04-08 00:00:00.000 | 1 |
13 | 2024-04-09 00:00:00.000 | 1 |
14 | 2024-04-10 00:00:00.000 | 1 |
15 | 2024-04-11 00:00:00.000 | 5 |
16 | 2024-04-12 00:00:00.000 | 1 |
17 | 2024-04-13 00:00:00.000 | 1 |
18 | 2024-04-14 00:00:00.000 | 3 |
19 | 2024-04-15 00:00:00.000 | 4 |
20 | 2024-04-17 00:00:00.000 | 3 |
MetaLightHelium Mobile - Pixels Onboarded
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_minted,
COUNT(address) AS daily_mint_count
FROM (
SELECT
mint AS address,
inserted_timestamp::date AS date_minted
FROM solana.nft.dim_nft_metadata
WHERE collection_id = '3gE6oipJ6AqtNkRRqF4iPUQR7aqHPi6cDAC167pJrPi1'
) AS subquery
GROUP BY date_minted
ORDER BY date_minted;
Last run: 10 days agoAuto-refreshes every 24 hours
...
110
3KB
99s