Untitled Query

ramishoowUntitled Query

Updated 2022-11-23

SELECT max(vote_events) as "Max vote event ", median(vote_events) as "median vote events",

avg(vote_events) as "Average 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

--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)

Run a query to Download Data

flipside