select

epoch

, node_pubkey

, active_stake / pow(10, 9) as active_stake

, coalesce(concat(validator_name, left(node_pubkey, 5)), concat(left(node_pubkey, 5), '...', right(node_pubkey, 5))) as validator_name

, software_version

, data_center_key

, longitude

, latitude

from solana.gov.fact_validators

qualify row_number() over (partition by node_pubkey order by epoch desc) = 1

and not delinquent

and not active_stake is null

),

stakes as (

select

epoch

, node_pubkey as "Node Pubkey"

, validator_name as "Validator Name"

, software_version as "Software Version"

, data_center_key as "ASN (Data Center Key)"

, active_stake as "Active Stake (SOL)"

from validators_info

where active_stake > 0

select *

from stakes