Skip to content

open()

Get the opening price from a candlestick aggregate

Since 1.14.0

Get the opening price from a candlestick aggregate.

The syntax is:

open(
candlestick Candlestick
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
candlestickCandlestick-✔Candlestick aggregate
ColumnTypeDescription
openDOUBLE PRECISIONThe opening price. If more than one tick has the earliest timestamp, which price is returned depends on the order in which the aggregate processes the input.