VALIDATOR_NAME | VOTING_POWER | Rate of Share % | TYPE | OPTION | |
|---|---|---|---|---|---|
1 | Coinbase Custody | 22924646.13 | 9.21 | not voted | |
2 | SG-1 | 17381722.66 | 6.98 | ABSTAIN | voted |
3 | Everstake | 10127406.73 | 4.07 | ABSTAIN | voted |
4 | Zero Knowledge Validator (ZKV) | 9561784.33 | 3.84 | YES | voted |
5 | Binance Node | 8998013 | 3.62 | not voted | |
6 | Cosmostation | 8924419.33 | 3.59 | NO | voted |
7 | Allnodes ⚡️ 0% fee | 8730460.72 | 3.51 | NO | voted |
8 | DokiaCapital | 8483934.74 | 3.41 | NO | voted |
9 | GAME | 6364797.02 | 2.56 | YES | voted |
10 | 🐠stake.fish | 6156427.9 | 2.47 | ABSTAIN | voted |
11 | Sikka | 5782769.47 | 2.32 | YES | voted |
12 | NO! Fee to 2025 💸 | melea.xyz | 5511006.55 | 2.21 | not voted | |
13 | P2P.ORG - P2P Validator | 4957283.76 | 1.99 | NO | voted |
14 | Ledger | 4791627.64 | 1.93 | not voted | |
15 | Kraken | 4704393.95 | 1.89 | not voted | |
16 | Provalidator | 4537997.04 | 1.82 | NO | voted |
17 | Chorus One | 4508670.74 | 1.81 | NO | voted |
18 | Informal Systems | 4492896.98 | 1.81 | YES | voted |
19 | Upbit Staking | 3764615.87 | 1.51 | not voted | |
20 | PRYZM | StakeDrop | 3572522.09 | 1.44 | NO | voted |
SocioAnalyticavalidator not voted yet on proposal 848
Updated 2024-02-11
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 json as (
SELECT livequery.live.udf_api ('https://api.flipsidecrypto.com/api/v2/queries/92d28ac2-933b-44e6-98c1-c61bac6eebc3/data/latest') as resp
)
,
account as (
SELECT value:ADDRESS as address,
value:ACCOUNT_ADDRESS as account_address
FROM json,
LATERAL FLATTEN(input => resp:data)
)
, main as (
SELECT
rank,
label as validator_name,
round(delegator_shares/1e6,2) as voting_power,
round(100 * voting_power / total_staked.total_value_staked,2) as "Rate of Share %",
round(sum("Rate of Share %") over (ORDER BY rank),2) as "Cumulative Share %",
a.address as validator_address,
b.account_address
FROM cosmos.gov.fact_validators a
JOIN account b using(address)
CROSS JOIN (
SELECT
sum(delegator_shares/1e6) as total_value_staked
FROM
cosmos.gov.fact_validators a
JOIN account b using(address)
) AS total_staked
ORDER BY rank
),
vote as (
SELECT
voter,
CASE when vote_option = 1 then 'YES'
when vote_option = 2 then 'ABSTAIN'
when vote_option = 3 then 'NO'
Last run: about 1 year agoAuto-refreshes every 3 hours
...
180
8KB
3s