almanac.httparchive.org/sql/2022/css/stylesheet_kbytes.sql at main · HTTPArchive/almanac.httparchive.org · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
#standardSQL
# Distribution of external stylesheet transfer size (compressed).
WITH summary_pages AS (
  SELECT
    2019 AS year,
    _TABLE_SUFFIX AS client,
    bytesCSS
  FROM
    `httparchive.summary_pages.2019_07_01_*`
  UNION ALL
  SELECT
    2020 AS year,
    _TABLE_SUFFIX AS client,
    bytesCSS
  FROM
    `httparchive.summary_pages.2020_08_01_*`
  UNION ALL
  SELECT
    2021 AS year,
    _TABLE_SUFFIX AS client,
    bytesCSS
  FROM
    `httparchive.summary_pages.2021_07_01_*`
  UNION ALL
  SELECT
    2022 AS year,
    _TABLE_SUFFIX AS client,
    bytesCSS
  FROM
    `httparchive.summary_pages.2022_06_01_*`
)

SELECT
  year,
  percentile,
  client,
  APPROX_QUANTILES(bytesCSS / 1024, 1000)[OFFSET(percentile * 10)] AS stylesheet_kbytes
FROM
  summary_pages,
  UNNEST([10, 25, 50, 75, 90, 100]) AS percentile
GROUP BY
  year,
  percentile,
  client
ORDER BY
  year,
  percentile,
  client