select

date_trunc('day', hour) as date,

avg(price) as WETH_Price

from optimism.core.fact_hourly_token_prices

where symbol like 'WETH'

group by 1

)

select

date_trunc('day', block_timestamp) as date,

case when date >= '2023-01-10' then 'After the Flip'

else 'Before the Flip' END as date_Flipped,

sum(tx_fee * WETH_Price)

from arbitrum.core.fact_transactions left outer join tab1

on date_trunc('day', block_timestamp) = tab1.date

where block_timestamp > '2022-12-01'

group by 1,2