STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

Can an AI Trading Track Record Be Verified?
Median quoted spread and the cost of a $25,000 round trip: midday hour, July 15, 2026ranking · 2026-08-03 · 6×3Preview: 6 ranked values, largest first. SPY holding-period outcomes since 2015: 5th percentile, median, 95th percentiletable · 2026-08-03 · 4×7 How far SPY travels from its opening print, by ET half hour, first half of 2026series · 2026-08-03 · 13×3Preview: a 13-point series, ending higher. Six US index funds, identical window: price return, January 2 to June 30, 2026ranking · 2026-08-03 · 6×3Preview: 6 ranked values, largest first.
AI Daily Market Research Reports: What Breaks
SPY: average overnight repricing vs average regular-session move, monthlyseries · 2026-08-01 · 24×3Preview: a 16-point series, roughly flat. What the next session did: 36 large caps bucketed by the prior day's move, Aug 2024 to Jul 2026table · 2026-08-01 · 5×5 When headlines actually land: article counts by ET clock hour, July 2026ranking · 2026-08-01 · 24×4Preview: 16 ranked values, smallest first. Headline coverage by size of daily move: 36 large caps, May to July 2026ranking · 2026-08-01 · 5×4Preview: 5 ranked values, smallest first. Daily turnover in the top ten movers: fixed 36 name large-cap list, July 2026series · 2026-08-01 · 21×3Preview: a 16-point series, ending lower.
Multi-Agent AI Trading Systems: What Is Real
The window decides the answer: SPY calendar-year price return and intra-year high-to-low range, 2016-2025ranking · 2026-07-31 · 10×4Preview: 10 ranked values, smallest first. Where the money trades: US dollar volume by liquidity rank tier, regular hours, June 30 2026ranking · 2026-07-31 · 5×4Preview: 5 ranked values, smallest first. How big a typical session is: SPY close-to-close moves by size band, calendar 2025ranking · 2026-07-31 · 5×3Preview: 5 ranked values, largest first. The cost floor: median quoted spread in basis points of the midpoint, regular hours, June 22-26 2026ranking · 2026-07-31 · 6×4Preview: 6 ranked values, smallest first.
Median quoted spread and the cost of a $25,000 round trip: midday hour, July 15, 2026

Median quoted spread and the cost of a $25,000 round trip: midday hour, July 15, 2026

most recentas of ranking 6×3read in context →
Median quoted spread and the cost of a $25,000 round trip: midday hour, July 15, 2026 — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickermedian_spread_bpsround_trip_cost_per_25k_usd
MSTR10.0825.2
MSFT2.015.03
NVDA1.433.59
AAPL1.243.09
KO1.213.01
SPY0.270.66
the exact SQL behind every number 
SELECT ticker,
       round(quantileDeterministic(0.5)(20000 * (toFloat64(ask_price) - toFloat64(bid_price))
                                        / (toFloat64(ask_price) + toFloat64(bid_price)),
                                        cityHash64(sip_timestamp)), 2) AS median_spread_bps,
       round(25000 * quantileDeterministic(0.5)(2 * (toFloat64(ask_price) - toFloat64(bid_price))
                                                / (toFloat64(ask_price) + toFloat64(bid_price)),
                                                cityHash64(sip_timestamp)), 2) AS round_trip_cost_per_25k_usd
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'NVDA', 'KO', 'MSTR')
  AND sip_timestamp >= toDateTime('2026-07-15 15:00:00')
  AND sip_timestamp < toDateTime('2026-07-15 16:00:00')
  AND bid_price > 1
  AND ask_price > bid_price
GROUP BY ticker
ORDER BY median_spread_bps DESC
More from this analysisCan an AI Trading Track Record Be Verified?
Six US index funds, identical window: price return, January 2 to June 30, 2026 ranking 6×3 → How far SPY travels from its opening print, by ET half hour, first half of 2026 series 13×3 → SPY holding-period outcomes since 2015: 5th percentile, median, 95th percentile table 4×7 → When market headlines publish, by New York clock hour ranking 24×2 → See all 2,170 queries →
$