PlaywoCrossChain: L2 Block TX Count
    Updated 2022-07-27
    WITH polygon AS (
    SELECT 'Polygon' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
    avg(tx_count) AS average_tx_count
    FROM polygon.core.fact_blocks
    GROUP BY time
    ),
    optimism AS (
    SELECT 'Optimism' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
    avg(tx_count) AS average_tx_count
    FROM optimism.core.fact_blocks
    GROUP BY time
    ),
    arbitrum AS (
    SELECT 'Arbitrum' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
    avg(tx_count) AS average_tx_count
    FROM arbitrum.core.fact_blocks
    GROUP BY time
    ),
    collected AS (
    SELECT * FROM polygon UNION
    SELECT * FROM arbitrum UNION
    SELECT * FROM optimism
    ),
    mins AS (
    SELECT min(time) AS first_entry_time
    FROM collected
    GROUP BY chain
    )
    SELECT * FROM collected
    WHERE time >= (SELECT max(first_entry_time) FROM mins)
    Run a query to Download Data