Pmisha-bmlMdxbucket.stakers
    Updated 2022-04-07
    select
    CASE
    when amount between '0' and '1' then 'Tiny: 0-1 ETH'
    when amount between '2' and '10'then 'Small: 2-10 ETH'
    when amount between '11' and '30' then 'Medium: 11-30 ETH'
    when amount between '31' and '100' then 'Big: 31-100 ETH'
    when amount > '100' then 'Huge: over 100 ETH'
    end as stakers,
    count(distinct origin_address) as stake_wallets,
    count (tx_id) as number_stake,
    sum(amount_usd) as stake_USD,
    sum(amount) as stake_ETH
    from ethereum.udm_events
    where to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and symbol='ETH' and event_name = 'transfer' and block_timestamp>= CURRENT_DATE-90
    group by 1 having stakers is not null
    Run a query to Download Data