flipside

    Optimism Chain Activity
    SniperOptimism Chain Activity
    Updated 2022-11-08

    SELECT
    Date(date_trunc('day', block_timestamp)) as Date,
    status,
    count(DISTINCT tx_hash) Count_Tr
    FROM optimism.core.fact_transactions
    WHERE block_timestamp BETWEEN '2022-07-01' AND '2022-08-01'
    GROUP BY Date,status
    Run a query to Download Data