--Distinct proposal IDs per day
--Distinct voters per day
--Number of transactions per day
SELECT count(*) , COUNT(DISTINCT VOTER)as voter,count(distinct proposal_id)as proposal_id , BLOCK_TIMESTAMP::DATE as date FROM ethereum.maker.ez_governance_votes group by 4
--SELECT count(*) , COUNT(DISTINCT VOTER)as voter,count(distinct proposal_id)as proposal_id , BLOCK_TIMESTAMP::DATE FROM ethereum.maker.ez_governance_votes group by 4