Skip to content

::CANDLESTICK

Dashboards: browser · CLI · servers Community extension: anofox_render

OHLC candlesticks: XAXIS + ::OPEN/::HIGH/::LOW, close as the measure.

Also spelled: ::CANDLE, ::OHLC

The minimal panel below, rendered

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);

Edit it in the builder ↗

From Which chart fits which question? — open it in the builder ↗:

SELECT 4::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

::LINECHART · ::LINECHART_PERCENT · ::STEP · ::SMOOTH · ::AREACHART · ::AREACHART_STACKED · ::SPARKLINE · ::SPARKBAR