select date_trunc ({{Time_Interval}},mindate) as date,
count (Distinct from_address) as "New Wallets",
sum ("New Wallets") over (order by date) as "Total Wallets"
from (
select from_address,
min (block_timestamp) as mindate
from blast.core.fact_transactions
where block_timestamp >= '2024-02-29 00:00:00.000'
group by 1)
group by 1
order by 1 desc