week(vote_timestamp) as week,

dayname(vote_timestamp :: date) as day,

count(distinct id) as num_votes

FROM ethereum.core.ez_snapshot

WHERE space_id ilike '%aave.eth%'

AND vote_timestamp :: date >= '2022-06-01'

AND vote_timestamp :: date <= '2022-12-31'

GROUP BY week(vote_timestamp), dayname(vote_timestamp :: date)