This is the first step for performing financial calculations on raw tick
data. Use candlestick_agg to create an intermediate aggregate from your
tick data. This intermediate form can then be used by one or more accessors
in this group to compute final results.
Optionally, multiple such intermediate aggregate objects can be combined
using rollup() before an accessor is applied.
If you're starting with pre-aggregated candlestick data rather than raw tick
data, use the companion candlestick() function instead.
This function transforms the existing aggregated data into the correct form
for use with the candlestick accessors.
Timestamp associated with stock price. Rows where ts or price is NULL are skipped. An aggregate over only such rows returns NULL.
price
DOUBLE PRECISION
-
✔
Stock quote/price at the given time. Rows where ts or price is NULL are skipped.
volume
DOUBLE PRECISION
-
✔
Volume of the trade. Pass NULL when the volume is unknown; if any aggregated row has a NULL volume, volume() and vwap() return NULL for the whole aggregate.
An object storing (timestamp, value) pairs for each of the opening, high, low, and closing prices, in addition to information used to calculate the total volume and Volume Weighted Average Price.