2,648 answered market questions

WITH dec_days AS
(
    SELECT
        toYear(date)                                                   AS yr,
        toFloat64(volume)                                              AS vol,
        toDayOfWeek(date) = 5 AND toDayOfMonth(date) BETWEEN 15 AND 21 AS is_recon_friday
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'QQQ'
      AND toMonth(date) = 12
      AND date >= '2016-12-01'
)
SELECT
    toString(yr)                                                            AS year,
    round(maxIf(vol, is_recon_friday) / 1e6, 1)                             AS recon_friday_volume_mn,
    round(avgIf(vol, NOT is_recon_friday) / 1e6, 1)                         AS other_december_volume_mn,
    round(maxIf(vol, is_recon_friday) / avgIf(vol, NOT is_recon_friday), 2) AS recon_day_ratio
FROM dec_days
GROUP BY yr
HAVING countIf(is_recon_friday) > 0 AND countIf(NOT is_recon_friday) > 0
ORDER BY yr