SELECT
a."date",
COUNT (DISTINCT (a.FROM_ADDRESS)) AS new_addresses,
SUM (new_addresses) OVER (ORDER BY "date") AS acm_new_addresses
FROM (
SELECT
BLOCK_TIMESTAMP::date AS "date",
FROM_ADDRESS,
ROW_NUMBER() OVER (PARTITION BY FROM_ADDRESS ORDER BY "date") AS SrNo
FROM arbitrum.core.fact_transactions
WHERE "date" > '2022-06-22'
) a
WHERE a.SrNo = 1
GROUP BY a."date"
ORDER BY a."date"