roketeth 13
    Updated 2022-09-27
    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