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
US Stock Market Hours in Singapore Time
Twelve months of dividends per share, gross and after 30% US withholdingranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Upcoming US closures, with the early-close finish in Singapore timeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. SPY volume by Singapore half hour: US winter month vs US summer monthseries · 2026-10-04 · 34×3Preview: a 16-point series, ending higher. Every US clock change since 2022, detected from the opening printseries · 2026-10-04 · 9×5Preview: a 9-point series, roughly flat.
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.
US Market Hours and Daylight Saving Time
London and Frankfurt distance from New York, session by session, March to April 2026series · 2026-08-04 · 29×6Preview: a 16-point series, ending lower. The New York open on two clocks: month-end sessions, August 2024 to July 2026series · 2026-08-04 · 24×6Preview: a 16-point series, ending higher. The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026table · 2026-08-04 · 8×5 London and Tokyo distance from New York, session by session, October to November 2025series · 2026-08-04 · 25×6Preview: a 16-point series, roughly flat.
US Stock Market Hours Around the World
The US trading day converted into ten local clocks: static illustrative reference, July 2026table · 2026-07-31 · 10×6 Local time of the 9:30 a.m. New York open, January against July: static illustrative reference for 2026ranking · 2026-07-31 · 6×4Preview: 6 ranked values, smallest first.
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 →
$