mlharb, count of active users1
    Updated 2022-09-08
    select date_trunc('day', block_timestamp) as day,
    count(distinct(active_user)) as active_users,
    'before Nitro' as type
    from (select block_timestamp,
    origin_from_address as active_user,
    event_inputs:value/1e6 as transaction_size
    from arbitrum.core.fact_event_logs
    where block_timestamp >= '2022-08-26'
    and block_timestamp < '2022-08-31'
    and event_inputs:value > 0
    )
    group by 1, 3

    UNION

    select date_trunc('day', block_timestamp) as day,
    count(distinct(active_user)) as active_users,
    'after Nitro' as type
    from (select block_timestamp,
    origin_from_address as active_user,
    event_inputs:value/1e6 as transaction_size
    from arbitrum.core.fact_event_logs
    where block_timestamp > '2022-08-31'
    and event_inputs:value > 0
    )
    group by 1, 3
    Run a query to Download Data