binhachonDaily stETH Metrics - #3
    Updated 2022-06-06
    with stETH_stake as (
    select
    min(block_timestamp) as block_timestamp,
    to_address as staker
    from flipside_prod_db.ethereum_core.fact_token_transfers
    where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    and from_address = '0x0000000000000000000000000000000000000000'
    group by 2
    )
    select
    date_trunc('day', block_timestamp) as time,
    count(*) as number_of_daily_stakers,
    sum(number_of_daily_stakers) over (order by time) as number_of_stakers_over_time
    from stETH_stake
    group by 1

    Run a query to Download Data