Elprognerd9 - avg daily fee
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
block_timestamp:: date as date,
'Arbitrum' as chain,
avg(TX_FEE) as "Average fee per txn"
FROM arbitrum.core.fact_transactions
where block_timestamp >= '2023-01-01'
GROUP by 1 , 2
UNION all
SELECT
block_timestamp:: date as date,
'Optimism' as chain,
avg(TX_FEE) as "Average fee per txn"
FROM optimism.core.fact_transactions
where block_timestamp >= '2023-01-01'
GROUP by 1, 2
order by 1
Run a query to Download Data