check_skedARB OP 1 Week TPS
    Updated 2023-08-09
    SELECT
    arb.TXS AS ARB_TXS,
    arb.TXS / 604800.0 AS ARB_TPS,
    op.TXS AS OP_TXS,
    op.TXS / 604800.0 AS OP_TPS
    FROM
    (
    SELECT
    COUNT(DISTINCT TX_HASH) AS TXS
    FROM
    arbitrum.core.fact_transactions
    WHERE
    block_timestamp >= CURRENT_DATE - INTERVAL '7 day'
    ) arb,
    (
    SELECT
    COUNT(DISTINCT TX_HASH) AS TXS
    FROM
    optimism.core.fact_transactions
    WHERE
    block_timestamp >= CURRENT_DATE - INTERVAL '7 day'
    ) op;
    Run a query to Download Data