mlh114
Updated 2022-11-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_trunc('day', block_timestamp) as days,
proposal_id,
DESCRIPTION,
count(DISTINCT voter) as voters,
sum(VOTE_WEIGHT) as voting_power
FROM osmosis.core.fact_governance_votes
LEFT outer JOIN osmosis.core.dim_vote_options
ON VOTE_ID = vote_option
WHERE proposal_id in (114)
GROUP by 1,2, 3
Run a query to Download Data