WITH aggregated_prices AS (

SELECT

DATE_TRUNC('hour', hour) AS selected_interval,

MIN(open) AS open_price,

MAX(high) AS high_price,

MIN(low) AS low_price,

MAX(close) AS close_price

FROM aptos.price.fact_prices_ohlc_hourly

WHERE asset_id = 'aptos'

AND DATE_TRUNC('month', hour) = DATE_TRUNC('month', CURRENT_DATE)

GROUP BY selected_interval

SELECT * FROM aggregated_prices

ORDER BY selected_interval ASC;