'' as token_address,

'ETH' as symbol,

date_trunc('{{date_aggregation}}', hour) as date_jan_1,

avg(price) as avg_price_jan_1

from ethereum.core.fact_hourly_token_prices

where token_address is null

and date_jan_1 = '2023-1-1'

group by date_jan_1, token_address, symbol

),

eth_price_second as (select

'' as token_address,

'ETH' as symbol,

date_trunc('{{date_aggregation}}', hour) as date_jan_16,

avg(price) as avg_price_jan_16

from ethereum.core.fact_hourly_token_prices

where token_address is null

and date_jan_16 = '2023-1-16'

group by date_jan_16, token_address, symbol

),

final_eth as (select *, ((s.avg_price_jan_16 - f.avg_price_jan_1)/f.avg_price_jan_1)*100 as price_change from eth_price_first f

join eth_price_second s using (symbol))

select * from final_eth