Rows returned by two common market-data request shapes

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    d.symbol                            AS symbol,
    d.daily_bars                        AS daily_bars_one_year,
    toUInt32(ifNull(m.minute_bars, 0))  AS minute_bars_one_session
FROM
(
    SELECT
        ticker   AS symbol,
        count()  AS daily_bars
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
      AND date >= '2025-09-15'
      AND date <  '2026-09-16'
    GROUP BY ticker
) AS d
LEFT JOIN
(
    SELECT
        ticker   AS symbol,
        count()  AS minute_bars
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
      AND window_start >= '2026-09-15 04:00:00'
      AND window_start <  '2026-09-16 04:00:00'
    GROUP BY ticker
) AS m ON m.symbol = d.symbol
ORDER BY minute_bars_one_session DESC, symbol