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

Làm việc với dữ liệu này trong trợ lý AI của bạn

Mở ra sẵn sàng truy vấn, với dữ liệu của trang này. Miễn phí, không cần tài khoản.

Claude ChatGPT Gemini Muse Agent của riêng bạn