alitaslimiArbitrum Fees Median Fees Daily
    Updated 2024-01-30
    WITH
    prices AS (
    SELECT
    hour::date AS day,
    AVG(price) AS price
    FROM
    crosschain.price.ez_hourly_token_prices
    WHERE
    symbol = 'WETH'
    GROUP BY
    day
    )
    SELECT
    block_timestamp::date AS "Date",
    MEDIAN(tx_fee * price) AS "Values"
    FROM
    arbitrum.core.fact_transactions transactions
    JOIN prices ON transactions.block_timestamp::date = prices.day
    WHERE
    block_timestamp::date >= (CURRENT_DATE - 10)
    GROUP BY
    "Date"
    QUALIFY
    "Date" < LAST_VALUE("Date") OVER (ORDER BY "Date")
    ORDER BY
    "Date" DESC
    Last run: about 1 year agoAuto-refreshes every 6 hours
    Date
    Values
    1
    2024-01-28 00:00:00.0000.07232871429
    2
    2024-01-27 00:00:00.0000.07289623635
    3
    2024-01-26 00:00:00.0000.1002647019
    4
    2024-01-25 00:00:00.0000.1152681389
    5
    2024-01-24 00:00:00.0000.07052193288
    6
    2024-01-23 00:00:00.0000.08883247712
    7
    2024-01-22 00:00:00.0000.1013507042
    8
    2024-01-21 00:00:00.0000.08468230707
    9
    2024-01-20 00:00:00.0000.0910087404
    9
    375B
    38s