STAKE_STATUS | STAKE_ACCOUNTS | STAKED_SOL | STAKES_USD | |
|---|---|---|---|---|
1 | inactive | 1967621 | 87241.11323499 | 22435567.68 |
2 | activating | 28 | 181.339663819 | 43116.78 |
3 | active | 473067 | 3035235.75014689 | 628305522.63 |
elovianoonative stakes 2a
Updated 2025-01-25
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 native_stakes as (
select *
from (
select stake_account
, case when validator_name like 'validator:%' then SPLIT_PART(validator_name, ':', -1) else validator_name end AS validator_name
, vote_account
, stake_active
, post_tx_staked_balance
, post_tx_staked_balance_usd
-- , max_by(stake_active , (block_timestamp , index , inner_index)) , max_by(POST_TX_STAKED_BALANCE , block_timestamp)
, row_number() over (partition by stake_account order by block_timestamp desc , index desc , inner_index desc) as recency
from solana.marinade.ez_native_staking_actions
) s
where s.recency = 1
-- group by 1
)
/*
-- QA
select stake_Account , count(*)
from native_stakes
group by 1
having count(*) > 1
*/
-- select *
-- from native_stakes
-- where stake_active = 'false' and post_tx_staked_balance < 1
-- where validator_name = '6m4ZwGp8zCuqjBoAn11pYAQun2FwSMe86RwPbqpf34YC'
select
case
when stake_active = 'true' then 'active'
when stake_active = 'false' or post_tx_staked_balance = 0 then 'inactive'
when stake_active is null then 'activating'
Last run: 3 months ago
3
138B
2s