SELECT
PERCENTILE(event.loadEventEnd, 0.5) AS median,
PERCENTILE(event.loadEventEnd, 0.9) AS p90,
PERCENTILE(event.loadEventEnd, 0.95) AS p95,
COUNT(*) AS count
FROM event.navigationtiming
WHERE year = 2019
AND month = 6
AND
(
(day = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5003)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5007 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5009)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1075 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1082)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2002)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2008)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2011)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2014)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2017)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3040 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3047)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3049)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4024 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4029)
);

SELECT
PERCENTILE(event.loadEventEnd, 0.5) AS median,
PERCENTILE(event.loadEventEnd, 0.9) AS p90,
PERCENTILE(event.loadEventEnd, 0.95) AS p95,
COUNT(*) AS count
FROM event.navigationtiming
WHERE year = 2019
AND month = 6
AND
(
(day = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5006)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5012)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1083 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1090)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2012 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2013)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2008)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2018 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2026)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2016)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3032 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3039)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3030)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4021 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4023)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4030 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4032)
);