DATE_trunc('day',block_timestamp) as day,

count(distinct proposal_id),

count (distinct voter),

count( distinct tx_hash)

from ethereum.aave.ez_votes

where BLOCK_TIMESTAMP >= CURRENT_DATE - 180

GROUP by 1