strawbettyTop 10 Validator Ranking Today
    Updated 2022-03-25
    select *
    from(
    select
    date_trunc('day', block_timestamp) as day,
    terra.validator_labels.label as Validator,
    avg(voting_power) as VotingPower,

    row_number() over (
    partition by day
    order by VotingPower desc
    ) as ranking
    from terra.validator_voting_power
    inner join terra.validator_labels on terra.validator_voting_power.address = terra.validator_labels.vp_address

    where date_trunc('day', block_timestamp) = '2022-03-25T00:00:00Z'

    group by day,
    terra.validator_labels.label
    order by day, VotingPower desc
    ) as toprows
    where toprows.ranking <= 10
    order by ranking
    Run a query to Download Data