query

gistfile1.txt

SELECT date, 
    NTH(50, quantiles(bytesHtml)) median_HtmlBytes,
    NTH(50, quantiles(bytesJS)) median_JsBytes,
    NTH(50, quantiles(bytesCSS)) median_CssBytes,
    NTH(50, quantiles(bytesImg)) median_ImgBytes

FROM (
   SELECT 
     STRFTIME_UTC_USEC(INTEGER(createDate*1000000), "%Y-%m") date, bytesHtml,bytesJS,bytesCSS,bytesImg
   FROM     httparchive:runs.2012_01_01_pages_mobile, httparchive:runs.2012_02_01_pages_mobile,
    httparchive:runs.2012_03_01_pages_mobile, httparchive:runs.2012_04_01_pages_mobile,
    httparchive:runs.2012_05_01_pages_mobile, 
    httparchive:runs.2012_07_01_pages_mobile, httparchive:runs.2012_08_01_pages_mobile,
    httparchive:runs.2012_09_01_pages_mobile, httparchive:runs.2012_10_01_pages_mobile,
    httparchive:runs.2012_11_01_pages_mobile, httparchive:runs.2012_12_01_pages_mobile,
    httparchive:runs.2013_01_01_pages_mobile, httparchive:runs.2013_02_01_pages_mobile,
    httparchive:runs.2013_03_01_pages_mobile, httparchive:runs.2013_04_01_pages_mobile,
    httparchive:runs.2013_05_01_pages_mobile, httparchive:runs.2013_06_01_pages_mobile,
    httparchive:runs.2013_07_01_pages_mobile, httparchive:runs.2013_08_01_pages_mobile,
    httparchive:runs.2013_09_01_pages_mobile, httparchive:runs.2013_10_01_pages_mobile,
    httparchive:runs.2013_11_01_pages_mobile, httparchive:runs.2013_12_15_pages_mobile,
    httparchive:runs.2014_01_01_pages_mobile, httparchive:runs.2014_02_01_pages_mobile,
    httparchive:runs.2014_03_01_pages_mobile, httparchive:runs.2014_04_01_pages_mobile,
    httparchive:runs.2014_05_01_pages_mobile, httparchive:runs.2014_06_01_pages_mobile,
    httparchive:runs.2014_07_01_pages_mobile, httparchive:runs.2014_08_01_pages_mobile,
    httparchive:runs.2014_09_01_pages_mobile, httparchive:runs.2014_10_01_pages_mobile, 
    httparchive:runs.2014_11_01_pages_mobile, httparchive:runs.2014_12_01_pages_mobile, 
    httparchive:runs.2015_01_01_pages_mobile, httparchive:runs.2015_02_01_pages_mobile,
    httparchive:runs.2015_03_01_pages_mobile, httparchive:runs.2015_04_01_pages_mobile,
    httparchive:runs.latest_pages_mobile
    where rank <100000
  ) 
GROUP BY date, order by date;