elasticsearch相关聚合查询示例

索引（index）：logstash-nginx-*，type:nginx_access

请求路径：

1、按照某个字段进行分组统计访问量

 1 {
 2     "query": {
 3         "bool":{
 4             "must_not":[{
 5                 "term":{
 6                     "userId.keyword":"-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "sort": [],
14     "aggs": {
15         "count_person": {
16             "terms": {
17                 "field": "userId.keyword",
18                 "order":{
19                     "readRow":"desc"
20                 },
21                 "size":5
22             },
23             "aggs":{
24                 "readRow":{
25                     "sum":{
26                         "field":"queryCount"
27                     }
28                 }
29             }
30         }
31     }
32 }

View Code

返回结果：

 1 {
 2   "took": 5,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 665385,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "count_person": {
16       "doc_count_error_upper_bound": -1,
17       "sum_other_doc_count": 63282,
18       "buckets": [
19         {
20           "key": "1804",
21           "doc_count": 40360,
22           "readRow": {
23             "value": 3679990
24           }
25         },
26         {
27           "key": "2089",
28           "doc_count": 758,
29           "readRow": {
30             "value": 1001372
31           }
32         },
33         {
34           "key": "1999",
35           "doc_count": 474076,
36           "readRow": {
37             "value": 469321
38           }
39         },
40         {
41           "key": "1758",
42           "doc_count": 2843,
43           "readRow": {
44             "value": 267010
45           }
46         },
47         {
48           "key": "2125",
49           "doc_count": 352,
50           "readRow": {
51             "value": 203845
52           }
53         },
54         {
55           "key": "1807",
56           "doc_count": 17897,
57           "readRow": {
58             "value": 109166
59           }
60         },
61         {
62           "key": "2109",
63           "doc_count": 931,
64           "readRow": {
65             "value": 93100
66           }
67         },
68         {
69           "key": "1544",
70           "doc_count": 50550,
71           "readRow": {
72             "value": 74456
73           }
74         },
75         {
76           "key": "2090",
77           "doc_count": 11997,
78           "readRow": {
79             "value": 52649
80           }
81         },
82         {
83           "key": "1862",
84           "doc_count": 2307,
85           "readRow": {
86             "value": 44913
87           }
88         }
89       ]
90     }
91   }
92 }

View Code

2、统计某个时间点的访问量

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }],
 9             "must": [{
10                 "term": {
11                     "http_time": "2018-04-01"
12                 }
13             }]
14         }
15     },
16     "from": 0,
17     "size": 0,
18     "sort": [],
19     "aggs": {
20         "readRow": {
21             "sum": {
22                 "field": "queryCount"
23             }
24         }
25     }
26 }

View Code

返回结果：

 1 {
 2   "took": 3,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 410,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "readRow": {
16       "value": 418
17     }
18   }
19 }

View Code

3、统计某个时间段的访问量

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }],
 9             "must": [{
10                 "range": {
11                    "http_time":{
12                        "gte":"2018-01-01",
13                        "lte":"2018-12-31"
14                    }
15                 }
16             }]
17         }
18     },
19     "from": 0,
20     "size": 0,
21     "sort": [],
22     "aggs": {
23         "readRow": {
24             "sum": {
25                 "field": "queryCount"
26             }
27         }
28     }
29 }

View Code

返回结果：

 1 {
 2   "took": 74,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 664925,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "readRow": {
16       "value": 6178094
17     }
18   }
19 }

View Code

4、按照年统计访问量（可用的时间间隔表达式：year, quarter, month, week, day, hour, minute, second（年份、季度、月、周、日、小时、分钟、秒）。）

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "sort": [],
14     "aggs": {
15         "group_by_http_time": {
16             "date_histogram":{
17                 "field":"http_time",
18                 "interval":"year",
19                 "format":"yyyy-MM-dd"
20             },
21             "aggs":{
22                 "readRow":{
23                     "sum":{
24                         "field":"queryCount"
25                     }
26                 }
27             }
28         }
29     }
30 }

View Code

返回结果：

 1 {
 2   "took": 24,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 665385,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "group_by_http_time": {
16       "buckets": [
17         {
18           "key_as_string": "2018-01-01",
19           "key": 1514764800000,
20           "doc_count": 664925,
21           "readRow": {
22             "value": 6178094
23           }
24         },
25         {
26           "key_as_string": "2019-01-01",
27           "key": 1546300800000,
28           "doc_count": 428,
29           "readRow": {
30             "value": 533
31           }
32         }
33       ]
34     }
35   }
36 }

View Code

5、按月统计访问量

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "sort": [],
14     "aggs": {
15         "group_by_http_time": {
16             "date_histogram":{//日期分析函数
17                 "field":"http_time",
18                 "interval":"month",
19                 "format":"yyyy-MM-dd"
20             },
21             "aggs":{
22                 "readRow":{
23                     "sum":{
24                         "field":"queryCount"
25                     }
26                 }
27             }
28         }
29     }
30 }

View Code

返回结果：

  1 {
  2   "took": 46,
  3   "timed_out": false,
  4   "_shards": {
  5     "total": 90,
  6     "successful": 85,
  7     "failed": 0
  8   },
  9   "hits": {
 10     "total": 665385,
 11     "max_score": 0,
 12     "hits": []
 13   },
 14   "aggregations": {
 15     "group_by_http_time": {
 16       "buckets": [
 17         {
 18           "key_as_string": "2018-01-01",
 19           "key": 1514764800000,
 20           "doc_count": 9617,
 21           "readRow": {
 22             "value": 27029
 23           }
 24         },
 25         {
 26           "key_as_string": "2018-02-01",
 27           "key": 1517443200000,
 28           "doc_count": 16851,
 29           "readRow": {
 30             "value": 99285
 31           }
 32         },
 33         {
 34           "key_as_string": "2018-03-01",
 35           "key": 1519862400000,
 36           "doc_count": 28362,
 37           "readRow": {
 38             "value": 52179
 39           }
 40         },
 41         {
 42           "key_as_string": "2018-04-01",
 43           "key": 1522540800000,
 44           "doc_count": 21202,
 45           "readRow": {
 46             "value": 258636
 47           }
 48         },
 49         {
 50           "key_as_string": "2018-05-01",
 51           "key": 1525132800000,
 52           "doc_count": 22585,
 53           "readRow": {
 54             "value": 1373383
 55           }
 56         },
 57         {
 58           "key_as_string": "2018-06-01",
 59           "key": 1527811200000,
 60           "doc_count": 531967,
 61           "readRow": {
 62             "value": 3305980
 63           }
 64         },
 65         {
 66           "key_as_string": "2018-07-01",
 67           "key": 1530403200000,
 68           "doc_count": 3287,
 69           "readRow": {
 70             "value": 1015279
 71           }
 72         },
 73         {
 74           "key_as_string": "2018-08-01",
 75           "key": 1533081600000,
 76           "doc_count": 13485,
 77           "readRow": {
 78             "value": 22379
 79           }
 80         },
 81         {
 82           "key_as_string": "2018-09-01",
 83           "key": 1535760000000,
 84           "doc_count": 6121,
 85           "readRow": {
 86             "value": 11770
 87           }
 88         },
 89         {
 90           "key_as_string": "2018-10-01",
 91           "key": 1538352000000,
 92           "doc_count": 4548,
 93           "readRow": {
 94             "value": 5129
 95           }
 96         },
 97         {
 98           "key_as_string": "2018-11-01",
 99           "key": 1541030400000,
100           "doc_count": 6492,
101           "readRow": {
102             "value": 4290
103           }
104         },
105         {
106           "key_as_string": "2018-12-01",
107           "key": 1543622400000,
108           "doc_count": 408,
109           "readRow": {
110             "value": 2755
111           }
112         },
113         {
114           "key_as_string": "2019-01-01",
115           "key": 1546300800000,
116           "doc_count": 371,
117           "readRow": {
118             "value": 372
119           }
120         },
121         {
122           "key_as_string": "2019-02-01",
123           "key": 1548979200000,
124           "doc_count": 0,
125           "readRow": {
126             "value": 0
127           }
128         },
129         {
130           "key_as_string": "2019-03-01",
131           "key": 1551398400000,
132           "doc_count": 0,
133           "readRow": {
134             "value": 0
135           }
136         },
137         {
138           "key_as_string": "2019-04-01",
139           "key": 1554076800000,
140           "doc_count": 0,
141           "readRow": {
142             "value": 0
143           }
144         },
145         {
146           "key_as_string": "2019-05-01",
147           "key": 1556668800000,
148           "doc_count": 57,
149           "readRow": {
150             "value": 161
151           }
152         }
153       ]
154     }
155   }
156 }

View Code

6、按天统计访问量

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "sort": [],
14     "aggs": {
15         "group_by_http_time": {
16             "date_histogram":{
17                 "field":"http_time",
18                 "interval":"day",
19                 "format":"yyyy-MM-dd",
20                 "order":{
21                     "readRow":"desc"
22                 }
23             },
24             "aggs":{
25                 "readRow":{
26                     "sum":{
27                         "field":"queryCount"
28                     }
29                 }
30             }
31         }
32     }
33 }

View Code

返回结果：

   1 {
   2   "took": 45,
   3   "timed_out": false,
   4   "_shards": {
   5     "total": 90,
   6     "successful": 85,
   7     "failed": 0
   8   },
   9   "hits": {
  10     "total": 665385,
  11     "max_score": 0,
  12     "hits": []
  13   },
  14   "aggregations": {
  15     "group_by_http_time": {
  16       "buckets": [
  17         {
  18           "key_as_string": "2018-06-06",
  19           "key": 1528243200000,
  20           "doc_count": 499063,
  21           "readRow": {
  22             "value": 1987113
  23           }
  24         },
  25         {
  26           "key_as_string": "2018-05-31",
  27           "key": 1527724800000,
  28           "doc_count": 19643,
  29           "readRow": {
  30             "value": 1340058
  31           }
  32         },
  33         {
  34           "key_as_string": "2018-06-05",
  35           "key": 1528156800000,
  36           "doc_count": 14828,
  37           "readRow": {
  38             "value": 1167418
  39           }
  40         },
  41         {
  42           "key_as_string": "2018-07-04",
  43           "key": 1530662400000,
  44           "doc_count": 207,
  45           "readRow": {
  46             "value": 1000443
  47           }
  48         },
  49         {
  50           "key_as_string": "2018-04-05",
  51           "key": 1522886400000,
  52           "doc_count": 3706,
  53           "readRow": {
  54             "value": 208128
  55           }
  56         },
  57         {
  58           "key_as_string": "2018-06-01",
  59           "key": 1527811200000,
  60           "doc_count": 14430,
  61           "readRow": {
  62             "value": 141136
  63           }
  64         },
  65         {
  66           "key_as_string": "2018-02-07",
  67           "key": 1517961600000,
  68           "doc_count": 355,
  69           "readRow": {
  70             "value": 32361
  71           }
  72         },
  73         {
  74           "key_as_string": "2018-02-24",
  75           "key": 1519430400000,
  76           "doc_count": 4539,
  77           "readRow": {
  78             "value": 26172
  79           }
  80         },
  81         {
  82           "key_as_string": "2018-04-26",
  83           "key": 1524700800000,
  84           "doc_count": 878,
  85           "readRow": {
  86             "value": 13526
  87           }
  88         },
  89         {
  90           "key_as_string": "2018-04-24",
  91           "key": 1524528000000,
  92           "doc_count": 2103,
  93           "readRow": {
  94             "value": 11384
  95           }
  96         },
  97         {
  98           "key_as_string": "2018-03-27",
  99           "key": 1522108800000,
 100           "doc_count": 7904,
 101           "readRow": {
 102             "value": 10953
 103           }
 104         },
 105         {
 106           "key_as_string": "2018-05-17",
 107           "key": 1526515200000,
 108           "doc_count": 738,
 109           "readRow": {
 110             "value": 10581
 111           }
 112         },
 113         {
 114           "key_as_string": "2018-05-18",
 115           "key": 1526601600000,
 116           "doc_count": 450,
 117           "readRow": {
 118             "value": 8736
 119           }
 120         },
 121         {
 122           "key_as_string": "2018-02-23",
 123           "key": 1519344000000,
 124           "doc_count": 1508,
 125           "readRow": {
 126             "value": 8351
 127           }
 128         },
 129         {
 130           "key_as_string": "2018-02-06",
 131           "key": 1517875200000,
 132           "doc_count": 170,
 133           "readRow": {
 134             "value": 6612
 135           }
 136         },
 137         {
 138           "key_as_string": "2018-02-27",
 139           "key": 1519689600000,
 140           "doc_count": 1338,
 141           "readRow": {
 142             "value": 6548
 143           }
 144         },
 145         {
 146           "key_as_string": "2018-02-05",
 147           "key": 1517788800000,
 148           "doc_count": 777,
 149           "readRow": {
 150             "value": 6503
 151           }
 152         },
 153         {
 154           "key_as_string": "2018-04-25",
 155           "key": 1524614400000,
 156           "doc_count": 343,
 157           "readRow": {
 158             "value": 6186
 159           }
 160         },
 161         {
 162           "key_as_string": "2018-03-14",
 163           "key": 1520985600000,
 164           "doc_count": 2307,
 165           "readRow": {
 166             "value": 6008
 167           }
 168         },
 169         {
 170           "key_as_string": "2018-07-27",
 171           "key": 1532649600000,
 172           "doc_count": 667,
 173           "readRow": {
 174             "value": 5853
 175           }
 176         },
 177         {
 178           "key_as_string": "2018-01-31",
 179           "key": 1517356800000,
 180           "doc_count": 1876,
 181           "readRow": {
 182             "value": 5720
 183           }
 184         },
 185         {
 186           "key_as_string": "2018-04-10",
 187           "key": 1523318400000,
 188           "doc_count": 4272,
 189           "readRow": {
 190             "value": 5227
 191           }
 192         },
 193         {
 194           "key_as_string": "2018-05-16",
 195           "key": 1526428800000,
 196           "doc_count": 659,
 197           "readRow": {
 198             "value": 4788
 199           }
 200         },
 201         {
 202           "key_as_string": "2018-03-01",
 203           "key": 1519862400000,
 204           "doc_count": 1640,
 205           "readRow": {
 206             "value": 4273
 207           }
 208         },
 209         {
 210           "key_as_string": "2018-03-23",
 211           "key": 1521763200000,
 212           "doc_count": 250,
 213           "readRow": {
 214             "value": 4198
 215           }
 216         },
 217         {
 218           "key_as_string": "2018-02-28",
 219           "key": 1519776000000,
 220           "doc_count": 4994,
 221           "readRow": {
 222             "value": 3658
 223           }
 224         },
 225         {
 226           "key_as_string": "2018-01-30",
 227           "key": 1517270400000,
 228           "doc_count": 2284,
 229           "readRow": {
 230             "value": 3472
 231           }
 232         },
 233         {
 234           "key_as_string": "2018-02-01",
 235           "key": 1517443200000,
 236           "doc_count": 2366,
 237           "readRow": {
 238             "value": 3354
 239           }
 240         },
 241         {
 242           "key_as_string": "2018-03-05",
 243           "key": 1520208000000,
 244           "doc_count": 1916,
 245           "readRow": {
 246             "value": 3282
 247           }
 248         },
 249         {
 250           "key_as_string": "2018-03-06",
 251           "key": 1520294400000,
 252           "doc_count": 1285,
 253           "readRow": {
 254             "value": 3162
 255           }
 256         },
 257         {
 258           "key_as_string": "2018-03-30",
 259           "key": 1522368000000,
 260           "doc_count": 1570,
 261           "readRow": {
 262             "value": 3018
 263           }
 264         },
 265         {
 266           "key_as_string": "2018-07-26",
 267           "key": 1532563200000,
 268           "doc_count": 309,
 269           "readRow": {
 270             "value": 2915
 271           }
 272         },
 273         {
 274           "key_as_string": "2018-09-05",
 275           "key": 1536105600000,
 276           "doc_count": 46,
 277           "readRow": {
 278             "value": 2824
 279           }
 280         },
 281         {
 282           "key_as_string": "2018-08-13",
 283           "key": 1534118400000,
 284           "doc_count": 2226,
 285           "readRow": {
 286             "value": 2730
 287           }
 288         },
 289         {
 290           "key_as_string": "2018-02-11",
 291           "key": 1518307200000,
 292           "doc_count": 290,
 293           "readRow": {
 294             "value": 2629
 295           }
 296         },
 297         {
 298           "key_as_string": "2018-01-12",
 299           "key": 1515715200000,
 300           "doc_count": 907,
 301           "readRow": {
 302             "value": 2571
 303           }
 304         },
 305         {
 306           "key_as_string": "2018-08-10",
 307           "key": 1533859200000,
 308           "doc_count": 2870,
 309           "readRow": {
 310             "value": 2545
 311           }
 312         },
 313         {
 314           "key_as_string": "2018-03-02",
 315           "key": 1519948800000,
 316           "doc_count": 1222,
 317           "readRow": {
 318             "value": 2502
 319           }
 320         },
 321         {
 322           "key_as_string": "2018-08-30",
 323           "key": 1535587200000,
 324           "doc_count": 2423,
 325           "readRow": {
 326             "value": 2497
 327           }
 328         },
 329         {
 330           "key_as_string": "2018-08-11",
 331           "key": 1533945600000,
 332           "doc_count": 1524,
 333           "readRow": {
 334             "value": 2448
 335           }
 336         },
 337         {
 338           "key_as_string": "2018-08-09",
 339           "key": 1533772800000,
 340           "doc_count": 202,
 341           "readRow": {
 342             "value": 2394
 343           }
 344         },
 345         {
 346           "key_as_string": "2018-08-15",
 347           "key": 1534291200000,
 348           "doc_count": 580,
 349           "readRow": {
 350             "value": 2338
 351           }
 352         },
 353         {
 354           "key_as_string": "2018-06-13",
 355           "key": 1528848000000,
 356           "doc_count": 1171,
 357           "readRow": {
 358             "value": 2295
 359           }
 360         },
 361         {
 362           "key_as_string": "2018-03-28",
 363           "key": 1522195200000,
 364           "doc_count": 399,
 365           "readRow": {
 366             "value": 2287
 367           }
 368         },
 369         {
 370           "key_as_string": "2018-01-15",
 371           "key": 1515974400000,
 372           "doc_count": 174,
 373           "readRow": {
 374             "value": 2266
 375           }
 376         },
 377         {
 378           "key_as_string": "2018-03-15",
 379           "key": 1521072000000,
 380           "doc_count": 2454,
 381           "readRow": {
 382             "value": 2256
 383           }
 384         },
 385         {
 386           "key_as_string": "2018-04-23",
 387           "key": 1524441600000,
 388           "doc_count": 781,
 389           "readRow": {
 390             "value": 2239
 391           }
 392         },
 393         {
 394           "key_as_string": "2018-03-26",
 395           "key": 1522022400000,
 396           "doc_count": 919,
 397           "readRow": {
 398             "value": 2133
 399           }
 400         },
 401         {
 402           "key_as_string": "2018-01-26",
 403           "key": 1516924800000,
 404           "doc_count": 501,
 405           "readRow": {
 406             "value": 2038
 407           }
 408         },
 409         {
 410           "key_as_string": "2018-04-09",
 411           "key": 1523232000000,
 412           "doc_count": 1151,
 413           "readRow": {
 414             "value": 1993
 415           }
 416         },
 417         {
 418           "key_as_string": "2018-01-11",
 419           "key": 1515628800000,
 420           "doc_count": 742,
 421           "readRow": {
 422             "value": 1969
 423           }
 424         },
 425         {
 426           "key_as_string": "2018-01-22",
 427           "key": 1516579200000,
 428           "doc_count": 476,
 429           "readRow": {
 430             "value": 1963
 431           }
 432         },
 433         {
 434           "key_as_string": "2018-08-28",
 435           "key": 1535414400000,
 436           "doc_count": 1500,
 437           "readRow": {
 438             "value": 1945
 439           }
 440         },
 441         {
 442           "key_as_string": "2018-01-10",
 443           "key": 1515542400000,
 444           "doc_count": 159,
 445           "readRow": {
 446             "value": 1836
 447           }
 448         },
 449         {
 450           "key_as_string": "2018-03-22",
 451           "key": 1521676800000,
 452           "doc_count": 1015,
 453           "readRow": {
 454             "value": 1829
 455           }
 456         },
 457         {
 458           "key_as_string": "2018-06-14",
 459           "key": 1528934400000,
 460           "doc_count": 617,
 461           "readRow": {
 462             "value": 1825
 463           }
 464         },
 465         {
 466           "key_as_string": "2018-04-12",
 467           "key": 1523491200000,
 468           "doc_count": 1834,
 469           "readRow": {
 470             "value": 1821
 471           }
 472         },
 473         {
 474           "key_as_string": "2018-04-11",
 475           "key": 1523404800000,
 476           "doc_count": 2027,
 477           "readRow": {
 478             "value": 1783
 479           }
 480         },
 481         {
 482           "key_as_string": "2018-01-23",
 483           "key": 1516665600000,
 484           "doc_count": 374,
 485           "readRow": {
 486             "value": 1668
 487           }
 488         },
 489         {
 490           "key_as_string": "2018-07-30",
 491           "key": 1532908800000,
 492           "doc_count": 195,
 493           "readRow": {
 494             "value": 1606
 495           }
 496         },
 497         {
 498           "key_as_string": "2018-02-22",
 499           "key": 1519257600000,
 500           "doc_count": 373,
 501           "readRow": {
 502             "value": 1515
 503           }
 504         },
 505         {
 506           "key_as_string": "2018-05-29",
 507           "key": 1527552000000,
 508           "doc_count": 87,
 509           "readRow": {
 510             "value": 1511
 511           }
 512         },
 513         {
 514           "key_as_string": "2018-07-25",
 515           "key": 1532476800000,
 516           "doc_count": 349,
 517           "readRow": {
 518             "value": 1507
 519           }
 520         },
 521         {
 522           "key_as_string": "2018-05-24",
 523           "key": 1527120000000,
 524           "doc_count": 110,
 525           "readRow": {
 526             "value": 1488
 527           }
 528         },
 529         {
 530           "key_as_string": "2018-06-26",
 531           "key": 1529971200000,
 532           "doc_count": 334,
 533           "readRow": {
 534             "value": 1424
 535           }
 536         },
 537         {
 538           "key_as_string": "2018-11-12",
 539           "key": 1541980800000,
 540           "doc_count": 1687,
 541           "readRow": {
 542             "value": 1417
 543           }
 544         },
 545         {
 546           "key_as_string": "2018-09-29",
 547           "key": 1538179200000,
 548           "doc_count": 596,
 549           "readRow": {
 550             "value": 1410
 551           }
 552         },
 553         {
 554           "key_as_string": "2018-05-21",
 555           "key": 1526860800000,
 556           "doc_count": 72,
 557           "readRow": {
 558             "value": 1404
 559           }
 560         },
 561         {
 562           "key_as_string": "2018-08-27",
 563           "key": 1535328000000,
 564           "doc_count": 1254,
 565           "readRow": {
 566             "value": 1379
 567           }
 568         },
 569         {
 570           "key_as_string": "2018-03-07",
 571           "key": 1520380800000,
 572           "doc_count": 189,
 573           "readRow": {
 574             "value": 1361
 575           }
 576         },
 577         {
 578           "key_as_string": "2018-09-06",
 579           "key": 1536192000000,
 580           "doc_count": 1257,
 581           "readRow": {
 582             "value": 1261
 583           }
 584         },
 585         {
 586           "key_as_string": "2018-09-12",
 587           "key": 1536710400000,
 588           "doc_count": 963,
 589           "readRow": {
 590             "value": 1249
 591           }
 592         },
 593         {
 594           "key_as_string": "2018-03-13",
 595           "key": 1520899200000,
 596           "doc_count": 798,
 597           "readRow": {
 598             "value": 1244
 599           }
 600         },
 601         {
 602           "key_as_string": "2018-08-08",
 603           "key": 1533686400000,
 604           "doc_count": 82,
 605           "readRow": {
 606             "value": 1236
 607           }
 608         },
 609         {
 610           "key_as_string": "2018-05-22",
 611           "key": 1526947200000,
 612           "doc_count": 60,
 613           "readRow": {
 614             "value": 1161
 615           }
 616         },
 617         {
 618           "key_as_string": "2018-09-28",
 619           "key": 1538092800000,
 620           "doc_count": 180,
 621           "readRow": {
 622             "value": 1040
 623           }
 624         },
 625         {
 626           "key_as_string": "2018-06-12",
 627           "key": 1528761600000,
 628           "doc_count": 702,
 629           "readRow": {
 630             "value": 1018
 631           }
 632         },
 633         {
 634           "key_as_string": "2018-05-02",
 635           "key": 1525219200000,
 636           "doc_count": 57,
 637           "readRow": {
 638             "value": 1016
 639           }
 640         },
 641         {
 642           "key_as_string": "2018-10-11",
 643           "key": 1539216000000,
 644           "doc_count": 811,
 645           "readRow": {
 646             "value": 978
 647           }
 648         },
 649         {
 650           "key_as_string": "2018-01-24",
 651           "key": 1516752000000,
 652           "doc_count": 1595,
 653           "readRow": {
 654             "value": 975
 655           }
 656         },
 657         {
 658           "key_as_string": "2018-03-19",
 659           "key": 1521417600000,
 660           "doc_count": 1096,
 661           "readRow": {
 662             "value": 958
 663           }
 664         },
 665         {
 666           "key_as_string": "2018-04-04",
 667           "key": 1522800000000,
 668           "doc_count": 1069,
 669           "readRow": {
 670             "value": 939
 671           }
 672         },
 673         {
 674           "key_as_string": "2018-11-15",
 675           "key": 1542240000000,
 676           "doc_count": 480,
 677           "readRow": {
 678             "value": 938
 679           }
 680         },
 681         {
 682           "key_as_string": "2018-09-26",
 683           "key": 1537920000000,
 684           "doc_count": 637,
 685           "readRow": {
 686             "value": 921
 687           }
 688         },
 689         {
 690           "key_as_string": "2018-05-25",
 691           "key": 1527206400000,
 692           "doc_count": 46,
 693           "readRow": {
 694             "value": 920
 695           }
 696         },
 697         {
 698           "key_as_string": "2018-03-21",
 699           "key": 1521590400000,
 700           "doc_count": 638,
 701           "readRow": {
 702             "value": 897
 703           }
 704         },
 705         {
 706           "key_as_string": "2018-08-14",
 707           "key": 1534204800000,
 708           "doc_count": 247,
 709           "readRow": {
 710             "value": 884
 711           }
 712         },
 713         {
 714           "key_as_string": "2018-09-14",
 715           "key": 1536883200000,
 716           "doc_count": 341,
 717           "readRow": {
 718             "value": 869
 719           }
 720         },
 721         {
 722           "key_as_string": "2018-10-15",
 723           "key": 1539561600000,
 724           "doc_count": 933,
 725           "readRow": {
 726             "value": 854
 727           }
 728         },
 729         {
 730           "key_as_string": "2018-08-01",
 731           "key": 1533081600000,
 732           "doc_count": 109,
 733           "readRow": {
 734             "value": 842
 735           }
 736         },
 737         {
 738           "key_as_string": "2018-06-08",
 739           "key": 1528416000000,
 740           "doc_count": 58,
 741           "readRow": {
 742             "value": 840
 743           }
 744         },
 745         {
 746           "key_as_string": "2018-01-18",
 747           "key": 1516233600000,
 748           "doc_count": 130,
 749           "readRow": {
 750             "value": 799
 751           }
 752         },
 753         {
 754           "key_as_string": "2018-03-12",
 755           "key": 1520812800000,
 756           "doc_count": 1883,
 757           "readRow": {
 758             "value": 783
 759           }
 760         },
 761         {
 762           "key_as_string": "2018-01-09",
 763           "key": 1515456000000,
 764           "doc_count": 47,
 765           "readRow": {
 766             "value": 760
 767           }
 768         },
 769         {
 770           "key_as_string": "2018-06-15",
 771           "key": 1529020800000,
 772           "doc_count": 332,
 773           "readRow": {
 774             "value": 746
 775           }
 776         },
 777         {
 778           "key_as_string": "2018-04-03",
 779           "key": 1522713600000,
 780           "doc_count": 650,
 781           "readRow": {
 782             "value": 726
 783           }
 784         },
 785         {
 786           "key_as_string": "2018-06-28",
 787           "key": 1530144000000,
 788           "doc_count": 34,
 789           "readRow": {
 790             "value": 640
 791           }
 792         },
 793         {
 794           "key_as_string": "2018-05-09",
 795           "key": 1525824000000,
 796           "doc_count": 303,
 797           "readRow": {
 798             "value": 618
 799           }
 800         },
 801         {
 802           "key_as_string": "2018-12-06",
 803           "key": 1544054400000,
 804           "doc_count": 62,
 805           "readRow": {
 806             "value": 613
 807           }
 808         },
 809         {
 810           "key_as_string": "2018-12-25",
 811           "key": 1545696000000,
 812           "doc_count": 68,
 813           "readRow": {
 814             "value": 597
 815           }
 816         },
 817         {
 818           "key_as_string": "2018-02-02",
 819           "key": 1517529600000,
 820           "doc_count": 42,
 821           "readRow": {
 822             "value": 576
 823           }
 824         },
 825         {
 826           "key_as_string": "2018-10-17",
 827           "key": 1539734400000,
 828           "doc_count": 362,
 829           "readRow": {
 830             "value": 564
 831           }
 832         },
 833         {
 834           "key_as_string": "2018-12-07",
 835           "key": 1544140800000,
 836           "doc_count": 56,
 837           "readRow": {
 838             "value": 550
 839           }
 840         },
 841         {
 842           "key_as_string": "2018-10-09",
 843           "key": 1539043200000,
 844           "doc_count": 247,
 845           "readRow": {
 846             "value": 547
 847           }
 848         },
 849         {
 850           "key_as_string": "2018-02-08",
 851           "key": 1518048000000,
 852           "doc_count": 16,
 853           "readRow": {
 854             "value": 541
 855           }
 856         },
 857         {
 858           "key_as_string": "2018-04-22",
 859           "key": 1524355200000,
 860           "doc_count": 27,
 861           "readRow": {
 862             "value": 540
 863           }
 864         },
 865         {
 866           "key_as_string": "2018-04-16",
 867           "key": 1523836800000,
 868           "doc_count": 369,
 869           "readRow": {
 870             "value": 533
 871           }
 872         },
 873         {
 874           "key_as_string": "2018-10-25",
 875           "key": 1540425600000,
 876           "doc_count": 544,
 877           "readRow": {
 878             "value": 528
 879           }
 880         },
 881         {
 882           "key_as_string": "2018-07-03",
 883           "key": 1530576000000,
 884           "doc_count": 351,
 885           "readRow": {
 886             "value": 523
 887           }
 888         },
 889         {
 890           "key_as_string": "2018-09-25",
 891           "key": 1537833600000,
 892           "doc_count": 482,
 893           "readRow": {
 894             "value": 519
 895           }
 896         },
 897         {
 898           "key_as_string": "2018-10-24",
 899           "key": 1540339200000,
 900           "doc_count": 568,
 901           "readRow": {
 902             "value": 510
 903           }
 904         },
 905         {
 906           "key_as_string": "2018-10-19",
 907           "key": 1539907200000,
 908           "doc_count": 368,
 909           "readRow": {
 910             "value": 493
 911           }
 912         },
 913         {
 914           "key_as_string": "2018-09-10",
 915           "key": 1536537600000,
 916           "doc_count": 418,
 917           "readRow": {
 918             "value": 477
 919           }
 920         },
 921         {
 922           "key_as_string": "2018-09-21",
 923           "key": 1537488000000,
 924           "doc_count": 536,
 925           "readRow": {
 926             "value": 475
 927           }
 928         },
 929         {
 930           "key_as_string": "2018-04-20",
 931           "key": 1524182400000,
 932           "doc_count": 127,
 933           "readRow": {
 934             "value": 471
 935           }
 936         },
 937         {
 938           "key_as_string": "2018-04-08",
 939           "key": 1523145600000,
 940           "doc_count": 245,
 941           "readRow": {
 942             "value": 449
 943           }
 944         },
 945         {
 946           "key_as_string": "2018-05-15",
 947           "key": 1526342400000,
 948           "doc_count": 24,
 949           "readRow": {
 950             "value": 440
 951           }
 952         },
 953         {
 954           "key_as_string": "2018-04-01",
 955           "key": 1522540800000,
 956           "doc_count": 410,
 957           "readRow": {
 958             "value": 418
 959           }
 960         },
 961         {
 962           "key_as_string": "2018-04-28",
 963           "key": 1524873600000,
 964           "doc_count": 274,
 965           "readRow": {
 966             "value": 416
 967           }
 968         },
 969         {
 970           "key_as_string": "2018-04-17",
 971           "key": 1523923200000,
 972           "doc_count": 28,
 973           "readRow": {
 974             "value": 412
 975           }
 976         },
 977         {
 978           "key_as_string": "2018-07-11",
 979           "key": 1531267200000,
 980           "doc_count": 56,
 981           "readRow": {
 982             "value": 405
 983           }
 984         },
 985         {
 986           "key_as_string": "2018-03-20",
 987           "key": 1521504000000,
 988           "doc_count": 335,
 989           "readRow": {
 990             "value": 400
 991           }
 992         },
 993         {
 994           "key_as_string": "2018-11-09",
 995           "key": 1541721600000,
 996           "doc_count": 818,
 997           "readRow": {
 998             "value": 393
 999           }
1000         },
1001         {
1002           "key_as_string": "2018-01-25",
1003           "key": 1516838400000,
1004           "doc_count": 295,
1005           "readRow": {
1006             "value": 386
1007           }
1008         },
1009         {
1010           "key_as_string": "2018-07-18",
1011           "key": 1531872000000,
1012           "doc_count": 182,
1013           "readRow": {
1014             "value": 368
1015           }
1016         },
1017         {
1018           "key_as_string": "2018-06-11",
1019           "key": 1528675200000,
1020           "doc_count": 18,
1021           "readRow": {
1022             "value": 360
1023           }
1024         },
1025         {
1026           "key_as_string": "2018-12-05",
1027           "key": 1543968000000,
1028           "doc_count": 78,
1029           "readRow": {
1030             "value": 346
1031           }
1032         },
1033         {
1034           "key_as_string": "2018-07-16",
1035           "key": 1531699200000,
1036           "doc_count": 19,
1037           "readRow": {
1038             "value": 342
1039           }
1040         },
1041         {
1042           "key_as_string": "2018-04-27",
1043           "key": 1524787200000,
1044           "doc_count": 344,
1045           "readRow": {
1046             "value": 336
1047           }
1048         },
1049         {
1050           "key_as_string": "2018-04-14",
1051           "key": 1523664000000,
1052           "doc_count": 148,
1053           "readRow": {
1054             "value": 328
1055           }
1056         },
1057         {
1058           "key_as_string": "2018-07-06",
1059           "key": 1530835200000,
1060           "doc_count": 31,
1061           "readRow": {
1062             "value": 322
1063           }
1064         },
1065         {
1066           "key_as_string": "2018-04-13",
1067           "key": 1523577600000,
1068           "doc_count": 204,
1069           "readRow": {
1070             "value": 320
1071           }
1072         },
1073         {
1074           "key_as_string": "2018-06-20",
1075           "key": 1529452800000,
1076           "doc_count": 65,
1077           "readRow": {
1078             "value": 312
1079           }
1080         },
1081         {
1082           "key_as_string": "2018-07-24",
1083           "key": 1532390400000,
1084           "doc_count": 740,
1085           "readRow": {
1086             "value": 304
1087           }
1088         },
1089         {
1090           "key_as_string": "2018-09-27",
1091           "key": 1538006400000,
1092           "doc_count": 266,
1093           "readRow": {
1094             "value": 298
1095           }
1096         },
1097         {
1098           "key_as_string": "2018-12-04",
1099           "key": 1543881600000,
1100           "doc_count": 29,
1101           "readRow": {
1102             "value": 296
1103           }
1104         },
1105         {
1106           "key_as_string": "2018-10-18",
1107           "key": 1539820800000,
1108           "doc_count": 28,
1109           "readRow": {
1110             "value": 278
1111           }
1112         },
1113         {
1114           "key_as_string": "2018-11-28",
1115           "key": 1543363200000,
1116           "doc_count": 221,
1117           "readRow": {
1118             "value": 268
1119           }
1120         },
1121         {
1122           "key_as_string": "2018-02-26",
1123           "key": 1519603200000,
1124           "doc_count": 81,
1125           "readRow": {
1126             "value": 265
1127           }
1128         },
1129         {
1130           "key_as_string": "2018-06-27",
1131           "key": 1530057600000,
1132           "doc_count": 17,
1133           "readRow": {
1134             "value": 264
1135           }
1136         },
1137         {
1138           "key_as_string": "2018-06-21",
1139           "key": 1529539200000,
1140           "doc_count": 264,
1141           "readRow": {
1142             "value": 243
1143           }
1144         },
1145         {
1146           "key_as_string": "2018-11-08",
1147           "key": 1541635200000,
1148           "doc_count": 518,
1149           "readRow": {
1150             "value": 243
1151           }
1152         },
1153         {
1154           "key_as_string": "2018-05-08",
1155           "key": 1525737600000,
1156           "doc_count": 94,
1157           "readRow": {
1158             "value": 240
1159           }
1160         },
1161         {
1162           "key_as_string": "2018-04-19",
1163           "key": 1524096000000,
1164           "doc_count": 121,
1165           "readRow": {
1166             "value": 240
1167           }
1168         },
1169         {
1170           "key_as_string": "2018-08-31",
1171           "key": 1535673600000,
1172           "doc_count": 29,
1173           "readRow": {
1174             "value": 239
1175           }
1176         },
1177         {
1178           "key_as_string": "2019-01-16",
1179           "key": 1547596800000,
1180           "doc_count": 319,
1181           "readRow": {
1182             "value": 233
1183           }
1184         },
1185         {
1186           "key_as_string": "2018-03-29",
1187           "key": 1522281600000,
1188           "doc_count": 64,
1189           "readRow": {
1190             "value": 222
1191           }
1192         },
1193         {
1194           "key_as_string": "2018-05-14",
1195           "key": 1526256000000,
1196           "doc_count": 126,
1197           "readRow": {
1198             "value": 200
1199           }
1200         },
1201         {
1202           "key_as_string": "2018-02-09",
1203           "key": 1518134400000,
1204           "doc_count": 2,
1205           "readRow": {
1206             "value": 200
1207           }
1208         },
1209         {
1210           "key_as_string": "2018-11-30",
1211           "key": 1543536000000,
1212           "doc_count": 65,
1213           "readRow": {
1214             "value": 194
1215           }
1216         },
1217         {
1218           "key_as_string": "2018-03-16",
1219           "key": 1521158400000,
1220           "doc_count": 177,
1221           "readRow": {
1222             "value": 190
1223           }
1224         },
1225         {
1226           "key_as_string": "2018-08-03",
1227           "key": 1533254400000,
1228           "doc_count": 53,
1229           "readRow": {
1230             "value": 188
1231           }
1232         },
1233         {
1234           "key_as_string": "2018-03-09",
1235           "key": 1520553600000,
1236           "doc_count": 294,
1237           "readRow": {
1238             "value": 183
1239           }
1240         },
1241         {
1242           "key_as_string": "2018-04-02",
1243           "key": 1522627200000,
1244           "doc_count": 89,
1245           "readRow": {
1246             "value": 181
1247           }
1248         },
1249         {
1250           "key_as_string": "2018-08-16",
1251           "key": 1534377600000,
1252           "doc_count": 81,
1253           "readRow": {
1254             "value": 170
1255           }
1256         },
1257         {
1258           "key_as_string": "2018-01-19",
1259           "key": 1516320000000,
1260           "doc_count": 10,
1261           "readRow": {
1262             "value": 160
1263           }
1264         },
1265         {
1266           "key_as_string": "2018-10-16",
1267           "key": 1539648000000,
1268           "doc_count": 47,
1269           "readRow": {
1270             "value": 158
1271           }
1272         },
1273         {
1274           "key_as_string": "2018-12-10",
1275           "key": 1544400000000,
1276           "doc_count": 11,
1277           "readRow": {
1278             "value": 156
1279           }
1280         },
1281         {
1282           "key_as_string": "2018-06-29",
1283           "key": 1530230400000,
1284           "doc_count": 15,
1285           "readRow": {
1286             "value": 146
1287           }
1288         },
1289         {
1290           "key_as_string": "2018-07-17",
1291           "key": 1531785600000,
1292           "doc_count": 116,
1293           "readRow": {
1294             "value": 140
1295           }
1296         },
1297         {
1298           "key_as_string": "2018-07-13",
1299           "key": 1531440000000,
1300           "doc_count": 8,
1301           "readRow": {
1302             "value": 140
1303           }
1304         },
1305         {
1306           "key_as_string": "2018-06-25",
1307           "key": 1529884800000,
1308           "doc_count": 16,
1309           "readRow": {
1310             "value": 140
1311           }
1312         },
1313         {
1314           "key_as_string": "2018-09-11",
1315           "key": 1536624000000,
1316           "doc_count": 105,
1317           "readRow": {
1318             "value": 140
1319           }
1320         },
1321         {
1322           "key_as_string": "2018-07-02",
1323           "key": 1530489600000,
1324           "doc_count": 7,
1325           "readRow": {
1326             "value": 140
1327           }
1328         },
1329         {
1330           "key_as_string": "2018-11-16",
1331           "key": 1542326400000,
1332           "doc_count": 98,
1333           "readRow": {
1334             "value": 135
1335           }
1336         },
1337         {
1338           "key_as_string": "2018-11-23",
1339           "key": 1542931200000,
1340           "doc_count": 60,
1341           "readRow": {
1342             "value": 131
1343           }
1344         },
1345         {
1346           "key_as_string": "2018-11-13",
1347           "key": 1542067200000,
1348           "doc_count": 75,
1349           "readRow": {
1350             "value": 131
1351           }
1352         },
1353         {
1354           "key_as_string": "2018-08-22",
1355           "key": 1534896000000,
1356           "doc_count": 49,
1357           "readRow": {
1358             "value": 128
1359           }
1360         },
1361         {
1362           "key_as_string": "2018-01-16",
1363           "key": 1516060800000,
1364           "doc_count": 6,
1365           "readRow": {
1366             "value": 120
1367           }
1368         },
1369         {
1370           "key_as_string": "2018-09-30",
1371           "key": 1538265600000,
1372           "doc_count": 131,
1373           "readRow": {
1374             "value": 120
1375           }
1376         },
1377         {
1378           "key_as_string": "2018-01-08",
1379           "key": 1515369600000,
1380           "doc_count": 7,
1381           "readRow": {
1382             "value": 104
1383           }
1384         },
1385         {
1386           "key_as_string": "2018-08-17",
1387           "key": 1534464000000,
1388           "doc_count": 33,
1389           "readRow": {
1390             "value": 104
1391           }
1392         },
1393         {
1394           "key_as_string": "2018-05-04",
1395           "key": 1525392000000,
1396           "doc_count": 27,
1397           "readRow": {
1398             "value": 102
1399           }
1400         },
1401         {
1402           "key_as_string": "2018-07-23",
1403           "key": 1532304000000,
1404           "doc_count": 12,
1405           "readRow": {
1406             "value": 100
1407           }
1408         },
1409         {
1410           "key_as_string": "2018-01-17",
1411           "key": 1516147200000,
1412           "doc_count": 9,
1413           "readRow": {
1414             "value": 100
1415           }
1416         },
1417         {
1418           "key_as_string": "2018-10-10",
1419           "key": 1539129600000,
1420           "doc_count": 64,
1421           "readRow": {
1422             "value": 99
1423           }
1424         },
1425         {
1426           "key_as_string": "2018-08-21",
1427           "key": 1534809600000,
1428           "doc_count": 27,
1429           "readRow": {
1430             "value": 94
1431           }
1432         },
1433         {
1434           "key_as_string": "2019-01-10",
1435           "key": 1547078400000,
1436           "doc_count": 8,
1437           "readRow": {
1438             "value": 84
1439           }
1440         },
1441         {
1442           "key_as_string": "2018-07-09",
1443           "key": 1531094400000,
1444           "doc_count": 12,
1445           "readRow": {
1446             "value": 82
1447           }
1448         },
1449         {
1450           "key_as_string": "2018-11-29",
1451           "key": 1543449600000,
1452           "doc_count": 32,
1453           "readRow": {
1454             "value": 82
1455           }
1456         },
1457         {
1458           "key_as_string": "2018-01-29",
1459           "key": 1517184000000,
1460           "doc_count": 8,
1461           "readRow": {
1462             "value": 80
1463           }
1464         },
1465         {
1466           "key_as_string": "2018-05-30",
1467           "key": 1527638400000,
1468           "doc_count": 4,
1469           "readRow": {
1470             "value": 80
1471           }
1472         },
1473         {
1474           "key_as_string": "2018-11-06",
1475           "key": 1541462400000,
1476           "doc_count": 32,
1477           "readRow": {
1478             "value": 80
1479           }
1480         },
1481         {
1482           "key_as_string": "2018-08-02",
1483           "key": 1533168000000,
1484           "doc_count": 9,
1485           "readRow": {
1486             "value": 76
1487           }
1488         },
1489         {
1490           "key_as_string": "2018-07-31",
1491           "key": 1532995200000,
1492           "doc_count": 14,
1493           "readRow": {
1494             "value": 69
1495           }
1496         },
1497         {
1498           "key_as_string": "2018-09-13",
1499           "key": 1536796800000,
1500           "doc_count": 10,
1501           "readRow": {
1502             "value": 67
1503           }
1504         },
1505         {
1506           "key_as_string": "2019-05-16",
1507           "key": 1557964800000,
1508           "doc_count": 5,
1509           "readRow": {
1510             "value": 64
1511           }
1512         },
1513         {
1514           "key_as_string": "2018-11-07",
1515           "key": 1541548800000,
1516           "doc_count": 2211,
1517           "readRow": {
1518             "value": 63
1519           }
1520         },
1521         {
1522           "key_as_string": "2018-11-01",
1523           "key": 1541030400000,
1524           "doc_count": 67,
1525           "readRow": {
1526             "value": 62
1527           }
1528         },
1529         {
1530           "key_as_string": "2018-08-20",
1531           "key": 1534723200000,
1532           "doc_count": 26,
1533           "readRow": {
1534             "value": 60
1535           }
1536         },
1537         {
1538           "key_as_string": "2018-11-26",
1539           "key": 1543190400000,
1540           "doc_count": 10,
1541           "readRow": {
1542             "value": 48
1543           }
1544         },
1545         {
1546           "key_as_string": "2018-12-03",
1547           "key": 1543795200000,
1548           "doc_count": 33,
1549           "readRow": {
1550             "value": 47
1551           }
1552         },
1553         {
1554           "key_as_string": "2019-01-02",
1555           "key": 1546387200000,
1556           "doc_count": 29,
1557           "readRow": {
1558             "value": 45
1559           }
1560         },
1561         {
1562           "key_as_string": "2018-10-29",
1563           "key": 1540771200000,
1564           "doc_count": 26,
1565           "readRow": {
1566             "value": 44
1567           }
1568         },
1569         {
1570           "key_as_string": "2018-11-14",
1571           "key": 1542153600000,
1572           "doc_count": 26,
1573           "readRow": {
1574             "value": 44
1575           }
1576         },
1577         {
1578           "key_as_string": "2018-01-05",
1579           "key": 1515110400000,
1580           "doc_count": 3,
1581           "readRow": {
1582             "value": 42
1583           }
1584         },
1585         {
1586           "key_as_string": "2018-12-11",
1587           "key": 1544486400000,
1588           "doc_count": 2,
1589           "readRow": {
1590             "value": 40
1591           }
1592         },
1593         {
1594           "key_as_string": "2018-12-17",
1595           "key": 1545004800000,
1596           "doc_count": 3,
1597           "readRow": {
1598             "value": 40
1599           }
1600         },
1601         {
1602           "key_as_string": "2018-09-03",
1603           "key": 1535932800000,
1604           "doc_count": 13,
1605           "readRow": {
1606             "value": 40
1607           }
1608         },
1609         {
1610           "key_as_string": "2018-08-23",
1611           "key": 1534982400000,
1612           "doc_count": 21,
1613           "readRow": {
1614             "value": 40
1615           }
1616         },
1617         {
1618           "key_as_string": "2018-06-22",
1619           "key": 1529625600000,
1620           "doc_count": 2,
1621           "readRow": {
1622             "value": 40
1623           }
1624         },
1625         {
1626           "key_as_string": "2018-12-20",
1627           "key": 1545264000000,
1628           "doc_count": 2,
1629           "readRow": {
1630             "value": 40
1631           }
1632         },
1633         {
1634           "key_as_string": "2018-05-28",
1635           "key": 1527465600000,
1636           "doc_count": 6,
1637           "readRow": {
1638             "value": 40
1639           }
1640         },
1641         {
1642           "key_as_string": "2018-11-22",
1643           "key": 1542844800000,
1644           "doc_count": 3,
1645           "readRow": {
1646             "value": 40
1647           }
1648         },
1649         {
1650           "key_as_string": "2018-04-18",
1651           "key": 1524009600000,
1652           "doc_count": 2,
1653           "readRow": {
1654             "value": 40
1655           }
1656         },
1657         {
1658           "key_as_string": "2018-03-08",
1659           "key": 1520467200000,
1660           "doc_count": 7,
1661           "readRow": {
1662             "value": 40
1663           }
1664         },
1665         {
1666           "key_as_string": "2018-09-07",
1667           "key": 1536278400000,
1668           "doc_count": 134,
1669           "readRow": {
1670             "value": 38
1671           }
1672         },
1673         {
1674           "key_as_string": "2018-08-24",
1675           "key": 1535068800000,
1676           "doc_count": 18,
1677           "readRow": {
1678             "value": 31
1679           }
1680         },
1681         {
1682           "key_as_string": "2018-10-22",
1683           "key": 1540166400000,
1684           "doc_count": 36,
1685           "readRow": {
1686             "value": 28
1687           }
1688         },
1689         {
1690           "key_as_string": "2019-05-27",
1691           "key": 1558915200000,
1692           "doc_count": 7,
1693           "readRow": {
1694             "value": 26
1695           }
1696         },
1697         {
1698           "key_as_string": "2019-05-28",
1699           "key": 1559001600000,
1700           "doc_count": 12,
1701           "readRow": {
1702             "value": 26
1703           }
1704         },
1705         {
1706           "key_as_string": "2018-10-08",
1707           "key": 1538956800000,
1708           "doc_count": 3,
1709           "readRow": {
1710             "value": 24
1711           }
1712         },
1713         {
1714           "key_as_string": "2018-09-04",
1715           "key": 1536019200000,
1716           "doc_count": 3,
1717           "readRow": {
1718             "value": 22
1719           }
1720         },
1721         {
1722           "key_as_string": "2019-05-29",
1723           "key": 1559088000000,
1724           "doc_count": 7,
1725           "readRow": {
1726             "value": 21
1727           }
1728         },
1729         {
1730           "key_as_string": "2018-07-20",
1731           "key": 1532044800000,
1732           "doc_count": 8,
1733           "readRow": {
1734             "value": 20
1735           }
1736         },
1737         {
1738           "key_as_string": "2018-12-18",
1739           "key": 1545091200000,
1740           "doc_count": 7,
1741           "readRow": {
1742             "value": 20
1743           }
1744         },
1745         {
1746           "key_as_string": "2018-11-21",
1747           "key": 1542758400000,
1748           "doc_count": 1,
1749           "readRow": {
1750             "value": 20
1751           }
1752         },
1753         {
1754           "key_as_string": "2018-06-07",
1755           "key": 1528329600000,
1756           "doc_count": 1,
1757           "readRow": {
1758             "value": 20
1759           }
1760         },
1761         {
1762           "key_as_string": "2018-10-12",
1763           "key": 1539302400000,
1764           "doc_count": 504,
1765           "readRow": {
1766             "value": 19
1767           }
1768         },
1769         {
1770           "key_as_string": "2018-08-29",
1771           "key": 1535500800000,
1772           "doc_count": 12,
1773           "readRow": {
1774             "value": 11
1775           }
1776         },
1777         {
1778           "key_as_string": "2019-01-25",
1779           "key": 1548374400000,
1780           "doc_count": 6,
1781           "readRow": {
1782             "value": 8
1783           }
1784         },
1785         {
1786           "key_as_string": "2019-05-06",
1787           "key": 1557100800000,
1788           "doc_count": 8,
1789           "readRow": {
1790             "value": 8
1791           }
1792         },
1793         {
1794           "key_as_string": "2019-05-24",
1795           "key": 1558656000000,
1796           "doc_count": 7,
1797           "readRow": {
1798             "value": 7
1799           }
1800         },
1801         {
1802           "key_as_string": "2018-12-26",
1803           "key": 1545782400000,
1804           "doc_count": 2,
1805           "readRow": {
1806             "value": 5
1807           }
1808         },
1809         {
1810           "key_as_string": "2019-05-31",
1811           "key": 1559260800000,
1812           "doc_count": 6,
1813           "readRow": {
1814             "value": 5
1815           }
1816         },
1817         {
1818           "key_as_string": "2018-10-23",
1819           "key": 1540252800000,
1820           "doc_count": 7,
1821           "readRow": {
1822             "value": 5
1823           }
1824         },
1825         {
1826           "key_as_string": "2018-12-27",
1827           "key": 1545868800000,
1828           "doc_count": 7,
1829           "readRow": {
1830             "value": 4
1831           }
1832         },
1833         {
1834           "key_as_string": "2019-05-26",
1835           "key": 1558828800000,
1836           "doc_count": 1,
1837           "readRow": {
1838             "value": 2
1839           }
1840         },
1841         {
1842           "key_as_string": "2019-01-03",
1843           "key": 1546473600000,
1844           "doc_count": 2,
1845           "readRow": {
1846             "value": 2
1847           }
1848         },
1849         {
1850           "key_as_string": "2019-05-15",
1851           "key": 1557878400000,
1852           "doc_count": 2,
1853           "readRow": {
1854             "value": 1
1855           }
1856         },
1857         {
1858           "key_as_string": "2018-12-28",
1859           "key": 1545955200000,
1860           "doc_count": 46,
1861           "readRow": {
1862             "value": 1
1863           }
1864         },
1865         {
1866           "key_as_string": "2019-05-21",
1867           "key": 1558396800000,
1868           "doc_count": 1,
1869           "readRow": {
1870             "value": 1
1871           }
1872         },
1873         {
1874           "key_as_string": "2018-11-05",
1875           "key": 1541376000000,
1876           "doc_count": 1,
1877           "readRow": {
1878             "value": 1
1879           }
1880         },
1881         {
1882           "key_as_string": "2018-08-25",
1883           "key": 1535155200000,
1884           "doc_count": 14,
1885           "readRow": {
1886             "value": 0
1887           }
1888         },
1889         {
1890           "key_as_string": "2018-08-26",
1891           "key": 1535241600000,
1892           "doc_count": 14,
1893           "readRow": {
1894             "value": 0
1895           }
1896         },
1897         {
1898           "key_as_string": "2018-08-05",
1899           "key": 1533427200000,
1900           "doc_count": 0,
1901           "readRow": {
1902             "value": 0
1903           }
1904         },
1905         {
1906           "key_as_string": "2018-07-21",
1907           "key": 1532131200000,
1908           "doc_count": 0,
1909           "readRow": {
1910             "value": 0
1911           }
1912         },
1913         {
1914           "key_as_string": "2018-07-29",
1915           "key": 1532822400000,
1916           "doc_count": 0,
1917           "readRow": {
1918             "value": 0
1919           }
1920         },
1921         {
1922           "key_as_string": "2018-07-19",
1923           "key": 1531958400000,
1924           "doc_count": 4,
1925           "readRow": {
1926             "value": 0
1927           }
1928         },
1929         {
1930           "key_as_string": "2018-07-15",
1931           "key": 1531612800000,
1932           "doc_count": 0,
1933           "readRow": {
1934             "value": 0
1935           }
1936         },
1937         {
1938           "key_as_string": "2018-09-01",
1939           "key": 1535760000000,
1940           "doc_count": 0,
1941           "readRow": {
1942             "value": 0
1943           }
1944         },
1945         {
1946           "key_as_string": "2018-09-02",
1947           "key": 1535846400000,
1948           "doc_count": 0,
1949           "readRow": {
1950             "value": 0
1951           }
1952         },
1953         {
1954           "key_as_string": "2018-07-14",
1955           "key": 1531526400000,
1956           "doc_count": 0,
1957           "readRow": {
1958             "value": 0
1959           }
1960         },
1961         {
1962           "key_as_string": "2018-07-08",
1963           "key": 1531008000000,
1964           "doc_count": 0,
1965           "readRow": {
1966             "value": 0
1967           }
1968         },
1969         {
1970           "key_as_string": "2018-07-22",
1971           "key": 1532217600000,
1972           "doc_count": 0,
1973           "readRow": {
1974             "value": 0
1975           }
1976         },
1977         {
1978           "key_as_string": "2018-09-22",
1979           "key": 1537574400000,
1980           "doc_count": 0,
1981           "readRow": {
1982             "value": 0
1983           }
1984         },
1985         {
1986           "key_as_string": "2018-07-07",
1987           "key": 1530921600000,
1988           "doc_count": 0,
1989           "readRow": {
1990             "value": 0
1991           }
1992         },
1993         {
1994           "key_as_string": "2018-09-08",
1995           "key": 1536364800000,
1996           "doc_count": 0,
1997           "readRow": {
1998             "value": 0
1999           }
2000         },
2001         {
2002           "key_as_string": "2018-09-09",
2003           "key": 1536451200000,
2004           "doc_count": 0,
2005           "readRow": {
2006             "value": 0
2007           }
2008         },
2009         {
2010           "key_as_string": "2018-07-05",
2011           "key": 1530748800000,
2012           "doc_count": 0,
2013           "readRow": {
2014             "value": 0
2015           }
2016         },
2017         {
2018           "key_as_string": "2018-07-01",
2019           "key": 1530403200000,
2020           "doc_count": 0,
2021           "readRow": {
2022             "value": 0
2023           }
2024         },
2025         {
2026           "key_as_string": "2018-06-30",
2027           "key": 1530316800000,
2028           "doc_count": 0,
2029           "readRow": {
2030             "value": 0
2031           }
2032         },
2033         {
2034           "key_as_string": "2018-06-24",
2035           "key": 1529798400000,
2036           "doc_count": 0,
2037           "readRow": {
2038             "value": 0
2039           }
2040         },
2041         {
2042           "key_as_string": "2018-06-23",
2043           "key": 1529712000000,
2044           "doc_count": 0,
2045           "readRow": {
2046             "value": 0
2047           }
2048         },
2049         {
2050           "key_as_string": "2018-09-15",
2051           "key": 1536969600000,
2052           "doc_count": 0,
2053           "readRow": {
2054             "value": 0
2055           }
2056         },
2057         {
2058           "key_as_string": "2018-06-19",
2059           "key": 1529366400000,
2060           "doc_count": 0,
2061           "readRow": {
2062             "value": 0
2063           }
2064         },
2065         {
2066           "key_as_string": "2018-01-03",
2067           "key": 1514937600000,
2068           "doc_count": 14,
2069           "readRow": {
2070             "value": 0
2071           }
2072         },
2073         {
2074           "key_as_string": "2018-09-18",
2075           "key": 1537228800000,
2076           "doc_count": 1,
2077           "readRow": {
2078             "value": 0
2079           }
2080         },
2081         {
2082           "key_as_string": "2018-09-19",
2083           "key": 1537315200000,
2084           "doc_count": 0,
2085           "readRow": {
2086             "value": 0
2087           }
2088         },
2089         {
2090           "key_as_string": "2018-07-10",
2091           "key": 1531180800000,
2092           "doc_count": 0,
2093           "readRow": {
2094             "value": 0
2095           }
2096         },
2097         {
2098           "key_as_string": "2018-05-05",
2099           "key": 1525478400000,
2100           "doc_count": 0,
2101           "readRow": {
2102             "value": 0
2103           }
2104         },
2105         {
2106           "key_as_string": "2018-06-18",
2107           "key": 1529280000000,
2108           "doc_count": 0,
2109           "readRow": {
2110             "value": 0
2111           }
2112         },
2113         {
2114           "key_as_string": "2018-09-23",
2115           "key": 1537660800000,
2116           "doc_count": 0,
2117           "readRow": {
2118             "value": 0
2119           }
2120         },
2121         {
2122           "key_as_string": "2018-09-24",
2123           "key": 1537747200000,
2124           "doc_count": 0,
2125           "readRow": {
2126             "value": 0
2127           }
2128         },
2129         {
2130           "key_as_string": "2018-06-17",
2131           "key": 1529193600000,
2132           "doc_count": 0,
2133           "readRow": {
2134             "value": 0
2135           }
2136         },
2137         {
2138           "key_as_string": "2018-06-16",
2139           "key": 1529107200000,
2140           "doc_count": 0,
2141           "readRow": {
2142             "value": 0
2143           }
2144         },
2145         {
2146           "key_as_string": "2018-06-10",
2147           "key": 1528588800000,
2148           "doc_count": 0,
2149           "readRow": {
2150             "value": 0
2151           }
2152         },
2153         {
2154           "key_as_string": "2018-06-09",
2155           "key": 1528502400000,
2156           "doc_count": 0,
2157           "readRow": {
2158             "value": 0
2159           }
2160         },
2161         {
2162           "key_as_string": "2018-06-04",
2163           "key": 1528070400000,
2164           "doc_count": 0,
2165           "readRow": {
2166             "value": 0
2167           }
2168         },
2169         {
2170           "key_as_string": "2018-06-03",
2171           "key": 1527984000000,
2172           "doc_count": 0,
2173           "readRow": {
2174             "value": 0
2175           }
2176         },
2177         {
2178           "key_as_string": "2018-10-01",
2179           "key": 1538352000000,
2180           "doc_count": 0,
2181           "readRow": {
2182             "value": 0
2183           }
2184         },
2185         {
2186           "key_as_string": "2018-10-02",
2187           "key": 1538438400000,
2188           "doc_count": 0,
2189           "readRow": {
2190             "value": 0
2191           }
2192         },
2193         {
2194           "key_as_string": "2018-10-03",
2195           "key": 1538524800000,
2196           "doc_count": 0,
2197           "readRow": {
2198             "value": 0
2199           }
2200         },
2201         {
2202           "key_as_string": "2018-10-04",
2203           "key": 1538611200000,
2204           "doc_count": 0,
2205           "readRow": {
2206             "value": 0
2207           }
2208         },
2209         {
2210           "key_as_string": "2018-10-05",
2211           "key": 1538697600000,
2212           "doc_count": 0,
2213           "readRow": {
2214             "value": 0
2215           }
2216         },
2217         {
2218           "key_as_string": "2018-10-06",
2219           "key": 1538784000000,
2220           "doc_count": 0,
2221           "readRow": {
2222             "value": 0
2223           }
2224         },
2225         {
2226           "key_as_string": "2018-10-07",
2227           "key": 1538870400000,
2228           "doc_count": 0,
2229           "readRow": {
2230             "value": 0
2231           }
2232         },
2233         {
2234           "key_as_string": "2018-06-02",
2235           "key": 1527897600000,
2236           "doc_count": 0,
2237           "readRow": {
2238             "value": 0
2239           }
2240         },
2241         {
2242           "key_as_string": "2018-05-27",
2243           "key": 1527379200000,
2244           "doc_count": 0,
2245           "readRow": {
2246             "value": 0
2247           }
2248         },
2249         {
2250           "key_as_string": "2018-05-26",
2251           "key": 1527292800000,
2252           "doc_count": 0,
2253           "readRow": {
2254             "value": 0
2255           }
2256         },
2257         {
2258           "key_as_string": "2018-05-23",
2259           "key": 1527033600000,
2260           "doc_count": 0,
2261           "readRow": {
2262             "value": 0
2263           }
2264         },
2265         {
2266           "key_as_string": "2018-05-20",
2267           "key": 1526774400000,
2268           "doc_count": 0,
2269           "readRow": {
2270             "value": 0
2271           }
2272         },
2273         {
2274           "key_as_string": "2018-10-13",
2275           "key": 1539388800000,
2276           "doc_count": 0,
2277           "readRow": {
2278             "value": 0
2279           }
2280         },
2281         {
2282           "key_as_string": "2018-10-14",
2283           "key": 1539475200000,
2284           "doc_count": 0,
2285           "readRow": {
2286             "value": 0
2287           }
2288         },
2289         {
2290           "key_as_string": "2018-05-19",
2291           "key": 1526688000000,
2292           "doc_count": 0,
2293           "readRow": {
2294             "value": 0
2295           }
2296         },
2297         {
2298           "key_as_string": "2018-05-13",
2299           "key": 1526169600000,
2300           "doc_count": 0,
2301           "readRow": {
2302             "value": 0
2303           }
2304         },
2305         {
2306           "key_as_string": "2018-05-12",
2307           "key": 1526083200000,
2308           "doc_count": 0,
2309           "readRow": {
2310             "value": 0
2311           }
2312         },
2313         {
2314           "key_as_string": "2018-05-11",
2315           "key": 1525996800000,
2316           "doc_count": 1,
2317           "readRow": {
2318             "value": 0
2319           }
2320         },
2321         {
2322           "key_as_string": "2018-05-10",
2323           "key": 1525910400000,
2324           "doc_count": 78,
2325           "readRow": {
2326             "value": 0
2327           }
2328         },
2329         {
2330           "key_as_string": "2018-10-20",
2331           "key": 1539993600000,
2332           "doc_count": 0,
2333           "readRow": {
2334             "value": 0
2335           }
2336         },
2337         {
2338           "key_as_string": "2018-10-21",
2339           "key": 1540080000000,
2340           "doc_count": 0,
2341           "readRow": {
2342             "value": 0
2343           }
2344         },
2345         {
2346           "key_as_string": "2018-08-19",
2347           "key": 1534636800000,
2348           "doc_count": 14,
2349           "readRow": {
2350             "value": 0
2351           }
2352         },
2353         {
2354           "key_as_string": "2018-05-06",
2355           "key": 1525564800000,
2356           "doc_count": 0,
2357           "readRow": {
2358             "value": 0
2359           }
2360         },
2361         {
2362           "key_as_string": "2018-02-03",
2363           "key": 1517616000000,
2364           "doc_count": 0,
2365           "readRow": {
2366             "value": 0
2367           }
2368         },
2369         {
2370           "key_as_string": "2018-05-03",
2371           "key": 1525305600000,
2372           "doc_count": 0,
2373           "readRow": {
2374             "value": 0
2375           }
2376         },
2377         {
2378           "key_as_string": "2018-10-26",
2379           "key": 1540512000000,
2380           "doc_count": 0,
2381           "readRow": {
2382             "value": 0
2383           }
2384         },
2385         {
2386           "key_as_string": "2018-10-27",
2387           "key": 1540598400000,
2388           "doc_count": 0,
2389           "readRow": {
2390             "value": 0
2391           }
2392         },
2393         {
2394           "key_as_string": "2018-10-28",
2395           "key": 1540684800000,
2396           "doc_count": 0,
2397           "readRow": {
2398             "value": 0
2399           }
2400         },
2401         {
2402           "key_as_string": "2018-05-01",
2403           "key": 1525132800000,
2404           "doc_count": 0,
2405           "readRow": {
2406             "value": 0
2407           }
2408         },
2409         {
2410           "key_as_string": "2018-10-30",
2411           "key": 1540857600000,
2412           "doc_count": 0,
2413           "readRow": {
2414             "value": 0
2415           }
2416         },
2417         {
2418           "key_as_string": "2018-10-31",
2419           "key": 1540944000000,
2420           "doc_count": 0,
2421           "readRow": {
2422             "value": 0
2423           }
2424         },
2425         {
2426           "key_as_string": "2018-04-30",
2427           "key": 1525046400000,
2428           "doc_count": 0,
2429           "readRow": {
2430             "value": 0
2431           }
2432         },
2433         {
2434           "key_as_string": "2018-11-02",
2435           "key": 1541116800000,
2436           "doc_count": 0,
2437           "readRow": {
2438             "value": 0
2439           }
2440         },
2441         {
2442           "key_as_string": "2018-11-03",
2443           "key": 1541203200000,
2444           "doc_count": 0,
2445           "readRow": {
2446             "value": 0
2447           }
2448         },
2449         {
2450           "key_as_string": "2018-11-04",
2451           "key": 1541289600000,
2452           "doc_count": 0,
2453           "readRow": {
2454             "value": 0
2455           }
2456         },
2457         {
2458           "key_as_string": "2019-01-22",
2459           "key": 1548115200000,
2460           "doc_count": 4,
2461           "readRow": {
2462             "value": 0
2463           }
2464         },
2465         {
2466           "key_as_string": "2018-04-29",
2467           "key": 1524960000000,
2468           "doc_count": 0,
2469           "readRow": {
2470             "value": 0
2471           }
2472         },
2473         {
2474           "key_as_string": "2018-04-21",
2475           "key": 1524268800000,
2476           "doc_count": 0,
2477           "readRow": {
2478             "value": 0
2479           }
2480         },
2481         {
2482           "key_as_string": "2018-04-15",
2483           "key": 1523750400000,
2484           "doc_count": 0,
2485           "readRow": {
2486             "value": 0
2487           }
2488         },
2489         {
2490           "key_as_string": "2018-04-07",
2491           "key": 1523059200000,
2492           "doc_count": 0,
2493           "readRow": {
2494             "value": 0
2495           }
2496         },
2497         {
2498           "key_as_string": "2018-11-10",
2499           "key": 1541808000000,
2500           "doc_count": 0,
2501           "readRow": {
2502             "value": 0
2503           }
2504         },
2505         {
2506           "key_as_string": "2018-11-11",
2507           "key": 1541894400000,
2508           "doc_count": 0,
2509           "readRow": {
2510             "value": 0
2511           }
2512         },
2513         {
2514           "key_as_string": "2018-04-06",
2515           "key": 1522972800000,
2516           "doc_count": 0,
2517           "readRow": {
2518             "value": 0
2519           }
2520         },
2521         {
2522           "key_as_string": "2018-03-31",
2523           "key": 1522454400000,
2524           "doc_count": 0,
2525           "readRow": {
2526             "value": 0
2527           }
2528         },
2529         {
2530           "key_as_string": "2018-03-25",
2531           "key": 1521936000000,
2532           "doc_count": 0,
2533           "readRow": {
2534             "value": 0
2535           }
2536         },
2537         {
2538           "key_as_string": "2018-03-24",
2539           "key": 1521849600000,
2540           "doc_count": 0,
2541           "readRow": {
2542             "value": 0
2543           }
2544         },
2545         {
2546           "key_as_string": "2018-03-18",
2547           "key": 1521331200000,
2548           "doc_count": 0,
2549           "readRow": {
2550             "value": 0
2551           }
2552         },
2553         {
2554           "key_as_string": "2018-11-17",
2555           "key": 1542412800000,
2556           "doc_count": 0,
2557           "readRow": {
2558             "value": 0
2559           }
2560         },
2561         {
2562           "key_as_string": "2018-11-18",
2563           "key": 1542499200000,
2564           "doc_count": 0,
2565           "readRow": {
2566             "value": 0
2567           }
2568         },
2569         {
2570           "key_as_string": "2018-11-19",
2571           "key": 1542585600000,
2572           "doc_count": 60,
2573           "readRow": {
2574             "value": 0
2575           }
2576         },
2577         {
2578           "key_as_string": "2018-11-20",
2579           "key": 1542672000000,
2580           "doc_count": 27,
2581           "readRow": {
2582             "value": 0
2583           }
2584         },
2585         {
2586           "key_as_string": "2018-03-17",
2587           "key": 1521244800000,
2588           "doc_count": 0,
2589           "readRow": {
2590             "value": 0
2591           }
2592         },
2593         {
2594           "key_as_string": "2018-03-11",
2595           "key": 1520726400000,
2596           "doc_count": 0,
2597           "readRow": {
2598             "value": 0
2599           }
2600         },
2601         {
2602           "key_as_string": "2018-03-10",
2603           "key": 1520640000000,
2604           "doc_count": 0,
2605           "readRow": {
2606             "value": 0
2607           }
2608         },
2609         {
2610           "key_as_string": "2018-11-24",
2611           "key": 1543017600000,
2612           "doc_count": 0,
2613           "readRow": {
2614             "value": 0
2615           }
2616         },
2617         {
2618           "key_as_string": "2018-11-25",
2619           "key": 1543104000000,
2620           "doc_count": 0,
2621           "readRow": {
2622             "value": 0
2623           }
2624         },
2625         {
2626           "key_as_string": "2018-03-04",
2627           "key": 1520121600000,
2628           "doc_count": 0,
2629           "readRow": {
2630             "value": 0
2631           }
2632         },
2633         {
2634           "key_as_string": "2018-11-27",
2635           "key": 1543276800000,
2636           "doc_count": 0,
2637           "readRow": {
2638             "value": 0
2639           }
2640         },
2641         {
2642           "key_as_string": "2018-03-03",
2643           "key": 1520035200000,
2644           "doc_count": 0,
2645           "readRow": {
2646             "value": 0
2647           }
2648         },
2649         {
2650           "key_as_string": "2018-02-25",
2651           "key": 1519516800000,
2652           "doc_count": 0,
2653           "readRow": {
2654             "value": 0
2655           }
2656         },
2657         {
2658           "key_as_string": "2018-02-21",
2659           "key": 1519171200000,
2660           "doc_count": 0,
2661           "readRow": {
2662             "value": 0
2663           }
2664         },
2665         {
2666           "key_as_string": "2018-12-01",
2667           "key": 1543622400000,
2668           "doc_count": 0,
2669           "readRow": {
2670             "value": 0
2671           }
2672         },
2673         {
2674           "key_as_string": "2018-12-02",
2675           "key": 1543708800000,
2676           "doc_count": 0,
2677           "readRow": {
2678             "value": 0
2679           }
2680         },
2681         {
2682           "key_as_string": "2018-02-20",
2683           "key": 1519084800000,
2684           "doc_count": 0,
2685           "readRow": {
2686             "value": 0
2687           }
2688         },
2689         {
2690           "key_as_string": "2018-02-19",
2691           "key": 1518998400000,
2692           "doc_count": 0,
2693           "readRow": {
2694             "value": 0
2695           }
2696         },
2697         {
2698           "key_as_string": "2018-02-18",
2699           "key": 1518912000000,
2700           "doc_count": 0,
2701           "readRow": {
2702             "value": 0
2703           }
2704         },
2705         {
2706           "key_as_string": "2018-02-17",
2707           "key": 1518825600000,
2708           "doc_count": 0,
2709           "readRow": {
2710             "value": 0
2711           }
2712         },
2713         {
2714           "key_as_string": "2018-02-16",
2715           "key": 1518739200000,
2716           "doc_count": 0,
2717           "readRow": {
2718             "value": 0
2719           }
2720         },
2721         {
2722           "key_as_string": "2018-12-08",
2723           "key": 1544227200000,
2724           "doc_count": 0,
2725           "readRow": {
2726             "value": 0
2727           }
2728         },
2729         {
2730           "key_as_string": "2018-12-09",
2731           "key": 1544313600000,
2732           "doc_count": 0,
2733           "readRow": {
2734             "value": 0
2735           }
2736         },
2737         {
2738           "key_as_string": "2018-02-15",
2739           "key": 1518652800000,
2740           "doc_count": 0,
2741           "readRow": {
2742             "value": 0
2743           }
2744         },
2745         {
2746           "key_as_string": "2018-02-14",
2747           "key": 1518566400000,
2748           "doc_count": 0,
2749           "readRow": {
2750             "value": 0
2751           }
2752         },
2753         {
2754           "key_as_string": "2018-12-12",
2755           "key": 1544572800000,
2756           "doc_count": 0,
2757           "readRow": {
2758             "value": 0
2759           }
2760         },
2761         {
2762           "key_as_string": "2018-12-13",
2763           "key": 1544659200000,
2764           "doc_count": 0,
2765           "readRow": {
2766             "value": 0
2767           }
2768         },
2769         {
2770           "key_as_string": "2018-12-14",
2771           "key": 1544745600000,
2772           "doc_count": 0,
2773           "readRow": {
2774             "value": 0
2775           }
2776         },
2777         {
2778           "key_as_string": "2018-12-15",
2779           "key": 1544832000000,
2780           "doc_count": 0,
2781           "readRow": {
2782             "value": 0
2783           }
2784         },
2785         {
2786           "key_as_string": "2018-12-16",
2787           "key": 1544918400000,
2788           "doc_count": 0,
2789           "readRow": {
2790             "value": 0
2791           }
2792         },
2793         {
2794           "key_as_string": "2018-02-13",
2795           "key": 1518480000000,
2796           "doc_count": 0,
2797           "readRow": {
2798             "value": 0
2799           }
2800         },
2801         {
2802           "key_as_string": "2018-02-12",
2803           "key": 1518393600000,
2804           "doc_count": 0,
2805           "readRow": {
2806             "value": 0
2807           }
2808         },
2809         {
2810           "key_as_string": "2018-12-19",
2811           "key": 1545177600000,
2812           "doc_count": 0,
2813           "readRow": {
2814             "value": 0
2815           }
2816         },
2817         {
2818           "key_as_string": "2018-02-10",
2819           "key": 1518220800000,
2820           "doc_count": 0,
2821           "readRow": {
2822             "value": 0
2823           }
2824         },
2825         {
2826           "key_as_string": "2018-12-21",
2827           "key": 1545350400000,
2828           "doc_count": 0,
2829           "readRow": {
2830             "value": 0
2831           }
2832         },
2833         {
2834           "key_as_string": "2018-12-22",
2835           "key": 1545436800000,
2836           "doc_count": 0,
2837           "readRow": {
2838             "value": 0
2839           }
2840         },
2841         {
2842           "key_as_string": "2018-12-23",
2843           "key": 1545523200000,
2844           "doc_count": 0,
2845           "readRow": {
2846             "value": 0
2847           }
2848         },
2849         {
2850           "key_as_string": "2018-12-24",
2851           "key": 1545609600000,
2852           "doc_count": 0,
2853           "readRow": {
2854             "value": 0
2855           }
2856         },
2857         {
2858           "key_as_string": "2019-05-03",
2859           "key": 1556841600000,
2860           "doc_count": 0,
2861           "readRow": {
2862             "value": 0
2863           }
2864         },
2865         {
2866           "key_as_string": "2019-05-02",
2867           "key": 1556755200000,
2868           "doc_count": 0,
2869           "readRow": {
2870             "value": 0
2871           }
2872         },
2873         {
2874           "key_as_string": "2018-02-04",
2875           "key": 1517702400000,
2876           "doc_count": 0,
2877           "readRow": {
2878             "value": 0
2879           }
2880         },
2881         {
2882           "key_as_string": "2019-05-08",
2883           "key": 1557273600000,
2884           "doc_count": 0,
2885           "readRow": {
2886             "value": 0
2887           }
2888         },
2889         {
2890           "key_as_string": "2018-12-29",
2891           "key": 1546041600000,
2892           "doc_count": 2,
2893           "readRow": {
2894             "value": 0
2895           }
2896         },
2897         {
2898           "key_as_string": "2018-12-30",
2899           "key": 1546128000000,
2900           "doc_count": 0,
2901           "readRow": {
2902             "value": 0
2903           }
2904         },
2905         {
2906           "key_as_string": "2018-12-31",
2907           "key": 1546214400000,
2908           "doc_count": 0,
2909           "readRow": {
2910             "value": 0
2911           }
2912         },
2913         {
2914           "key_as_string": "2019-01-01",
2915           "key": 1546300800000,
2916           "doc_count": 0,
2917           "readRow": {
2918             "value": 0
2919           }
2920         },
2921         {
2922           "key_as_string": "2018-01-28",
2923           "key": 1517097600000,
2924           "doc_count": 0,
2925           "readRow": {
2926             "value": 0
2927           }
2928         },
2929         {
2930           "key_as_string": "2018-08-18",
2931           "key": 1534550400000,
2932           "doc_count": 14,
2933           "readRow": {
2934             "value": 0
2935           }
2936         },
2937         {
2938           "key_as_string": "2018-08-07",
2939           "key": 1533600000000,
2940           "doc_count": 14,
2941           "readRow": {
2942             "value": 0
2943           }
2944         },
2945         {
2946           "key_as_string": "2018-08-12",
2947           "key": 1534032000000,
2948           "doc_count": 14,
2949           "readRow": {
2950             "value": 0
2951           }
2952         },
2953         {
2954           "key_as_string": "2019-01-06",
2955           "key": 1546732800000,
2956           "doc_count": 0,
2957           "readRow": {
2958             "value": 0
2959           }
2960         },
2961         {
2962           "key_as_string": "2019-01-07",
2963           "key": 1546819200000,
2964           "doc_count": 1,
2965           "readRow": {
2966             "value": 0
2967           }
2968         },
2969         {
2970           "key_as_string": "2019-01-08",
2971           "key": 1546905600000,
2972           "doc_count": 1,
2973           "readRow": {
2974             "value": 0
2975           }
2976         },
2977         {
2978           "key_as_string": "2019-01-09",
2979           "key": 1546992000000,
2980           "doc_count": 1,
2981           "readRow": {
2982             "value": 0
2983           }
2984         },
2985         {
2986           "key_as_string": "2018-01-27",
2987           "key": 1517011200000,
2988           "doc_count": 0,
2989           "readRow": {
2990             "value": 0
2991           }
2992         },
2993         {
2994           "key_as_string": "2019-01-11",
2995           "key": 1547164800000,
2996           "doc_count": 0,
2997           "readRow": {
2998             "value": 0
2999           }
3000         },
3001         {
3002           "key_as_string": "2019-01-12",
3003           "key": 1547251200000,
3004           "doc_count": 0,
3005           "readRow": {
3006             "value": 0
3007           }
3008         },
3009         {
3010           "key_as_string": "2019-01-13",
3011           "key": 1547337600000,
3012           "doc_count": 0,
3013           "readRow": {
3014             "value": 0
3015           }
3016         },
3017         {
3018           "key_as_string": "2019-01-14",
3019           "key": 1547424000000,
3020           "doc_count": 0,
3021           "readRow": {
3022             "value": 0
3023           }
3024         },
3025         {
3026           "key_as_string": "2019-01-15",
3027           "key": 1547510400000,
3028           "doc_count": 0,
3029           "readRow": {
3030             "value": 0
3031           }
3032         },
3033         {
3034           "key_as_string": "2018-01-21",
3035           "key": 1516492800000,
3036           "doc_count": 0,
3037           "readRow": {
3038             "value": 0
3039           }
3040         },
3041         {
3042           "key_as_string": "2019-01-17",
3043           "key": 1547683200000,
3044           "doc_count": 0,
3045           "readRow": {
3046             "value": 0
3047           }
3048         },
3049         {
3050           "key_as_string": "2019-01-18",
3051           "key": 1547769600000,
3052           "doc_count": 0,
3053           "readRow": {
3054             "value": 0
3055           }
3056         },
3057         {
3058           "key_as_string": "2019-01-19",
3059           "key": 1547856000000,
3060           "doc_count": 0,
3061           "readRow": {
3062             "value": 0
3063           }
3064         },
3065         {
3066           "key_as_string": "2019-01-20",
3067           "key": 1547942400000,
3068           "doc_count": 0,
3069           "readRow": {
3070             "value": 0
3071           }
3072         },
3073         {
3074           "key_as_string": "2019-01-21",
3075           "key": 1548028800000,
3076           "doc_count": 0,
3077           "readRow": {
3078             "value": 0
3079           }
3080         },
3081         {
3082           "key_as_string": "2018-05-07",
3083           "key": 1525651200000,
3084           "doc_count": 0,
3085           "readRow": {
3086             "value": 0
3087           }
3088         },
3089         {
3090           "key_as_string": "2019-01-23",
3091           "key": 1548201600000,
3092           "doc_count": 0,
3093           "readRow": {
3094             "value": 0
3095           }
3096         },
3097         {
3098           "key_as_string": "2019-01-24",
3099           "key": 1548288000000,
3100           "doc_count": 0,
3101           "readRow": {
3102             "value": 0
3103           }
3104         },
3105         {
3106           "key_as_string": "2018-01-20",
3107           "key": 1516406400000,
3108           "doc_count": 0,
3109           "readRow": {
3110             "value": 0
3111           }
3112         },
3113         {
3114           "key_as_string": "2019-01-26",
3115           "key": 1548460800000,
3116           "doc_count": 0,
3117           "readRow": {
3118             "value": 0
3119           }
3120         },
3121         {
3122           "key_as_string": "2019-01-27",
3123           "key": 1548547200000,
3124           "doc_count": 0,
3125           "readRow": {
3126             "value": 0
3127           }
3128         },
3129         {
3130           "key_as_string": "2019-01-28",
3131           "key": 1548633600000,
3132           "doc_count": 0,
3133           "readRow": {
3134             "value": 0
3135           }
3136         },
3137         {
3138           "key_as_string": "2019-01-29",
3139           "key": 1548720000000,
3140           "doc_count": 0,
3141           "readRow": {
3142             "value": 0
3143           }
3144         },
3145         {
3146           "key_as_string": "2019-01-30",
3147           "key": 1548806400000,
3148           "doc_count": 0,
3149           "readRow": {
3150             "value": 0
3151           }
3152         },
3153         {
3154           "key_as_string": "2019-01-31",
3155           "key": 1548892800000,
3156           "doc_count": 0,
3157           "readRow": {
3158             "value": 0
3159           }
3160         },
3161         {
3162           "key_as_string": "2019-02-01",
3163           "key": 1548979200000,
3164           "doc_count": 0,
3165           "readRow": {
3166             "value": 0
3167           }
3168         },
3169         {
3170           "key_as_string": "2019-02-02",
3171           "key": 1549065600000,
3172           "doc_count": 0,
3173           "readRow": {
3174             "value": 0
3175           }
3176         },
3177         {
3178           "key_as_string": "2019-02-03",
3179           "key": 1549152000000,
3180           "doc_count": 0,
3181           "readRow": {
3182             "value": 0
3183           }
3184         },
3185         {
3186           "key_as_string": "2019-02-04",
3187           "key": 1549238400000,
3188           "doc_count": 0,
3189           "readRow": {
3190             "value": 0
3191           }
3192         },
3193         {
3194           "key_as_string": "2019-02-05",
3195           "key": 1549324800000,
3196           "doc_count": 0,
3197           "readRow": {
3198             "value": 0
3199           }
3200         },
3201         {
3202           "key_as_string": "2019-02-06",
3203           "key": 1549411200000,
3204           "doc_count": 0,
3205           "readRow": {
3206             "value": 0
3207           }
3208         },
3209         {
3210           "key_as_string": "2019-02-07",
3211           "key": 1549497600000,
3212           "doc_count": 0,
3213           "readRow": {
3214             "value": 0
3215           }
3216         },
3217         {
3218           "key_as_string": "2019-02-08",
3219           "key": 1549584000000,
3220           "doc_count": 0,
3221           "readRow": {
3222             "value": 0
3223           }
3224         },
3225         {
3226           "key_as_string": "2019-02-09",
3227           "key": 1549670400000,
3228           "doc_count": 0,
3229           "readRow": {
3230             "value": 0
3231           }
3232         },
3233         {
3234           "key_as_string": "2019-02-10",
3235           "key": 1549756800000,
3236           "doc_count": 0,
3237           "readRow": {
3238             "value": 0
3239           }
3240         },
3241         {
3242           "key_as_string": "2019-02-11",
3243           "key": 1549843200000,
3244           "doc_count": 0,
3245           "readRow": {
3246             "value": 0
3247           }
3248         },
3249         {
3250           "key_as_string": "2019-02-12",
3251           "key": 1549929600000,
3252           "doc_count": 0,
3253           "readRow": {
3254             "value": 0
3255           }
3256         },
3257         {
3258           "key_as_string": "2019-02-13",
3259           "key": 1550016000000,
3260           "doc_count": 0,
3261           "readRow": {
3262             "value": 0
3263           }
3264         },
3265         {
3266           "key_as_string": "2019-02-14",
3267           "key": 1550102400000,
3268           "doc_count": 0,
3269           "readRow": {
3270             "value": 0
3271           }
3272         },
3273         {
3274           "key_as_string": "2019-02-15",
3275           "key": 1550188800000,
3276           "doc_count": 0,
3277           "readRow": {
3278             "value": 0
3279           }
3280         },
3281         {
3282           "key_as_string": "2019-02-16",
3283           "key": 1550275200000,
3284           "doc_count": 0,
3285           "readRow": {
3286             "value": 0
3287           }
3288         },
3289         {
3290           "key_as_string": "2019-02-17",
3291           "key": 1550361600000,
3292           "doc_count": 0,
3293           "readRow": {
3294             "value": 0
3295           }
3296         },
3297         {
3298           "key_as_string": "2019-02-18",
3299           "key": 1550448000000,
3300           "doc_count": 0,
3301           "readRow": {
3302             "value": 0
3303           }
3304         },
3305         {
3306           "key_as_string": "2019-02-19",
3307           "key": 1550534400000,
3308           "doc_count": 0,
3309           "readRow": {
3310             "value": 0
3311           }
3312         },
3313         {
3314           "key_as_string": "2019-02-20",
3315           "key": 1550620800000,
3316           "doc_count": 0,
3317           "readRow": {
3318             "value": 0
3319           }
3320         },
3321         {
3322           "key_as_string": "2019-02-21",
3323           "key": 1550707200000,
3324           "doc_count": 0,
3325           "readRow": {
3326             "value": 0
3327           }
3328         },
3329         {
3330           "key_as_string": "2019-02-22",
3331           "key": 1550793600000,
3332           "doc_count": 0,
3333           "readRow": {
3334             "value": 0
3335           }
3336         },
3337         {
3338           "key_as_string": "2019-02-23",
3339           "key": 1550880000000,
3340           "doc_count": 0,
3341           "readRow": {
3342             "value": 0
3343           }
3344         },
3345         {
3346           "key_as_string": "2019-02-24",
3347           "key": 1550966400000,
3348           "doc_count": 0,
3349           "readRow": {
3350             "value": 0
3351           }
3352         },
3353         {
3354           "key_as_string": "2019-02-25",
3355           "key": 1551052800000,
3356           "doc_count": 0,
3357           "readRow": {
3358             "value": 0
3359           }
3360         },
3361         {
3362           "key_as_string": "2019-02-26",
3363           "key": 1551139200000,
3364           "doc_count": 0,
3365           "readRow": {
3366             "value": 0
3367           }
3368         },
3369         {
3370           "key_as_string": "2019-02-27",
3371           "key": 1551225600000,
3372           "doc_count": 0,
3373           "readRow": {
3374             "value": 0
3375           }
3376         },
3377         {
3378           "key_as_string": "2019-02-28",
3379           "key": 1551312000000,
3380           "doc_count": 0,
3381           "readRow": {
3382             "value": 0
3383           }
3384         },
3385         {
3386           "key_as_string": "2019-03-01",
3387           "key": 1551398400000,
3388           "doc_count": 0,
3389           "readRow": {
3390             "value": 0
3391           }
3392         },
3393         {
3394           "key_as_string": "2019-03-02",
3395           "key": 1551484800000,
3396           "doc_count": 0,
3397           "readRow": {
3398             "value": 0
3399           }
3400         },
3401         {
3402           "key_as_string": "2019-03-03",
3403           "key": 1551571200000,
3404           "doc_count": 0,
3405           "readRow": {
3406             "value": 0
3407           }
3408         },
3409         {
3410           "key_as_string": "2019-03-04",
3411           "key": 1551657600000,
3412           "doc_count": 0,
3413           "readRow": {
3414             "value": 0
3415           }
3416         },
3417         {
3418           "key_as_string": "2019-03-05",
3419           "key": 1551744000000,
3420           "doc_count": 0,
3421           "readRow": {
3422             "value": 0
3423           }
3424         },
3425         {
3426           "key_as_string": "2019-03-06",
3427           "key": 1551830400000,
3428           "doc_count": 0,
3429           "readRow": {
3430             "value": 0
3431           }
3432         },
3433         {
3434           "key_as_string": "2019-03-07",
3435           "key": 1551916800000,
3436           "doc_count": 0,
3437           "readRow": {
3438             "value": 0
3439           }
3440         },
3441         {
3442           "key_as_string": "2019-03-08",
3443           "key": 1552003200000,
3444           "doc_count": 0,
3445           "readRow": {
3446             "value": 0
3447           }
3448         },
3449         {
3450           "key_as_string": "2019-03-09",
3451           "key": 1552089600000,
3452           "doc_count": 0,
3453           "readRow": {
3454             "value": 0
3455           }
3456         },
3457         {
3458           "key_as_string": "2019-03-10",
3459           "key": 1552176000000,
3460           "doc_count": 0,
3461           "readRow": {
3462             "value": 0
3463           }
3464         },
3465         {
3466           "key_as_string": "2019-03-11",
3467           "key": 1552262400000,
3468           "doc_count": 0,
3469           "readRow": {
3470             "value": 0
3471           }
3472         },
3473         {
3474           "key_as_string": "2019-03-12",
3475           "key": 1552348800000,
3476           "doc_count": 0,
3477           "readRow": {
3478             "value": 0
3479           }
3480         },
3481         {
3482           "key_as_string": "2019-03-13",
3483           "key": 1552435200000,
3484           "doc_count": 0,
3485           "readRow": {
3486             "value": 0
3487           }
3488         },
3489         {
3490           "key_as_string": "2019-03-14",
3491           "key": 1552521600000,
3492           "doc_count": 0,
3493           "readRow": {
3494             "value": 0
3495           }
3496         },
3497         {
3498           "key_as_string": "2019-03-15",
3499           "key": 1552608000000,
3500           "doc_count": 0,
3501           "readRow": {
3502             "value": 0
3503           }
3504         },
3505         {
3506           "key_as_string": "2019-03-16",
3507           "key": 1552694400000,
3508           "doc_count": 0,
3509           "readRow": {
3510             "value": 0
3511           }
3512         },
3513         {
3514           "key_as_string": "2019-03-17",
3515           "key": 1552780800000,
3516           "doc_count": 0,
3517           "readRow": {
3518             "value": 0
3519           }
3520         },
3521         {
3522           "key_as_string": "2019-03-18",
3523           "key": 1552867200000,
3524           "doc_count": 0,
3525           "readRow": {
3526             "value": 0
3527           }
3528         },
3529         {
3530           "key_as_string": "2019-03-19",
3531           "key": 1552953600000,
3532           "doc_count": 0,
3533           "readRow": {
3534             "value": 0
3535           }
3536         },
3537         {
3538           "key_as_string": "2019-03-20",
3539           "key": 1553040000000,
3540           "doc_count": 0,
3541           "readRow": {
3542             "value": 0
3543           }
3544         },
3545         {
3546           "key_as_string": "2019-03-21",
3547           "key": 1553126400000,
3548           "doc_count": 0,
3549           "readRow": {
3550             "value": 0
3551           }
3552         },
3553         {
3554           "key_as_string": "2019-03-22",
3555           "key": 1553212800000,
3556           "doc_count": 0,
3557           "readRow": {
3558             "value": 0
3559           }
3560         },
3561         {
3562           "key_as_string": "2019-03-23",
3563           "key": 1553299200000,
3564           "doc_count": 0,
3565           "readRow": {
3566             "value": 0
3567           }
3568         },
3569         {
3570           "key_as_string": "2019-03-24",
3571           "key": 1553385600000,
3572           "doc_count": 0,
3573           "readRow": {
3574             "value": 0
3575           }
3576         },
3577         {
3578           "key_as_string": "2019-03-25",
3579           "key": 1553472000000,
3580           "doc_count": 0,
3581           "readRow": {
3582             "value": 0
3583           }
3584         },
3585         {
3586           "key_as_string": "2019-03-26",
3587           "key": 1553558400000,
3588           "doc_count": 0,
3589           "readRow": {
3590             "value": 0
3591           }
3592         },
3593         {
3594           "key_as_string": "2019-03-27",
3595           "key": 1553644800000,
3596           "doc_count": 0,
3597           "readRow": {
3598             "value": 0
3599           }
3600         },
3601         {
3602           "key_as_string": "2019-03-28",
3603           "key": 1553731200000,
3604           "doc_count": 0,
3605           "readRow": {
3606             "value": 0
3607           }
3608         },
3609         {
3610           "key_as_string": "2019-03-29",
3611           "key": 1553817600000,
3612           "doc_count": 0,
3613           "readRow": {
3614             "value": 0
3615           }
3616         },
3617         {
3618           "key_as_string": "2019-03-30",
3619           "key": 1553904000000,
3620           "doc_count": 0,
3621           "readRow": {
3622             "value": 0
3623           }
3624         },
3625         {
3626           "key_as_string": "2019-03-31",
3627           "key": 1553990400000,
3628           "doc_count": 0,
3629           "readRow": {
3630             "value": 0
3631           }
3632         },
3633         {
3634           "key_as_string": "2019-04-01",
3635           "key": 1554076800000,
3636           "doc_count": 0,
3637           "readRow": {
3638             "value": 0
3639           }
3640         },
3641         {
3642           "key_as_string": "2019-04-02",
3643           "key": 1554163200000,
3644           "doc_count": 0,
3645           "readRow": {
3646             "value": 0
3647           }
3648         },
3649         {
3650           "key_as_string": "2019-04-03",
3651           "key": 1554249600000,
3652           "doc_count": 0,
3653           "readRow": {
3654             "value": 0
3655           }
3656         },
3657         {
3658           "key_as_string": "2019-04-04",
3659           "key": 1554336000000,
3660           "doc_count": 0,
3661           "readRow": {
3662             "value": 0
3663           }
3664         },
3665         {
3666           "key_as_string": "2019-04-05",
3667           "key": 1554422400000,
3668           "doc_count": 0,
3669           "readRow": {
3670             "value": 0
3671           }
3672         },
3673         {
3674           "key_as_string": "2019-04-06",
3675           "key": 1554508800000,
3676           "doc_count": 0,
3677           "readRow": {
3678             "value": 0
3679           }
3680         },
3681         {
3682           "key_as_string": "2019-04-07",
3683           "key": 1554595200000,
3684           "doc_count": 0,
3685           "readRow": {
3686             "value": 0
3687           }
3688         },
3689         {
3690           "key_as_string": "2019-04-08",
3691           "key": 1554681600000,
3692           "doc_count": 0,
3693           "readRow": {
3694             "value": 0
3695           }
3696         },
3697         {
3698           "key_as_string": "2019-04-09",
3699           "key": 1554768000000,
3700           "doc_count": 0,
3701           "readRow": {
3702             "value": 0
3703           }
3704         },
3705         {
3706           "key_as_string": "2019-04-10",
3707           "key": 1554854400000,
3708           "doc_count": 0,
3709           "readRow": {
3710             "value": 0
3711           }
3712         },
3713         {
3714           "key_as_string": "2019-04-11",
3715           "key": 1554940800000,
3716           "doc_count": 0,
3717           "readRow": {
3718             "value": 0
3719           }
3720         },
3721         {
3722           "key_as_string": "2019-04-12",
3723           "key": 1555027200000,
3724           "doc_count": 0,
3725           "readRow": {
3726             "value": 0
3727           }
3728         },
3729         {
3730           "key_as_string": "2019-04-13",
3731           "key": 1555113600000,
3732           "doc_count": 0,
3733           "readRow": {
3734             "value": 0
3735           }
3736         },
3737         {
3738           "key_as_string": "2019-04-14",
3739           "key": 1555200000000,
3740           "doc_count": 0,
3741           "readRow": {
3742             "value": 0
3743           }
3744         },
3745         {
3746           "key_as_string": "2019-04-15",
3747           "key": 1555286400000,
3748           "doc_count": 0,
3749           "readRow": {
3750             "value": 0
3751           }
3752         },
3753         {
3754           "key_as_string": "2019-04-16",
3755           "key": 1555372800000,
3756           "doc_count": 0,
3757           "readRow": {
3758             "value": 0
3759           }
3760         },
3761         {
3762           "key_as_string": "2019-04-17",
3763           "key": 1555459200000,
3764           "doc_count": 0,
3765           "readRow": {
3766             "value": 0
3767           }
3768         },
3769         {
3770           "key_as_string": "2019-04-18",
3771           "key": 1555545600000,
3772           "doc_count": 0,
3773           "readRow": {
3774             "value": 0
3775           }
3776         },
3777         {
3778           "key_as_string": "2019-04-19",
3779           "key": 1555632000000,
3780           "doc_count": 0,
3781           "readRow": {
3782             "value": 0
3783           }
3784         },
3785         {
3786           "key_as_string": "2019-04-20",
3787           "key": 1555718400000,
3788           "doc_count": 0,
3789           "readRow": {
3790             "value": 0
3791           }
3792         },
3793         {
3794           "key_as_string": "2019-04-21",
3795           "key": 1555804800000,
3796           "doc_count": 0,
3797           "readRow": {
3798             "value": 0
3799           }
3800         },
3801         {
3802           "key_as_string": "2019-04-22",
3803           "key": 1555891200000,
3804           "doc_count": 0,
3805           "readRow": {
3806             "value": 0
3807           }
3808         },
3809         {
3810           "key_as_string": "2019-04-23",
3811           "key": 1555977600000,
3812           "doc_count": 0,
3813           "readRow": {
3814             "value": 0
3815           }
3816         },
3817         {
3818           "key_as_string": "2019-04-24",
3819           "key": 1556064000000,
3820           "doc_count": 0,
3821           "readRow": {
3822             "value": 0
3823           }
3824         },
3825         {
3826           "key_as_string": "2019-04-25",
3827           "key": 1556150400000,
3828           "doc_count": 0,
3829           "readRow": {
3830             "value": 0
3831           }
3832         },
3833         {
3834           "key_as_string": "2019-04-26",
3835           "key": 1556236800000,
3836           "doc_count": 0,
3837           "readRow": {
3838             "value": 0
3839           }
3840         },
3841         {
3842           "key_as_string": "2019-04-27",
3843           "key": 1556323200000,
3844           "doc_count": 0,
3845           "readRow": {
3846             "value": 0
3847           }
3848         },
3849         {
3850           "key_as_string": "2019-04-28",
3851           "key": 1556409600000,
3852           "doc_count": 0,
3853           "readRow": {
3854             "value": 0
3855           }
3856         },
3857         {
3858           "key_as_string": "2019-04-29",
3859           "key": 1556496000000,
3860           "doc_count": 0,
3861           "readRow": {
3862             "value": 0
3863           }
3864         },
3865         {
3866           "key_as_string": "2019-04-30",
3867           "key": 1556582400000,
3868           "doc_count": 0,
3869           "readRow": {
3870             "value": 0
3871           }
3872         },
3873         {
3874           "key_as_string": "2019-05-01",
3875           "key": 1556668800000,
3876           "doc_count": 0,
3877           "readRow": {
3878             "value": 0
3879           }
3880         },
3881         {
3882           "key_as_string": "2018-09-20",
3883           "key": 1537401600000,
3884           "doc_count": 0,
3885           "readRow": {
3886             "value": 0
3887           }
3888         },
3889         {
3890           "key_as_string": "2018-07-12",
3891           "key": 1531353600000,
3892           "doc_count": 0,
3893           "readRow": {
3894             "value": 0
3895           }
3896         },
3897         {
3898           "key_as_string": "2019-05-04",
3899           "key": 1556928000000,
3900           "doc_count": 0,
3901           "readRow": {
3902             "value": 0
3903           }
3904         },
3905         {
3906           "key_as_string": "2019-05-05",
3907           "key": 1557014400000,
3908           "doc_count": 0,
3909           "readRow": {
3910             "value": 0
3911           }
3912         },
3913         {
3914           "key_as_string": "2018-01-14",
3915           "key": 1515888000000,
3916           "doc_count": 0,
3917           "readRow": {
3918             "value": 0
3919           }
3920         },
3921         {
3922           "key_as_string": "2019-05-07",
3923           "key": 1557187200000,
3924           "doc_count": 0,
3925           "readRow": {
3926             "value": 0
3927           }
3928         },
3929         {
3930           "key_as_string": "2018-07-28",
3931           "key": 1532736000000,
3932           "doc_count": 0,
3933           "readRow": {
3934             "value": 0
3935           }
3936         },
3937         {
3938           "key_as_string": "2019-05-09",
3939           "key": 1557360000000,
3940           "doc_count": 0,
3941           "readRow": {
3942             "value": 0
3943           }
3944         },
3945         {
3946           "key_as_string": "2019-05-10",
3947           "key": 1557446400000,
3948           "doc_count": 0,
3949           "readRow": {
3950             "value": 0
3951           }
3952         },
3953         {
3954           "key_as_string": "2019-05-11",
3955           "key": 1557532800000,
3956           "doc_count": 0,
3957           "readRow": {
3958             "value": 0
3959           }
3960         },
3961         {
3962           "key_as_string": "2019-05-12",
3963           "key": 1557619200000,
3964           "doc_count": 0,
3965           "readRow": {
3966             "value": 0
3967           }
3968         },
3969         {
3970           "key_as_string": "2019-05-13",
3971           "key": 1557705600000,
3972           "doc_count": 0,
3973           "readRow": {
3974             "value": 0
3975           }
3976         },
3977         {
3978           "key_as_string": "2019-05-14",
3979           "key": 1557792000000,
3980           "doc_count": 0,
3981           "readRow": {
3982             "value": 0
3983           }
3984         },
3985         {
3986           "key_as_string": "2018-08-04",
3987           "key": 1533340800000,
3988           "doc_count": 3,
3989           "readRow": {
3990             "value": 0
3991           }
3992         },
3993         {
3994           "key_as_string": "2018-08-06",
3995           "key": 1533513600000,
3996           "doc_count": 23,
3997           "readRow": {
3998             "value": 0
3999           }
4000         },
4001         {
4002           "key_as_string": "2018-01-13",
4003           "key": 1515801600000,
4004           "doc_count": 0,
4005           "readRow": {
4006             "value": 0
4007           }
4008         },
4009         {
4010           "key_as_string": "2019-05-17",
4011           "key": 1558051200000,
4012           "doc_count": 0,
4013           "readRow": {
4014             "value": 0
4015           }
4016         },
4017         {
4018           "key_as_string": "2019-05-18",
4019           "key": 1558137600000,
4020           "doc_count": 0,
4021           "readRow": {
4022             "value": 0
4023           }
4024         },
4025         {
4026           "key_as_string": "2019-05-19",
4027           "key": 1558224000000,
4028           "doc_count": 0,
4029           "readRow": {
4030             "value": 0
4031           }
4032         },
4033         {
4034           "key_as_string": "2019-05-20",
4035           "key": 1558310400000,
4036           "doc_count": 0,
4037           "readRow": {
4038             "value": 0
4039           }
4040         },
4041         {
4042           "key_as_string": "2019-01-04",
4043           "key": 1546560000000,
4044           "doc_count": 0,
4045           "readRow": {
4046             "value": 0
4047           }
4048         },
4049         {
4050           "key_as_string": "2019-05-22",
4051           "key": 1558483200000,
4052           "doc_count": 0,
4053           "readRow": {
4054             "value": 0
4055           }
4056         },
4057         {
4058           "key_as_string": "2019-05-23",
4059           "key": 1558569600000,
4060           "doc_count": 0,
4061           "readRow": {
4062             "value": 0
4063           }
4064         },
4065         {
4066           "key_as_string": "2018-01-07",
4067           "key": 1515283200000,
4068           "doc_count": 0,
4069           "readRow": {
4070             "value": 0
4071           }
4072         },
4073         {
4074           "key_as_string": "2019-05-25",
4075           "key": 1558742400000,
4076           "doc_count": 0,
4077           "readRow": {
4078             "value": 0
4079           }
4080         },
4081         {
4082           "key_as_string": "2019-01-05",
4083           "key": 1546646400000,
4084           "doc_count": 0,
4085           "readRow": {
4086             "value": 0
4087           }
4088         },
4089         {
4090           "key_as_string": "2018-01-06",
4091           "key": 1515196800000,
4092           "doc_count": 0,
4093           "readRow": {
4094             "value": 0
4095           }
4096         },
4097         {
4098           "key_as_string": "2018-01-04",
4099           "key": 1515024000000,
4100           "doc_count": 0,
4101           "readRow": {
4102             "value": 0
4103           }
4104         },
4105         {
4106           "key_as_string": "2018-09-16",
4107           "key": 1537056000000,
4108           "doc_count": 0,
4109           "readRow": {
4110             "value": 0
4111           }
4112         },
4113         {
4114           "key_as_string": "2019-05-30",
4115           "key": 1559174400000,
4116           "doc_count": 1,
4117           "readRow": {
4118             "value": 0
4119           }
4120         },
4121         {
4122           "key_as_string": "2018-09-17",
4123           "key": 1537142400000,
4124           "doc_count": 2,
4125           "readRow": {
4126             "value": 0
4127           }
4128         }
4129       ]
4130     }
4131   }
4132 }

View Code

7、按小时统计访问量（此处也可以根据小时分组，1.5h则用分钟来表示（90m））

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "sort": [],
14     "aggs": {
15         "group_by_http_time": {
16             "date_histogram":{
17                 "field":"http_time",
18                 "interval":"hour",
19                 "format":"yyyy-MM-dd HH:mm:ss",
20                 "order":{
21                     "readRow":"desc"
22                 }
23             },
24             "aggs":{
25                 "readRow":{
26                     "sum":{
27                         "field":"queryCount"
28                     }
29                 }
30             }
31         }
32     }
33 }

View Code

返回略

8、统计某个索引中有多少数据

{
   "size": 0
}

返回结果：

 1 {
 2   "took": 3,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 844389,
11     "max_score": 0,
12     "hits": []
13   }
14 }

View Code

9、计算哪个用户访问量最大

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "aggs": {
14         "group_by_userId": {
15             "terms":{
16                 "field":"userId.keyword",
17                 "size":1,
18                 "order":{
19                     "readRow":"desc"
20                 }
21             },
22             "aggs":{
23                 "readRow":{
24                     "sum":{
25                         "field":"queryCount"
26                     }
27                 }
28             }
29         }
30     }
31 }

View Code

返回结果：

 1 {
 2   "took": 4,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 665385,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "group_by_userId": {
16       "doc_count_error_upper_bound": -1,
17       "sum_other_doc_count": 624993,
18       "buckets": [
19         {
20           "key": "1804",
21           "doc_count": 40360,
22           "readRow": {
23             "value": 3679990
24           }
25         }
26       ]
27     }
28   }
29 }

View Code

10、计算哪个时间访问量最大

 1 {
 2     "query": {
 3         "bool": {
 4             "must_not": [{
 5                 "term": {
 6                     "userId.keyword": "-1"
 7                 }
 8             }]
 9         }
10     },
11     "from": 0,
12     "size": 0,
13     "aggs": {
14         "group_by_http_time": {
15             "terms":{
16                 "field":"http_time",
17                 "size":1,
18                 "order":{
19                     "readRow":"desc"
20                 }
21             },
22             "aggs":{
23                 "readRow":{
24                     "sum":{
25                         "field":"queryCount"
26                     }
27                 }
28             }
29         }
30     }
31 }

View Code

返回结果：

 1 {
 2   "took": 128,
 3   "timed_out": false,
 4   "_shards": {
 5     "total": 90,
 6     "successful": 85,
 7     "failed": 0
 8   },
 9   "hits": {
10     "total": 665385,
11     "max_score": 0,
12     "hits": []
13   },
14   "aggregations": {
15     "group_by_http_time": {
16       "doc_count_error_upper_bound": -1,
17       "sum_other_doc_count": 665352,
18       "buckets": [
19         {
20           "key": 1530673309000,
21           "key_as_string": "2018-07-04T03:01:49.000Z",
22           "doc_count": 1,
23           "readRow": {
24             "value": 1000000
25           }
26         }
27       ]
28     }
29   }
30 }

View Code

posted @ 2019-06-12 15:03 炫舞风中阅读(455) 评论(0) 编辑收藏举报

刷新页面返回顶部

炫舞风中

elasticsearch相关聚合查询示例

公告