NuveveCryptoArchivedA vs B Total Fees
    Updated 2022-07-03
    with arb as (
    select
    concat('Arbitrum') as category,
    sum(tx_fee) as total
    from arbitrum.core.fact_transactions
    where block_timestamp > '2022-06-20 00:00'
    and block_timestamp < '2022-06-27 01:00'
    ),

    bsc as (
    select
    concat('BSC') as category,
    sum(tx_fee) as total
    from bsc.core.fact_transactions
    where block_timestamp > '2022-06-20 00:00'
    and block_timestamp < '2022-06-27 01:00'
    )

    select *
    from arb
    union
    select *
    from bsc

    Run a query to Download Data