> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# open_time()

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

<Icon icon="tag" iconType="duotone" /> Since [1.14.0][toolkit-1.14.0]

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

## Arguments

The syntax is:

```sql theme={"dark"}
open_time(
    candlestick Candlestick
) RETURNS TIMESTAMPTZ
```

| Name        | Type        | Default | Required | Description           |
| ----------- | ----------- | ------- | -------- | --------------------- |
| candlestick | Candlestick | -       | ✔        | Candlestick aggregate |

## Returns

| Column     | Type        | Description                                  |
| ---------- | ----------- | -------------------------------------------- |
| open\_time | TIMESTAMPTZ | The time at which the opening price occurred |

[toolkit-1.14.0]: https://github.com/timescale/timescaledb-toolkit/releases/tag/1.14.0