date_trunc('day',block_timestamp) as date,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as user_count,

count(distinct block_number) as block_count,

avg(tx_fee) as tx_fee_average,

avg(price) as price,

avg(eth_value) as eth_val,

case when date >= '2022-09-15' then 'After Merge' else 'Before Merge' end as type --else 'Before Merge'

from ethereum.core.fact_transactions

left join ethereum.core.fact_hourly_token_prices on block_timestamp::date = hour::date

where date >= '2022-08-01'

and date != current_date

and symbol = 'WETH'

group by date