ZSaed5.1 pro 3665
Updated 2023-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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