vote_timestamp :: date as vote_date,

count(voter) as num_voters

FROM "ETHEREUM"."CORE"."EZ_SNAPSHOT"

WHERE

vote_timestamp :: date >= CURRENT_DATE - {{days}}

AND space_id = 'opcollective.eth'

GROUP BY vote_timestamp :: date