Query - Get min/max of nested documents field for every root document

Elastic Stack Elasticsearch
4

Something like this should work.

{
      "aggs": {
        "products": {
          "terms": {
            "field": "name"
          },
          "aggs": {
            "prices": {
              "nested": {
                "path": "prices"
              },
              "aggs": {
                "min_price": {
                  "min": {
                    "field": "prices.price"
                  }
                }
              }
            }
          }
        }