WITH First_txns AS (
SELECT
FROM_ADDRESS,
Min(BLOCK_TIMESTAMP) AS first_txn
FROM polygon.core.fact_transactions
WHERE BLOCK_TIMESTAMP>='2022-06-30' --since July
AND STATUS='SUCCESS'
GROUP BY FROM_ADDRESS)
SELECT
DATE_TRUNC('DAY',first_txn)::DATE AS DAY,
COUNT(DISTINCT FROM_ADDRESS) AS Number_of_new_wallets
FROM First_txns
GROUP BY DAY
ORDER BY DAY ASC