yearly-aggregate.flux

data = from(bucket: "daily-aggregate")

|> range(start: -1y)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(every: 1y)

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()