select date_trunc (day, hour) as date,

avg(price) as "DEGEN price"

from base.price.ez_prices_hourly

where token_address=lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')

GROUP by 1

order by 1

),

eth_tbl as (

select date_trunc (day, hour) as date,

avg(price) as "ETH price"

from base.price.ez_prices_hourly

where token_address=lower ('0x4200000000000000000000000000000000000006')

GROUP by 1

order by 1)

select a.date,

"DEGEN price",

from DEGEN_tbl a join eth_tbl b on a.date = b.date

order by 1