ZSaed5.1 pro 3665
    Updated 2023-01-22
    select
    BLOCK_TIMESTAMP::date as day,
    PROPOSAL_ID::string as ID ,
    VOTE_OPTION_TEXT,
    count(tx_id) as num_vote,
    sum(num_vote) over(Partition by VOTE_OPTION_TEXT order by day ) as cum_vote

    from terra.core.fact_governance_votes
    where TX_SUCCEEDED = TRUE
    and PROPOSAL_ID in(3665)
    GROUP by id ,VOTE_OPTION_TEXT,day

    Run a query to Download Data