Mrftiprinted-amaranth
    Updated 2025-06-23
    SELECT
    COUNT(DISTINCT block_number) AS "Block Count",
    SUM(tx_count) AS "Transaction Count",
    SUM(GAS_USED) AS "Total Gas Used",
    "Transaction Count" / "Block Count" AS "Average Transactions per Block",
    AVG(GAS_USED / NULLIF(GAS_LIMIT, 0)) * 100 AS "Average Block Utilization (%)"
    FROM
    swell.core.fact_blocks
    Last run: 3 months ago
    Block Count
    Transaction Count
    Total Gas Used
    Average Transactions per Block
    Average Block Utilization (%)
    1
    89840161550186836947832307361.7254940.6854446381
    1
    56B
    4s