boomer77offlinee
Updated 2021-09-13
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
25
26
27
28
›
⌄
with slash as (select date_trunc('month',block_timestamp) as block_month, msg_value:address::string as Validator, count(distinct tx_id) as Offline
from terra.msgs
where msg_module = 'slashing' and block_timestamp >= '2021-03-01'
group by 1,2),
label as (select operator_address, label
from terra.validator_labels),
final as (select *,
case
when validator = 'terravaloper1mgdsc0get3w984h03a02zy6gmg3kgqtfqs3tky' then 'Lambda Core'
when validator = 'terravaloper1duku408ll59lre9gurvwrfchac8895y92gatpl' then 'unknown1'
when validator = 'terravaloper1zc9uadde55t4k3aw9uvgpkhwpsyzkq3k20g38r' then 'Austism Capital'
when validator = 'terravaloper1p3uz3qztr2faqqq0h20qdwmvkc3ugupgyk4qyg' then '#decentralizehk'
when validator = 'terravaloper143klnw7s5968g3h7rf5eenj75mxej34jm5ntc7' then 'LearnTerra.io'
when validator = 'terravaloper197d5p7lpn34r2uff0drx78zf5e4jle4wwthzyd' then 'unknown2'
when validator = 'terravaloper170m0v5uy40ydx9kdynxf9zhk8a0s34qwywhd52' then 'StakeTo.Me'
when validator = 'terravaloper1f2ly4rft3kz2rv0sx69022puv5lfds6ghfwg25' then 'Free Staking'
else b.label
end as Validator_Name
from slash a
left join label b on a.validator = b.operator_address
order by 1 desc)
select validator_name, sum(offline)
from final
group by 1
order by 2 desc
Run a query to Download Data