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.
Arguments
Section titled “Arguments”The syntax is:
low_time( candlestick Candlestick) RETURNS TIMESTAMPTZ| Name | Type | Default | Required | Description |
|---|---|---|---|---|
| candlestick | Candlestick | - | ✔ | Candlestick aggregate |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| low_time | TIMESTAMPTZ | The 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). |