Odd lots, round lots and sub-one-share prints across six names, July 8 to 10, 2026

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-08-12, from How Fractional Shares Hit the Tape.

Rows × columns

6 × 4

Computed

2026-08-12

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

SELECT
    ticker,
    round(100 * countIf(toFloat64(size) >= 1 AND toFloat64(size) < 100) / count(), 1) AS odd_lot_pct,
    round(100 * countIf(toFloat64(size) >= 100) / count(), 1)                         AS round_lot_pct,
    countIf(toFloat64(size) < 1)                                                      AS sub_one_share_prints
FROM global_markets.stocks_trades
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'PG', 'SPY')
  AND sip_timestamp >= '2026-07-08 00:00:00'
  AND sip_timestamp <  '2026-07-11 00:00:00'
GROUP BY ticker
ORDER BY odd_lot_pct DESC