WITH new_wallets AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT from_address) AS total_new_wallets
FROM MONAD.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
)
SELECT
day,
total_new_wallets
FROM new_wallets
ORDER BY day DESC
LIMIT 1