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
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 →