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

    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_stakewise
    group by days
    order by days
    Run a query to Download Data