maybeyonaslido_reth_deposit
    Updated 2022-04-24
    with
    lido_daily as (
    select
    date(block_timestamp) as date,
    sum(event_inputs:amount/pow(10,18)) as amount_staked,
    count(distinct tx_hash) as txs
    from ethereum_core.fact_event_logs
    where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
    and event_name = 'Submitted'
    group by 1
    order by date desc
    ),
    rocket_daily as (
    select
    date(block_timestamp) as date,
    sum(event_inputs:ethAmount/pow(10,18)) as amount_staked,
    count(distinct tx_hash) as txs
    from ethereum_core.fact_event_logs
    where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
    and event_name = 'TokensMinted'
    group by 1
    order by date desc
    )

    -- select * from ethereum_core.fact_event_logs
    -- where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
    -- -- and
    -- limit 100
    select *, 'lido' as type from lido_daily
    union all
    select *, 'rocket' as type from rocket_daily

    Run a query to Download Data