MINTED BASENAMES | TOTAL WALLETS | |
|---|---|---|
1 | 1 | 645240 |
2 | 2 | 16098 |
3 | 3 to 5 | 3939 |
4 | 6 to 10 | 817 |
5 | 11 to 25 | 401 |
6 | 26 to 50 | 115 |
7 | 51 to 100 | 70 |
8 | 101 to 250 | 23 |
9 | 251 to 500 | 8 |
10 | More than 500 | 4 |
feyikemiconventional-emerald
Updated 2025-03-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
24
25
26
27
28
›
⌄
WITH minted_names AS(
SELECT
COUNT(DISTINCT TX_HASH) AS tx_count,
NFT_TO_ADDRESS
FROM base.nft.ez_nft_transfers
WHERE NFT_address = lower('0x03c4738Ee98aE44591e1A4A4F3CaB6641d95DD9a')
AND NFT_from_address = '0x0000000000000000000000000000000000000000'
AND block_timestamp >= '2024-08-20'
GROUP BY 2
)
SELECT
CASE
WHEN tx_count = 1 THEN '1'
WHEN tx_count = 2 THEN '2'
WHEN tx_count BETWEEN 3 AND 5 THEN '3 to 5'
WHEN tx_count BETWEEN 6 AND 10 THEN '6 to 10'
WHEN tx_count BETWEEN 11 AND 25 THEN '11 to 25'
WHEN tx_count BETWEEN 26 AND 50 THEN '26 to 50'
WHEN tx_count BETWEEN 51 AND 100 THEN '51 to 100'
WHEN tx_count BETWEEN 101 AND 250 THEN '101 to 250'
WHEN tx_count BETWEEN 251 AND 500 THEN '251 to 500'
ELSE 'More than 500'
END AS "MINTED BASENAMES ",
COUNT(DISTINCT a.NFT_TO_ADDRESS) AS "TOTAL WALLETS"
FROM minted_names a
GROUP BY 1
ORDER BY 2 DESC
Last run: about 2 months ago
10
164B
9s