case

when day >= '2022-09-01' then '2 Weeks Prior to The Merge'

else 'Other Days'

end as periods,

sum(amount_withdrawn) as eth_amount,

sum(amount_withdrawn) * avg(price) as eth_amount_usd

from ethereum.maker.ez_withdrawals a

join ethereum.core.fact_hourly_token_prices b

on date_trunc('day', a.block_timestamp) = date_trunc('day', b.hour)

where a.symbol = 'WETH'

and b.symbol = 'WETH'

and day >= '2022-06-01'

group by 1