MasiAverage Fee November
    Updated 2024-12-04
    -- Credit to hess

    with chains as (select date(block_timestamp) as date,
    'Arbitrum' as chain,
    'WETH' as symbol,
    tx_fee
    from arbitrum.core.fact_transactions
    where block_timestamp::date >= '2024-11-01' and block_timestamp < '2024-12-01'
    and status = 'SUCCESS'

    UNION
    select date(block_timestamp) as date,
    'Optimism' as chain,
    'WETH' as symbol,
    tx_fee
    from optimism.core.fact_transactions
    where block_timestamp::date >= '2024-11-01' and block_timestamp < '2024-12-01'
    and status = 'SUCCESS'

    UNION
    select date(block_timestamp) as date,
    'Polygon' as chain,
    'WMATIC' as symbol,
    tx_fee
    from polygon.core.fact_transactions
    where block_timestamp::date >= '2024-11-01' and block_timestamp < '2024-12-01'
    and status = 'SUCCESS'

    UNION
    select date(block_timestamp) as date,
    'Avalanche' as chain,
    'WAVAX' as symbol,
    tx_fee
    from avalanche.core.fact_transactions
    where block_timestamp::date >= '2024-11-01' and block_timestamp < '2024-12-01'
    and status = 'SUCCESS'
    Last run: about 1 month ago
    CHAIN
    TYPE
    AVG_FEE
    1
    NearNear0.003540030475
    2
    PolygonOther Chains0.01222555124
    3
    SeiOther Chains0.0155425505
    4
    OptimismOther Chains0.03141530282
    5
    ArbitrumOther Chains0.03890453137
    6
    BaseOther Chains0.06740134285
    7
    AptOther Chains0.07931632605
    8
    AvalancheOther Chains0.3359623455
    9
    SolanaOther Chains0.4076763387
    10
    EthereumOther Chains6.477816641
    10
    389B
    350s