Skip to content

high_time()

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

Since 1.14.0

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

The syntax is:

high_time(
candlestick Candlestick
) RETURNS TIMESTAMPTZ
NameTypeDefaultRequiredDescription
candlestickCandlestick-✔Candlestick aggregate
ColumnTypeDescription
high_timeTIMESTAMPTZThe time at which the high price occurred. If more than one tick has the high 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).