select hour,

avg (price) as savaxprice

from avalanche.price.ez_prices_hourly

where token_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

and hour >= '2025-03-01'

group by 1),

pricet as (

select date_trunc (hour,hour) as day,

avg (price) as price

from avalanche.price.ez_prices_hourly

where token_address = '0x3fe4902b275caf603c46c81f3d921bb8515b5bc0'

group by 1),

pricet1 as (

select date_trunc (hour,block_timestamp) as day1,

median (amount_in_usd/amount_out) as price

from avalanche.defi.ez_dex_swaps

where symbol_in in ('WAVAX','USDC')

and (token_out = '0x3fe4902b275caf603c46c81f3d921bb8515b5bc0')

and block_timestamp >= '2025-04-03'

group by 1),

pricet2 as (

select date_trunc (hour,block_timestamp) as day1,

median (amount_in*savaxprice/amount_out) as price

from avalanche.defi.ez_dex_swaps t1 join savaxpricet t2 on date_Trunc (hour,t1.block_timestamp) = t2.hour

where token_in = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

and (token_out = '0x3fe4902b275caf603c46c81f3d921bb8515b5bc0')

and block_timestamp >= '2025-04-03'

group by 1),

low_high_table as (

select day1,

min (price) as low_price,