boomer77Top 10 Redelegation Percentage
Updated 2021-08-17
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 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),
stake as
(select
action, validator_address, sum(event_amount) as Redelegations
from terra.staking
where tx_status = 'SUCCEEDED' and action = 'redelegate'
group by 1,2
order by 3 desc)
select A.address as icon_address, A.voting_power, B.label, B.operator_address, C.Redelegations, (C.Redelegations/A.voting_power)*100 as Redelegation_Percentage
from vp A
join label B on A.address = B.vp_address
join stake C on B.operator_address = C.validator_address
order by voting_power desc