odd lots — 4 answered market questions

Round lot size for a basket of familiar tickers, from the latest close

most recentas of 2026-08-22 ranking 9×3read in context →

Round lot size for a basket of familiar tickers, from the latest close — 9 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
ticker	close_price	round_lot_size
NVR	6305.86	10
COST	935	40
SPY	765.91	40
MSFT	481.8	40
AAPL	312.08	40
NVDA	218.05	100
BKNG	210.15	100
KO	90.51	100
F	14.08	100

the exact SQL behind every number

SELECT
    ticker,
    round(toFloat64(any(close)), 2) AS close_price,
    multiIf(any(close) <= 250,   100,
            any(close) <= 1000,  40,
            any(close) <= 10000, 10,
                                 1)  AS round_lot_size
FROM global_markets.stocks_daily_aggs
WHERE date = (SELECT max(date) FROM global_markets.stocks_daily_aggs WHERE date >= today() - 10)
  AND ticker IN ('F', 'KO', 'NVDA', 'AAPL', 'MSFT', 'SPY', 'COST', 'BKNG', 'NVR')
GROUP BY ticker
ORDER BY close_price DESC

More from this analysisWhy Odd Lots Don't Set the NBBO

AAPL trade sizes on the 27 April 2026 session ranking 4×3 → How many listed names sit in each round lot tier ranking 3×3 → Listed names averaging above $250 a share, by month series 24×2 → Where AAPL trades printed, June 17 2026, 10:00 to 11:30 ET ranking 17×3 → See all 2,170 queries →