Same $500-a-month plan vs a lump sum across five stocks, 2016 to 2026 ($ thousands)

WITH
monthly AS (
    SELECT ticker, toStartOfMonth(dt) AS mo, argMin(c, dt) AS px
    FROM (
        SELECT ticker, toDate(toTimeZone(window_start, 'America/New_York')) AS dt,
               argMax(toFloat64(close), window_start) AS c
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('SPY', 'QQQ', 'MSFT', 'JNJ', 'KO')
          AND window_start >= '2016-01-01 00:00:00' AND window_start < '2026-07-01 00:00:00'
          AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
               + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
        GROUP BY ticker, dt
    )
    GROUP BY ticker, mo
)
SELECT ticker,
       round(sum(500.0 / px) * argMax(px, mo) / 1000, 1) AS dca_final,
       round(sum(500.0) / argMin(px, mo) * argMax(px, mo) / 1000, 1) AS lumpsum_final
FROM monthly
GROUP BY ticker
HAVING count() = 126
ORDER BY lumpsum_final DESC