SalehAll Validators Overview_date
Updated 2024-04-15
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
›
⌄
-- forked from All Validators Overview @ https://flipsidecrypto.xyz/edit/queries/28f50b98-cf92-481a-9129-fcb7713a50fb
with lst_sei_price as (
select
value[1] as avg_price
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=0&interval=daily&precision=3') as resp
)
,lateral flatten (input => resp:data:prices)
)
--##############################Delegate##############################
,lst_delegate_tx as (
select
block_timestamp::date as date
,tx_id as tx
,attribute_value as validator
from sei.core.fact_msg_attributes
where
msg_type = 'delegate' and attribute_key = 'validator'
and TX_SUCCEEDED=true
)
,lst_delegate as (
select
date
,tx_id
,validator
,to_number(split(attribute_value,'usei')[0])/1e6 as amount_SEI
from sei.core.fact_msg_attributes
join lst_delegate_tx on tx = tx_id
where attribute_key ='amount' and msg_type = 'delegate'
)
--##############################UnDelegate_2##############################
,lst_redelegate_tx_neg as (
select
QueryRunArchived: QueryRun has been archived