eferfanO1
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with Base as (
SELECT
block_timestamp,
description,
VOTE_WEIGHT
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'
)
SELECT
date_trunc('hour', block_timestamp) as Date,
description,
count(1) as events,
sum(VOTE_WEIGHT) as power
FROM Base
GROUP by 1,2
Run a query to Download Data