Date_trunc('month',PROPOSAL_START_TIME) AS Month,

Count(*) AS Total_votes,

Count(DISTINCT VOTER) AS Total_voters,

Count(DISTINCT PROPOSAL_ID) AS Total_Proposals,

Count(DISTINCT PROPOSAL_AUTHOR) AS Total_Proposal_authors,

Count(DISTINCT SPACE_ID) AS Total_spaces

FROM ethereum.core.ez_snapshot

Group By 1