3,171 answered market questions

WITH splits AS
(
    SELECT
        ticker,
        execution_date,
        any(split_from) AS from_shares,
        any(split_to)   AS to_shares
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2024-06-01'
      AND execution_date <= '2026-06-30'
      AND split_to > split_from
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
)
SELECT
    concat(s.ticker, ' ', formatDateTime(s.execution_date, '%b %e, %Y')) AS split_label,
    round(s.to_shares / s.from_shares, 2)                                AS declared_ratio,
    round(
        argMaxIf(toFloat64(d.close), d.date, d.date <  s.execution_date)
      / argMinIf(toFloat64(d.close), d.date, d.date >= s.execution_date), 2
    )                                                                    AS close_ratio
FROM global_markets.stocks_daily_aggs AS d
INNER JOIN splits AS s ON s.ticker = d.ticker
WHERE d.date >= '2024-05-20'
  AND d.date <= '2026-07-10'
  AND d.date >= s.execution_date - 7
  AND d.date <= s.execution_date + 7
GROUP BY s.ticker, s.execution_date, s.from_shares, s.to_shares
HAVING countIf(d.date <  s.execution_date) > 1
   AND countIf(d.date >= s.execution_date) > 1
   AND max(d.volume) > 2000000
ORDER BY s.execution_date DESC
LIMIT 10