h5i-db: Point-in-Time Data for Backtests
Stock splits taking effect each quarter, forward and reverseseries ·
2026-08-22 · 16×3
When market headlines publish, by New York clock hourranking ·
2026-08-22 · 24×2
How long 13F holdings filings take to reach the publicseries ·
2026-08-22 · 16×3
Days between a dividend declaration and its ex-date, by monthseries ·
2026-08-22 · 24×3
Self-Hosted A-Share Quant Workbench, Explained
The twelve biggest forward stock splits on US listings, 1 January to 13 August 2026ranking ·
2026-08-13 · 12×3
What crossing the spread costs: average quoted spread, six US listings, midday 17 June 2026ranking ·
2026-08-13 · 6×2
How far the price travels inside one minute: KO, by New York clock time, 17 June 2026series ·
2026-08-13 · 18×2
Local A-Share Data Lake for AI Agents
Who left the tape: March 2021 symbols by daily dollar volume, checked against late July 2026ranking ·
2026-08-05 · 5×4
Survivorship, measured: March cohorts of US symbols still trading in late July 2026table ·
2026-08-05 · 10×5
One week of the US minute tape: symbols and bars per session, Jul 20-24, 2026series ·
2026-08-05 · 5×4
Stock splits taking effect each quarter, forward and reverse
Stock splits taking effect each quarter, forward and reverse
| quarter_start_date | forward_splits | reverse_splits |
|---|---|---|
| 2022-07-01 | 102 | 154 |
| 2022-10-01 | 77 | 216 |
| 2023-01-01 | 76 | 176 |
| 2023-04-01 | 94 | 227 |
| 2023-07-01 | 124 | 215 |
| 2023-10-01 | 68 | 219 |
| 2024-01-01 | 101 | 192 |
| 2024-04-01 | 126 | 216 |
| 2024-07-01 | 113 | 205 |
| 2024-10-01 | 114 | 258 |
| 2025-01-01 | 89 | 253 |
| 2025-04-01 | 110 | 259 |
| 2025-07-01 | 119 | 239 |
| 2025-10-01 | 111 | 287 |
| 2026-01-01 | 102 | 293 |
| 2026-04-01 | 131 | 303 |
the exact SQL behind every number
SELECT
toString(toStartOfQuarter(execution_date)) AS quarter_start_date,
countDistinctIf(id, split_to > split_from) AS forward_splits,
countDistinctIf(id, split_to < split_from) AS reverse_splits
FROM global_markets.stocks_splits
WHERE execution_date >= toStartOfQuarter(today() - 1460)
AND execution_date < toStartOfQuarter(today())
AND split_from > 0
AND split_to > 0
GROUP BY quarter_start_date
ORDER BY quarter_start_date
More from this analysish5i-db: Point-in-Time Data for Backtests
Days between a dividend declaration and its ex-date, by month
series 24×3
→
How long 13F holdings filings take to reach the public
series 16×3
→
When market headlines publish, by New York clock hour
ranking 24×2
→
KO quarterly dividend in cents and as a percent of the share price, 2016 to 2026
series 42×4
→
See all 2,173 queries →