flipside

    delicate-blackTransaction Type Gas Fee Analysis (Last 30 Days)
    gihankumardelicate-blackTransaction Type Gas Fee Analysis (Last 30 Days)
    Updated 2025-04-25
    SELECT
    case
    when tx_type = '0' then 'legacy transactions'
    when tx_type = '2' then 'EIP-1559 transactions'
    else 'other'
    end AS Tx_type,
    COUNT(*) AS tx_count,
    AVG(effective_gas_price / 1e9) AS avg_effective_gas_price_gwei,
    AVG(tx_fee) AS avg_fee_eth
    FROM ethereum.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
    GROUP BY 1
    ORDER BY 1;

    Last run: about 2 months ago
    TX_TYPE
    TX_COUNT
    AVG_EFFECTIVE_GAS_PRICE_GWEI
    AVG_FEE_ETH
    1
    		EIP-1559 transactions306052042.998462471e-90.0003820102009
    2
    		legacy transactions67004782.730451652e-90.0001376721042
    3
    		other5939912.857317886e-90.0002018128089
    3
    178B
    3s