nimasadjadiThe number of stakeholders and the amount of staked ETH
    Updated 2022-08-05
    select
    block_timestamp::DATE as BLOCK_DAY,
    sum(amount) as sum_amount,
    avg(amount) as average_staked,
    count(distinct origin_address) as stakeholders
    from ethereum.udm_events
    where symbol = 'stETH' and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and amount is not null
    and block_timestamp> CURRENT_TIMESTAMP::DATE-210
    group by block_day
    order by block_day desc
    Run a query to Download Data