select HOUR::date as date
,avg(PRICE) as avg
,max(PRICE) as max
,min(PRICE) as min
,max-min as change_range
,((min/avg)-1)*100 as "% Decrease"
,((max/avg)-1)*100 as "% Increase"
,"% Decrease"+"% Increase" as "%Price Change In 24h"
from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS='0x6982508145454ce325ddbe47a25d4ec3d2311933'
group by 1