STRASMORE/EXPLORE 2,170 QUERIES

Session verification: sessions, bars, holiday rows, up and down closes, next closure

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-12, from Market Recap: Week of July 20, 2026.

as of scalar 1×9read in context →
sessions in week
5
first session
2026-07-20
last session
2026-07-24
regular bars in week
1,950
holiday rows in week
0
up sessions
2
down sessions
3
next closure date
2026-09-07
next closure name
Labor Day
Rows × columns
1 × 9
Period covered
Computed
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 Session verification: sessions, bars, holiday rows, up and down closes, next closure, derived from the stored result.
ColumnTypeRangeNotes
sessions_in_week number every row is 5
first_session date 2026-07-20
last_session date 2026-07-24
regular_bars_in_week number every row is 1,950
holiday_rows_in_week number every row is 0
up_sessions number every row is 2
down_sessions number every row is 3
next_closure_date date 2026-09-07
next_closure_name text 1 distinct value (Labor Day)

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 , and the query below is what returned them.

the exact SQL behind every number 
WITH spy AS (
    SELECT d, c, lagInFrame(c) OVER (ORDER BY d ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS p
    FROM (
        SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
               argMax(toFloat64(close), window_start) AS c
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND ((window_start >= '2026-07-17 13:30:00' AND window_start < '2026-07-17 20:00:00')
            OR (window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'))
          AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
        GROUP BY d
    )
)
SELECT
    uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS sessions_in_week,
    toString(min(toDate(toTimeZone(window_start, 'America/New_York')))) AS first_session,
    toString(max(toDate(toTimeZone(window_start, 'America/New_York')))) AS last_session,
    count() AS regular_bars_in_week,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-20' AND date <= '2026-07-24') AS holiday_rows_in_week,
    (SELECT countIf(c > p) FROM spy WHERE d >= '2026-07-20') AS up_sessions,
    (SELECT countIf(c < p) FROM spy WHERE d >= '2026-07-20') AS down_sessions,
    (SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-24' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_date,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-24' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= '2026-07-20 13:30:00' AND window_start < '2026-07-24 20:00:00'
  AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMarket Recap: Week of July 20, 2026
Next week on the calendar: closures, ex-dividends, splits, and the expiry pull scalar 1×6 → The week's corporate calendar: dividends, splits, listings, news scalar 1×9 → SPY's week in trailing-year context (open-to-close weekly returns) scalar 1×5 → Weekly breadth: July 24 regular close vs July 17 regular close, names with $5M+ traded during the week scalar 1×6 → Weekly movers: ten biggest gainers and decliners, regular-hours closes, $5M+ traded, splits excluded table 20×6 → Sector ETFs, full-week change: July 24 close vs July 17 close ranking 11×3 → See all 2,170 queries →