sub_dollar_trend

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-18, from how-long-can-a-stock-trade-under-1-dollar.

Rows × columns

105 × 3

Period covered

2026-04-21 to 2026-09-18

Computed

2026-09-18

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

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-18, and the query below is what returned them.

SELECT
    toString(date)                                                     AS session_date,
    uniqExactIf(ticker, close < 1)                                     AS names_under_1,
    round(100 * uniqExactIf(ticker, close < 1) / uniqExact(ticker), 2) AS share_of_listed_pct
FROM global_markets.stocks_daily_aggs
WHERE date >= today() - 150
  AND date <= (SELECT max(date) FROM global_markets.stocks_daily_aggs
               WHERE ticker = 'SPY' AND date >= today() - 14)
  AND ifNull(otc, 0) = 0
  AND length(ticker) <= 4
  AND ticker NOT IN ('SPCX')
  AND volume > 0
  AND close > 0
GROUP BY date
ORDER BY date