kiacryptoHolders distribution
Updated 2022-06-22Copy Reference Fork
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
›
⌄
with holders as (
select nft_to_address as address, '+1' as hold_count
from ethereum.core.ez_nft_transfers
where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
union all
select nft_from_address as address, '-1' as hold_count
from ethereum.core.ez_nft_transfers
where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
),
hold_count as (
select address, sum(hold_count) as NFTs_count
from holders
group by 1 having NFTs_count > 0
)
select case
when NFTs_count = 1 then '1'
when NFTs_count = 2 then '2'
when NFTs_count > 2 and NFTs_count <= 4 then '3 - 4'
when NFTs_count > 4 and NFTs_count <= 8 then '5 - 8'
when NFTs_count > 8 and NFTs_count <= 16 then '9 - 16'
when NFTs_count > 16 and NFTs_count <= 32 then '17 - 32' end as dis, count(*)
from hold_count
group by 1
Run a query to Download Data