Daily-aggregate-union.flux

data = from(bucket: "daily-aggregate")
|> range(start: -1d) |> filter(fn: (r) => r["_measurement"] == "ticks") |> filter(fn: (r) => r["product"] == "AGUX/USD") |> window(every: 1d) max = data
|> filter(fn: (r) => r["_field"] == "max") |> max()
|> set(key: "type", value: "max" ) min = data
|> filter(fn: (r) => r["_field"] == "min") |> min()
|> set(key: "type", value: "min" ) union(tables: [min, max])
|> group(columns:["type"], mode: "by")
|> yield()