cypherGoverning the Cosmos - avg votes per proposal
Updated 2023-01-12
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 terra_votes as (select
proposal_id,
count(distinct(tx_id)) as n_amount_votes
from terra.core.fact_governance_votes
group by proposal_id),
terra_avg as (select
round(avg(n_amount_votes),1) as avg_votes,
median(n_amount_votes) as median_votes,
'terra' as chain
from terra_votes),
cosmos_votes as (select
proposal_id,
count(distinct(tx_id)) as n_amount_votes
from cosmos.core.fact_governance_votes
group by proposal_id
),
cosmos_avg as (select
round(avg(n_amount_votes),1) as avg_votes,
median(n_amount_votes) as median_votes,
'cosmos' as chain
from cosmos_votes
),
osmosis_votes as (select
proposal_id,
count(distinct(tx_id)) as n_votes
from osmosis.core.fact_governance_votes v
where v.vote_option != 'VOTE_OPTION_UNSPECIFIED'
group by proposal_id),
osmosis_avg as (select
round(avg(n_votes),1) as avg_votes,
median(n_votes) as median_votes,
Run a query to Download Data