AlishTop lido stakers: Amount and Labels
    Updated 2022-05-02

    with a as (
    select
    event_inputs:amount/1e18 as amount,
    event_inputs:sender as wallet,
    *
    from ethereum_core.fact_event_logs
    where contract_address = LOWER('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') --stETH
    and block_timestamp >= '2021-01-01'
    and event_name = 'Submitted'
    )

    select
    wallet,
    l.address_name,
    sum(amount) as stake_amount
    from a t left join ethereum_core.dim_labels l on t.wallet = l.address
    group by wallet, l.address_name
    order by stake_amount desc
    limit 100
    Run a query to Download Data