Arkannholder 1
Updated 2023-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
symbol,
case
when CURRENT_BAL < 0.1 then 'less than 0.1'
when CURRENT_BAL between 0.1 and 1 then 'between 0.1 and 1'
when CURRENT_BAL between 1 and 10 then 'between 1 and 10'
when CURRENT_BAL between 10 and 100 then 'between 10 and 100'
when CURRENT_BAL between 100 and 1000 then 'between 100 and 1000'
when CURRENT_BAL between 100 and 1000 then 'between 1000 and 10000'
when CURRENT_BAL > 1000 then 'greater than 1000' end as holding_bag,
count(holding_bag) AS Holders_number
FROM
ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS = LOWER('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
GROUP BY 1,2
Run a query to Download Data