Skip to content
Join us at Tiger Data Aggregate 2026 for workshops, talks, and networking.

open_time()

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

Since 1.14.0

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

The syntax is:

open_time(
candlestick Candlestick
) RETURNS TIMESTAMPTZ
NameTypeDefaultRequiredDescription
candlestickCandlestick-Candlestick aggregate
ColumnTypeDescription
open_timeTIMESTAMPTZThe time at which the opening price occurred