SELECT
-- *
date_trunc('day',BLOCK_TIMESTAMP) AS "DATE",
COUNT(DISTINCT(TX_ID)) AS "NO_TXNS",
COUNT(DISTINCT(FROM_ADDRESS)) AS "NO_FROM_ADDR",
COUNT(DISTINCT(TO_ADDRESS)) AS "NO_TO_ADDR" FROM polygon.transactions
WHERE "DATE" >= '2022-07-01T00:00:00Z'
GROUP BY 1
ORDER BY 1 DESC
-- -- LIMIT 10