Guest User

Untitled

a guest
May 2nd, 2019
37
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.38 KB | None | 0 0
  1. {
  2. "took": 484,
  3. "timed_out": false,
  4. "_shards": {
  5. "total": 5,
  6. "successful": 5,
  7. "skipped": 0,
  8. "failed": 0
  9. },
  10. "hits": {
  11. "total": 903235,
  12. "max_score": 1,
  13. "hits": [{
  14. "_index": "pingdata-201904",
  15. "_type": "pingdata",
  16. "_id": "7212a97f7cb647b78e16027664aef826_1556024135",
  17. "_score": 1,
  18. "_source": {
  19. "server_timestamp": "2019-04-23T12:55:35.056114042Z",
  20. "timestamp": "2019-04-23T12:55:30.6959334Z",
  21. "user": "kweebia_2000@yahoo.com",
  22. "usid": "44E0A59A46A849912857D1AA6C5BCC4CEF6873F9",
  23. "game_id": 5649,
  24. "gsid": "7212a97f7cb647b78e16027664aef826",
  25. "conn_id": "3",
  26. "src": "72.193.144.7",
  27. "dst": "137.221.101.138",
  28. "int_rtt": 22,
  29. "int_is_spike": false,
  30. "int_is_timeout": false,
  31. "int_running_avg": 25.4666672,
  32. "int_num_spikes": 15,
  33. "int_icmp_status": "TtlExpired",
  34. "int_result_method": "Wall clock",
  35. "int_last_hop_ttl": 11,
  36. "int_last_hop_ip": "137.221.100.3",
  37. "wtf_leg1_px1": "64.147.116.83",
  38. "wtf_legs23_px1": "64.147.116.83",
  39. "wtf_px2": "N/A",
  40. "wtf_rtt": 18,
  41. "wtf_leg1_time": 13,
  42. "wtf_leg2_time": -1,
  43. "wtf_leg3_time": 6,
  44. "wtf_leg1_icmp_status": "ICMP_ECHO",
  45. "wtf_leg2_icmp_status": "N/A",
  46. "wtf_leg3_icmp_status": "ICMP_ECHO",
  47. "wtf_median": 5,
  48. "wtf_is_spike": false,
  49. "wtf_leg1_is_timeout": false,
  50. "wtf_leg3_is_timeout": false,
  51. "wtf_running_avg": 18.666666,
  52. "wtf_num_spikes": 9,
  53. "wtf_leg1_result_method": "Wall clock",
  54. "wtf_num_legs": 2,
  55. "wtf_last_hop_ttl": 9,
  56. "wtf_last_hop_ip": "137.221.100.3",
  57. "partner_name": ""
  58. }
  59. }, {
  60. "_index": "pingdata-201904",
  61. "_type": "pingdata",
  62. "_id": "4e020508c634485a8d5b9c4a167d5bc3_1555994658",
  63. "_score": 1,
  64. "_source": {
  65. "server_timestamp": "2019-04-23T04:44:18.795454542Z",
  66. "timestamp": "2019-04-23T04:44:14.4438356Z",
  67. "user": "christopherrachford@gmail.com",
  68. "usid": "51DE2C3552F199195BFC0B06BE42316665BC4C95",
  69. "game_id": 5820,
  70. "gsid": "4e020508c634485a8d5b9c4a167d5bc3",
  71. "conn_id": "1",
  72. "src": "174.72.88.8",
  73. "dst": "37.244.26.20",
  74. "int_rtt": 25,
  75. "int_is_spike": false,
  76. "int_is_timeout": false,
  77. "int_running_avg": 26.8,
  78. "int_num_spikes": 373,
  79. "int_icmp_status": "Success",
  80. "int_result_method": "ICMP",
  81. "int_last_hop_ttl": 30,
  82. "int_last_hop_ip": "37.244.26.20",
  83. "wtf_leg1_px1": "67.203.3.251",
  84. "wtf_legs23_px1": "67.203.3.251",
  85. "wtf_px2": "66.155.58.107",
  86. "wtf_rtt": 19,
  87. "wtf_leg1_time": 18,
  88. "wtf_leg2_time": 0,
  89. "wtf_leg3_time": 1,
  90. "wtf_leg1_icmp_status": "ICMP_ECHO",
  91. "wtf_leg2_icmp_status": "ICMP_PADDING_BY_PASS",
  92. "wtf_leg3_icmp_status": "ICMP_ECHO",
  93. "wtf_median": 1,
  94. "wtf_is_spike": false,
  95. "wtf_leg1_is_timeout": false,
  96. "wtf_leg3_is_timeout": false,
  97. "wtf_running_avg": 25.4,
  98. "wtf_num_spikes": 1069,
  99. "wtf_leg1_result_method": "Wall clock",
  100. "wtf_num_legs": 3,
  101. "wtf_last_hop_ttl": 6,
  102. "wtf_last_hop_ip": "24.105.30.159",
  103. "partner_name": ""
  104. }
  105. }, {
  106. "_index": "pingdata-201904",
  107. "_type": "pingdata",
  108. "_id": "4e020508c634485a8d5b9c4a167d5bc3_1555994662",
  109. "_score": 1,
  110. "_source": {
  111. "server_timestamp": "2019-04-23T04:44:22.844054322Z",
  112. "timestamp": "2019-04-23T04:44:18.4919585Z",
  113. "user": "christopherrachford@gmail.com",
  114. "usid": "51DE2C3552F199195BFC0B06BE42316665BC4C95",
  115. "game_id": 5820,
  116. "gsid": "4e020508c634485a8d5b9c4a167d5bc3",
  117. "conn_id": "1",
  118. "src": "174.72.88.8",
  119. "dst": "37.244.26.20",
  120. "int_rtt": 29,
  121. "int_is_spike": false,
  122. "int_is_timeout": false,
  123. "int_running_avg": 26.666666,
  124. "int_num_spikes": 373,
  125. "int_icmp_status": "Success",
  126. "int_result_method": "ICMP",
  127. "int_last_hop_ttl": 30,
  128. "int_last_hop_ip": "37.244.26.20",
  129. "wtf_leg1_px1": "67.203.3.251",
  130. "wtf_legs23_px1": "67.203.3.251",
  131. "wtf_px2": "66.155.58.107",
  132. "wtf_rtt": 28,
  133. "wtf_leg1_time": 27,
  134. "wtf_leg2_time": 0,
  135. "wtf_leg3_time": 1,
  136. "wtf_leg1_icmp_status": "ICMP_ECHO",
  137. "wtf_leg2_icmp_status": "ICMP_PADDING_BY_PASS",
  138. "wtf_leg3_icmp_status": "ICMP_ECHO",
  139. "wtf_median": 1,
  140. "wtf_is_spike": false,
  141. "wtf_leg1_is_timeout": false,
  142. "wtf_leg3_is_timeout": false,
  143. "wtf_running_avg": 25.2666664,
  144. "wtf_num_spikes": 1069,
  145. "wtf_leg1_result_method": "Wall clock",
  146. "wtf_num_legs": 3,
  147. "wtf_last_hop_ttl": 6,
  148. "wtf_last_hop_ip": "24.105.30.159",
  149. "partner_name": ""
  150. }
  151. }, {
  152. "_index": "pingdata-201904",
  153. "_type": "pingdata",
  154. "_id": "4b1a9bafd950437e80c15bee9ac4cea3_1555994675",
  155. "_score": 1,
  156. "_source": {
  157. "server_timestamp": "2019-04-23T04:44:35.301128365Z",
  158. "timestamp": "2019-04-23T04:44:34.6659222Z",
  159. "user": "mcmallow@cox.net",
  160. "usid": "483C0265B46E7FD87F00147CCE45CEABB9B6DDC4",
  161. "game_id": 5649,
  162. "gsid": "4b1a9bafd950437e80c15bee9ac4cea3",
  163. "conn_id": "-1",
  164. "src": "174.68.157.120",
  165. "dst": "137.221.99.122",
  166. "int_rtt": 82,
  167. "int_is_spike": true,
  168. "int_is_timeout": false,
  169. "int_running_avg": 47.7333336,
  170. "int_num_spikes": 135,
  171. "int_icmp_status": "TtlExpired",
  172. "int_result_method": "Wall clock",
  173. "int_last_hop_ttl": 11,
  174. "int_last_hop_ip": "137.221.96.2",
  175. "wtf_leg1_px1": "67.203.3.251",
  176. "wtf_legs23_px1": "67.203.3.251",
  177. "wtf_px2": "N/A",
  178. "wtf_rtt": 16,
  179. "wtf_leg1_time": 16,
  180. "wtf_leg2_time": -1,
  181. "wtf_leg3_time": 0,
  182. "wtf_leg1_icmp_status": "ICMP_ECHO",
  183. "wtf_leg2_icmp_status": "N/A",
  184. "wtf_leg3_icmp_status": "ICMP_ECHO",
  185. "wtf_median": 0,
  186. "wtf_is_spike": false,
  187. "wtf_leg1_is_timeout": false,
  188. "wtf_leg3_is_timeout": false,
  189. "wtf_running_avg": 19.666666,
  190. "wtf_num_spikes": 94,
  191. "wtf_leg1_result_method": "Wall clock",
  192. "wtf_num_legs": 2,
  193. "wtf_last_hop_ttl": 3,
  194. "wtf_last_hop_ip": "38.99.219.57",
  195. "partner_name": ""
  196. }
  197. }, {
  198. "_index": "pingdata-201904",
  199. "_type": "pingdata",
  200. "_id": "b1875a9f0835408eae0e506889e9c193_1555694771",
  201. "_score": 1,
  202. "_source": {
  203. "server_timestamp": "2019-04-19T17:26:11.167725446Z",
  204. "timestamp": "2019-04-19T17:26:08.4244127Z",
  205. "user": "oxe1850testing@cox.net",
  206. "usid": "602EBC34D9E86D8E1D2F755D91CBB38191C4D05F",
  207. "game_id": 5992,
  208. "gsid": "b1875a9f0835408eae0e506889e9c193",
  209. "conn_id": "1",
  210. "src": "72.195.188.123",
  211. "dst": "24.105.28.10",
  212. "int_rtt": 132,
  213. "int_is_spike": false,
  214. "int_is_timeout": false,
  215. "int_running_avg": 136.53334,
  216. "int_num_spikes": 1,
  217. "int_icmp_status": "Success",
  218. "int_result_method": "ICMP",
  219. "int_last_hop_ttl": 30,
  220. "int_last_hop_ip": "24.105.28.10",
  221. "wtf_leg1_px1": "45.56.118.14",
  222. "wtf_legs23_px1": "45.56.118.14",
  223. "wtf_px2": "N/A",
  224. "wtf_rtt": 68,
  225. "wtf_leg1_time": 18,
  226. "wtf_leg2_time": -1,
  227. "wtf_leg3_time": 50,
  228. "wtf_leg1_icmp_status": "ICMP_ECHO",
  229. "wtf_leg2_icmp_status": "N/A",
  230. "wtf_leg3_icmp_status": "ICMP_ECHO",
  231. "wtf_median": 50,
  232. "wtf_is_spike": false,
  233. "wtf_leg1_is_timeout": false,
  234. "wtf_leg3_is_timeout": false,
  235. "wtf_running_avg": 89.4,
  236. "wtf_num_spikes": 1,
  237. "wtf_leg1_result_method": "Wall clock",
  238. "wtf_num_legs": 2,
  239. "wtf_last_hop_ttl": 12,
  240. "wtf_last_hop_ip": "10.104.1.38",
  241. "partner_name": ""
  242. }
  243. }, {
  244. "_index": "pingdata-201904",
  245. "_type": "pingdata",
  246. "_id": "4e020508c634485a8d5b9c4a167d5bc3_1555994713",
  247. "_score": 1,
  248. "_source": {
  249. "server_timestamp": "2019-04-23T04:45:13.503797182Z",
  250. "timestamp": "2019-04-23T04:45:09.1482224Z",
  251. "user": "christopherrachford@gmail.com",
  252. "usid": "51DE2C3552F199195BFC0B06BE42316665BC4C95",
  253. "game_id": 5820,
  254. "gsid": "4e020508c634485a8d5b9c4a167d5bc3",
  255. "conn_id": "1",
  256. "src": "174.72.88.8",
  257. "dst": "37.244.26.20",
  258. "int_rtt": 29,
  259. "int_is_spike": false,
  260. "int_is_timeout": false,
  261. "int_running_avg": 27.2666664,
  262. "int_num_spikes": 373,
  263. "int_icmp_status": "Success",
  264. "int_result_method": "ICMP",
  265. "int_last_hop_ttl": 30,
  266. "int_last_hop_ip": "37.244.26.20",
  267. "wtf_leg1_px1": "67.203.3.251",
  268. "wtf_legs23_px1": "67.203.3.251",
  269. "wtf_px2": "66.155.58.107",
  270. "wtf_rtt": 73,
  271. "wtf_leg1_time": 72,
  272. "wtf_leg2_time": 0,
  273. "wtf_leg3_time": 1,
  274. "wtf_leg1_icmp_status": "ICMP_ECHO",
  275. "wtf_leg2_icmp_status": "ICMP_PADDING_BY_PASS",
  276. "wtf_leg3_icmp_status": "ICMP_ECHO",
  277. "wtf_median": 1,
  278. "wtf_is_spike": true,
  279. "wtf_leg1_is_timeout": false,
  280. "wtf_leg3_is_timeout": false,
  281. "wtf_running_avg": 27.7333336,
  282. "wtf_num_spikes": 1072,
  283. "wtf_leg1_result_method": "Wall clock",
  284. "wtf_num_legs": 3,
  285. "wtf_last_hop_ttl": 6,
  286. "wtf_last_hop_ip": "24.105.30.159",
  287. "partner_name": ""
  288. }
  289. }, {
  290. "_index": "pingdata-201904",
  291. "_type": "pingdata",
  292. "_id": "4e020508c634485a8d5b9c4a167d5bc3_1555994565",
  293. "_score": 1,
  294. "_source": {
  295. "server_timestamp": "2019-04-23T04:42:45.58147018Z",
  296. "timestamp": "2019-04-23T04:42:41.2275097Z",
  297. "user": "christopherrachford@gmail.com",
  298. "usid": "51DE2C3552F199195BFC0B06BE42316665BC4C95",
  299. "game_id": 5820,
  300. "gsid": "4e020508c634485a8d5b9c4a167d5bc3",
  301. "conn_id": "1",
  302. "src": "174.72.88.8",
  303. "dst": "37.244.26.20",
  304. "int_rtt": 25,
  305. "int_is_spike": false,
  306. "int_is_timeout": false,
  307. "int_running_avg": 25.6,
  308. "int_num_spikes": 372,
  309. "int_icmp_status": "Success",
  310. "int_result_method": "ICMP",
  311. "int_last_hop_ttl": 30,
  312. "int_last_hop_ip": "37.244.26.20",
  313. "wtf_leg1_px1": "67.203.3.251",
  314. "wtf_legs23_px1": "67.203.3.251",
  315. "wtf_px2": "66.155.58.107",
  316. "wtf_rtt": 28,
  317. "wtf_leg1_time": 27,
  318. "wtf_leg2_time": 0,
  319. "wtf_leg3_time": 1,
  320. "wtf_leg1_icmp_status": "ICMP_ECHO",
  321. "wtf_leg2_icmp_status": "ICMP_PADDING_BY_PASS",
  322. "wtf_leg3_icmp_status": "ICMP_ECHO",
  323. "wtf_median": 1,
  324. "wtf_is_spike": false,
  325. "wtf_leg1_is_timeout": false,
  326. "wtf_leg3_is_timeout": false,
  327. "wtf_running_avg": 26.4,
  328. "wtf_num_spikes": 1065,
  329. "wtf_leg1_result_method": "Wall clock",
  330. "wtf_num_legs": 3,
  331. "wtf_last_hop_ttl": 6,
  332. "wtf_last_hop_ip": "24.105.30.159",
  333. "partner_name": ""
  334. }
  335. }, {
  336. "_index": "pingdata-201904",
  337. "_type": "pingdata",
  338. "_id": "4e020508c634485a8d5b9c4a167d5bc3_1555994640",
  339. "_score": 1,
  340. "_source": {
  341. "server_timestamp": "2019-04-23T04:44:00.568590623Z",
  342. "timestamp": "2019-04-23T04:43:56.2099896Z",
  343. "user": "christopherrachford@gmail.com",
  344. "usid": "51DE2C3552F199195BFC0B06BE42316665BC4C95",
  345. "game_id": 5820,
  346. "gsid": "4e020508c634485a8d5b9c4a167d5bc3",
  347. "conn_id": "1",
  348. "src": "174.72.88.8",
  349. "dst": "37.244.26.20",
  350. "int_rtt": 26,
  351. "int_is_spike": false,
  352. "int_is_timeout": false,
  353. "int_running_avg": 27.0666676,
  354. "int_num_spikes": 373,
  355. "int_icmp_status": "Success",
  356. "int_result_method": "ICMP",
  357. "int_last_hop_ttl": 30,
  358. "int_last_hop_ip": "37.244.26.20",
  359. "wtf_leg1_px1": "67.203.3.251",
  360. "wtf_legs23_px1": "67.203.3.251",
  361. "wtf_px2": "66.155.58.107",
  362. "wtf_rtt": 30,
  363. "wtf_leg1_time": 29,
  364. "wtf_leg2_time": 0,
  365. "wtf_leg3_time": 1,
  366. "wtf_leg1_icmp_status": "ICMP_ECHO",
  367. "wtf_leg2_icmp_status": "ICMP_PADDING_BY_PASS",
  368. "wtf_leg3_icmp_status": "ICMP_ECHO",
  369. "wtf_median": 1,
  370. "wtf_is_spike": true,
  371. "wtf_leg1_is_timeout": false,
  372. "wtf_leg3_is_timeout": false,
  373. "wtf_running_avg": 23.9333324,
  374. "wtf_num_spikes": 1068,
  375. "wtf_leg1_result_method": "Wall clock",
  376. "wtf_num_legs": 3,
  377. "wtf_last_hop_ttl": 6,
  378. "wtf_last_hop_ip": "24.105.30.159",
  379. "partner_name": ""
  380. }
  381. }, {
  382. "_index": "pingdata-201904",
  383. "_type": "pingdata",
  384. "_id": "5d427c44d4364a2da96e6c4b2416cf20_1556229636",
  385. "_score": 1,
  386. "_source": {
  387. "server_timestamp": "2019-04-25T22:00:36.904689818Z",
  388. "timestamp": "2019-04-25T22:00:32.1266086Z",
  389. "user": "kweebia_2000@yahoo.com",
  390. "usid": "44E0A59A46A849912857D1AA6C5BCC4CEF6873F9",
  391. "game_id": 5649,
  392. "gsid": "5d427c44d4364a2da96e6c4b2416cf20",
  393. "conn_id": "-1",
  394. "src": "72.193.144.7",
  395. "dst": "137.221.101.222",
  396. "int_rtt": 20,
  397. "int_is_spike": false,
  398. "int_is_timeout": false,
  399. "int_running_avg": 21.2,
  400. "int_num_spikes": 39,
  401. "int_icmp_status": "TtlExpired",
  402. "int_result_method": "Wall clock",
  403. "int_last_hop_ttl": 11,
  404. "int_last_hop_ip": "137.221.100.2",
  405. "wtf_leg1_px1": "67.203.3.251",
  406. "wtf_legs23_px1": "67.203.3.251",
  407. "wtf_px2": "N/A",
  408. "wtf_rtt": 23,
  409. "wtf_leg1_time": 17,
  410. "wtf_leg2_time": -1,
  411. "wtf_leg3_time": 6,
  412. "wtf_leg1_icmp_status": "ICMP_ECHO",
  413. "wtf_leg2_icmp_status": "N/A",
  414. "wtf_leg3_icmp_status": "ICMP_ECHO",
  415. "wtf_median": 6,
  416. "wtf_is_spike": false,
  417. "wtf_leg1_is_timeout": false,
  418. "wtf_leg3_is_timeout": false,
  419. "wtf_running_avg": 22.2,
  420. "wtf_num_spikes": 19,
  421. "wtf_leg1_result_method": "Wall clock",
  422. "wtf_num_legs": 2,
  423. "wtf_last_hop_ttl": 12,
  424. "wtf_last_hop_ip": "10.74.1.84",
  425. "partner_name": ""
  426. }
  427. }, {
  428. "_index": "pingdata-201904",
  429. "_type": "pingdata",
  430. "_id": "5d427c44d4364a2da96e6c4b2416cf20_1556229638",
  431. "_score": 1,
  432. "_source": {
  433. "server_timestamp": "2019-04-25T22:00:38.922065809Z",
  434. "timestamp": "2019-04-25T22:00:34.1437485Z",
  435. "user": "kweebia_2000@yahoo.com",
  436. "usid": "44E0A59A46A849912857D1AA6C5BCC4CEF6873F9",
  437. "game_id": 5649,
  438. "gsid": "5d427c44d4364a2da96e6c4b2416cf20",
  439. "conn_id": "-1",
  440. "src": "72.193.144.7",
  441. "dst": "137.221.101.222",
  442. "int_rtt": 20,
  443. "int_is_spike": false,
  444. "int_is_timeout": false,
  445. "int_running_avg": 21.0666676,
  446. "int_num_spikes": 39,
  447. "int_icmp_status": "TtlExpired",
  448. "int_result_method": "Wall clock",
  449. "int_last_hop_ttl": 11,
  450. "int_last_hop_ip": "137.221.100.2",
  451. "wtf_leg1_px1": "67.203.3.251",
  452. "wtf_legs23_px1": "67.203.3.251",
  453. "wtf_px2": "N/A",
  454. "wtf_rtt": 22,
  455. "wtf_leg1_time": 16,
  456. "wtf_leg2_time": -1,
  457. "wtf_leg3_time": 6,
  458. "wtf_leg1_icmp_status": "ICMP_ECHO",
  459. "wtf_leg2_icmp_status": "N/A",
  460. "wtf_leg3_icmp_status": "ICMP_ECHO",
  461. "wtf_median": 6,
  462. "wtf_is_spike": false,
  463. "wtf_leg1_is_timeout": false,
  464. "wtf_leg3_is_timeout": false,
  465. "wtf_running_avg": 22.0666676,
  466. "wtf_num_spikes": 19,
  467. "wtf_leg1_result_method": "Wall clock",
  468. "wtf_num_legs": 2,
  469. "wtf_last_hop_ttl": 12,
  470. "wtf_last_hop_ip": "10.74.1.84",
  471. "partner_name": ""
  472. }
  473. }]
  474. },
  475. "aggregations": {
  476. "group_by_gsid_conn_id": {
  477. "doc_count_error_upper_bound": 3694,
  478. "sum_other_doc_count": 206623,
  479. "buckets": [{
  480. "key": "3",
  481. "doc_count": 191506,
  482. "stats_direct": {
  483. "count": 191506,
  484. "min": 16,
  485. "max": 130,
  486. "avg": 93.81204244253443,
  487. "sum": 17965569,
  488. "sum_of_squares": 1772795049,
  489. "variance": 456.4260517567025,
  490. "std_deviation": 21.364130025739463,
  491. "std_deviation_bounds": {
  492. "upper": 136.54030249401336,
  493. "lower": 51.08378239105551
  494. }
  495. },
  496. "stats_wtf": {
  497. "count": 191506,
  498. "min": 11,
  499. "max": 200,
  500. "avg": 65.0497843409606,
  501. "sum": 12457424,
  502. "sum_of_squares": 850374886,
  503. "variance": 208.98635737832385,
  504. "std_deviation": 14.456360447163865,
  505. "std_deviation_bounds": {
  506. "upper": 93.96250523528833,
  507. "lower": 36.137063446632865
  508. }
  509. }
  510. }, {
  511. "key": "0",
  512. "doc_count": 136912,
  513. "stats_direct": {
  514. "count": 136912,
  515. "min": 0,
  516. "max": 271,
  517. "avg": 63.51471748276265,
  518. "sum": 8695927,
  519. "sum_of_squares": 683119691,
  520. "variance": 955.3607013576038,
  521. "std_deviation": 30.908909740681633,
  522. "std_deviation_bounds": {
  523. "upper": 125.33253696412592,
  524. "lower": 1.6968980013993828
  525. }
  526. },
  527. "stats_wtf": {
  528. "count": 136912,
  529. "min": 12,
  530. "max": 451,
  531. "avg": 46.436557788944725,
  532. "sum": 6357722,
  533. "sum_of_squares": 417316966,
  534. "variance": 891.7132241217332,
  535. "std_deviation": 29.86156767689421,
  536. "std_deviation_bounds": {
  537. "upper": 106.15969314273315,
  538. "lower": -13.286577564843697
  539. }
  540. }
  541. }, {
  542. "key": "-1",
  543. "doc_count": 109818,
  544. "stats_direct": {
  545. "count": 109818,
  546. "min": 0,
  547. "max": 446,
  548. "avg": 55.634294924329346,
  549. "sum": 6109647,
  550. "sum_of_squares": 690989409,
  551. "variance": 3196.95774753188,
  552. "std_deviation": 56.54164613390629,
  553. "std_deviation_bounds": {
  554. "upper": 168.71758719214193,
  555. "lower": -57.448997343483235
  556. }
  557. },
  558. "stats_wtf": {
  559. "count": 109818,
  560. "min": 0,
  561. "max": 450,
  562. "avg": 49.087553952903896,
  563. "sum": 5390697,
  564. "sum_of_squares": 568203483,
  565. "variance": 2764.4589517997306,
  566. "std_deviation": 52.578122368526344,
  567. "std_deviation_bounds": {
  568. "upper": 154.24379868995658,
  569. "lower": -56.06869078414879
  570. }
  571. }
  572. }, {
  573. "key": "1",
  574. "doc_count": 109461,
  575. "stats_direct": {
  576. "count": 109461,
  577. "min": 0,
  578. "max": 461,
  579. "avg": 43.99089173312869,
  580. "sum": 4815287,
  581. "sum_of_squares": 273163877,
  582. "variance": 560.3375441395377,
  583. "std_deviation": 23.671449979659837,
  584. "std_deviation_bounds": {
  585. "upper": 91.33379169244836,
  586. "lower": -3.352008226190982
  587. }
  588. },
  589. "stats_wtf": {
  590. "count": 109461,
  591. "min": 15,
  592. "max": 190,
  593. "avg": 38.091402417299314,
  594. "sum": 4169523,
  595. "sum_of_squares": 187620205,
  596. "variance": 263.08207049830463,
  597. "std_deviation": 16.21980488471747,
  598. "std_deviation_bounds": {
  599. "upper": 70.53101218673424,
  600. "lower": 5.651792647864376
  601. }
  602. }
  603. }, {
  604. "key": "5",
  605. "doc_count": 43122,
  606. "stats_direct": {
  607. "count": 43122,
  608. "min": 19,
  609. "max": 131,
  610. "avg": 72.95575344371782,
  611. "sum": 3145998,
  612. "sum_of_squares": 262614166,
  613. "variance": 767.4855428220077,
  614. "std_deviation": 27.703529428973624,
  615. "std_deviation_bounds": {
  616. "upper": 128.3628123016651,
  617. "lower": 17.548694585770576
  618. }
  619. },
  620. "stats_wtf": {
  621. "count": 43122,
  622. "min": 16,
  623. "max": 93,
  624. "avg": 48.579935995547515,
  625. "sum": 2094864,
  626. "sum_of_squares": 112567448,
  627. "variance": 250.43107835033982,
  628. "std_deviation": 15.825014323858914,
  629. "std_deviation_bounds": {
  630. "upper": 80.22996464326535,
  631. "lower": 16.929907347829687
  632. }
  633. }
  634. }, {
  635. "key": "2",
  636. "doc_count": 32489,
  637. "stats_direct": {
  638. "count": 32489,
  639. "min": 11,
  640. "max": 216,
  641. "avg": 62.30465696081751,
  642. "sum": 2024216,
  643. "sum_of_squares": 156266344,
  644. "variance": 927.9528611345943,
  645. "std_deviation": 30.462318709096888,
  646. "std_deviation_bounds": {
  647. "upper": 123.2292943790113,
  648. "lower": 1.3800195426237352
  649. }
  650. },
  651. "stats_wtf": {
  652. "count": 32489,
  653. "min": 12,
  654. "max": 205,
  655. "avg": 49.81181322909293,
  656. "sum": 1618336,
  657. "sum_of_squares": 99200332,
  658. "variance": 572.1346125175496,
  659. "std_deviation": 23.919335536706484,
  660. "std_deviation_bounds": {
  661. "upper": 97.6504843025059,
  662. "lower": 1.9731421556799589
  663. }
  664. }
  665. }, {
  666. "key": "7",
  667. "doc_count": 19288,
  668. "stats_direct": {
  669. "count": 19288,
  670. "min": 1,
  671. "max": 500,
  672. "avg": 75.14651596847781,
  673. "sum": 1449426,
  674. "sum_of_squares": 139668276,
  675. "variance": 1594.2016769946642,
  676. "std_deviation": 39.927455178043395,
  677. "std_deviation_bounds": {
  678. "upper": 155.0014263245646,
  679. "lower": -4.708394387608976
  680. }
  681. },
  682. "stats_wtf": {
  683. "count": 19288,
  684. "min": 18,
  685. "max": 226,
  686. "avg": 46.65631480713397,
  687. "sum": 899907,
  688. "sum_of_squares": 49862009,
  689. "variance": 408.31940641105814,
  690. "std_deviation": 20.206914816741772,
  691. "std_deviation_bounds": {
  692. "upper": 87.07014444061751,
  693. "lower": 6.242485173650422
  694. }
  695. }
  696. }, {
  697. "key": "6",
  698. "doc_count": 18616,
  699. "stats_direct": {
  700. "count": 18616,
  701. "min": 19,
  702. "max": 152,
  703. "avg": 82.05941125913193,
  704. "sum": 1527618,
  705. "sum_of_squares": 133759000,
  706. "variance": 451.41632419141575,
  707. "std_deviation": 21.24656029081921,
  708. "std_deviation_bounds": {
  709. "upper": 124.55253184077036,
  710. "lower": 39.56629067749351
  711. }
  712. },
  713. "stats_wtf": {
  714. "count": 18616,
  715. "min": 10,
  716. "max": 91,
  717. "avg": 46.40518908465836,
  718. "sum": 863879,
  719. "sum_of_squares": 45571475,
  720. "variance": 294.5319434214879,
  721. "std_deviation": 17.1619329745075,
  722. "std_deviation_bounds": {
  723. "upper": 80.72905503367336,
  724. "lower": 12.081323135643359
  725. }
  726. }
  727. }, {
  728. "key": "44",
  729. "doc_count": 17781,
  730. "stats_direct": {
  731. "count": 17781,
  732. "min": 50,
  733. "max": 250,
  734. "avg": 182.95956357910129,
  735. "sum": 3253204,
  736. "sum_of_squares": 603926762,
  737. "variance": 490.52235117335266,
  738. "std_deviation": 22.147739188760386,
  739. "std_deviation_bounds": {
  740. "upper": 227.25504195662205,
  741. "lower": 138.66408520158052
  742. }
  743. },
  744. "stats_wtf": {
  745. "count": 17781,
  746. "min": 30,
  747. "max": 173,
  748. "avg": 157.94696586243742,
  749. "sum": 2808455,
  750. "sum_of_squares": 445999731,
  751. "variance": 135.69456098128757,
  752. "std_deviation": 11.648800838768237,
  753. "std_deviation_bounds": {
  754. "upper": 181.2445675399739,
  755. "lower": 134.64936418490095
  756. }
  757. }
  758. }, {
  759. "key": "4",
  760. "doc_count": 17619,
  761. "stats_direct": {
  762. "count": 17619,
  763. "min": 19,
  764. "max": 157,
  765. "avg": 63.99239457403939,
  766. "sum": 1127482,
  767. "sum_of_squares": 85448982,
  768. "variance": 754.7936307890865,
  769. "std_deviation": 27.47350779913418,
  770. "std_deviation_bounds": {
  771. "upper": 118.93941017230775,
  772. "lower": 9.04537897577103
  773. }
  774. },
  775. "stats_wtf": {
  776. "count": 17619,
  777. "min": 10,
  778. "max": 109,
  779. "avg": 46.31131165219365,
  780. "sum": 815959,
  781. "sum_of_squares": 44266207,
  782. "variance": 367.67554660240165,
  783. "std_deviation": 19.174867577180336,
  784. "std_deviation_bounds": {
  785. "upper": 84.66104680655432,
  786. "lower": 7.961576497832979
  787. }
  788. }
  789. }]
  790. }
  791. }
  792. }
Add Comment
Please, Sign In to add comment