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 = 362

AND block_timestamp::date > '2022-11-13'

group by 1,2