flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
SNAPSHOT--Top 10 Voter based on Their Vote Number
adambala
SNAPSHOT--Top 10 Voter based on Their Vote Number
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
›
⌄
select
VOTER
,
count
(
distinct
ID
)
as
vote
,
avg
(
voting_power
)
as
"Avg Voting Power over Time"
--- ,PROPOSAL_START_TIME ,PROPOSAL_ID ,
from
ethereum
.
core
.
ez_snapshot
where
SPACE_ID
=
'ocm.eth'
group
by
1
order
by
2
desc
Results
Run a query to Download Data