brian-terraTotal Delegation Amount - Angel
Updated 2021-12-30
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
30
31
32
33
34
35
36
›
⌄
WITH
dates AS (
select distinct date_trunc('day',block_timestamp) as date
from terra.msgs
)
,
delegate AS (
select date_trunc('day',block_timestamp) as date,
'delegate' as action,
sum(msg_value:amount:amount::float / 1e6) AS amount
from terra.msgs
where tx_status = 'SUCCEEDED'
and msg_type = 'staking/MsgDelegate'
and msg_value:validator_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
group by 1,2
)
,
undelegate AS (
select date_trunc('day',block_timestamp) as date,
'undelegate' as action,
sum(msg_value:amount:amount::float / 1e6) AS amount
from terra.msgs
where tx_status = 'SUCCEEDED'
and msg_type = 'staking/MsgUndelegate'
and msg_value:validator_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
group by 1,2
)
,
redelegate_to AS (
select date_trunc('day',block_timestamp) as date,
'redelegate_to' as action,
sum(msg_value:amount:amount::float / 1e6) AS amount
from terra.msgs
where tx_status = 'SUCCEEDED'
and msg_type = 'staking/MsgBeginRedelegate'
and msg_value:validator_dst_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
Run a query to Download Data