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

US Premarket and After-Hours in Israel Time
AAPL quoted spread and top-of-book size by hour, 16 September 2026ranking · 2026-10-05 · 16×4Preview: 16 ranked values, largest first. Upcoming windows where Israel is not seven hours ahead of New Yorkseries · 2026-10-05 · 3×7Preview: a 3-point series, roughly flat. This week's US sessions mapped onto Israeli weekdays and clock timestable · 2026-10-05 · 5×5 US session boundaries in New York, UTC and Israel timeseries · 2026-10-05 · 4×7Preview: a 4-point series, roughly flat. UTC offsets and the Israel to New York gap, one Wednesday per week aheadseries · 2026-10-05 · 57×5Preview: a 16-point series, roughly flat.
US Stock Market Hours in UAE Time (GST)
Upcoming US market closures, with early-close times in GSTseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Share of September 2026 volume by US session windowranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. SPY volume by clock hour, New York and Dubai (1 to 25 September 2026)ranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first. The US trading day on a UAE clock, across a US time changetable · 2026-10-04 · 10×7
Ex-Dividend Date: Open Orders and Premarket
KO premarket on its latest ex-dividend morning, both references side by sideseries · 2026-10-04 · 11×4Preview: a 11-point series, ending lower. KO's ex-date opening print, measured against both referencesseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. KO: every quarterly ex-dividend adjustment over the trailing three yearsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. Upcoming ex-dividend dates and the size of the open-order reductionranking · 2026-10-04 · 2×4Preview: 2 ranked values, largest first.
Premarket and After-Hours Trading Hours (ET)
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-10-04 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-10-04 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-10-04 · 24×3Preview: 16 ranked values, smallest first. AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-10-04 · 2×3Preview: a 2-point series, ending lower. AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-10-04 · 32×3Preview: a 16-point series, ending lower.
AMZN Premarket and After-Hours Prices
The eight widest overnight gaps on AMZN, Oct 2023 through Sep 2025ranking · 2026-10-02 · 8×3Preview: 8 ranked values, smallest first. AMZN quoted spread and inside size by ET hour, after the close into the next openranking · 2026-10-02 · 11×3Preview: 11 ranked values, largest first. AMZN share volume by ET clock hour (September 2025 sessions)ranking · 2026-10-02 · 16×3Preview: 16 ranked values, largest first. AMZN from the Jul 31, 2025 close through the next morning's first half hourranking · 2026-10-02 · 20×3Preview: 16 ranked values, largest first.
US Premarket and After-Hours in UK Time
SPY volume by New York hour, with the London clock beside itseries · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat. AAPL median quoted spread by hour across one full extended dayseries · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat. The London clock time of the 9:30am ET open, late October 2025series · 2026-10-01 · 16×4Preview: a 16-point series, roughly flat.
AAPL quoted spread and top-of-book size by hour, 16 September 2026

AAPL quoted spread and top-of-book size by hour, 16 September 2026

most recentas of ranking 16×4read in context →
AAPL quoted spread and top-of-book size by hour, 16 September 2026 — 16 rows by 4 columns, computed from US exchange, SIP and OPRA data.
new_york_hourisrael_houravg_spread_bpsavg_top_of_book_size
04:0011:009.01259
05:0012:008.81218
06:0013:007.6190
07:0014:006.4270
08:0015:004.21238
09:0016:002.22247
10:0017:001.36228
11:0018:001.13233
12:0019:000.93269
13:0020:000.79388
14:0021:001.32263
15:0022:001.11296
16:0023:004.48458
17:0000:003.38182
18:0001:008.15610
19:0002:006.69157
the exact SQL behind every number 
SELECT
    formatDateTime(toStartOfHour(toTimeZone(sip_timestamp, 'America/New_York')), '%H:%i') AS new_york_hour,
    formatDateTime(toStartOfHour(toTimeZone(sip_timestamp, 'Asia/Jerusalem')), '%H:%i')   AS israel_hour,
    round(avg(20000 * toFloat64(ask_price - bid_price) / toFloat64(ask_price + bid_price)), 2) AS avg_spread_bps,
    round(avg(toFloat64(bid_size + ask_size)), 0)                                         AS avg_top_of_book_size
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-09-16 08:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-09-17 00:00:00', 'UTC')
  AND bid_price > 0
  AND ask_price > bid_price
GROUP BY new_york_hour, israel_hour
ORDER BY new_york_hour
More from this analysisUS Premarket and After-Hours in Israel Time
UTC offsets and the Israel to New York gap, one Wednesday per week ahead series 57×5 → This week's US sessions mapped onto Israeli weekdays and clock times table 5×5 → US session boundaries in New York, UTC and Israel time series 4×7 → Upcoming windows where Israel is not seven hours ahead of New York series 3×7 → See all 3,256 queries →
$