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

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