hessTotal Daily New users
    Updated 2025-01-07
    with new as ( select min(block_timestamp::date) as day,
    from_address
    from blast.core.fact_transactions
    where status = 'SUCCESS'
    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
    QueryRunArchived: QueryRun has been archived