SELECT

CASE

WHEN '{{TimeFrame}}' = 'hourly' THEN DATE_TRUNC('hour', hour)

WHEN '{{TimeFrame}}' = 'daily' THEN DATE_TRUNC('day', hour)

WHEN '{{TimeFrame}}' = 'weekly' THEN DATE_TRUNC('week', hour)

END AS selected_interval,

MIN(open) AS open_price,

MAX(high) AS high_price,

MIN(low) AS low_price,

MAX(close) AS close_price

FROM solana.price.fact_prices_ohlc_hourly

WHERE asset_id = 'wrapped-solana'

AND hour BETWEEN '2024-07-01' AND '2024-09-30'

GROUP BY selected_interval

SELECT * FROM aggregated_prices

ORDER BY selected_interval ASC;