flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
BECOME A PARTNER
flipside
voting power
camp
voting power
Updated 2022-04-25
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
count
(
distinct
PROPOSAL_ID
)
as
num_proposals
,
sum
(
VOTING_POWER
)
/
num_proposals
as
votepower_avg
FROM
terra
.
gov_vote
where
TX_STATUS
=
'SUCCEEDED'
and
OPTION
in
(
'Yes'
)
and
block_timestamp
::
Date
<=
'2022-04-20'
Results
Run a query to Download Data