Moevotes 2
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
›
⌄
select
'Osmosis' as chain ,
count (distinct proposal_id) as proposals,
count (distinct tx_id) as votes,
count (distinct voter) as voters,
votes / voters as votes_per_voter ,
votes / proposals as votes_per_proposal
,
voters / proposals as voters_per_proposal
from osmosis.core.fact_governance_votes
where BLOCK_TIMESTAMP >= current_date - interval '{{months_back}} months'
group by 1
union all
select
'Solana' as chain ,
count (distinct proposal) as proposals,
count (distinct tx_id) as votes,
count (distinct voter) as voters,
votes / voters as votes_per_voter ,
votes / proposals as votes_per_proposal,
voters / proposals as voters_per_proposal
from solana.core.fact_proposal_votes
where BLOCK_TIMESTAMP >= current_date - interval '{{months_back}} months'
group by 1
union all -------------------------------
(with base as (with
governanceVotersweek as (
SELECT
date_trunc('week', tx.block_timestamp) as week,
tx.tx_signer, tx.tx_hash
FROM
Run a query to Download Data