x402 — 4 answered market questions

Rows returned by two common market-data request shapes

most recentas of 2026-10-16 series 5×3read in context →

Rows returned by two common market-data request shapes — 5 rows by 3 columns, computed 2026-10-16 from US exchange, SIP and OPRA data.
symbol	daily_bars_one_year	minute_bars_one_session
NVDA	252	941
SPY	252	882
AAPL	252	844
MSFT	252	730
KO	252	487

the exact SQL behind every number

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

More from this analysisPaying per request for market data: x402

Dividend records with an ex-date in each of the last 12 months series 12×4 → SEC filings indexed per month over the trailing year series 12×3 → Quote updates in a single pinned hour, by symbol ranking 5×3 → AAPL median quoted spread by New York clock time, September 15, 2026 series 61×3 → See all 3,293 queries →