Date(block_timestamp::date) as date,

count(DISTINCT tx_hash) as total_votes,

count(DISTINCT origin_from_address) as total_voters

FROM optimism.velodrome.ez_votes

GROUP BY 1