niloCopy of Untitled Query
    Updated 2022-11-10
    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