MLDZMNstk1
    Updated 2022-09-05
    select
    BLOCK_TIMESTAMP::date as day,
    'LIDO' as platform,
    sum(AMOUNT) as stake_vol,
    avg(AMOUNT) as average_volume,
    min(AMOUNT) as min_stake,
    max(AMOUNT) as max_stake,
    median(AMOUNT) as median_stake,
    count(distinct ORIGIN_FROM_ADDRESS) as number_stakers,
    count(distinct tx_hash) as number_stakes,
    sum(stake_vol) over (order by day) as cum_vol,
    sum(number_stakers) over (order by day) as cum_users
    from ethereum.core.ez_token_transfers

    where ORIGIN_TO_ADDRESS=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and from_address='0x0000000000000000000000000000000000000000'
    group by 1
    union all
    select
    BLOCK_TIMESTAMP::date as day,
    'Stakewise' as platform,
    sum(AMOUNT) as stake_vol,
    avg(AMOUNT) as average_volume,
    min(AMOUNT) as min_stake,
    max(AMOUNT) as max_stake,
    median(AMOUNT) as median_stake,
    count(distinct ORIGIN_FROM_ADDRESS) as number_stakers,
    count(distinct tx_hash) as number_stakes,
    sum(stake_vol) over (order by day) as cum_vol,
    sum(number_stakers) over (order by day) as cum_users
    from ethereum.core.ez_token_transfers

    where ORIGIN_TO_ADDRESS=lower('0xC874b064f465bdD6411D45734b56fac750Cda29A')
    and from_address='0x0000000000000000000000000000000000000000'
    Run a query to Download Data