# What are the quantiles of the Pagespeed score for the latest crawl?

**URL:** <https://discuss.httparchive.org/t/what-are-the-quantiles-of-the-pagespeed-score-for-the-latest-crawl/154>\
**Category:** Analysis\
**Created:** [December 14, 2013, 4:53am UTC](https://discuss.httparchive.org/t/what-are-the-quantiles-of-the-pagespeed-score-for-the-latest-crawl/154 "2013-12-14T04:53:08Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 14, 2013, 8:53pm UTC](https://discuss.httparchive.org/t/what-are-the-quantiles-of-the-pagespeed-score-for-the-latest-crawl/154/2 "2013-12-14T20:53:29Z")

</div>

Nice. I was also curious about how/if the distribution has changed over time:

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/111/ef898c466626d85c.png)

Interesting to see that the lower quantiles all gained ~3 extra points over the past two years, whereas the best performers only added one or two points. Full query:

```sql
SELECT  
  date,
  NTH(10, quantiles(pageSpeed)) tenth,
  NTH(20, quantiles(pageSpeed)) twentieth,
  NTH(30, quantiles(pageSpeed)) thirtieth,
  NTH(40, quantiles(pageSpeed)) fortieth,
  NTH(50, quantiles(pageSpeed)) fiftieth,
  NTH(60, quantiles(pageSpeed)) sixtieth,
  NTH(70, quantiles(pageSpeed)) seventieth,
  NTH(80, quantiles(pageSpeed)) eightieth,
  NTH(90, quantiles(pageSpeed)) ninetieth
FROM (
  SELECT STRFTIME_UTC_USEC(INTEGER(createDate*1000000), "%Y-%m") date, pageSpeed FROM 
    httparchive:runs.2012_01_01_pages, httparchive:runs.2012_02_01_pages,
    httparchive:runs.2012_03_01_pages, httparchive:runs.2012_04_01_pages,
    httparchive:runs.2012_05_01_pages, httparchive:runs.2012_06_01_pages,
    httparchive:runs.2012_07_01_pages, httparchive:runs.2012_08_01_pages,
    httparchive:runs.2012_09_01_pages, httparchive:runs.2012_10_01_pages,
    httparchive:runs.2012_11_01_pages, httparchive:runs.2012_12_01_pages,
    httparchive:runs.2013_01_01_pages, httparchive:runs.2013_02_01_pages,
    httparchive:runs.2013_03_01_pages, httparchive:runs.2013_04_01_pages,
    httparchive:runs.2013_05_01_pages, httparchive:runs.2013_06_01_pages,
    httparchive:runs.2013_07_01_pages, httparchive:runs.2013_08_01_pages,
    httparchive:runs.2013_09_01_pages, httparchive:runs.2013_10_01_pages,
    httparchive:runs.2013_11_01_pages
) GROUP BY date, order by date

```

@stevesoudersorg it would be great to add PageSpeed to mobile runs as well! Currently, all of those columns report zero scores.

---

_[View the full topic](https://discuss.httparchive.org/t/what-are-the-quantiles-of-the-pagespeed-score-for-the-latest-crawl/154)._