boomer77good or bad
Updated 2021-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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, a.address, b.label, case
when b.label is null then a.address
when b.label is not null then b.label
else ' ' end as labels,
a.vp, a.rank, concat(a.rank,'-',labels) as dx,
CASE
when a.rank < 15 then 'bad'
when a.rank between 15 and 70 then 'good'
when a.rank > 70 then 'risky' else null end as good_bad
from raw a
left outer join labels b on a.address = b.address
order by vp desc
Run a query to Download Data