Last SPY and SPX option print, minutes past the 4:00 p.m. equity close

Name: Last SPY and SPX option print, minutes past the 4:00 p.m. equity close
Creator: Strasmore
Published: 2026-08-16
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-16, from What Time Do Options Stop Trading?.

as of 2026-08-16 series 12×4read in context →

Last SPY and SPX option print, minutes past the 4:00 p.m. equity close — 12 rows by 4 columns, computed 2026-08-16 from US exchange, SIP and OPRA data.
session_date	spy_minutes_after_4pm	spx_minutes_after_4pm	spy_last_print_et
2026-07-01	15	59	16:15
2026-07-02	14	59	16:14
2026-07-06	14	59	16:14
2026-07-07	14	59	16:14
2026-07-08	14	59	16:14
2026-07-09	14	59	16:14
2026-07-10	14	59	16:14
2026-07-13	14	59	16:14
2026-07-14	14	59	16:14
2026-07-15	14	59	16:14
2026-07-16	14	59	16:14
2026-07-17	56	59	16:56

Rows × columns: 12 × 4
Period covered: 2026-07-01 to 2026-07-17
Computed: 2026-08-16
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Last SPY and SPX option print, minutes past the 4:00 p.m. equity close, derived from the stored result.
Column	Type	Range
`session_date`	date	2026-07-01 to 2026-07-17
`spy_minutes_after_4pm`	number	14 to 56
`spx_minutes_after_4pm`	number	every row is 59
`spy_last_print_et`	text	3 distinct values (16:14, 16:15, 16:56)

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-16, and the query below is what returned them.

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
    session_date,
    spy_last_minute - 960 AS spy_minutes_after_4pm,
    spx_last_minute - 960 AS spx_minutes_after_4pm,
    concat(toString(intDiv(spy_last_minute, 60)), ':',
           leftPad(toString(modulo(spy_last_minute, 60)), 2, '0')) AS spy_last_print_et
FROM
(
    WITH
        extract(ticker, '^O:([A-Z]+)')                AS root,
        toTimeZone(sip_timestamp, 'America/New_York') AS et
    SELECT
        toString(toDate(et))                                          AS session_date,
        maxIf(toHour(et) * 60 + toMinute(et), root = 'SPY')            AS spy_last_minute,
        maxIf(toHour(et) * 60 + toMinute(et), root IN ('SPX', 'SPXW')) AS spx_last_minute
    FROM global_markets.options_trades
    WHERE (ticker LIKE 'O:SPY%' OR ticker LIKE 'O:SPX%')
      AND root IN ('SPY', 'SPX', 'SPXW')
      AND sip_timestamp >= '2026-07-01 20:00:00'
      AND sip_timestamp <  '2026-07-17 21:00:00'
      AND (toHour(et) * 60 + toMinute(et)) BETWEEN 960 AND 1020
    GROUP BY session_date
    HAVING countIf(root = 'SPY') > 0
       AND countIf(root IN ('SPX', 'SPXW')) > 0
)
ORDER BY session_date

SQL to run

SELECT
    session_date,
    spy_last_minute - 960 AS spy_minutes_after_4pm,
    spx_last_minute - 960 AS spx_minutes_after_4pm,
    concat(toString(intDiv(spy_last_minute, 60)), ':',
           leftPad(toString(modulo(spy_last_minute, 60)), 2, '0')) AS spy_last_print_et
FROM
(
    WITH
        extract(ticker, '^O:([A-Z]+)')                AS root,
        toTimeZone(sip_timestamp, 'America/New_York') AS et
    SELECT
        toString(toDate(et))                                          AS session_date,
        maxIf(toHour(et) * 60 + toMinute(et), root = 'SPY')            AS spy_last_minute,
        maxIf(toHour(et) * 60 + toMinute(et), root IN ('SPX', 'SPXW')) AS spx_last_minute
    FROM global_markets.options_trades
    WHERE (ticker LIKE 'O:SPY%' OR ticker LIKE 'O:SPX%')
      AND root IN ('SPY', 'SPX', 'SPXW')
      AND sip_timestamp >= '2026-07-01 20:00:00'
      AND sip_timestamp <  '2026-07-17 21:00:00'
      AND (toHour(et) * 60 + toMinute(et)) BETWEEN 960 AND 1020
    GROUP BY session_date
    HAVING countIf(root = 'SPY') > 0
       AND countIf(root IN ('SPX', 'SPXW')) > 0
)
ORDER BY session_date

⌘/Ctrl + Enter

More from this analysisWhat Time Do Options Stop Trading?

SPY and SPX option volume by the minute, 15:45 to 16:25 ET series 41×3 → Share of late session option volume printed after 4:00 p.m. ET, July 15, 2026 ranking 7×3 → Last SPY option print on each 1:00 p.m. ET early close since July 2024 ranking 6×3 → Dividend owed per assigned contract, recent ex dividend dates series 6×3 → What 100 shares per contract is worth, six household names series 6×3 → SPY: widest open print to close print gaps on monthly expiration Fridays since 2021 ranking 12×4 → See all 2,401 queries →