# Help with BigQuery to extract all datapoints for top 1,000 sites

**URL:** <https://discuss.httparchive.org/t/help-with-bigquery-to-extract-all-datapoints-for-top-1-000-sites/2544>\
**Category:** Analysis\
**Created:** [March 14, 2023, 9:30am UTC](https://discuss.httparchive.org/t/help-with-bigquery-to-extract-all-datapoints-for-top-1-000-sites/2544 "2023-03-14T09:30:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![matt](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/matt/32/2119_2.png) [@matt](https://discuss.httparchive.org/u/matt)\
**Post date:** [March 14, 2023, 9:30am UTC](https://discuss.httparchive.org/t/help-with-bigquery-to-extract-all-datapoints-for-top-1-000-sites/2544/1 "2023-03-14T09:30:30Z")

</div>

Hi, would anyone be interested in helping me to extract the full data points for the top 1,000 domains on HTTP Archive for page size, and the worst 1,000 for size?

Happy to pay for this, so please provide a rough quote.

---

<div class="post-metadata">

**Author:** ![paulcalvano](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/paulcalvano/32/1601_2.png) [@paulcalvano](https://discuss.httparchive.org/u/paulcalvano)\
**Post date:** [March 14, 2023, 9:36pm UTC](https://discuss.httparchive.org/t/help-with-bigquery-to-extract-all-datapoints-for-top-1-000-sites/2544/2 "2023-03-14T21:36:08Z")

</div>

Hey @matt . Can you share more details about what data points you are looking for? Also, this is a free community forum, so there is no need to pay for this.

I wrote a blog post a few years ago where I did something similar to this (comparing page weight to CrUX performance data). Back then it was using the Alexa rankings, but it might make sense to update this analysis with the new CrUX rankings and more recent data.

> **[Impact of Page Weight on Load Time](https://paulcalvano.com/2018-07-02-impact-of-page-weight-on-load-time/)**
>
> Over the years it has been fun to track website page weight by comparing it to milestones such as the size of a floppy disk (1.44MB), the size of the original install size of DOOM (2.39MB) and when it hit 3MB last summer.

Paul
