mohammadh4)Open Analytics Bounty: Aribtrum
    Updated 2022-09-08
    with A as(select
    distinct (FROM_ADDRESS) as distinct_user
    from arbitrum.core.fact_transactions
    where block_timestamp < '2022-07-01')

    select
    date_trunc('day', block_timestamp) as block_day,
    count(distinct FROM_ADDRESS) as new_distinct_user,
    CASE
    when block_day < '2022-08-31' then 'before nitro upgrade' else 'after nitro upgrade' end as time_category
    from arbitrum.core.fact_transactions
    where FROM_ADDRESS not in (select distinct_user from A)
    and block_day >= '2022-07-01'
    group by block_day