boomer77Redelegate To
Updated 2021-08-20
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
29
›
⌄
with redel as (select
date_trunc('month', block_timestamp) as block_month,
sum(msg_value:amount:amount/1e6) as Amount,
msg_value:validator_dst_address::string as to_validator,
msg_value:validator_src_address::string as from_validator
from terra.msgs
where msg_value:validator_dst_address::string is not null and msg_value:validator_src_address::string is not null
group by 1,3,4
order by 1 DESC
),
labelA as
(select delegator_address, label, operator_address, vp_address
from
terra.validator_labels),
labelB as
(select delegator_address, label, operator_address, vp_address
from
terra.validator_labels)
select
sum(A.amount), A.to_validator, B.label as From_Label
from redel A
join labelA B on A.to_validator=B.operator_address
group by 2,3
order by 1 desc
limit 20