COUNT (DISTINCT TO_ADDRESS)

FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP BETWEEN '2022-06-01' AND '2022-06-30';