Final trading days by month, rolling 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
    toStartOfMonth(last_session)                          AS month,
    formatDateTime(toStartOfMonth(last_session), '%b %Y') AS month_label,
    count()                                               AS listings_retired
FROM
(
    SELECT
        ticker,
        max(date) AS last_session
    FROM global_markets.stocks_daily_aggs
    WHERE date >= '2015-01-01'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
)
WHERE last_session >= toStartOfMonth(today() - 1130)
  AND last_session <  toStartOfMonth(today() - 150)
GROUP BY month, month_label
ORDER BY month