count (DISTINCT (FROM_ADDRESS)) UNIQUE_ADDRESSES,

DATE_TRUNC('HOUR',BLOCK_TIMESTAMP) HOUR

FROM polygon.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2022-07-01'

GROUP BY HOUR