boomer77Top 10 validators
Updated 2021-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with raw as (select date_trunc('day', block_timestamp) as dt, address, avg(voting_power) as vp, ROW_NUMBER() OVER (PARTITION BY dt ORDER BY vp desc) as rank
from terra.validator_voting_power
where dt = CURRENT_DATE
group by 1,2),
labels as (select address, label
from terra.labels)
select a.dt, b.label, a.vp, a.rank
from raw a
left outer join labels b on a.address = b.address
where a.rank < 21
order by 3 desc
Run a query to Download Data