adriaparcerisasOsmosis governance 4
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--Create a dashboard that maps community participation in governance.
--On average, how long does it take for a new wallet to become active in Osmosis governance?
--Do wallets that are active in governance vote on every proposal? Or do they only vote on select proposals?
WITH
votes as (
SELECT
distinct voter as user,
min(block_timestamp) as debut,
count(distinct proposal_id) as n_proposals
from osmosis.core.fact_governance_votes
group by 1
)
SELECT
trunc(debut,'day') as date,
count(distinct user) as n_users,
avg(n_proposals) as avg_proposals_per_user
from votes
group by 1
order by 1 asc
Run a query to Download Data