One SQL endpoint over every US equity and option: equities, options, fundamentals, filings and macro in one schema, joinable in a single query. Nothing to download and no warehouse to build. Run a query right now with no key and no signup.
Free tier, no credit card. 15-minute delayed stocks, T+1 options. Nothing to download.
Pick a question, we answer it live:
› Compare SPY and QQQ performance (normalized % return) over the last 45 days.
Showing the first 20 of 32 rows.
| day | SPY | QQQ | SPY_return | QQQ_return |
|---|---|---|---|---|
| 2026-07-23 | 738.79 | 693.54 | 0 | 0 |
| 2026-07-24 | 738.66 | 683.9 | -0.02 | -1.39 |
| 2026-07-27 | 738.87 | 681.24 | 0.01 | -1.78 |
| 2026-07-28 | 743.57 | 679.88 | 0.64 | -1.97 |
| 2026-07-29 | 732.4 | 666.07 | -0.87 | -3.97 |
| 2026-07-30 | 743.33 | 688.28 | 0.61 | -0.76 |
| 2026-07-31 | 744.2 | 684.47 | 0.73 | -1.31 |
| 2026-08-03 | 758.33 | 701.8 | 2.64 | 1.19 |
| 2026-08-04 | 772.68 | 722.77 | 4.58 | 4.21 |
| 2026-08-05 | 771.12 | 716.51 | 4.37 | 3.31 |
| 2026-08-06 | 768.99 | 717 | 4.08 | 3.38 |
| 2026-08-07 | 773.38 | 723.23 | 4.68 | 4.28 |
| 2026-08-10 | 772.35 | 719.96 | 4.54 | 3.8 |
| 2026-08-11 | 770.98 | 718.99 | 4.35 | 3.66 |
| 2026-08-12 | 772.3 | 722.58 | 4.53 | 4.18 |
| 2026-08-13 | 778.12 | 732.29 | 5.32 | 5.58 |
| 2026-08-14 | 776.01 | 730.85 | 5.03 | 5.37 |
| 2026-08-17 | 772.7 | 729.96 | 4.58 | 5.25 |
| 2026-08-18 | 767.04 | 716.18 | 3.82 | 3.26 |
| 2026-08-19 | 770.01 | 718.76 | 4.22 | 3.63 |
SELECT day, SPY, QQQ,
round((SPY / first_value(SPY) OVER (ORDER BY day ASC) - 1) * 100, 2) AS SPY_return,
round((QQQ / first_value(QQQ) OVER (ORDER BY day ASC) - 1) * 100, 2) AS QQQ_return
FROM (
SELECT toDate(window_start) AS day,
round(argMaxIf(close, window_start, ticker = 'SPY'), 2) AS SPY,
round(argMaxIf(close, window_start, ticker = 'QQQ'), 2) AS QQQ
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'QQQ') AND window_start >= now() - INTERVAL 45 DAY
GROUP BY day
)
ORDER BY day
LIMIT 100
Every chip is a live question answered from the warehouse, no key needed. A free account asks its own: SQL or plain English, always with the SQL shown.
No key and no signup for the first one. Paste SQL and get rows back. Every response carries the exact query that produced it and the date it was true, so you can read it, change it, and check us.
SELECT ticker, argMax(close, window_start) AS last FROM delayed_stocks_minute_aggs WHERE ticker IN ('SPY', 'QQQ') GROUP BY ticker;
“What's the latest close for SPY and QQQ?”
In finance a confidently-wrong answer is worse than no answer. That's why we never hide the query. You verify exactly what ran.
Per-scan and per-GB providers punish you for exploring. Every heavy query is a line item; every big month is a surprise invoice.
We run on owned hardware, so an extra query costs us almost nothing, and we pass that straight to you.
Pick a tier, know your bill, and scan as much as you want.
~8 trillion records, including nearly 7 trillion options quotes, for US equities and options. Every exchange-listed ticker, full SIP & OPRA, down to the tick.
Prices are the lead, not the limit. Fundamentals, corporate actions, SEC filings, short data, macro series, and news, all in the same place. A year means history reaches back to it; unlabelled sets are included.
Macro, fundamentals, filings, and short data live in the same schema as your tick data, joinable in a single SQL statement. Correlate price moves with CPI prints, screen by short interest, or line trades up against dividend dates, without juggling endpoints or stitching CSVs.
SELECT si.settlement_date, si.short_interest, p.close FROM stocks_short_interest AS si LEFT JOIN ( SELECT toDate(window_start) AS day, argMax(close, window_start) AS close FROM delayed_stocks_minute_aggs WHERE ticker = 'NVDA' GROUP BY day ) AS p ON p.day = si.settlement_date WHERE si.ticker = 'NVDA' ORDER BY si.settlement_date DESC;
Equity price × FINRA short interest. One statement, no endpoint juggling.
One flat price per tier, and query volume is not metered. What you pay for is how far back you can see and which datasets you can reach, and nothing else.
Discover the product. No card.
Building something real on it.
The whole warehouse. Both asset classes, full history.
The door is open on all four of these. Ask rather than assuming the answer is no.
“Unlimited” means unlimited. A fair-use layer keeps the service healthy for everyone, but your bill is the flat number above. Never a per-query meter.
Same data, same flat price. The difference is only whether you are checking us or shipping something.
Self-serve, write your own SQL, ship in an afternoon.
Check every claim on this page without an account, in a browser.
Instant access. No sales call, no credit card. Query 22 years of US equities and 12 years of options in SQL or plain English, right now.
Start free: get your API keyYes. Paid tiers carry no per-query or per-gigabyte meter. A light fair-use layer keeps the service healthy, but your bill is the flat monthly price, full stop.
No. Ask in plain English and we generate the SQL for you, and always show it so you can verify, edit, and re-run. Developers can skip straight to writing their own SQL or hitting the REST API.
Never. One subscription covers all US stocks and options. They're complements (options work needs the underlying), so we bundle them.
Every self-serve tier is T+1 historical, which is fully licensed. Real-time (which triggers OPRA fees) and redistribution rights live in the Enterprise plan.
Far more than prices. Alongside tick quotes, trades, and minute bars you get fundamentals (income, balance-sheet & cash-flow statements, valuation ratios), corporate actions (dividends, splits, IPOs), full-text SEC filings (10-K sections, risk factors, the EDGAR index, 8-Ks), short interest & short volume, macro series (Treasury yields, CPI/PCE inflation, labor market), and market news, all in one ClickHouse schema. Because it's one schema, you can join across datasets, price against short interest, CPI, or dividend dates, in a single SQL query.
No credit card, no sales call. One key, one endpoint, and the whole schema. You can also run a query right now without signing up at all.