I ran a similar query to see the distribution of frontend SPOF resources (JS, CSS & font). Query:
SELECT party,
NTH(10, quantiles(cnt)) p10,
NTH(20, quantiles(cnt)) p20,
NTH(30, quantiles(cnt)) p30,
NTH(40, quantiles(cnt)) p40,
NTH(50, quantiles(cnt)) p50,
NTH(60, quantiles(cnt)) p60,
NTH(70, quantiles(cnt)) p70,
NTH(80, quantiles(cnt)) p80,
NTH(90, quantiles(cnt)) p90,
NTH(99, quantiles(cnt)) p99
FROM (
SELECT
origin,
IF (req_host CONTAINS REGEXP_EXTRACT(origin, r'([\w-]+)'), INTEGER(1), INTEGER(3)) AS party,
COUNT(*) as cnt
FROM [httparchive:runs.2014_04_15_requests] requests JOIN EACH (
SELECT pageid, DOMAIN(url) as origin
FROM [httparchive:runs.2014_04_15_pages]
) pages ON pages.pageid = requests.pageid
GROUP BY origin, party
)
GROUP by party
The results: