Elprognerd8 - fee
    Updated 2023-03-06
    SELECT
    'Arbitrum' as chain,
    max(TX_FEE) as "Maximum txn fee",
    avg(TX_FEE) as "Average fee per txn"
    FROM arbitrum.core.fact_transactions
    where block_timestamp >= '2023-01-01'
    GROUP by 1
    UNION all
    SELECT
    'Optimism' as chain,
    max(TX_FEE) as "Maximum txn fee",
    avg(TX_FEE) as "Average fee per txn"
    FROM optimism.core.fact_transactions
    where block_timestamp >= '2023-01-01'
    GROUP by 1
    Run a query to Download Data