es.sh

#!/bin/sh
curl -XPUT 'http://localhost:9200/test/offer/1' -d '{
    "arrival": "2015-01-01",
    "price": 100,
		"hotel_id": "H1",
		"offer_code": "O1"
}'

echo

curl -XPUT 'http://localhost:9200/test/offer/2' -d '{
    "arrival" : "2015-01-01",
    "price" : 90,
		"hotel_id": "H1",
		"offer_code": "O2"
}'

echo

curl -XPUT 'http://localhost:9200/test/offer/3' -d '{
    "arrival" : "2015-01-02",
    "price" : 80,
		"hotel_id": "H1",
		"offer_code": "O3"
}'

echo

curl -XPUT 'http://localhost:9200/test/offer/4' -d '{
    "arrival": "2015-01-01",
    "price": 100,
		"hotel_id": "H2",
		"offer_code": "O1"

}'

echo
sleep 1

curl -XPOST "http://localhost:9200/test/offer/_search?pretty=true" -d'
{
  "size": 0,
  "aggregations": {
    "arrival": {
      "filter": {
        "term": {
          "arrival": "2015-01-01"
        }
      },
      "aggregations": {
        "hotel_ids": {
          "terms": {
            "field": "hotel_id",
            "order": {
              "min_price": "asc"
            }
          },
          "aggregations": {
            "min_price": {
              "min": {
                "field": "price"
              }
            }
          }
        }
      }
    }
  }
}'
echo