MINT_DATE | TOTAL_MINTS | UNIQUE_MINTERS | TOTAL_UNIQUE_NFTS | |
|---|---|---|---|---|
1 | 2025-01-22 00:00:00.000 | 61 | 13 | 23022 |
2 | 2025-01-23 00:00:00.000 | 7 | 7 | 7 |
3 | 2025-01-24 00:00:00.000 | 3 | 3 | 3 |
4 | 2025-01-25 00:00:00.000 | 4 | 3 | 20 |
5 | 2025-01-26 00:00:00.000 | 3 | 3 | 3 |
6 | 2025-01-27 00:00:00.000 | 1 | 1 | 1 |
7 | 2025-01-28 00:00:00.000 | 1 | 1 | 1 |
8 | 2025-01-29 00:00:00.000 | 1 | 1 | 1 |
9 | 2025-01-30 00:00:00.000 | 1 | 1 | 1 |
10 | 2025-01-31 00:00:00.000 | 2 | 2 | 2 |
11 | 2025-02-03 00:00:00.000 | 1 | 1 | 1 |
12 | 2025-02-05 00:00:00.000 | 1 | 1 | 1 |
13 | 2025-02-06 00:00:00.000 | 1 | 1 | 1 |
14 | 2025-02-10 00:00:00.000 | 1 | 1 | 1 |
15 | 2025-02-13 00:00:00.000 | 2 | 2 | 3 |
16 | 2025-02-14 00:00:00.000 | 1 | 1 | 1 |
17 | 2025-02-15 00:00:00.000 | 1 | 1 | 1 |
18 | 2025-02-17 00:00:00.000 | 3 | 3 | 3 |
19 | 2025-02-18 00:00:00.000 | 3 | 3 | 3 |
20 | 2025-02-22 00:00:00.000 | 1 | 1 | 1 |
datavortexdaily
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH mint_events AS (
SELECT
tx_hash,
DATE_TRUNC('day', block_timestamp) AS mint_date,
'0x' || SUBSTR(topics[2], 27) AS minter_address,
ethereum.public.udf_hex_to_int(topics[3]) AS nft_id
FROM kaia.core.fact_event_logs
WHERE
contract_address = LOWER('0x2f0bcecce06b6eb32a83073984d0b793640aeaf6')
AND '0x' || SUBSTR(topics[1], 27) = '0x0000000000000000000000000000000000000000'
)
SELECT
mint_date,
COUNT(DISTINCT tx_hash) AS total_mints,
COUNT(DISTINCT minter_address) AS unique_minters,
COUNT(DISTINCT nft_id) AS total_unique_nfts
FROM mint_events
GROUP BY mint_date
ORDER BY mint_date;
Last run: 2 months ago
21
722B
3s