DATE_TRUNC('week', hour) AS week,

symbol,

blockchain,

MAX(price) - MIN(price) AS weekly_price_change

FROM

kaia.price.ez_prices_hourly

WHERE

hour >= '2024-01-01' AND hour < CURRENT_DATE

AND is_native = TRUE

GROUP BY

week, symbol, blockchain

ORDER BY

week;