SELECT date_trunc('day',BLOCK_TIMESTAMP) date, count(FROM_ADDRESS) "Number of Unique Wallet"
FROM flipside_prod_db.polygon.transactions t
INNER JOIN
(
SELECT FROM_ADDRESS wallet, MIN(BLOCK_TIMESTAMP) As first_occurence
FROM flipside_prod_db.polygon.transactions
where --block_timestamp>='2022-01-01 00:00:00.000' and
SUCCESS=TRUE
GROUP BY FROM_ADDRESS
) X
ON t.FROM_ADDRESS = X.wallet AND t.BLOCK_TIMESTAMP = x.first_occurence
group by date order by date
--limit 10