NFT_MINTED_2024_04_10 | NFT_MINTED_2024_10_2025 | NFT_MINTED_CHANGE | NFT_MINTED_CHANGE_PCT | TOTAL_MINTERS_2024_04_10 | TOTAL_MINTERS_2024_10_2025 | TOTAL_MINTERS_CHANGE | TOTAL_MINTERS_CHANGE_PCT | TOTAL_NFT_MINTS_2024_04_10 | TOTAL_NFT_MINTS_2024_10_2025 | TOTAL_NFT_MINTS_CHANGE | TOTAL_NFT_MINTS_CHANGE_PCT | MINTS_PER_SECOND_2024_04_10 | MINTS_PER_SECOND_2024_10_2025 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 148671 | 252690 | 104019 | 69.97 | 30934 | 3790 | -27144 | -87.75 | 321451 | 365283 | 43832 | 13.64 | 0.020386 | 0.023166 |
datavortexNft mints and Minters Change
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH period_metrics AS (
SELECT
'2024-04-29_to_2024-10-29' AS period,
COUNT(DISTINCT token_id) AS nft_minted,
COUNT(DISTINCT signer_id) AS total_minters,
COUNT(fact_nft_mints_id) AS total_nft_mints,
COUNT(fact_nft_mints_id) / 15768000.0 AS mints_per_second
FROM near.nft.fact_nft_mints
WHERE tx_succeeded = TRUE
AND block_timestamp >= '2024-04-29'
AND block_timestamp < '2024-10-30'
UNION ALL
SELECT
'2024-10-29_to_2025-04-29' AS period,
COUNT(DISTINCT token_id) AS nft_minted,
COUNT(DISTINCT signer_id) AS total_minters,
COUNT(fact_nft_mints_id) AS total_nft_mints,
COUNT(fact_nft_mints_id) / 15768000.0 AS mints_per_second
FROM near.nft.fact_nft_mints
WHERE tx_succeeded = TRUE
AND block_timestamp >= '2024-10-29'
AND block_timestamp < '2025-04-30'
),
change_summary AS (
SELECT
MAX(CASE WHEN period = '2024-04-29_to_2024-10-29' THEN nft_minted END) AS nft_minted_2024_04_10,
MAX(CASE WHEN period = '2024-10-29_to_2025-04-29' THEN nft_minted END) AS nft_minted_2024_10_2025,
MAX(CASE WHEN period = '2024-04-29_to_2024-10-29' THEN total_minters END) AS total_minters_2024_04_10,
MAX(CASE WHEN period = '2024-10-29_to_2025-04-29' THEN total_minters END) AS total_minters_2024_10_2025,
MAX(CASE WHEN period = '2024-04-29_to_2024-10-29' THEN total_nft_mints END) AS total_nft_mints_2024_04_10,
MAX(CASE WHEN period = '2024-10-29_to_2025-04-29' THEN total_nft_mints END) AS total_nft_mints_2024_10_2025,
MAX(CASE WHEN period = '2024-04-29_to_2024-10-29' THEN mints_per_second END) AS mints_per_second_2024_04_10,
MAX(CASE WHEN period = '2024-10-29_to_2025-04-29' THEN mints_per_second END) AS mints_per_second_2024_10_2025
FROM period_metrics
)
SELECT
Last run: 25 days ago
1
99B
4s