Date | Values | |
---|---|---|
1 | 2024-01-28 00:00:00.000 | 0.07232871429 |
2 | 2024-01-27 00:00:00.000 | 0.07289623635 |
3 | 2024-01-26 00:00:00.000 | 0.1002647019 |
4 | 2024-01-25 00:00:00.000 | 0.1152681389 |
5 | 2024-01-24 00:00:00.000 | 0.07052193288 |
6 | 2024-01-23 00:00:00.000 | 0.08883247712 |
7 | 2024-01-22 00:00:00.000 | 0.1013507042 |
8 | 2024-01-21 00:00:00.000 | 0.08468230707 |
9 | 2024-01-20 00:00:00.000 | 0.0910087404 |
alitaslimiArbitrum Fees Median Fees Daily
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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
9
375B
38s