alirsOptimism TX per Block
    Updated 2022-07-27
    WITH tab1 as (
    SELECT
    BLOCK_NUMBER,
    count(*) as amt
    FROM optimism.core.fact_transactions
    GROUP BY 1

    )

    SELECT
    date_trunc('day', block_timestamp),
    avg(amt) as avg,
    min(amt) as min,
    max(amt) as max
    FROM optimism.core.fact_blocks JOIN tab1 on tab1.BLOCK_NUMBER= optimism.core.fact_blocks.BLOCK_NUMBER
    GROUP BY 1

    Run a query to Download Data