gokcinall proposals
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT proposal_id,date_trunc('month',block_timestamp) as date,
DESCRIPTION,
count(DISTINCT voter) as voters,
count(DISTINCT tx_id) as votes
FROM osmosis.core.fact_governance_votes
LEFT outer JOIN osmosis.core.dim_vote_options
ON VOTE_ID = vote_option
WHERE proposal_id in (114, 196, 337) and tx_status ='SUCCEEDED'
GROUP by 1,2,3
order by date
Run a query to Download Data