7day-1month-union.txt

data = from(bucket: "local")
|> range(start: -30d)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(every: 1w) min = data

|> min()
|> set(key: "type", value: "min" ) max = data

|> max()
|> set(key: "type", value: "max" ) first = data

|> first()
|> set(key: "type", value: "first" ) last = data

|> last()
|> set(key: "type", value: "last" ) union(tables: [min, max, first, last])

|> group(columns:["type"], mode: "by")
|> yield()