flyingfishsolana validators stake by latitude
Updated 2023-09-28Copy Reference Fork
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
›
⌄
⌄
⌄
-- 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