Updated 2022-06-15
    with lido_eth_stakes as (
    select origin_address as wallet , sum(amount) as total_staked_eth
    from ethereum.udm_events
    where to_address_name = 'stETH' and to_label_subtype = 'token_contract' and event_type = 'native_eth'
    and block_timestamp::date >= '2022-03-15' and block_timestamp::date < '2022-04-05'
    group by 1
    ),

    wallets_balance as (
    select user_address , non_adjusted_balance/pow(10,18) as balance
    from ethereum.erc20_balances
    where user_address in (select wallet from lido_eth_stakes) and balance_date = date('2022-06-15')
    and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and non_adjusted_balance is not null
    )

    select wallet , total_staked_eth
    from lido_eth_stakes left join wallets_balance
    on wallet = user_address
    order by 2 desc
    Run a query to Download Data