strawbettyTop 10 Validator Ranking Today
Updated 2022-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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