mz0111Distribution of ETH deposits in 'stkr'
    Updated 2022-09-04
    SELECT
    CASE
    WHEN volume BETWEEN 0 AND 0.5 THEN '0-0.5 Ether'
    WHEN volume BETWEEN 0.5 AND 1 THEN '0.5-1 Ether'
    WHEN volume BETWEEN 1 AND 5 THEN '1-5 Ether'
    WHEN volume BETWEEN 5 AND 10 THEN '5-10 Ether'
    WHEN volume BETWEEN 10 AND 20 THEN '10-20 Ether'
    WHEN volume BETWEEN 20 AND 30 THEN '20-30 Ether'
    WHEN volume BETWEEN 30 AND 40 THEN '30-40 Ether'
    WHEN volume BETWEEN 40 AND 50 THEN '40-50 Ether'
    WHEN volume > 50 THEN 'More than 50 Ether'
    END AS volume_distribution,
    count("Staker") as number_of_users
    FROM
    (SELECT
    "Staker",
    SUM("Total Amount of ETH Staked") as volume
    FROM
    ( SELECT
    'stkr' as "platform name",
    origin_from_address as "Staker",
    sum(event_inputs:value/1e18) as "Total Amount of ETH Staked"
    from ethereum.core.fact_event_logs
    where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
    and origin_function_signature in ('0x9fa65c56','0xeb834a2c') -- Stake and Claim Aeth C , Stake and Claim Aeth B
    and event_inputs:from = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
    group by 2
    )
    group by 1
    )
    group by 1
    Run a query to Download Data