2,170 answered market questions

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