STRASMORE/EXPLORE 3,293 QUERIES

How long retired listings had traded before their last session

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-11-07, from What Happens When an ETF Closes.

as of ranking 5×3read in context →
How long retired listings had traded before their last session — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
age_bucketlistings_retiredshare_pct
under 1 year42511.1
1 to 2 years48312.6
2 to 5 years162542.3
5 to 10 years51413.4
10 years or more79220.6
Rows × columns
5 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for How long retired listings had traded before their last session, derived from the stored result.
ColumnTypeRangeNotes
age_bucket text 5 distinct values
listings_retired number 425 to 1,625
share_pct number 11.1 to 42.3 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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
    bucket                                         AS age_bucket,
    count()                                        AS listings_retired,
    round(100 * count() / sum(count()) OVER (), 1) AS share_pct
FROM
(
    SELECT
        ticker,
        dateDiff('day', min(date), max(date)) / 365.25 AS years_listed,
        multiIf(
            dateDiff('day', min(date), max(date)) / 365.25 < 1,  'under 1 year',
            dateDiff('day', min(date), max(date)) / 365.25 < 2,  '1 to 2 years',
            dateDiff('day', min(date), max(date)) / 365.25 < 5,  '2 to 5 years',
            dateDiff('day', min(date), max(date)) / 365.25 < 10, '5 to 10 years',
                                                                 '10 years or more') AS bucket
    FROM global_markets.stocks_daily_aggs
    WHERE date >= '2003-01-01'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    HAVING max(date) >= today() - 1130
       AND max(date) <  today() - 150
)
GROUP BY bucket
ORDER BY min(years_listed)
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisWhat Happens When an ETF Closes
Listings that printed their final daily bar, by year ranking 11×2 → How the tape behaved into the final session ranking 5×3 → Final trading days by month, rolling three years series 32×3 → GLD overnight gaps against intraday moves, by year ranking 10×4 → GLD sponsor fee on a stake matching one MGC, by years held ranking 10×3 → How far seven ETFs travel in a regular session, first half of 2026 ranking 7×3 → See all 3,293 queries →