siavashjLido ETH Stakes
    Updated 2022-09-05
    -- Q3. Find the following stETH metrics:
    -- -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?

    with base as (
    select
    block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    event_inputs:amount/1e18 as amount
    from ethereum.core.fact_event_logs
    where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    and event_name = 'Submitted'
    and tx_status = 'SUCCESS'
    )
    select
    date,
    count(tx_hash) as "Number Stakes",
    --sum(stakes) as "Cumu Stakes",
    count(distinct origin_from_address) as "Number Stakers",
    sum("Number Stakers") over (order by date) as "Cumu Stakers",
    sum(amount) as "ETH Amount",
    sum("ETH Amount") over (order by date) as "Cumu Amount ETH"
    from base
    group by 1
    --order by 2 desc
    Run a query to Download Data