nsa2000ETH price
Updated 2022-10-03
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
a.hour::date as date,
case
when b.block_number < 15537351 then 'Before Merge'
when b.block_number >= 15537351 then 'After Merge'
end as merge,
avg (a.price) as ETH_Price
from ethereum.core.fact_hourly_token_prices a join ethereum.core.fact_transactions b on a.HOUR::date=b.BLOCK_TIMESTAMP::date
where a.symbol = 'WETH'
and date>='2022-09-01'
group by 1,2
order by 1