Does the PDT Rule Apply to Crypto and Futures?
Regular session, premarket and after-hours share of volumeranking ·
2026-11-07 · 4×4
Share of monthly volume by 15-minute ET clock slice, SPY and AAPLseries ·
2026-11-07 · 64×3
Calendar days spanned by each rolling five-session windowseries ·
2026-11-07 · 79×3
Crypto Covered Call ETFs: Yield Explained
Implied volatility on near the money contracts, last four monthsranking ·
2026-11-07 · 5×3
Monthly near the money implied volatility, two yearsseries ·
2026-11-07 · 24×4
Month end close measured against the two year highseries ·
2026-11-07 · 24×3
Count of big up months over the last three yearstable ·
2026-11-07 · 3×5
One month call premium as a percentage of the underlying priceranking ·
2026-11-07 · 5×3
Limit Orders on Crypto Exchanges vs Stocks
The same stock, quoted venue by venue: AAPL spreads by exchangeranking ·
2026-10-06 · 3×4
AAPL print sizes in one hour, Sep 23 2026ranking ·
2026-10-06 · 5×3
Where AAPL's volume sat by ET hour, September 2026series ·
2026-10-06 · 16×3
Average quoted spread across household names, five minutes on Sep 23 2026ranking ·
2026-10-06 · 5×3
Regular session, premarket and after-hours share of volume
Regular session, premarket and after-hours share of volume
| ticker | regular_session_pct | premarket_pct | after_hours_pct |
|---|---|---|---|
| KO | 94.22 | 1.42 | 4.36 |
| MSFT | 91.64 | 2.59 | 5.77 |
| AAPL | 90.63 | 2.87 | 6.5 |
| SPY | 83.61 | 2.88 | 13.52 |
the exact SQL behind every number
SELECT
ticker,
round(100 * toFloat64(sumIf(volume, et_min >= 570 AND et_min < 960)) / toFloat64(sum(volume)), 2) AS regular_session_pct,
round(100 * toFloat64(sumIf(volume, et_min < 570)) / toFloat64(sum(volume)), 2) AS premarket_pct,
round(100 * toFloat64(sumIf(volume, et_min >= 960)) / toFloat64(sum(volume)), 2) AS after_hours_pct
FROM
(
SELECT
ticker,
volume,
toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York')) AS et_min
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'KO')
AND window_start >= today() - 45
AND window_start < today() - 2
)
GROUP BY ticker
ORDER BY regular_session_pct DESC
More from this analysisDoes the PDT Rule Apply to Crypto and Futures?
Calendar days spanned by each rolling five-session window
series 79×3
→
Share of monthly volume by 15-minute ET clock slice, SPY and AAPL
series 64×3
→
SPY contract volume by days to expiry, September 2026
ranking 4×3
→
Share of August 2026 options volume expiring within five days, by underlying
ranking 6×2
→
See all 3,293 queries →