3,094 answered market questions

WITH
(
    SELECT toFloat64(any(close))
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date = '2025-02-14'
) AS sale_day_close
SELECT
    toString(date)                                          AS date,
    formatDateTime(toDate(date), '%b %e, %Y')               AS session_label,
    round(toFloat64(close), 2)                              AS close,
    round(100 * (toFloat64(close) / sale_day_close - 1), 2) AS change_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
  AND date >= '2025-01-15'
  AND date <= '2025-03-16'
ORDER BY date