WITH new_accounts AS (
SELECT DISTINCT address, block_timestamp
FROM flipside_prod_db.algorand.account account
LEFT JOIN flipside_prod_db.algorand.block ON account.created_at = block.block_id
WHERE block.block_timestamp::date >= '2022-01-01'
)
SELECT
date_trunc('day',block_timestamp) as day_created,
COUNT(*) AS daily_new_wallets
FROM new_accounts
GROUP BY day_created
ORDER BY day_created