mattkstewTF Arbitrum 4
    Updated 2023-01-19
    with tab1 as (
    select
    from_address,
    min(date_trunc('day', block_timestamp)) as date

    from arbitrum.core.fact_transactions
    where block_timestamp > '2022-12-01'
    group by 1 )

    , tab2 as (
    select
    date,
    count(*) as New_Users
    from tab1
    group by 1 )

    select
    date,
    sum(New_Users) over (order by date)
    from tab2


    Run a query to Download Data