datavortexdelegate amount
Updated 2024-12-04
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_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'
AND (ATTRIBUTE_KEY = 'validator' OR ATTRIBUTE_KEY = 'amount')
)
SELECT
validator,
SUM(COALESCE(stake_amount, 0)) AS total_staked_amount
FROM delegate_data
GROUP BY validator
HAVING SUM(COALESCE(stake_amount, 0)) > 0;
*/
/*
SELECT
ATTRIBUTE_VALUE
FROM sei.core.fact_msg_attributes
WHERE ATTRIBUTE_KEY = 'amount' AND msg_type = 'delegate'
LIMIT 10;
*/
WITH delegate_data AS (
QueryRunArchived: QueryRun has been archived