roketeth 12
Updated 2022-09-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select eth_from_address as staker, count(tx_hash) as stake_count, case
when stake_count=1 then 'Staking Count=1'
when stake_count>1 and stake_count<=5 then '1<Staking Count<=5'
when stake_count>5 and stake_count<=10 then '5<Staking Count<=10'
when stake_count>10 and stake_count<=50 then '10<Staking Count<=50'
when stake_count>50 and stake_count<=100 then '50<Staking Count<=100'
when stake_count>100 then 'Staking Count>100'
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