gistfile1.json

{
  "query": {
      "filtered": {
        "query": {
            "match_all": {}
        },
        "filter": {
            "bool": {
              "must": [
                  {
                    "range": {
                        "date_created": {
                          "from": "2014-08-11T00:00:00-03:00",
                          "to": "2014-08-17T23:59:59-03:00"
                        }
                    }
                  }
              ]
            }
        }
      }
  },
  "aggs": {
      "myagg": {
        "filter": {
            "query": {
              "query_string": {
                  "query": "user_id:1"
              }
            }
        },
        "aggs": {
            "over_time": {
              "date_histogram": {
                  "field": "date_created",
                  "interval": "day",
                  "pre_offset": "-3h",
                  "post_offset": "+3h",
                  "min_doc_count": 0,
                  "extended_bounds": {
                    "min": "2014-08-11T00:00:00-03:00",
                    "max": "2014-08-17T23:59:59-03:00"
                  }
              },
              "aggs": {
                  "cost": {
                    "sum": {
                        "field": "billed"
                    }
                  }
              }
            }
        }
      }
  }
}