hessOverview of Validators copy
Updated 2024-09-16
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 lava.gov.fact_staking
where action in ('delegate','lava_delegate_to_provider')
and TX_SUCCEEDED = 'TRUE'
UNION
select VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as delegate_amt,
delegator_address
from lava.gov.fact_staking
where action in ('redelegate','lava_redelegate_between_providers')
and TX_SUCCEEDED = 'TRUE'
)
,
undelegate as (select VALIDATOR_ADDRESS,
tx_id,
amount/pow(10,6) as undelegate_amt,
delegator_address
from lava.gov.fact_staking
where action in ('unbond','lava_unbond_from_provider')
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 lava.gov.fact_staking
where action in ('redelegate','lava_redelegate_between_providers')
and TX_SUCCEEDED = 'TRUE'
)
,
delegation as ( select validator_address,
sum(delegate_amt) as delegate_amounts
QueryRunArchived: QueryRun has been archived