longest_chains

Name: longest_chains
Creator: Strasmore
Published: 2026-09-27
License: https://www.strasmore.com/terms/

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-09-27, from which-stocks-have-leaps.

as of 2026-09-27 table 11×5read in context →

longest_chains — 11 rows by 5 columns, computed 2026-09-27 from US exchange, SIP and OPRA data.
symbol	tier	longest_expiry	dte_max	leaps_expiries
AAPL	vốn hóa lớn	19/01/2029	848	6
AMZN	vốn hóa lớn	19/01/2029	848	5
CHWY	vốn hóa vừa	19/01/2029	848	2
DKNG	vốn hóa vừa	19/01/2029	848	3
ETSY	vốn hóa vừa	19/01/2029	848	4
KO	vốn hóa lớn	19/01/2029	848	4
LYFT	vốn hóa vừa	19/01/2029	848	5
MSFT	vốn hóa lớn	19/01/2029	848	5
NVDA	vốn hóa lớn	19/01/2029	848	5
SPY	ETF chỉ số	19/01/2029	848	5
CROX	vốn hóa vừa	21/01/2028	484	1

Rows × columns: 11 × 5
Computed: 2026-09-27
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 longest_chains, derived from the stored result.
Column	Type	Range
`symbol`	text	11 distinct values (AAPL, AMZN, CHWY…)
`tier`	text	3 distinct values (ETF chỉ số, vốn hóa lớn, vốn hóa vừa)
`longest_expiry`	text	2 distinct values (19/01/2029, 21/01/2028)
`dte_max`	number	484 to 848
`leaps_expiries`	number	1 to 6

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 2026-09-27, 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.

WITH (SELECT max(date) FROM global_markets.options_greeks) AS asof
SELECT
    symbol,
    tier,
    longest_expiry,
    dte_max,
    leaps_expiries
FROM
(
    SELECT
        underlying_symbol                                AS symbol,
        any(multiIf(underlying_symbol = 'SPY', 'ETF chỉ số',
                    underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO'), 'vốn hóa lớn',
                    'vốn hóa vừa'))                      AS tier,
        formatDateTime(max(expiration_date), '%d/%m/%Y') AS longest_expiry,
        max(dateDiff('day', date, expiration_date))      AS dte_max,
        countDistinctIf(expiration_date,
                        dateDiff('day', date, expiration_date) > 365) AS leaps_expiries
    FROM global_markets.options_greeks
    WHERE date = asof
      AND underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO', 'SPY',
                                'ETSY', 'CROX', 'CHWY', 'LYFT', 'DKNG')
    GROUP BY underlying_symbol
)
ORDER BY dte_max DESC, symbol

SQL to run

WITH (SELECT max(date) FROM global_markets.options_greeks) AS asof
SELECT
    symbol,
    tier,
    longest_expiry,
    dte_max,
    leaps_expiries
FROM
(
    SELECT
        underlying_symbol                                AS symbol,
        any(multiIf(underlying_symbol = 'SPY', 'ETF chỉ số',
                    underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO'), 'vốn hóa lớn',
                    'vốn hóa vừa'))                      AS tier,
        formatDateTime(max(expiration_date), '%d/%m/%Y') AS longest_expiry,
        max(dateDiff('day', date, expiration_date))      AS dte_max,
        countDistinctIf(expiration_date,
                        dateDiff('day', date, expiration_date) > 365) AS leaps_expiries
    FROM global_markets.options_greeks
    WHERE date = asof
      AND underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'KO', 'SPY',
                                'ETSY', 'CROX', 'CHWY', 'LYFT', 'DKNG')
    GROUP BY underlying_symbol
)
ORDER BY dte_max DESC, symbol

⌘/Ctrl + Enter

Work with this data in your AI assistant

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

Claude ChatGPT Gemini Muse Your own agent