SELECT hour, open, high, low, close

FROM near.price.fact_prices_ohlc_hourly

WHERE asset_id = 'near'

AND provider = 'coingecko'

AND hour >= DATE_TRUNC('week', CURRENT_DATE - INTERVAL '1 week')

AND hour < DATE_TRUNC('week', CURRENT_DATE)

SELECT

hour AS timestamp,

ROUND(open, 4) AS open,

ROUND(high, 4) AS high,

ROUND(low, 4) AS low,

ROUND(close, 4) AS close,

ROUND((close - open) / open * 100, 2) AS price_change_percentage

FROM last_week_prices

ORDER BY hour ASC;