SELECT
date_trunc('day',block_timestamp) as day,
count(*) as new_wallets
FROM algorand.account a
LEFT JOIN algorand.block b
ON a.created_at = b.block_id
WHERE block_timestamp >= current_date -30
AND block_timestamp < current_date
GROUP BY day
ORDER BY day