MLDZMNDIW3
Updated 2023-02-14
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
›
⌄
--Proposals
--WETH-> Pool #704
--WBTC-> 229 -> Pool #712
--WMATIC-> 384,385,386 -> Pool #789 2022-12-14 -> 2022-12-25
--WAVAX-> 408,409,410 -> Pool #899
--WBNB-> 405, 360, 359,358 -> Pool #840
SELECT
date_trunc('hour', block_timestamp) as days,
description as vote,
sum(VOTE_WEIGHT) as VOTE_WEIGHTs,
avg(VOTE_WEIGHT) as avg_VOTE_WEIGHTs,
sum(VOTE_WEIGHTs)over(partition by vote order by days rows between unbounded preceding and current row ) as cumulative_VOTE_WEIGHTs,
count(*) as votes_casted,
count (distinct VOTER) as voters
FROM
osmosis.core.fact_governance_votes v , osmosis.core.dim_vote_options s
where
vote_id = vote_option
and
proposal_id = 386 -- WMATIC
group by 1,2
order by 1
Run a query to Download Data