select date_trunc('day', block_timestamp) as hours,
median(amount_usd/amount) as avax_price,
sum(amount) as avax_transfer
from avalanche.core.ez_avax_transfers
where block_timestamp::date <= CURRENT_DATE-1 AND amount_usd>0
group by hours
ORDER BY hours DESC