leaps_universe
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.
| horizon | snapshot_label | underlyings |
|---|---|---|
| trên 365 ngày | 24/09/2026 | 1558 |
| trên 456 ngày | 24/09/2026 | 1449 |
| trên 548 ngày | 24/09/2026 | 1010 |
| trên 730 ngày | 24/09/2026 | 1008 |
- Rows × columns
- 4 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
horizon |
text | 4 distinct values | |
snapshot_label |
text | 1 distinct value (24/09/2026) | |
underlyings |
number | 1,008 to 1,558 |
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.
WITH (SELECT max(date) FROM global_markets.options_greeks) AS asof
SELECT
concat('trên ', toString(threshold), ' ngày') AS horizon,
formatDateTime(asof, '%d/%m/%Y') AS snapshot_label,
countDistinct(underlying_symbol) AS underlyings
FROM
(
SELECT
underlying_symbol,
max(dateDiff('day', date, expiration_date)) AS max_dte
FROM global_markets.options_greeks
WHERE date = asof
AND underlying_symbol NOT IN ('SPCX')
GROUP BY underlying_symbol
) AS per_name
ARRAY JOIN [365, 456, 548, 730] AS threshold
WHERE max_dte > threshold
GROUP BY threshold, snapshot_label
ORDER BY threshold
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.