farid-c9j0VMLido dis*
    Updated 2022-09-05
    select
    COUNT (DISTINCT TX_HASH) as "Total Number of Unique Staker",
    (raw_amount)/pow(10,18) as "Total Amount of ETH Staked",
    case
    when "Total Amount of ETH Staked" < 0.1 then 'Lower than 0.1 ETHs'
    when "Total Amount of ETH Staked" BETWEEN 0.1 and 1 then 'between 0.1-1 ETHs'
    when "Total Amount of ETH Staked" BETWEEN 1 and 10 then 'between 1-10 ETHs'
    when "Total Amount of ETH Staked" BETWEEN 10 and 100 then 'between 10-100 ETHs'
    when "Total Amount of ETH Staked" BETWEEN 100 and 1000 then 'between 100-1000 ETHs'
    when "Total Amount of ETH Staked" BETWEEN 1000 and 10000 then 'between 1000-10000 ETHs'
    when "Total Amount of ETH Staked" > 10000 then ' more than 10000 ETHs'
    end as label
    from ethereum_core.fact_token_transfers
    where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
    and from_address = '0x0000000000000000000000000000000000000000'
    and raw_amount > 0
    group by label,"Total Amount of ETH Staked"
    Run a query to Download Data