select
date,
count(distinct address) as address_count,
address_count - lag(address_count,1) over (order by date) as new_accounts
from terra.daily_balances
--where date > getdate() - interval'92 day'
-- and date <= getdate() - interval'2 day'
where date > '2021-03-27'
and date < '2021-06-27'
and address_label is null
group by 1
order by date