Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('hour', block_timestamp) as "day",
Description,
count (distinct tx_id) as "Votes",
count (distinct voter) as "Voters",
sum(VOTE_WEIGHT) as "vote power"
from osmosis.core.fact_governance_votes t1 join osmosis.core.dim_vote_options t2 on t1.vote_option = t2.vote_id
where tx_status = 'SUCCEEDED'
and block_timestamp < CURRENT_DATE
and proposal_id in ('362')
group by 1,2
order by 2 desc
Run a query to Download Data