Ali3NDately New & Total Lava Users Over Time
    Updated 2024-08-15
    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


    QueryRunArchived: QueryRun has been archived