0-MIDeth tx fee before
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select BLOCK_TIMESTAMP::date as date,avg(TX_FEE) as eth_tx_fee
, avg(eth_tx_fee)over(order by date asc) daily_avg_eth_tx_fee
, case
when date ='2022-09-15' then 'merge day'
when date <='2022-09-15' and date>='2022-09-08' then '1 week before merge'
end as time
from ethereum.core.fact_transactions
where date>='2022-09-08' and date<='2022-09-15'
group by 1
Run a query to Download Data