-- Daily New Users Based on the first Transaction date
with new as ( select min(block_timestamp::date) as day,
from_address
from berachain.testnet.fact_transactions
group by 2)
select day,
count(DISTINCT from_address) as "New Users",
sum("New Users") over (order by day asc) as "Cumulative New Users"
from new
group by 1