maybeyonaslido_eth_balance
    Updated 2022-02-09
    with
    st_eth_bals as(
    select *
    from ethereum.erc20_balances
    where contract_address ='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    and balance_date >= getdate() - interval '90 days'
    )--,
    -- beth_bals as(
    -- select *
    -- from ethereum.erc20_balances
    -- where contract_address ='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    -- and user_address = '0xa2f987a546d4cd1c607ee8141276876c26b72bdf'
    -- and balance_date in (select * from today)
    -- )

    select
    balance_date,
    sum(balance) as total_steth,
    sum(amount_usd) as total_usd_val
    from st_eth_bals
    group by 1
    Run a query to Download Data