fomc_reaction

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(date)                                                     AS meeting_date,
    concat(toString(toDayOfMonth(date)), ' ',
           arrayElement(['Jan','Feb','Mac','Apr','Mei','Jun','Jul','Ogos','Sep','Okt','Nov','Dis'], toMonth(date)), ' ',
           toString(toYear(date)))                                     AS meeting_label,
    round((close / prev_close - 1) * 100, 2)                           AS decision_day_pct,
    round((next_close / close - 1) * 100, 2)                           AS next_day_pct
FROM
(
    SELECT
        date,
        close,
        any(close) OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prev_close,
        any(close) OVER (ORDER BY date ASC ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) AS next_close
    FROM
    (
        SELECT
            date,
            argMax(toFloat64(close), _ingest_time) AS close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= '2024-08-01'
        GROUP BY date
    )
)
WHERE date IN ('2024-09-18','2024-11-07','2024-12-18','2025-01-29','2025-03-19',
               '2025-05-07','2025-06-18','2025-07-30','2025-09-17','2025-10-29',
               '2025-12-10','2026-01-28','2026-03-18','2026-04-29','2026-06-17',
               '2026-07-29','2026-09-16')
  AND prev_close > 0
  AND next_close > 0
ORDER BY date ASC