Date | Number of NFTs Minted | Total Number of NFTs Minted | Minting Volume (MON) | Total Minting Volume (MON) | Minting Fees (MON) | Total Minting Fees (MON) | Number of Minters | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-02-19 03:00:00.000 | 2 | 2 | 0 | 0 | 0.00943485 | 0.00943485 | 1 |
2 | 2025-02-19 04:00:00.000 | 12 | 14 | 0 | 0 | 0.0838529952 | 0.0932878452 | 2 |
3 | 2025-02-19 05:00:00.000 | 7 | 21 | 0 | 0 | 0.029992404 | 0.1232802492 | 3 |
4 | 2025-02-19 09:00:00.000 | 1 | 22 | 0 | 0 | 0.004036032 | 0.1273162812 | 1 |
5 | 2025-02-19 10:00:00.000 | 5 | 27 | 0 | 0 | 0.02192034 | 0.1492366212 | 1 |
6 | 2025-02-19 11:00:00.000 | 16 | 43 | 0 | 0 | 0.0987735843 | 0.2480102055 | 11 |
7 | 2025-02-19 12:00:00.000 | 47 | 90 | 0.005776212 | 0.005776212 | 3.259365968 | 3.507376173 | 35 |
8 | 2025-02-19 13:00:00.000 | 112 | 202 | 0 | 0.005776212 | 1.700973807 | 5.20834998 | 97 |
9 | 2025-02-19 14:00:00.000 | 85 | 287 | 0 | 0.005776212 | 0.7876158305 | 5.995965811 | 59 |
10 | 2025-02-19 15:00:00.000 | 2304 | 2591 | 0 | 0.005776212 | 21.571867317 | 27.567833128 | 1345 |
11 | 2025-02-19 16:00:00.000 | 5651 | 8242 | 0 | 0.005776212 | 34.052064554 | 61.619897682 | 2638 |
12 | 2025-02-19 17:00:00.000 | 33782 | 42024 | 0 | 0.005776212 | 175.56929572 | 237.189193402 | 13362 |
13 | 2025-02-19 18:00:00.000 | 27672 | 69696 | 0 | 0.005776212 | 144.25655529 | 381.445748691 | 13582 |
14 | 2025-02-19 19:00:00.000 | 20222 | 89918 | 0.021370912 | 0.027147124 | 106.253233233 | 487.698981924 | 9544 |
15 | 2025-02-19 20:00:00.000 | 19723 | 109641 | 0 | 0.027147124 | 109.053235971 | 596.752217896 | 11947 |
16 | 2025-02-19 21:00:00.000 | 10875 | 120516 | 0 | 0.027147124 | 56.899977108 | 653.652195004 | 5333 |
17 | 2025-02-19 22:00:00.000 | 8327 | 128843 | 0 | 0.027147124 | 43.803066844 | 697.455261848 | 3178 |
18 | 2025-02-19 23:00:00.000 | 7880 | 136723 | 0 | 0.027147124 | 41.059992122 | 738.515253969 | 3243 |
19 | 2025-02-20 00:00:00.000 | 9198 | 145921 | 0 | 0.027147124 | 46.408822297 | 784.924076266 | 3772 |
20 | 2025-02-20 01:00:00.000 | 11035 | 156956 | 0 | 0.027147124 | 56.286999525 | 841.211075791 | 4974 |
Eman-Raznft minting over time
Updated 2025-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with overview as (select block_timestamp, tx_hash, from_address as minter, tx_fee as mint_fee, value as price, case
when (to_address='0xb33d7138c53e516871977094b249c8f2ab89a4f4' and origin_function_signature='0xa0712d68') then 'Open Edition Chogstar'
when (to_address='0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' and origin_function_signature='0x1249c58b') then 'Chapter1: The Genesis'
when (to_address='0xdd23ade69fc2fe1934aa36c5ab12f6dc58a3446f' and origin_function_signature='0x1249c58b') then 'Community Member of Monad'
when (to_address='0x51e6da0e284609cd96e3134b12e94b4c4f0ca241' and origin_function_signature='0xa7244eb6') then 'Kintsu Beta Access Pass'
when (to_address='0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7' and origin_function_signature='0xd123b4d8') then 'Layer3 CUBE'
end as collection_name
from monad.testnet.fact_transactions
where tx_succeeded='TRUE' and
to_address in ('0xb33d7138c53e516871977094b249c8f2ab89a4f4','0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e',
'0xdd23ade69fc2fe1934aa36c5ab12f6dc58a3446f','0x51e6da0e284609cd96e3134b12e94b4c4f0ca241',
'0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7')
and origin_function_signature in ('0xa0712d68','0x1249c58b','0x1249c58b','0xa7244eb6','0xd123b4d8'))
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct tx_hash) as "Number of NFTs Minted",
sum("Number of NFTs Minted") over (order by "Date") as "Total Number of NFTs Minted", sum(price) as "Minting Volume (MON)",
sum("Minting Volume (MON)") over (order by "Date") as "Total Minting Volume (MON)", sum(mint_fee) as "Minting Fees (MON)",
sum("Minting Fees (MON)") over (order by "Date") as "Total Minting Fees (MON)", count(distinct minter) as "Number of Minters"
from overview
where collection_name='{{Collection_Name}}' AND BLOCK_TIMESTAMP::DATE>='2025-02-19'
group by 1
order by 1
Last run: 22 days ago
...
1064
93KB
154s