MrftiTop voters (Based on vote count)
Updated 2024-10-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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
QueryRunArchived: QueryRun has been archived