flipside

    Sum LUNA Staked by Top 25 Delegators
    boomer77Sum LUNA Staked by Top 25 Delegators
    Updated 2021-11-10
    with x as (select
    delegator_address, sum(event_amount) as LUNA_staked
    from terra.staking
    where action = 'delegate' and currency = 'LUNA' and tx_status = 'SUCCEEDED'
    group by 1
    order by 2 DESC
    limit 25)

    select
    sum(LUNA_staked)
    from x

    Run a query to Download Data