tavoBlock Trends Analysis
    Updated 2024-08-29
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    AVG(gas_used) AS avg_gas_used,
    AVG(tx_count) AS avg_transactions_per_block,
    AVG(difficulty) AS avg_difficulty
    FROM
    kaia.core.fact_blocks
    WHERE
    block_timestamp >= CURRENT_DATE - INTERVAL '2 months'
    GROUP BY
    DATE_TRUNC('day', block_timestamp)
    ORDER BY
    date DESC;

    QueryRunArchived: QueryRun has been archived