select date_trunc ({{Time_Interval}},mindate) as date,
count (Distinct tx_from) as New_Users,
sum (New_Users) over (order by date) as Total_users
from
(select tx_from,
min (block_timestamp) as mindate
from lava.core.fact_transactions
group by 1
having mindate >= '2024-07-30 11:00:00.000') -- Public Mainnet Launch
group by 1
order by 1 desc