max(vote_events),

median(vote_events),

avg(vote_events)

FROM (

SELECT

date_trunc('hour', block_timestamp) as day,

count(*) as vote_events

FROM osmosis.core.fact_governance_votes

LEFT outer join osmosis.core.dim_vote_options

on vote_id = vote_option

WHERE proposal_id = 362

AND block_timestamp > '2022-11-13'

GROUP by 1