with native_stakes as (

select *

from (

select stake_account

, provider_address as staker

, case when validator_name like 'validator:%' then SPLIT_PART(validator_name, ':', -1) else validator_name end AS validator_address

, vote_account

, stake_active

, post_tx_staked_balance as stake

, post_tx_staked_balance_usd as stake_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

, validator_names as (

select distinct vote_pubkey , validator_name

from solana.gov.fact_validators

-- where vote_pubkey = 'H7JJ6aE73ufbUuDCZSQMxguQsj28XHe4VQyMk2hsVGoo'

-- order by epoch desc

, summary as (

select distinct stake_account

-- '<a href="https://solscan.io/account/' || stake_account || '" target="_blank">' || stake_account || '</a>' as stake_account

, case

when stake_active = 'true' then 'active'

when stake_active = 'false' or stake = 0 then 'inactive'