Skip to content

low_time()

Get the timestamp corresponding to the low time from a candlestick aggregate

Since 1.14.0

Get the timestamp corresponding to the low time from a candlestick aggregate.

The syntax is:

low_time(
candlestick Candlestick
) RETURNS TIMESTAMPTZ
NameTypeDefaultRequiredDescription
candlestickCandlestick-✔Candlestick aggregate
ColumnTypeDescription
low_timeTIMESTAMPTZThe time at which the low price occurred. If more than one tick has the low price, which of their times is returned depends on the order in which the aggregate processes the input. To get the earliest, order the aggregate input by ts, for example candlestick_agg(ts, price, volume ORDER BY ts).