us_clock_volume
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-23, from krx-after-hours-trading.
| et_time | aapl_share_pct | ko_share_pct |
|---|---|---|
| 04:00 | 0.272 | 0.171 |
| 04:30 | 0.056 | 0.035 |
| 05:00 | 0.053 | 0.03 |
| 05:30 | 0.052 | 0.023 |
| 06:00 | 0.05 | 0.021 |
| 06:30 | 0.099 | 0.019 |
| 07:00 | 0.387 | 0.057 |
| 07:30 | 0.396 | 0.04 |
| 08:00 | 0.375 | 0.072 |
| 08:30 | 0.494 | 0.097 |
| 09:00 | 1.187 | 0.212 |
| 09:30 | 15.569 | 13.778 |
| 10:00 | 9.082 | 8.512 |
| 10:30 | 7.341 | 6.783 |
| 11:00 | 6.803 | 6.463 |
| 11:30 | 5.809 | 5.148 |
| 12:00 | 4.827 | 4.888 |
| 12:30 | 4.484 | 4.389 |
| 13:00 | 4.216 | 3.992 |
| 13:30 | 4.346 | 3.885 |
| 14:00 | 4.99 | 4.474 |
| 14:30 | 5.486 | 5.19 |
| 15:00 | 5.601 | 6.343 |
| 15:30 | 12.884 | 20.048 |
| 16:00 | 3.91 | 4.718 |
| 16:30 | 0.458 | 0.203 |
| 17:00 | 0.466 | 0.082 |
| 17:30 | 0.112 | 0.269 |
| 18:00 | 0.057 | 0.016 |
| 18:30 | 0.043 | 0.014 |
| 19:00 | 0.038 | 0.01 |
| 19:30 | 0.057 | 0.019 |
- Rows × columns
- 32 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
et_time |
text | 32 distinct values (04:00, 04:30, 05:00…) | |
aapl_share_pct |
number | 0.038 to 15.569 | percent |
ko_share_pct |
number | 0.01 to 20.048 | 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 , 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
formatDateTime(toStartOfInterval(b.et_ts, INTERVAL 30 MINUTE), '%H:%i') AS et_time,
round(100 * toFloat64(sumIf(b.volume, b.ticker = 'AAPL')) / toFloat64(any(t.aapl_total)), 3) AS aapl_share_pct,
round(100 * toFloat64(sumIf(b.volume, b.ticker = 'KO')) / toFloat64(any(t.ko_total)), 3) AS ko_share_pct
FROM
(
SELECT
ticker,
toTimeZone(window_start, 'America/New_York') AS et_ts,
volume
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('AAPL', 'KO')
AND window_start >= today() - 45
AND window_start < today() - 2
AND toHour(toTimeZone(window_start, 'America/New_York')) >= 4
AND toHour(toTimeZone(window_start, 'America/New_York')) < 20
) AS b
CROSS JOIN
(
SELECT
sumIf(volume, ticker = 'AAPL') AS aapl_total,
sumIf(volume, ticker = 'KO') AS ko_total
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('AAPL', 'KO')
AND window_start >= today() - 45
AND window_start < today() - 2
AND toHour(toTimeZone(window_start, 'America/New_York')) >= 4
AND toHour(toTimeZone(window_start, 'America/New_York')) < 20
) AS t
GROUP BY et_time
ORDER BY et_time
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.