hour AS day,

high - low AS volatility,

close AS price

FROM bitcoin.price.fact_hourly_token_prices

WHERE hour >= current_date - {{price_action_days}}

AND provider = 'coinmarketcap'

ORDER BY hour