SELECT 'proposals' AS proposals,
date_trunc('month',block_timestamp) AS date,
count(distinct proposal_id) AS total_proposals
FROM ethereum.maker.ez_governance_votes
WHERE block_timestamp::DATE BETWEEN '2022-01-01' AND '2022-08-31'
GROUP BY 2
ORDER BY date