Free SQL API for stock market data wey no need card

One free SQL API dey for stock market data, and dis page dey document am. Free market data APIs full everywhere; but one API wey go accept your own SQL, run am against 22 years of US equities history, and return the result as JSON na different thing. Strasmore free tier na exactly dat: 100 queries per day, wey you write yourself, no credit card.

Free data APIs common. Free SQL no common.

Typical free data API dey give you fixed endpoints. One URL per dataset, parameters wey the vendor choose, and every question wey you ask must fit endpoint wey somebody don already build. The moment your question cross two datasets ("dividend growth for companies wey their short interest fall") you go dey download CSVs and dey join dem yourself.

SQL dey remove dat ceiling. The query NA the endpoint. Joins, window functions, aggregations, and date arithmetic dey run where the data dey live, and you dey download the answer instead of the raw material. Every panel for dis blog dey work dat way, and the SQL dey sit one click under each chart.

Wetin the warehouse hold

The queryable surface na ClickHouse warehouse of US market data: daily and minute price aggregates from 2003, dividends and splits, quarterly fundamentals, valuation ratios, short interest and short volume, IPOs, market news, and one options dataset with end-of-day greeks and implied volatility from 2014. The panels below dey run three real queries against am, each one na shape wey fixed-endpoint API dey struggle with.

One twenty-year dividend record for one GROUP BY. Coca-Cola pay 1 per share across 2004 and 2.04 across 2025, and the 22 yearly rows in between draw the whole history. For deeper single-name treatment, see Microsoft dividend record.

SELECT toYear(ex_dividend_date) AS year,
       round(sum(cash_amount), 2) AS total_cash_per_share
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
  AND cash_amount IS NOT NULL
  AND ex_dividend_date >= '2004-01-01'
  AND toYear(ex_dividend_date) < toYear(today())
GROUP BY year
ORDER BY year

The options volatility term structure, computed for one pass. Average end-of-day implied volatility for SPY by expiry bucket, 9 buckets from the front of the curve go out past one year. The front bucket read 26.4% as of the latest session. Dis dataset (greeks and implied volatility) dey sit for the paid tiers, and the seven-day trial wey come with free account cover am in full.

SELECT least(floor(days_to_expiry / 30) * 30, 360) AS dte_bucket_days,
       round(avg(implied_volatility) * 100, 1) AS avg_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date = (SELECT max(date) FROM global_markets.options_greeks)
  AND iv_converged
  AND days_to_expiry BETWEEN 1 AND 400
GROUP BY dte_bucket_days
ORDER BY dte_bucket_days

One valuation screen across the largest names. Every company above $500 billion for market cap with positive P/E, ranked by size. The largest, NVDA, dey trade at 30.8 times earnings as of the latest session.

SELECT ticker,
       round(price_to_earnings, 1) AS pe_ratio
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND market_cap > 5e11
  AND price_to_earnings > 0
  AND ticker NOT IN ('SPCX')
ORDER BY market_cap DESC
LIMIT 12

Wetin the free tier include

The free account na real SQL surface with honest limits, stated here exactly:

• 100 queries per day, wey you write for SQL or plain English (the terminal dey translate English to SQL and show you the query before e run).
• Two years of price history for the free tier; the full 22 years open for paid tiers.
• Daily and minute aggregates, dividends, splits, fundamentals, ratios, short interest, IPOs, and news all dey queryable for free. Tick-level trades and quotes, plus the greeks/IV dataset, na paid features.
• Every new account dey start with seven-day trial of the Quotes tier, no card for file, wey dey unlock the full history and the gated datasets while you dey evaluate.
• All access na read-only through SQL gate. SELECT and WITH dey run; nothing else dey run.

No scraping-tier tricks: the limits above na the actual product configuration, and the gate dey apply dem the same way to browser session and API call.

Try am before you sign up

The keyless companion to the SQL surface na the free demo API: one catalog of fixed queries, no account at all, each response dey carry the SQL wey produce am. E dey exist so you (or your AI agent) fit see the data shapes for one curl before you decide whether the SQL tier worth email address. The catalog for https://ai.strasmore.com/api/demo/catalog dey list every key.

FAQ

True-true free API dey wey dey accept SQL?

Yes. One free Strasmore account dey run up to 100 of your own SQL queries per day against the US equities warehouse, read-only, with two years of history. No payment details dey involved.

Which SQL dialect e dey use?

ClickHouse SQL. Standard SELECT syntax with window functions, plus ClickHouse aggregate combinators. The blog panels double as worked examples, with the exact SQL wey fit expand under each chart.

I fit use am without writing SQL?

Yes. The terminal dey accept plain-English questions, write the SQL for you, and show the query before e run am. The generated SQL dey editable, wey be fast way to learn the schema.

Wetin be the free tier exact limits?

100 queries per day, 2 years of history, read-only, and the tick-level and greeks datasets reserved for paid tiers. 7-day full trial dey start at signup with no card.

Anything dey wey no need signup at all?

The demo API. One catalog of fixed queries over the same warehouse, open CORS, no key. E no dey accept custom SQL; e dey exist for instant evaluation and for AI agents.

The panels above na stored queries wey anybody fit read; the same warehouse dey take questions wey you write yourself for the Strasmore terminal.