Updated 2023-01-03
    --credit : https://app.flipsidecrypto.com/velocity/queries/b8d37b49-806c-4cc4-b374-f88fb20bd1c8
    with maintable as (
    select date_trunc (day,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 osmosis.core.fact_transactions
    group by 1)
    group by 1)

    select avg (new_users) as Average_Daily_New_Users
    from maintable
    Run a query to Download Data