Balance tier | Number of Minters | Total NFTs in tier | |
|---|---|---|---|
1 | 1 NFT | 166940 | 166940 |
2 | 2 NFTs | 741 | 1482 |
3 | 3 NFTs | 2 | 6 |
kingneduDistr of holders
Updated 2025-03-05
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
›
⌄
WITH nft_mints AS (
SELECT
origin_from_address AS minter,
COUNT(*) AS nfts_minted
FROM monad.testnet.fact_event_logs
WHERE contract_address = lower('0xCaB08943346761701EC9757befe79eA88dD67670')
AND origin_to_address = lower('0xCaB08943346761701EC9757befe79eA88dD67670')
AND topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
GROUP BY 1
)
SELECT
CASE
WHEN nfts_minted = 1 THEN '1 NFT'
WHEN nfts_minted = 2 THEN '2 NFTs'
WHEN nfts_minted = 3 THEN '3 NFTs'
WHEN nfts_minted = 4 THEN '4 NFTs'
WHEN nfts_minted = 5 THEN '5 NFTs'
WHEN nfts_minted = 6 THEN '6 NFTs'
WHEN nfts_minted = 7 THEN '7 NFTs'
WHEN nfts_minted = 8 THEN '8 NFTs'
WHEN nfts_minted = 9 THEN '9 NFTs'
WHEN nfts_minted >= 10 THEN '10+ NFTs'
END AS "Balance tier",
COUNT(DISTINCT minter) AS "Number of Minters",
SUM(nfts_minted) AS "Total NFTs in tier"
FROM nft_mints
GROUP BY 1
ORDER BY 2 DESC
Last run: 12 days ago
3
60B
2s