boomer77Redel
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
›
⌄
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 from_validator,
msg_value:validator_src_address::string as to_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
A.block_month, A.amount, A.from_validator, B.label as From_Label, A.to_validator, C.label as To_label
from redel A
join labelA B on A.from_validator=B.operator_address
join labelB C on A.to_validator=C.operator_address
Run a query to Download Data