flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Optimism Snapshot Voting
theericstone
Optimism Snapshot Voting
Updated 2022-10-24
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
lower
(
voter
)
as
address
,
count
(
1
)
as
n_votes
FROM
"ETHEREUM"
.
"CORE"
.
"EZ_SNAPSHOT"
WHERE
vote_timestamp
::
date
>=
CURRENT_DATE
-
90
AND
space_id
=
'opcollective.eth'
GROUP
BY
voter
;
Results
Run a query to Download Data