boomer77VP distribution
Updated 2021-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with raw as (select date_trunc('day', block_timestamp) as dt, address, max(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 - 1
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
order by vp desc
Run a query to Download Data