LittlerDataOsmosis New Users
    Updated 2023-01-03
    with arrivals as (
    select
    tx_from
    ,min(block_timestamp) as arrival
    from osmosis.core.fact_transactions
    group by 1
    )


    select
    count(tx_from) as New_Wallets
    ,date_trunc('day',arrival) as date
    ,sum(New_Wallets) over (order by date asc) "Over Time"
    from arrivals
    group by 2
    order by date asc

    Run a query to Download Data