select date_trunc('day',block_timestamp) as date , count(distinct tx_hash) as votes

from ethereum.maker.ez_governance_votes

where block_timestamp >= '2022-01-01'

group by date

order by date asc

select * from votes_tb