Market Data at Your Command

Query 70,000+ securities using SQL or plain English.

Ask in Plain English

You ask:

“Show me Apple stock prices for the last month”

Completed30 rows•0.18s

Date	Symbol	Close	Volume
2026-01-22	AAPL	$243.18	47,892,341
2026-01-21	AAPL	$241.56	53,218,765
2026-01-17	AAPL	$239.84	49,103,452
... 27 more rows

No SQL required - just ask in plain English

Complex Analysis from Natural Language

You ask:

“Compare revenue growth for AAPL, MSFT, GOOGL over last 5 years”

Generated SQL (via AI):

SELECT i.symbol, i.fiscalYear, i.revenue,
  g.growthRevenue as revenue_growth_pct
FROM fmp.income_statement i
JOIN fmp.income_statement_growth g
  ON i.symbol = g.symbol
  AND i.date = g.date
  AND i.period = g.period
WHERE i.symbol IN ('AAPL', 'MSFT', 'GOOGL')
  AND i.fiscalYear >= 2019
  AND i.period = 'FY'
ORDER BY i.symbol, i.fiscalYear;

AI generates complex JOINs and window functions

Sophisticated Stock Screening

You ask:

“Find stocks with P/E under 15, P/B under 3, and strong buy rating”

Generated SQL (3-table JOIN):

SELECT cs.symbol, cs.companyName, cs.sector,
  r.priceToEarningsRatioTTM as pe_ratio,
  r.priceToBookRatioTTM as pb_ratio, ud.consensus
FROM fmp.company_screener cs
JOIN fmp.financial_ratios_ttm r
  ON cs.symbol = r.symbol
JOIN fmp.upgrades_downgrades_consensus ud
  ON cs.symbol = ud.symbol
WHERE cs.country = 'US'
  AND cs.exchange IN ('NASDAQ', 'New York Stock Exchange')
  AND cs.marketCap > 10000000000
  AND r.priceToEarningsRatioTTM BETWEEN 5 AND 15
  AND r.priceToBookRatioTTM > 0
  AND r.priceToBookRatioTTM < 3
  AND cs.isEtf = false
  AND cs.isFund = false
  AND ud.consensus IN ('Strong Buy', 'Buy')
ORDER BY r.priceToEarningsRatioTTM ASC LIMIT 50;