SocioCryptoARB vs OPT: Tx fee
Updated 2023-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT 'arbitrum' as label,
avg(daily_avg_fee) as avg_tx_fee
FROM (SELECT
date_trunc('day',block_timestamp) as dates,
avg(tx_fee) as daily_avg_fee
FROM arbitrum.core.fact_transactions
WHERE date_trunc('day',block_timestamp) between CURRENT_DATE-interval '1 d,1 y' and CURRENT_DATE-1
GROUP BY dates)
UNION
SELECT 'optimism' as label,
avg(daily_avg_fee) as avg_tx_fee
FROM (SELECT
date_trunc('day',block_timestamp) as dates,
avg(tx_fee) as daily_avg_fee
FROM optimism.core.fact_transactions
WHERE date_trunc('day',block_timestamp) between CURRENT_DATE-interval '1 d,1 y' and CURRENT_DATE-1
GROUP BY dates)
Run a query to Download Data