boomer77top 10 val
Updated 2021-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with vp as
(select address, max(voting_power) as Voting_power,date_trunc('day', block_timestamp) as days
from terra.validator_voting_power
where days = CURRENT_DATE
group by 1,3
order by voting_power desc
limit 10),
label as
(select delegator_address, label, operator_address, vp_address
from
terra.validator_labels)
select B.label, A.voting_power
from vp A
join label B on A.address = B.vp_address
order by voting_power desc
Run a query to Download Data