hessCurrent Net Per Validator
Updated 2024-12-18
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 delegate as (select VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as delegate_amt,
delegator_address
from axelar.gov.fact_staking
where action = 'delegate'
and TX_SUCCEEDED = 'TRUE'
UNION
select VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as delegate_amt,
delegator_address
from axelar.gov.fact_staking
where action = 'redelegate'
and TX_SUCCEEDED = 'TRUE'
)
,
undelegate as (select VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as undelegate_amt,
delegator_address
from axelar.gov.fact_staking
where action = 'undelegate'
and TX_SUCCEEDED = 'TRUE'
UNION
select REDELEGATE_SOURCE_VALIDATOR_ADDRESS as VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as undelegate_amt,
delegator_address
from axelar.gov.fact_staking
where action = 'redelegate'
and TX_SUCCEEDED = 'TRUE'
)
,
delegation as ( select validator_address,
sum(delegate_amt) as delegate_amounts
QueryRunArchived: QueryRun has been archived