p90 query

gistfile1.txt

SELECT date, 
    NTH(90, quantiles(bytesTotal)) p90_bytes_Total,
    NTH(90, quantiles(bytesHtml)) p90_bytes_Html,
    NTH(90, quantiles(bytesJS)) p90_bytes_JS,
    NTH(90, quantiles(reqTotal)) p90_req_Total,
    NTH(90, quantiles(reqHtml)) p90_req_Html,
    NTH(90, quantiles(reqJS)) p90_req_JS
    NTH(90, quantiles(onLoad)) p90_onLoad,
    NTH(90, quantiles(SpeedIndex)) p90_SpeedIndex,
    NTH(90, quantiles(fullyLoaded)) p90_e2eTime
FROM (
   SELECT 
     STRFTIME_UTC_USEC(INTEGER(createDate*1000000), "%Y-%m") date, SpeedIndex, fullyLoonLoad,bytesTotal,bytesHtml,bytesJS, reqHTML,reqTotal,reqJS
   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.latest_pages_mobile
    where rank <100000
  ) 
GROUP BY date, order by date;