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

as of 2026-09-28 ranking 24×3read in context →

Stock headlines by ET hour of publication (last 30 days, all days) — 24 rows by 3 columns, computed 2026-09-28 from US exchange, SIP and OPRA data.
et_hour	articles	pct_of_items
0	63	1.1
1	60	1
2	87	1.5
3	83	1.4
4	154	2.6
5	166	2.8
6	334	5.7
7	200	3.4
8	426	7.3
9	545	9.3
10	322	5.5
11	938	16
12	425	7.2
13	232	4
14	217	3.7
15	172	2.9
16	236	4
17	439	7.5
18	294	5
19	126	2.1
20	140	2.4
21	78	1.3
22	97	1.7
23	31	0.5

Rows × columns: 24 × 3
Computed: 2026-09-28
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	31 to 938
`pct_of_items`	number	0.5 to 16	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-09-28, 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.

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

SQL to run

⌘/Ctrl + Enter

AI 어시스턴트에서 이 데이터로 작업하기

이 페이지의 데이터로 바로 쿼리할 수 있게 열립니다. 무료, 계정 불필요.

Claude ChatGPT Gemini Muse 나만의 에이전트

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 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 → See all 2,948 queries →

et_hour	articles	pct_of_items
0	63	1.1
1	60	1
2	87	1.5
3	83	1.4
4	154	2.6
5	166	2.8
6	334	5.7
7	200	3.4
8	426	7.3
9	545	9.3
10	322	5.5
11	938	16
12	425	7.2
13	232	4
14	217	3.7
15	172	2.9
16	236	4
17	439	7.5
18	294	5
19	126	2.1
20	140	2.4
21	78	1.3
22	97	1.7
23	31	0.5

et_hour	articles	pct_of_items
0	63	1.1
1	60	1
2	87	1.5
3	83	1.4
4	154	2.6
5	166	2.8
6	334	5.7
7	200	3.4
8	426	7.3
9	545	9.3
10	322	5.5
11	938	16
12	425	7.2
13	232	4
14	217	3.7
15	172	2.9
16	236	4
17	439	7.5
18	294	5
19	126	2.1
20	140	2.4
21	78	1.3
22	97	1.7
23	31	0.5

et_hour	articles	pct_of_items
0	63	1.1
1	60	1
2	87	1.5
3	83	1.4
4	154	2.6
5	166	2.8
6	334	5.7
7	200	3.4
8	426	7.3
9	545	9.3
10	322	5.5
11	938	16
12	425	7.2
13	232	4
14	217	3.7
15	172	2.9
16	236	4
17	439	7.5
18	294	5
19	126	2.1
20	140	2.4
21	78	1.3
22	97	1.7
23	31	0.5