Yousefi_1994Ankr - avg, median, max and min of ETH deposits over time
    Updated 2022-09-05
    with liquid_staking_by_ankr as (
    select
    block_timestamp,
    amount,
    origin_from_address
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670'
    )

    select
    block_timestamp::date as days,
    max(amount) as "Max of ETH Deposits",
    min(amount) as "Min of ETH Deposits",
    avg(amount) as "Avg of ETH Deposits",
    median(amount) as "Median of ETH Deposits",
    sum(amount) / count(distinct origin_from_address) as "ETH Stake per User"
    from liquid_staking_by_ankr
    group by days
    order by days
    Run a query to Download Data