2,173 answered market questions

SELECT
    ticker AS symbol,
    concat('$', toString(round(min(lot_price), 2)),
           ' to $', toString(round(max(lot_price), 2)))  AS lot_price_band,
    round(100 * (max(lot_price) / min(lot_price) - 1), 1) AS spread_pct
FROM
(
    SELECT
        ticker,
        toStartOfMonth(date)           AS month,
        toFloat64(argMin(close, date)) AS lot_price
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'SPY', 'KO', 'JNJ')
      AND date >= '2024-01-01'
      AND date <  '2025-01-01'
    GROUP BY ticker, month
)
GROUP BY ticker
ORDER BY spread_pct DESC