roketeth 13
Updated 2022-09-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as (select eth_from_address as staker, sum(amount) as eth_vol, case
when eth_vol<=0.01 then 'ETH<=0.01'
when eth_vol>0.01 and eth_vol<=0.1 then '0.01<ETH<=0.1'
when eth_vol>0.1 and eth_vol<=1 then '0.1<ETH<=1'
when eth_vol>1 and eth_vol<=10 then '1<ETH<=10'
when eth_vol>10 and eth_vol<=100 then '10<ETH<=100'
when eth_vol>100 and eth_vol<=1000 then '100<ETH<=1000'
when eth_vol>1000 then 'ETH>1000'
end as Group_
from ethereum.core.ez_eth_transfers
where (
eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' -- Ankr
or eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' --staked.us
or eth_to_address='0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' --stakefish
)
group by 1)
select group_, count(staker) as staker_count
from tab1
group by 1
Run a query to Download Data