SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS TIME, count(TX_HASH)

FROM ethereum.aave.ez_deposits

WHERE BLOCK_TIMESTAMP::DATE BETWEEN '2022-08-01' AND '2022-08-31'

GROUP BY 1

ORDER BY 1 DESC;