STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

AI Trading Bots and Real Brokerage Orders
Upcoming market closures that move a settlement dateseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. AAPL quoted spread and quote traffic by ET clock time, 14 August 2026series · 2026-10-04 · 36×3Preview: a 16-point series, roughly flat. AAPL near-the-money option volume and implied volatility by time to expiry, August 2026ranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Trade print sizes across five liquid names, 13:00 to 14:00 ET on 14 August 2026ranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. Minutes with a 1% high to low range, January to September 2026ranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first.
Open-Source Trading Terminal for Python
Median quoted spread across six large caps, 10:00 to 10:30 ET on June 15 2026ranking · 2026-10-03 · 6×4Preview: 6 ranked values, smallest first. Apple in June 2026: full-day range against the widest single minuteseries · 2026-10-03 · 21×4Preview: a 16-point series, ending higher. Apple near-the-money implied volatility by days to expiry, June 15 2026ranking · 2026-10-03 · 5×3Preview: 5 ranked values, smallest first. Apple quoted spread by 30 minute ET bucket, June 15 2026 sessionseries · 2026-10-03 · 13×3Preview: a 13-point series, ending lower.
Market Data Skills for AI Agents
Trading sessions per month: SPY bars, July 2025 through June 2026series · 2026-09-28 · 12×4Preview: a 12-point series, roughly flat. Where the volume sits: share of June 2026 volume by half hour, New York timeseries · 2026-09-28 · 32×3Preview: a 16-point series, roughly flat. One company, two tickers: share class volume split, June 2026ranking · 2026-09-28 · 6×4Preview: 6 ranked values, largest first. Minute bars per session: nine widely held names, June 2026series · 2026-09-28 · 9×4Preview: a 9-point series, ending lower.
Local A-Share Data Lake for AI Agents
Who left the tape: March 2021 symbols by daily dollar volume, checked against late July 2026ranking · 2026-08-05 · 5×4Preview: 5 ranked values, largest first. Survivorship, measured: March cohorts of US symbols still trading in late July 2026table · 2026-08-05 · 10×5 One week of the US minute tape: symbols and bars per session, Jul 20-24, 2026series · 2026-08-05 · 5×4Preview: a 5-point series, ending lower.
Upcoming market closures that move a settlement date

Upcoming market closures that move a settlement date

most recentas of series 12×6read in context →
Upcoming market closures that move a settlement date — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
holiday_dateholiday_labelweekdayholidayday_statusdays_away
2026-11-26Nov 26ThuThanksgivingclosed53
2026-11-27Nov 27FriThanksgivingearly-close54
2026-12-24Dec 24ThuChristmasearly-close81
2026-12-25Dec 25FriChristmasclosed82
2027-01-01Jan 1FriNew Years Dayclosed89
2027-01-18Jan 18MonMartin Luther King, Jr. Dayclosed106
2027-02-15Feb 15MonWashington's Birthdayclosed134
2027-03-26Mar 26FriGood Fridayclosed173
2027-05-31May 31MonMemorial Dayclosed239
2027-06-18Jun 18FriJuneteenthclosed257
2027-07-05Jul 5MonIndependence Dayclosed274
2027-09-06Sep 6MonLabor Dayclosed337
the exact SQL behind every number 
SELECT
    toString(date)                                                         AS holiday_date,
    concat(formatDateTime(date, '%b'), ' ', toString(toDayOfMonth(date)))   AS holiday_label,
    formatDateTime(date, '%a')                                             AS weekday,
    any(name)                                                              AS holiday,
    any(status)                                                            AS day_status,
    dateDiff('day', today(), date)                                         AS days_away
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
More from this analysisAI Trading Bots and Real Brokerage Orders
AAPL quoted spread and quote traffic by ET clock time, 14 August 2026 series 36×3 → AAPL near-the-money option volume and implied volatility by time to expiry, August 2026 ranking 5×3 → Trade print sizes across five liquid names, 13:00 to 14:00 ET on 14 August 2026 ranking 5×4 → Minutes with a 1% high to low range, January to September 2026 ranking 5×4 → See all 3,256 queries →
$