flyingfishsolana validators stake by latitude
    Updated 2023-09-28
    -- forked from solana validators location with stake size @ https://flipsidecrypto.xyz/edit/queries/99cf93ad-0bcf-4f51-9225-66f90699aa1a

    SELECT
    round(latitude/5,0)*5 as latitude_bin
    , round((sum(active_stake) / pow(10, 9)) / 100000,0) as stake
    -- , latitude::float AS latitude
    -- , longitude::float AS longitude
    FROM solana.gov.fact_validators
    WHERE epoch_active = 509
    AND NOT delinquent -- = FALSE
    AND latitude IS NOT NULL
    GROUP BY 1
    --AND latitude is not NULL


    /* SELECT
    iff(latitude is null, 'missing', 'complete') AS flag
    , sum(active_stake) / pow(10, 9) AS stake
    FROM solana.gov.fact_validators
    WHERE epoch_active = 509
    AND NOT delinquent -- = FALSE
    group by 1 */
    /*
    SELECT
    --data_center_key
    latitude::float AS latitude
    , longitude::float AS longitude
    , sum(active_stake) / pow(10, 9) AS stake
    FROM solana.gov.fact_validators
    WHERE epoch_active = 509
    AND NOT delinquent
    AND latitude is not NULL
    AND longitude IS NOT NULL
    GROUP by all
    ORDER by stake DESC */
    Run a query to Download Data