One row per period: ::XAXIS, ::OPEN, ::HIGH, ::LOW; the measure is the close.
SELECT d ::XAXIS, o ::OPEN, h ::HIGH, l ::LOW, c ::CANDLESTICK
FROM (VALUES (DATE'2026-03-02',10,12,9,11),(DATE'2026-03-03',11,13,10,12.5),(DATE'2026-03-04',12.5,13,11,11.2),(DATE'2026-03-05',11.2,12,10.5,11.8)) t(d, o, h, l, c);
SELECT4::COL; SELECT d::XAXIS, open::OPEN, high::HIGH, low::LOW, close::CANDLESTICK, 'Candlestick — 30-day OHLC'::TITLE FROM ohlc WHERE d <DATE'2024-01-31'ORDER BY d