Let’s say i insert multiple series data for a symbol “XXC”, with interval of 1000 (1 second), is there a way to query the data using range, let’s say 5min, 15min, 1h .e.t.c { "ticker": "XXC", "ts_start": 1677730930000, "ts_end": 1677730939000, "ts_interval": 1000, "ts_data": [ 16.30, 16.3…

WITH range_start AS (STR_TO_MILLIS ("2013-07-01", "YYYY-MM-DD")), range_end AS (STR_TO_MILLIS ("2013-08-31", "YYYY-MM-DD")) SELECT minutes, AVG(t._v0) AS average FROM mycollection AS d UNNEST _timeseries(d, {"ts_ranges": [range_start, range_end]}) AS t WHERE d.ticker = 'XXC' AND (d.ts_star…

i think i should just query whatever i stored in the db throw it to the client, then let the client sort/aggregate by it’s range 1m/5m/15m/1h …e.t.c

_TIMESERIES Function | Couchbase Docs The _TIMESERIES function enables you to query time series data. Check examples here, Example 4 refers window function but it is similar concept you can use

Thank you @vsr1 Can you provide an example query please, in influxdb i use something like this from(bucket: "${bucket}") |> range(start: ${startDate.toISOString()}, stop: ${endDate.toISOString()}) |> filter(fn: (r) => r["symbol"] == "${symbol.toLocaleUpperCase()}") |> aggregateWindow(every…

@vsr1 how to save OHLC data? is it like this when saving ts_data: [date, open, high, low, close, vol] then when querying i do this SELECT AVG(t._v0) AS open, AVG(t._v1) AS high, AVG(t._v2) AS low, AVG(t._v3) AS close, AVG(t._v4) AS vol

_TIMESERIES Function | Couchbase Docs The _TIMESERIES function enables you to query time series data. Example 2 ts_data: [[date, open, high, low, close, vol], [date, open, high, low, close, vol], ...]

Query series data with range

Couchbase Server

ceddy November 22, 2024, 4:21am 6

Sick!

R.I.P InfluxDB

Topic		Replies	Views
Slow N1ql query for search between date range SQL++ n1ql	8	6690	September 11, 2020
Interval and nearest match SQL++	22	2981	May 2, 2017
How to group result based on time intervals SQL++ n1ql	15	1439	November 6, 2023
Help: Need N1ql Query to get last two weekdays data? SQL++ query , n1ql	12	1516	August 3, 2022
Query to fetch items at certain interval between them (if it exist) SQL++	14	1386	November 19, 2020

Query series data with range

Related topics