# Calculate medians for latest HTTP Archive run

**URL:** <https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7>\
**Category:** Analysis\
**Created:** [June 27, 2013, 5:28am UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7 "2013-06-27T05:28:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [June 27, 2013, 5:28am UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7/1 "2013-06-27T05:28:26Z")

</div>

```sql
SELECT
  NTH(50, quantiles(bytesTotal)) TOTAL_med,
  NTH(50, quantiles(bytesHtmlDoc)) HTMLDOC_med,
  NTH(50, quantiles(bytesHtml)) HTML_med,
  NTH(50, quantiles(bytesJS)) JS_med,
  NTH(50, quantiles(bytesCSS)) CSS_med,
  NTH(50, quantiles(bytesImg)) IMG_med,
  NTH(50, quantiles(bytesGif)) GIF_med,
  NTH(50, quantiles(bytesJpg)) JPG_med,
  NTH(50, quantiles(bytesPng)) PNG_med,
  NTH(50, quantiles(bytesFont)) FONT_med,
  NTH(50, quantiles(bytesFlash)) FLASH_med,
  NTH(50, quantiles(bytesJson)) JSON_med,
  NTH(50, quantiles(bytesOther)) OTHER_med
FROM [httparchive:runs.latest_pages]

```

---

<div class="post-metadata">

**Author:** ![beinwal](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/beinwal/32/1309_2.png) [@beinwal](https://discuss.httparchive.org/u/beinwal)\
**Post date:** [July 9, 2013, 5:31pm UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7/2 "2013-07-09T17:31:56Z")

</div>

Why do you set the quantiles buckets to 101 vs. 100?

---

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [July 10, 2013, 3:20am UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7/3 "2013-07-10T03:20:55Z")

</div>

@beinwal No particular reason, I think I was just working with a previous example, and it stuck. Updated the query above to use the default (100) bucket count.

---

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [August 19, 2013, 5:47pm UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7/4 "2013-08-19T17:47:24Z")

</div>

Mobile stats for July 2013:  
 ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/37/89c2b30ae382f75f.png)

22.5KB for HTML + CSS! JavaScript comes in at ~108KB, but some of that (hopefully) is not necessary critical (i.e. can be deferred).

---

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [September 2, 2013, 9:52pm UTC](https://discuss.httparchive.org/t/calculate-medians-for-latest-http-archive-run/7/5 "2013-09-02T21:52:13Z")

</div>

Desktop stats for Aug 15 2013:  
 ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/50/552563cf10ebacca.png)

Median page at ~970KB, with ~50% of that in images. Oh, and it’s a longgg tail (clipped at 7500KB):

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/51/52a55303a7984d20.png)