Stocks + Options · One Flat Price

22 years of US equities and 12 years of options— down to the tick.

One flat price. Unlimited queries. Nothing to download. The tick-level options quotes—since 2022—others charge $199+ for, starting free.

No credit card. No ETL pipelines. No per-gigabyte bills.

STRASMORE / TRY IT
no signup required
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

Compare SPY and QQQ performance (normalized % return) over the last 45 days.

↳ We translate this to the exact SQL on the left—and show it to you before it runs.

Same answer, two ways to ask. The terminal always shows you the generated SQL before it runs.

One flat price
No per-GB, no surprises
Unlimited queries
Scan as much as you want
Nothing to download
Query in place, instantly
Stocks + options
Bundled, never split
SQL or plain English
Both, on every tier
Proof by doing

Write SQL, or just ask.

The same question, two ways—returning the exact same result. Developers write SQL. Analysts ask in plain English. We always show the generated SQL so you can read it, edit it, and re-run it.

You write SQL
SELECT ticker,
       argMax(close, window_start) AS last
FROM   delayed_stocks_minute_aggs
WHERE  ticker IN ('SPY', 'QQQ')
GROUP BY ticker;
Or you ask Plain English

“What's the latest close for SPY and QQQ?”

Translated to the SQL on the left, shown to you, then executed.
2 rows 0.04s

In finance a confidently-wrong answer is worse than no answer. That's why we never hide the query—you verify exactly what ran.

Predictable by design

Stop paying per gigabyte.

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.

Per-GB incumbents

  • Metered per byte scanned
  • Surprise end-of-month bills
  • Stocks & options billed apart
  • Download & host it yourself

Strasmore

  • One flat monthly price
  • Unlimited queries
  • Stocks + options, one bill
  • Query in place, nothing to host
The coverage

Hard numbers, not logos.

~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.

~8T
Quote & trade rows
100%
Of US exchange-listed equities & options
~7T
Options NBBO quotes · since 2022
22yr
US equities · since 2003
<1s
Aggregate query latency
T+1
Full SIP & OPRA, fresh daily
The full catalog

One schema. Every dataset.

Prices are the lead, not the limit. Fundamentals, corporate actions, SEC filings, short data, macro series, and news — in the same place. A year means history reaches back to it; unlabelled sets are included.

Market data

  • Tick quotes, trades & minute bars
  • Equities since 2003 · options since 2014 (quotes 2022)

Fundamentals

  • Income statementssince 2009
  • Balance sheetssince 2009
  • Cash-flow statementssince 2009
  • Valuation ratios (P/E, P/B, EV/EBITDA, yield, ROE)

Corporate actions

  • Dividendssince 2000
  • Stock splitssince 1978
  • IPOssince 2008

SEC filings · full text

  • 10-K sectionssince 2015
  • Risk factorssince 2015
  • EDGAR filing indexsince 1999
  • 8-K filings

Short data

  • Short interestsince 2017
  • Short volume

Macro & economic

  • Treasury yieldssince 1970
  • Inflation — CPI & PCEsince 1970
  • Inflation expectationssince 1982
  • Labor marketsince 1970

News

  • Market news & sentimentsince 2001

It's all one query away.

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.

One query cross-dataset join
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.

Transparent pricing

Stocks and options. One subscription.

Every tier includes the full product—REST API, SQL console, and plain-English querying. You only pay for more history, lower latency, and deeper datasets.

Free

Discover the product. No card.

$0
  • Stocks + options
  • 2 years history, T+1 / EOD
  • Aggregates + reference data
  • API, SQL & plain English
  • ·100 queries / day
Start free

Starter

For builders shipping their first integration.

$29 /mo
  • Everything in Free
  • 5 years history
  • Unlimited queries
  • Greeks, IV & open interest
  • Flat-file export + WebSockets
Start free

Pro

Full depth plus tick-level trades.

$79 /mo
  • Everything in Starter
  • Full history — equities since 2003, options since 2014
  • Tick-level trades (stocks + options)
  • Unlimited queries
  • ·Quotes firehose not included
Start free
Recommended

Quotes

The full NBBO firehose—what others weld to real-time and charge $199+ for.

$129 /mo
  • Everything in Pro
  • Tick NBBO quotes — equities since 2003, options since 2022
  • T+1, continuous — no gaps
  • Unlimited queries
  • Unbundled from real-time
Start free

Enterprise

Real-time data, redistribution rights, and an SLA. Custom pricing.

  • Real-time stocks + options
  • Redistribution rights
  • Dedicated SLA & support

“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.

Built for both sides of the desk.

The same data and the same flat price—whether you write code or write sentences.

For developers & quants

Self-serve, write your own SQL, ship in an afternoon.

  • REST API with one key—no per-asset entitlements
  • WebSockets streaming on paid tiers
  • Flat-file export for your own pipelines
  • Raw ClickHouse SQL against a stable, narrow schema
Get your API key

For analysts & investors

No SQL required. Ask in plain English, read the answer, see the chart.

  • Ask questions in plain English in the web console
  • Always see—and can edit—the generated SQL
  • Charts to see what you just queried
  • A Wall St terminal, without Wall St's price
Start free

Start free.

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 key

Frequently asked questions

Is it really unlimited queries?

Yes. 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.

Do I need to know SQL?

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.

Are stocks and options billed separately?

Never. One subscription covers all US stocks and options. They're complements—options work needs the underlying—so we bundle them.

What about real-time data?

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.

What datasets are included?

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.