# Archive of Alexa ranks

**URL:** <https://discuss.httparchive.org/t/archive-of-alexa-ranks/188>\
**Category:** Analysis\
**Created:** [March 4, 2014, 5:46pm UTC](https://discuss.httparchive.org/t/archive-of-alexa-ranks/188 "2014-03-04T17:46:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevesoudersorg](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/stevesoudersorg/32/1293_2.png) [@stevesoudersorg](https://discuss.httparchive.org/u/stevesoudersorg)\
**Post date:** [March 4, 2014, 5:46pm UTC](https://discuss.httparchive.org/t/archive-of-alexa-ranks/188/1 "2014-03-04T17:46:18Z")

</div>

The HTTP Archive started recording the Alexa rank for each URL starting on Nov 1 2011. This is a nice side benefit of the archive as it provides a history of ranks over time.

Here’s the query to get the Top 10 for Nov 1 2011:

```sql
select rank, url from httparchive:runs.2011_11_01_pages 
      where rank > 0 and rank <= 10 order by rank asc

```

We can get similar results for other times by changing the table name. Here are the results for the above query as well as 2012\_11\_01\_pages, 2013\_11\_01\_pages, and 2014\_02\_01\_pages:

 ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/141/80620413864296d0.png) ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/143/07f5065e893bb11b.png) ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/144/23c11d95cb32b878.png) ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/145/7d8991929a166939.png)

Over the past 2 years and 4 months the top six have remained the same, with Baidu and Wikipedia swapping the 5 and 6 slots. Slots 7-10 have seen seven occupants. Blogspot was replaced by Amazon in 2012. Amazon was replaced by LinkedIn in 2013. Twitter was replaced by Taobao in 2014.