-- forked from jackguy / Snapshot DAO Activity Tool 2 @ https://flipsidecrypto.xyz/jackguy/q/untitled-query-eo6dMJ
with tab1 as (
SELECT
proposal_id,
proposal_start_time,
count(*) as votes,
count(DISTINCT voter) as voters
FROM ethereum.core.ez_snapshot
WHERE space_id LIKE '{{dao}}'
GROUP BY 1,2
)
SELECT *
from tab1
--ORDER BY 2 DESC
--LIMIT 100