Forward stock splits at liquid US names, past three years

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
    s.ticker                                                    AS ticker,
    formatDateTime(s.execution_date, '%b %e, %Y')               AS effective_on,
    round(toFloat64(s.to_factor) / toFloat64(s.from_factor), 2) AS shares_multiplier
FROM
(
    SELECT
        ticker,
        execution_date,
        any(split_from) AS from_factor,
        any(split_to)   AS to_factor
    FROM global_markets.stocks_splits
    WHERE execution_date >= today() - 1095
      AND execution_date <= today()
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
    HAVING to_factor >= 2 * from_factor
) AS s
INNER JOIN
(
    SELECT
        ticker,
        avg(volume) AS adv,
        avg(close)  AS avg_close
    FROM global_markets.stocks_daily_aggs
    WHERE date >= today() - 1125
    GROUP BY ticker
    HAVING adv > 1000000 AND avg_close > 5
) AS liq ON liq.ticker = s.ticker
ORDER BY s.execution_date DESC
LIMIT 12