mlharb, daily usdc trx volume
    Updated 2022-09-08
    select date_trunc('day', block_timestamp) as day,
    count(distinct(active_user)) as users,
    sum(transaction_size) as trx_size,
    'before Nitro' as type
    from (select block_timestamp,
    event_inputs:from as active_user,
    event_inputs:value/1e6 as transaction_size
    from arbitrum.core.fact_event_logs
    where contract_address ilike '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'
    and event_name = 'Transfer'
    and tx_hash not in (select tx_hash
    from (select tx_hash
    from arbitrum.core.fact_event_logs
    where event_name = 'Swap'
    )
    )
    and block_timestamp >= '2022-08-26' and block_timestamp < '2022-08-31'
    and event_inputs:value > 0
    )
    group by 1,4

    UNION

    select date_trunc('day', block_timestamp) as day,
    count(distinct(active_user)) as users,
    sum(transaction_size) as trx_size,
    'after Nitro' as type
    from (select block_timestamp,
    event_inputs:from as active_user,
    event_inputs:value/1e6 as transaction_size
    from arbitrum.core.fact_event_logs
    where contract_address ilike '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'
    and event_name = 'Transfer'
    and tx_hash not in (select tx_hash
    from (select tx_hash
    from arbitrum.core.fact_event_logs
    Run a query to Download Data