STRASMORE/EXPLORE 3,293 QUERIES

JPM before the open: the heaviest premarket morning of Q3 2026, on both clocks

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-16, from US Earnings Release Times in Beijing Time.

as of ranking 12×4read in context →
JPM before the open: the heaviest premarket morning of Q3 2026, on both clocks — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
beijing_clocket_clockus_morningshares_thousands
18:0006:00Jul 142.7
18:1506:15Jul 141.1
18:3006:30Jul 1451.3
18:4506:45Jul 1443.1
19:0007:00Jul 1447.8
19:1507:15Jul 1434.2
19:3007:30Jul 1426.2
19:4507:45Jul 1424.3
20:0008:00Jul 1420.5
20:1508:15Jul 1427
20:3008:30Jul 1454.5
20:4508:45Jul 1413.1
Rows × columns
12 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for JPM before the open: the heaviest premarket morning of Q3 2026, on both clocks, derived from the stored result.
ColumnTypeRangeNotes
beijing_clock text 12 distinct values (18:00, 18:15, 18:30…)
et_clock text 12 distinct values (06:00, 06:15, 06:30…)
us_morning text 1 distinct value (Jul 14)
shares_thousands number 1.1 to 54.5 count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH busiest_morning AS
(
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'JPM'
      AND window_start >= '2026-07-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
      AND toHour(toTimeZone(window_start, 'America/New_York')) BETWEEN 6 AND 8
    GROUP BY d
    ORDER BY sum(volume) DESC
    LIMIT 1
)
SELECT
    formatDateTime(toStartOfFifteenMinutes(toTimeZone(window_start, 'Asia/Shanghai')), '%H:%i')    AS beijing_clock,
    formatDateTime(toStartOfFifteenMinutes(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS et_clock,
    formatDateTime(toTimeZone(window_start, 'America/New_York'), '%b %e')                          AS us_morning,
    round(toFloat64(sum(volume)) / 1e3, 1)                                                         AS shares_thousands
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'JPM'
  AND window_start >= '2026-07-01 00:00:00'
  AND window_start <  '2026-10-01 00:00:00'
  AND toDate(toTimeZone(window_start, 'America/New_York')) = (SELECT d FROM busiest_morning)
  AND toHour(toTimeZone(window_start, 'America/New_York')) BETWEEN 6 AND 8
GROUP BY beijing_clock, et_clock, us_morning
ORDER BY et_clock
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisUS Earnings Release Times in Beijing Time
Earnings headlines by the hour on a Beijing clock, Q3 2026 ranking 24×4 → AAPL after the close: the heaviest post-close evening of Q3 2026, on both clocks table 16×5 → Earnings headlines by US weekday, and the Beijing day a post-close print arrives on series 5×4 → SPY volume by New York hour, with the London clock beside it series 16×4 → AAPL median quoted spread by hour across one full extended day series 16×4 → The London clock time of the 9:30am ET open, late October 2025 series 16×4 → See all 3,293 queries →