BlockTrackerValidator
Updated 2024-10-11
999
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
tx_id ,
msg_index,
ATTRIBUTE_VALUE as validator
FROM lava.core.fact_msg_attributes
WHERE ATTRIBUTE_KEY = 'validator' AND msg_type = 'delegate'
and block_timestamp::date >= '2024-01-07'
and TX_SUCCEEDED
)
,
delegate_amount as (
SELECT
validator,
sum((split(ATTRIBUTE_VALUE, 'ulava')[0])/1e6) as stake_amount
FROM lava.core.fact_msg_attributes a
INNER JOIN delegate b using(tx_id,msg_index)
WHERE msg_type = 'delegate' AND ATTRIBUTE_KEY = 'amount'
and block_timestamp::date >= '2024-01-07'
GROUP BY 1
)
,
redelegate_to as (
SELECT
tx_id,
msg_index,
ATTRIBUTE_VALUE as validator
FROM lava.core.fact_msg_attributes
WHERE ATTRIBUTE_KEY = 'destination_validator' AND msg_type = 'redelegate'
and block_timestamp::date >= '2024-01-07'
and TX_SUCCEEDED
)
,
redelegate_to_amount as (
SELECT
validator,
QueryRunArchived: QueryRun has been archived