capped_months
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-25, from crypto-covered-call-etfs.
| symbol | months_up_over_5 | months_up_over_10 | months_up_over_20 | months_measured |
|---|---|---|---|---|
| MSTR | 17 | 15 | 10 | 36 |
| COIN | 16 | 12 | 8 | 36 |
| SPY | 5 | 0 | 0 | 36 |
- Rows × columns
- 3 × 5
- 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 |
|---|---|---|---|
symbol |
text | 3 distinct values (COIN, MSTR, SPY) | |
months_up_over_5 |
number | 5 to 17 | |
months_up_over_10 |
number | 0 to 15 | |
months_up_over_20 |
number | 0 to 10 | |
months_measured |
number | every row is 36 |
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 monthly AS
(
SELECT
ticker,
toStartOfMonth(date) AS m,
argMin(toFloat64(close), date) AS first_close,
argMax(toFloat64(close), date) AS last_close
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('MSTR', 'COIN', 'SPY')
AND date >= toStartOfMonth(today() - 1095)
AND date < toStartOfMonth(today())
GROUP BY ticker, m
)
SELECT
ticker AS symbol,
countIf(last_close / first_close - 1 > 0.05) AS months_up_over_5,
countIf(last_close / first_close - 1 > 0.10) AS months_up_over_10,
countIf(last_close / first_close - 1 > 0.20) AS months_up_over_20,
count() AS months_measured
FROM monthly
GROUP BY symbol
ORDER BY months_up_over_20 DESC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.