SELECT 'Voter' AS voters,

date_trunc('day',block_timestamp) AS date,

count(distinct voter) AS total

FROM ethereum.maker.ez_governance_votes

WHERE block_timestamp::date BETWEEN '2022-08-01' AND '2022-08-31'

GROUP BY 2

ORDER BY date

select avg(total),

sum(total) as total_voters

from August