sunslingerAngel Delegations
Updated 2022-07-07
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 delegations as (
SELECT
delegator_address::string as delegator,
SUM(event_amount) as total_delegated -- total staked
FROM terra.staking s
WHERE validator_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
AND action = 'delegate'
GROUP BY 1
),
undelegations as (
SELECT
delegator_address::string as delegator,
SUM(event_amount) as total_undelegated
FROM terra.staking s
WHERE validator_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
AND action = 'undelegate'
GROUP BY 1
),
re_to as (
SELECT
msg_value:delegator_address::string as delegator,
SUM(msg_value:amount:amount::float / 1e6) as total_redelegated_to
FROM terra.msgs
WHERE tx_status = 'SUCCEEDED'
AND msg_type = 'staking/MsgBeginRedelegate'
AND msg_value:validator_dst_address::string = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
GROUP BY 1
),
re_away as (
SELECT
msg_value:delegator_address::string as delegator,
SUM(msg_value:amount:amount::float / 1e6) as total_redelegated_away
FROM terra.msgs
Run a query to Download Data