datavortexper val
Updated 2024-12-05
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 unbond_data AS (
SELECT
tx_id,
CASE
WHEN ATTRIBUTE_KEY = 'validator' AND msg_type = 'unbond' THEN ATTRIBUTE_VALUE
ELSE NULL
END AS validator,
CASE
WHEN ATTRIBUTE_KEY = 'amount' AND msg_type = 'unbond' THEN CAST(REPLACE(ATTRIBUTE_VALUE, 'usei', '') AS DECIMAL) / 1000000
ELSE NULL
END AS unstake_amount
FROM
sei.core.fact_msg_attributes
WHERE
msg_type = 'unbond'
AND (
ATTRIBUTE_KEY = 'validator'
OR ATTRIBUTE_KEY = 'amount'
)
),
delegate_data AS (
SELECT
tx_id,
CASE
WHEN ATTRIBUTE_KEY = 'validator' AND msg_type = 'delegate' THEN ATTRIBUTE_VALUE
ELSE NULL
END AS validator,
CASE
WHEN ATTRIBUTE_KEY = 'amount' AND msg_type = 'delegate' THEN CAST(REPLACE(ATTRIBUTE_VALUE, 'usei', '') AS DECIMAL) / 1000000
ELSE NULL
END AS stake_amount
FROM
sei.core.fact_msg_attributes
WHERE
msg_type = 'delegate'
QueryRunArchived: QueryRun has been archived