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

3,293 answered market questions

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

Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-11-07 · 13×3Preview: a 13-point series, ending higher. How far one index ETF travelled inside each recent sessionseries · 2026-11-07 · 31×4Preview: a 16-point series, roughly flat. Upcoming market closures that move a fund order's strike dateseries · 2026-11-07 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-11-07 · 6×4Preview: 6 ranked values, largest first.
Buying Before or After a Stock Split
Forward and reverse splits by year, US listed companiesranking · 2026-11-07 · 10×3Preview: 10 ranked values, smallest first. Recent forward splits at large US companies, by effective sessionranking · 2026-11-07 · 12×4Preview: 12 ranked values, smallest first. Most-used forward split multipliers, last ten yearsranking · 2026-11-07 · 10×3Preview: 10 ranked values, largest first. AAPL across its 2020 four for one split: split-adjusted closes and volumeseries · 2026-11-07 · 10×4Preview: a 10-point series, roughly flat.
Stock Order Types Explained: The Core Four
AAPL average quoted spread by ET clock time, Sep 16 2026series · 2026-10-08 · 64×3Preview: a 16-point series, ending lower. Average quoted spread across six household names, one mid-morning hourranking · 2026-10-08 · 6×3Preview: 6 ranked values, smallest first. How often a buy limit under the prior close was reached (AAPL, one year of sessions)ranking · 2026-10-08 · 6×2Preview: 6 ranked values, largest first. Overnight gap between one close and the next open, year to Sep 2026ranking · 2026-10-08 · 6×4Preview: 6 ranked values, largest first.
Can You Lose More Than You Invest?
The largest US oil tracking fund through April 2020: daily close and session lowseries · 2026-10-05 · 17×3Preview: a 16-point series, ending lower. 2023 run from the first close of the year: year end and peakranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. Deepest overnight gap down per name, 2015 to 2025 (split dates removed)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. One NVDA option contract, mid January to March 1, 2024: the furthest travellerseries · 2026-10-05 · 33×3Preview: a 16-point series, ending higher.
Buy Limit vs Sell Limit Orders Explained
How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. A 1% buy limit vs a 1% sell limit: share of SPY sessions reached, by yearranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. The gap a marketable limit crosses: average quoted spread, five names, Sep 15 2026ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. A real quote in motion: Apple's bid and ask by the minute, Sep 15 2026series · 2026-10-05 · 15×4Preview: a 15-point series, ending higher.
Stop Order vs Limit Order: Trigger or Price
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first. AAPL sessions that opened at least 1.5% below the prior close, 2025series · 2026-10-02 · 16×2Preview: a 16-point series, ending higher. AAPL one minute range and volume by ET clock hour, September 2025ranking · 2026-10-02 · 16×3Preview: 16 ranked values, largest first. Median daily range and sub-open dips across five household names, 2025ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first.
One index ETF's price through a single session, in half-hour ET buckets

One index ETF's price through a single session, in half-hour ET buckets

most recentas of series 13×3read in context →
One index ETF's price through a single session, in half-hour ET buckets — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timeetf_priceasof_label
09:30766.06Nov 4
10:00767.39Nov 4
10:30766.18Nov 4
11:00765.28Nov 4
11:30766.89Nov 4
12:00767.84Nov 4
12:30768.35Nov 4
13:00768.58Nov 4
13:30767.71Nov 4
14:00768.16Nov 4
14:30767.69Nov 4
15:00767.57Nov 4
15:30767.34Nov 4
the exact SQL behind every number
WITH
    (
        SELECT max(toDate(toTimeZone(window_start, 'America/New_York')))
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= today() - 20
          AND window_start <  today() - 2
    ) AS charted_session
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
    round(avg(toFloat64(close)), 2)                                                                             AS etf_price,
    min(formatDateTime(toTimeZone(window_start, 'America/New_York'), '%b %e'))                                  AS asof_label
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND toDate(toTimeZone(window_start, 'America/New_York')) = charted_session
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
GROUP BY et_time
ORDER BY et_time
$