niloCopy of Untitled Query
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC ('DAY', BLOCK_TIMESTAMP) AS DATE,
--DESCRIPTION,
CASE
WHEN PROPOSAL_ID = '114' THEN 'Proposal No. 114'
WHEN PROPOSAL_ID = '196' THEN 'Proposal No. 196'
WHEN PROPOSAL_ID = '337' THEN 'Proposal No. 337'
END AS TYPE,
SUM (VOTE_WEIGHT) AS VOTE_WEIGHTS,
sum (VOTE_WEIGHTS) over (partition by TYPE order by date ) as cum
FROM osmosis.core.fact_governance_votes
LEFT JOIN osmosis.core.dim_vote_options ON VOTE_OPTION = VOTE_ID
WHERE PROPOSAL_ID IN (337,114,196)
GROUP BY 1,2
Run a query to Download Data