shreex2023-01-20 11:29 PM
    Updated 2023-01-20
    with
    tb1 as (
    select
    date,
    'Optimism + Arbitrum Chain' as chain,
    new_user,
    cumulative_new_user
    from
    (
    select
    min_date::date as date,
    count(distinct address) as new_user,
    sum(new_user) over (
    order by
    date
    ) as cumulative_new_user
    from
    (
    select
    from_address as address,
    min(block_timestamp) as min_date
    from
    arbitrum.core.fact_transactions
    GROUP BY
    address
    )
    group by
    date
    )
    WHERE
    date >= '2022-01-01'
    UNION
    select
    date,
    'Optimism + Arbitrum Chain' as chain,
    new_user,
    Run a query to Download Data