LTirrellFlipside validator outfows
Updated 2021-10-25
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
›
⌄
-- select * from terra.validator_labels
-- where operator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
-- -- flipside
-- -- terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6
-- -- terra1r843mpk5zzkfgtnduskd0dzgeltv0n503h6l5f
-- -- terravalcons1twdyzfcr4dxydyh97kcpe3al4pp978zrhmvxr5
with outflow as (
select
date_trunc('hour', block_timestamp) as date,
tx_status,
action,
DELEGATOR_ADDRESS,
validator_address,
EVENT_AMOUNT,
EVENT_AMOUNT_USD
from terra.staking
where validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6' and tx_status = 'SUCCEEDED' and action = 'undelegate'
)
select
date,
sum(EVENT_AMOUNT),
sum(EVENT_AMOUNT_USD)
FROM
outflow
group by date
order by date
Run a query to Download Data