3,256 answered market questions

SELECT
    toYear(execution_date) AS year,
    countIf(mult > 1)      AS forward_splits,
    countIf(mult < 1)      AS reverse_splits
FROM
(
    SELECT
        execution_date,
        ticker,
        toFloat64(any(split_to)) / toFloat64(any(split_from)) AS mult
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2016-01-01'
      AND execution_date <  toStartOfYear(today())
    GROUP BY execution_date, ticker
)
GROUP BY year
ORDER BY year