date(b.block_timestamp) as date,

COUNT(DISTINCT b.tx_hash) AS "Votes",

COUNT(DISTINCT b.voter) AS "Voters"

FROM ethereum.aave.ez_votes b

where date(b.block_timestamp) >= CURRENT_DATE - 180

GROUP BY date