-- forked from Top 10 voters @ https://flipsidecrypto.xyz/studio/queries/539e6e09-d845-4e84-ab3b-c22abeda49fb
SELECT
voter AS "Address",
count(DISTINCT proposal_id) as "voting count",
avg (voting_power) as "average voting power",
min (voting_power) as "minimum voting power",
max (voting_power) as "maximum voting power",
sum (voting_power) as "total voting power"
FROM
ethereum.core.ez_snapshot
where
space_id = 'opcollective.eth'
GROUP BY 1
order by 2 desc
limit 500