kaibladeDaily Total Transaction Volume (Optimism vs Arbitrum)
    Updated 2023-01-16
    WITH optimism_daily AS
    (SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Total Transaction Volume",
    'Optimism' AS chain_type
    FROM optimism.core.fact_transactions
    WHERE status = 'SUCCESS'
    GROUP BY "Days", chain_type),

    arbitrum_daily AS
    (SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Total Transaction Volume",
    'Arbitrum' AS chain_type
    FROM arbitrum.core.fact_transactions
    WHERE status = 'SUCCESS'
    GROUP BY "Days", chain_type)

    SELECT *
    FROM optimism_daily

    UNION

    SELECT *
    FROM arbitrum_daily
    Run a query to Download Data