Number of NFTs Minted | Number of Minters | |
|---|---|---|
1 | 1 | 1138259 |
2 | 2 | 226925 |
3 | 3 | 97836 |
4 | 4 | 41895 |
5 | 5 | 23897 |
6 | 6 | 16002 |
7 | 7 | 12930 |
8 | 8 | 9513 |
9 | 9 | 7369 |
10 | 10 | 84631 |
11 | 11 | 1 |
Eman-RazDistribution of Users By Number of NFTs Minted
Updated 3 days ago
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
›
⌄
with overview as (with tab1 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 minter, count(distinct tx_hash) as "Number of NFTs Minted"
from tab1
where collection_name='{{Collection_Name}}' AND BLOCK_TIMESTAMP::DATE>='2025-02-19'
group by 1)
select "Number of NFTs Minted", count(distinct minter) as "Number of Minters"
from overview
group by 1
order by 1
Last run: 3 days ago
11
110B
149s