GET _search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "site.id": "757"
          }
        },
        {
          "range": {
            "timestamp": {
              "gte": "2016-01-29T22:00:00.000",
              "lt": "2016-01-31T22:00:00.000"
            }
          }
        }
      ]
    }
  },
  "from": 0,
  "size": 0,
  "aggs": {
    "non-operating-hours": {
      "filter": {
        "bool": {
          "should": [
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-30T00:00:00.000",
                  "lt": "2016-01-30T09:00:00.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-31T00:00:00.000",
                  "lt": "2016-01-31T09:00:00.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-30T17:00:00.000",
                  "lt": "2016-01-30T23:59:59.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-31T17:00:00.000",
                  "lt": "2016-01-31T23:59:59.000"
                }
              }
            }
          ]
        }
      },
      "aggs": {
        "sum_kwh": {
          "sum": {
            "field": "kwh_avg"
          }
        }
      }
    },
    "operating-hours": {
      "filter": {
        "bool": {
          "should": [
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-30T09:00:00.000",
                  "lt": "2016-01-30T17:00:00.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-31T09:00:00.000",
                  "lt": "2016-01-31T17:00:00.000"
                }
              }
            }
          ]
        }
      },
      "aggs": {
        "sum_kwh": {
          "sum": {
            "field": "kwh_avg"
          }
        }
      }
    },
    "peak": {
      "filter": {
        "bool": {
          "should": [
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-30T07:00:00.000",
                  "lt": "2016-01-30T23:59:59.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-31T07:00:00.000",
                  "lt": "2016-01-31T23:59:59.000"
                }
              }
            }
          ]
        }
      },
      "aggs": {
        "sum_kwh": {
          "sum": {
            "field": "kwh_avg"
          }
        },
        "sum_kwh_cost": {
          "sum": {
            "field": "kwh_avg",
            "script": {
              "inline": "_value * cost",
              "params": {
                "cost": 22.5
              }
            }
          }
        }
      }
    },
    "off-peak": {
      "filter": {
        "bool": {
          "should": [
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-30T00:00:00.000",
                  "lt": "2016-01-30T06:59:59.000"
                }
              }
            },
            {
              "range": {
                "timestamp": {
                  "gte": "2016-01-31T00:00:00.000",
                  "lt": "2016-01-31T06:59:59.000"
                }
              }
            }
          ]
        }
      },
      "aggs": {
        "sum_kwh": {
          "sum": {
            "field": "kwh_avg"
          }
        },
        "sum_kwh_cost": {
          "sum": {
            "field": "kwh_avg",
            "script": {
              "inline": "_value * cost",
              "params": {
                "cost": 5.5
              }
            }
          }
        }
      }
    }
  }
}

{
  "took": 282,
  "timed_out": false,
  "_shards": {
    "total": 230,
    "successful": 230,
    "failed": 0
  },
  "hits": {
    "total": 139301,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "operating-hours": {
      "doc_count": 46440,
      "sum_kwh": {
        "value": 0.5701111111111342
      }
    },
    "off-peak": {
      "doc_count": 40612,
      "sum_kwh_cost": {
        "value": 3.438416666666704
      },
      "sum_kwh": {
        "value": 0.6251666666666927
      }
    },
    "peak": {
      "doc_count": 92881,
      "sum_kwh_cost": {
        "value": 336.82687499999844
      },
      "sum_kwh": {
        "value": 14.97008333333339
      }
    },
    "non-operating-hours": {
      "doc_count": 87053,
      "sum_kwh": {
        "value": 15.02513888888894
      }
    }
  }
}