Mrftiprinted-amaranth
    Updated 13 hours ago
    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: about 13 hours agoAuto-refreshes every 12 hours
    Block Count
    Transaction Count
    Total Gas Used
    Average Transactions per Block
    Average Block Utilization (%)
    1
    470630851652172616269332111.0975090.0926570573
    1
    54B
    2s