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

2,358 answered market questions

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

where-to-find-options-trade-data
venue_sharetable · 2026-09-18 · 18×5 session_clockseries · 2026-09-18 · 14×5Preview: a 14-point series, ending higher. largest_printstable · 2026-09-18 · 10×7 iv_skewtable · 2026-09-18 · 29×4
what-is-the-cme-cvol-index
spy_term_structureranking · 2026-09-18 · 7×2Preview: 7 ranked values, largest first. spy_strike_weightsranking · 2026-09-18 · 11×4Preview: 11 ranked values, largest first.
what-are-tokenized-stocks
volume_by_segmentranking · 2026-09-18 · 5×3Preview: 5 ranked values, largest first. off_hours_shareranking · 2026-09-18 · 5×3Preview: 5 ranked values, largest first. aapl_dividendsseries · 2026-09-18 · 11×7Preview: a 11-point series, ending lower.
upcoming-ipo-lockup-expirations
prospectus_receiptstable · 2026-09-18 · 50×4 price_vs_offertable · 2026-09-18 · 51×5 lockup_pipelineseries · 2026-09-18 · 13×3Preview: a 13-point series, ending lower. lockup_calendartable · 2026-09-18 · 57×8 early_release_watchtable · 2026-09-18 · 25×6
upcoming-dividend-payment-dates
sector_gaptable · 2026-09-18 · 7×5 pay_daysseries · 2026-09-18 · 12×4Preview: a 12-point series, ending higher. pay_calendartable · 2026-09-18 · 30×8 gap_bucketsranking · 2026-09-18 · 6×4Preview: 6 ranked values, largest first.
the-september-effect
worst_septembersranking · 2026-09-18 · 3×2Preview: 3 ranked values, smallest first. septembers_by_yearranking · 2026-09-18 · 22×2Preview: 16 ranked values, smallest first. monthlytable · 2026-09-18 · 12×6 decadesranking · 2026-09-18 · 3×4Preview: 3 ranked values, largest first.
stock-split-candidates
stubborntable · 2026-09-18 · 12×5 split_historytable · 2026-09-18 · 16×6 candidatestable · 2026-09-18 · 15×8 aapl_traceseries · 2026-09-18 · 84×4Preview: a 16-point series, ending lower. aapl_splitstable · 2026-09-18 · 3×5
nasdaq-opening-cross-explained
open_minute_shareranking · 2026-09-18 · 5×4Preview: 5 ranked values, largest first. open_conditionsranking · 2026-09-18 · 14×3Preview: 14 ranked values, smallest first. aapl_open_minute_traceseries · 2026-09-18 · 21×4Preview: a 16-point series, ending higher.
market-wide-circuit-breakers-explained
trigger_levelstable · 2026-09-18 · 3×7 march_2020_sessionsseries · 2026-09-18 · 22×6Preview: a 16-point series, ending lower. halt_daysseries · 2026-09-18 · 4×8Preview: a 4-point series, ending lower. daily_recalcseries · 2026-09-18 · 15×5Preview: a 15-point series, ending lower.
how-much-money-do-you-need-to-trade-options
spread_ladderranking · 2026-09-18 · 8×3Preview: 8 ranked values, largest first. put_traceseries · 2026-09-18 · 31×5Preview: a 16-point series, ending lower. put_laddertable · 2026-09-18 · 8×5 call_laddertable · 2026-09-18 · 8×5
how-long-can-a-stock-trade-under-1-dollar
sub_dollar_trendseries · 2026-09-18 · 105×3Preview: a 16-point series, ending higher. streaksranking · 2026-09-18 · 4×3Preview: 4 ranked values, largest first. reverse_splits_monthlyseries · 2026-09-18 · 12×3Preview: a 12-point series, roughly flat. price_bucketsranking · 2026-09-18 · 5×4Preview: 5 ranked values, smallest first.
free-stock-data-api-in-python
avg_volume_by_tickerseries · 2026-09-18 · 4×4Preview: a 4-point series, ending lower. aapl_volume_traceseries · 2026-09-18 · 34×3Preview: a 16-point series, ending lower.
are-0dte-options-high-risk
strike_gammaranking · 2026-09-18 · 9×3Preview: 9 ranked values, largest first. premium_laddertable · 2026-09-18 · 5×5 greeks_ladderseries · 2026-09-18 · 5×5Preview: a 5-point series, ending lower. expiry_outcomesranking · 2026-09-18 · 5×2Preview: 5 ranked values, largest first. expiry_dayseries · 2026-09-18 · 21×6Preview: a 16-point series, ending lower.
when-do-vix-options-expire
wednesday_expiriesranking · 2026-09-17 · 12×3Preview: 12 ranked values, largest first.
what-is-the-3m10y-spread
recentseries · 2026-09-17 · 60×6Preview: a 16-point series, ending higher. monthlyseries · 2026-09-17 · 241×4Preview: a 16-point series, ending higher. inversionsseries · 2026-09-17 · 9×6Preview: a 9-point series, roughly flat. front_endseries · 2026-09-17 · 42×5Preview: a 16-point series, ending higher. episodes_comparedtable · 2026-09-17 · 3×9
what-does-cross-mean-in-trading
quote_statesranking · 2026-09-17 · 3×4Preview: 3 ranked values, largest first. cross_minutesseries · 2026-09-17 · 7×4Preview: a 7-point series, roughly flat. cross_codestable · 2026-09-17 · 13×5
Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-09-17 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-09-17 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-09-17 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-09-17 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-09-17 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-17 · 5×3Preview: a 5-point series, roughly flat.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-09-17 · 30×5 Announced upcoming splits by directionranking · 2026-09-17 · 2×2Preview: 2 ranked values, largest first. Announced stock splits by effective month: forward vs reverseseries · 2026-09-17 · 4×4Preview: a 4-point series, ending lower.
Unusual Volume Stocks This Week, Measured
How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-09-17 · 7×4Preview: 7 ranked values, smallest first. Persistence check: the eight leaders' daily relative volume across the five sessionstable · 2026-09-17 · 8×5 Highest relative volume this week: trailing 5 sessions vs. the prior 40, for names trading $500M+ in the weekseries · 2026-09-17 · 8×6Preview: a 8-point series, roughly flat. The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-09-17 · 15×5Preview: a 15-point series, roughly flat. Wild multiples the dollar floor removes: highest relative volume among names trading under $500M this weekseries · 2026-09-17 · 6×5Preview: a 6-point series, ending higher.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-17 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-09-17 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-09-17 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-09-17 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-17 · 10×8
twap-vs-vwap-vs-pov-orders
volume_curveseries · 2026-09-17 · 13×4Preview: a 13-point series, roughly flat. open_vs_lunchtable · 2026-09-17 · 5×6 lunch_povseries · 2026-09-17 · 13×4Preview: a 13-point series, ending higher. curve_dispersionseries · 2026-09-17 · 13×4Preview: a 13-point series, ending higher.
the-7-5-3-1-rule-mutual-funds
worst_windowstable · 2026-09-17 · 8×6 step_uptable · 2026-09-17 · 10×5 rolling_7yseries · 2026-09-17 · 193×5Preview: a 16-point series, ending higher. return_bucketsranking · 2026-09-17 · 5×3Preview: 5 ranked values, smallest first.
the-390-rule-in-options-trading
spy_trade_sizesranking · 2026-09-17 · 5×3Preview: 5 ranked values, largest first. spy_option_paceseries · 2026-09-17 · 14×3Preview: a 14-point series, ending lower. session_shapeseries · 2026-09-17 · 16×3Preview: a 16-point series, roughly flat. one_lot_shareranking · 2026-09-17 · 6×4Preview: 6 ranked values, largest first.
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-17 · 12×4Preview: 12 ranked values, largest first. The screened names ranked by short interest against shares outstanding (not float)table · 2026-09-17 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-09-17 · 6×3Preview: 6 ranked values, smallest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-17 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-09-17 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-17 · 12×4Preview: a 12-point series, ending higher.
santa-claus-rally
worst_windowstable · 2026-09-17 · 5×5 window_vs_decembertable · 2026-09-17 · 3×8 window_volumeranking · 2026-09-17 · 7×4Preview: 7 ranked values, smallest first. santa_windowstable · 2026-09-17 · 23×5 folklore_testtable · 2026-09-17 · 2×6
page 1 of 24
S&P 500 tracker: May to October vs November to April, season by season

S&P 500 tracker: May to October vs November to April, season by season

as of ranking 21×3read in context →
S&P 500 tracker: May to October vs November to April, season by season — 21 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearmay_oct_pctnov_apr_pct
20054.328.65
20065.067.58
20074.43-10.56
2008-29.81-10.03
200918.5414.66
2010-0.2915.19
2011-8.1311.53
20121.0213.06
201310.037.21
20147.043.37
2015-0.29-0.73
2016312.04
20177.982.85
20182.368.6
20193.16-4.24
202012.4527.8
202110.05-10.27
2022-6.277.7
20230.5520.04
202413.25-2.5
202523.035.34
the exact SQL behind every number 
WITH monthly AS (
    SELECT toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York'))) AS month_start,
           argMax(close, window_start) AS month_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2005-04-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-04-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY month_start
)
SELECT toYear(apr_m.month_start) AS year,
       round(100 * (toFloat64(oct_m.month_close) / toFloat64(apr_m.month_close) - 1), 2) AS may_oct_pct,
       round(100 * (toFloat64(apr_next.month_close) / toFloat64(oct_m.month_close) - 1), 2) AS nov_apr_pct
FROM monthly AS apr_m
INNER JOIN monthly AS oct_m ON oct_m.month_start = addMonths(apr_m.month_start, 6)
INNER JOIN monthly AS apr_next ON apr_next.month_start = addMonths(apr_m.month_start, 12)
WHERE toMonth(apr_m.month_start) = 4
ORDER BY year
More from this analysisDoes Sell in May and Go Away Work?
Growth of one dollar: holding all year vs holding only November through April ranking 21×3 → SPY distributions by ex-dividend month: inside the May to October window vs outside it ranking 19×3 → Average S&P 500 tracker return by calendar month, May 2005 through April 2026 table 12×5 → The seasonal gap by era: average half-year returns and the spread between them table 3×6 → See all 2,358 queries →
$