space_id,

count(DISTINCT proposal_id) AS proposals,

count(DISTINCT voter) AS unique_voters

FROM ethereum.core.ez_snapshot

WHERE proposal_start_time >= CURRENT_DATE - 30

GROUP BY space_id

ORDER BY unique_voters DESC