Stock headlines by ET hour of publication (last 30 days, all days)

Name: Stock headlines by ET hour of publication (last 30 days, all days)
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

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-08-22, from Premarket and After-Hours Trading Hours (ET).

as of 2026-08-22 ranking 24×3read in context →

Stock headlines by ET hour of publication (last 30 days, all days) — 24 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
et_hour	articles	pct_of_items
0	39	1.2
1	61	1.9
2	70	2.2
3	71	2.2
4	114	3.6
5	158	4.9
6	194	6
7	176	5.5
8	157	4.9
9	155	4.8
10	208	6.5
11	176	5.5
12	174	5.4
13	200	6.2
14	165	5.1
15	170	5.3
16	185	5.8
17	154	4.8
18	132	4.1
19	135	4.2
20	98	3.1
21	83	2.6
22	73	2.3
23	59	1.8

Rows × columns: 24 × 3
Computed: 2026-08-22
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 Stock headlines by ET hour of publication (last 30 days, all days), derived from the stored result.
Column	Type	Range	Notes
`et_hour`	number	0 to 23
`articles`	number	39 to 208
`pct_of_items`	number	1.2 to 6.5	percent

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 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT toHour(toTimeZone(published_utc, 'America/New_York')) AS et_hour,
       count() AS articles,
       round(100 * count() / sum(count()) OVER (), 1) AS pct_of_items
FROM global_markets.stocks_news
WHERE published_utc >= now() - INTERVAL 30 DAY
  AND toDate(toTimeZone(published_utc, 'America/New_York')) < toDate(toTimeZone(now(), 'America/New_York'))
GROUP BY et_hour
ORDER BY et_hour

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisPremarket and After-Hours Trading Hours (ET)

AAPL median shares per traded minute, and the share of minutes that traded at all (ET) series 32×3 → Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only) table 3×5 → AAPL median quoted spread: regular session vs extended hours (past week, full sessions) series 2×3 → The session envelope, read from SPY minute bars (last two weeks, ET) scalar 1×7 → SPY volume by half hour on the early-close session, premarket through the shortened after-hours (ET clock) ranking 21×2 → Local time of the 9:30 a.m. New York open, January against July: static illustrative reference for 2026 ranking 6×4 → See all 2,170 queries →

et_hour	articles	pct_of_items
0	39	1.2
1	61	1.9
2	70	2.2
3	71	2.2
4	114	3.6
5	158	4.9
6	194	6
7	176	5.5
8	157	4.9
9	155	4.8
10	208	6.5
11	176	5.5
12	174	5.4
13	200	6.2
14	165	5.1
15	170	5.3
16	185	5.8
17	154	4.8
18	132	4.1
19	135	4.2
20	98	3.1
21	83	2.6
22	73	2.3
23	59	1.8

et_hour	articles	pct_of_items
0	39	1.2
1	61	1.9
2	70	2.2
3	71	2.2
4	114	3.6
5	158	4.9
6	194	6
7	176	5.5
8	157	4.9
9	155	4.8
10	208	6.5
11	176	5.5
12	174	5.4
13	200	6.2
14	165	5.1
15	170	5.3
16	185	5.8
17	154	4.8
18	132	4.1
19	135	4.2
20	98	3.1
21	83	2.6
22	73	2.3
23	59	1.8

et_hour	articles	pct_of_items
0	39	1.2
1	61	1.9
2	70	2.2
3	71	2.2
4	114	3.6
5	158	4.9
6	194	6
7	176	5.5
8	157	4.9
9	155	4.8
10	208	6.5
11	176	5.5
12	174	5.4
13	200	6.2
14	165	5.1
15	170	5.3
16	185	5.8
17	154	4.8
18	132	4.1
19	135	4.2
20	98	3.1
21	83	2.6
22	73	2.3
23	59	1.8