block_timestamp as time,

amount_usd/amount as avax_price

from avalanche.core.ez_avax_transfers

where block_timestamp >= '2022-10-20'),

final as (select

date_trunc('hour', time) as hour,

avg(avax_price) as avg_avax_price

from data

group by hour)

select

date_trunc('day', hour) as date,

avg(avg_avax_price) as avg_price_avax

from final

where date >= current_date() - 30

group by date