0-MIDeth value after
Updated 2023-04-13
9
1
2
3
4
5
6
7
8
9
›
⌄
select BLOCK_TIMESTAMP::date as date,sum(ETH_VALUE) as eth_vlume
, avg(eth_vlume)over(order by date asc) daily_avg_eth_vlume
, case
when date ='2022-09-15'then 'merge day' else 'after merge' end as day
from ethereum.core.fact_transactions
where date>='2022-09-15'
group by 1
Run a query to Download Data