Get Median and 95th percentile duration of requests by day

[trieloff]

WITH durations AS (
    SELECT 
        TIMESTAMP_MICROS(CAST(time_start_usec AS INT64)) AS time, 
        CAST(time_elapsed_usec AS INT64) AS duration,
        status_code
    FROM `helix-225321.helix_logging_1McGRQOYFuABWBHyD8D4Ux.requests202*`
    WHERE 
        status_code = "200" AND 
        resp_http_Content_Type LIKE "text/html%" AND 
        fastly_info_state LIKE "MISS%"
)
SELECT
    DATE(EXTRACT(YEAR FROM time), EXTRACT(MONTH FROM time), EXTRACT(DAY FROM time)) AS date,
    COUNT(time) AS reqs,
    APPROX_QUANTILES(duration, 100)[OFFSET(50)]/1000000 AS median_duration,
    APPROX_QUANTILES(duration, 100)[OFFSET(95)]/1000000 AS duration_95th
FROM durations
GROUP BY date
ORDER BY date ASC