# Strasmore Research

> 22 years of US equities and 12 years of options data, measured. Queryable in SQL or plain English.

## Content
- Explore (2,236 answered questions, each with its SQL and result, free and no signup): https://www.strasmore.com/explore
- Explore index (JSON, every question with its slug/qid): https://www.strasmore.com/explore/index.json
- One answered question, as a page you can cite: https://www.strasmore.com/explore/q/<slug>/<qid> (add .json for the raw result)
- Every answered question, as a sitemap: https://www.strasmore.com/explore/sitemap.xml
- Blog index: https://www.strasmore.com/blog
- Blog sitemap: https://www.strasmore.com/blog/sitemap.xml

## Free SQL finance API
A SQL API over 22 years of US equities and 12 years of options data. The demo tier
needs no key and no signup; a free account writes its own SQL (100 queries a day,
no card). Every response includes the exact SQL that produced it.

### Ask your own question (no key, no signup)
- Run any read-only SQL: https://ai.strasmore.com/api/demo/sql?sql=SELECT+ticker,close+FROM+delayed_stocks_minute_aggs+LIMIT+5
  Also accepts POST with a JSON body: {"sql": "SELECT ..."}
- Every table and column you may query: https://ai.strasmore.com/api/demo/schema
  36 tables, one schema, all joinable on ticker. Write the SQL yourself.
- Anonymous limits: 500 rows, 20 seconds, 1 year of history.
  Tick-level trades need a paid plan; the NBBO quote tapes are open for the last
  5 days; everything else is open in full.
  Rejections say exactly why, so a failed call is worth reading.


### One runnable example per table
Paste any of these as the ?sql= value. All are read-only and inside the
no-signup limits unless marked [paid].

Equities — prices
- delayed_stocks_minute_aggs: SELECT ticker, window_start, open, close FROM delayed_stocks_minute_aggs WHERE window_start >= now() - INTERVAL 3 DAY ORDER BY window_start DESC LIMIT 5

Equities — tick data
- stocks_trades [paid]: SELECT ticker, sip_timestamp, participant_timestamp, trf_timestamp FROM stocks_trades WHERE sip_timestamp >= now() - INTERVAL 1 DAY ORDER BY sip_timestamp DESC LIMIT 5
- cache_stocks_quotes [paid]: SELECT ticker, sip_timestamp, participant_timestamp, trf_timestamp FROM cache_stocks_quotes WHERE sip_timestamp >= now() - INTERVAL 1 DAY ORDER BY sip_timestamp DESC LIMIT 5

Options
- options_greeks [paid]: SELECT ticker, date, underlying_symbol, option_type FROM options_greeks ORDER BY date DESC LIMIT 5
- options_trades [paid]: SELECT ticker, sip_timestamp, participant_timestamp, price FROM options_trades WHERE sip_timestamp >= now() - INTERVAL 1 DAY ORDER BY sip_timestamp DESC LIMIT 5
- cache_options_quotes [paid]: SELECT ticker, sip_timestamp, sequence_number, ask_price FROM cache_options_quotes WHERE sip_timestamp >= now() - INTERVAL 1 DAY ORDER BY sip_timestamp DESC LIMIT 5
- options_minute_aggs: SELECT ticker, window_start, open, close FROM options_minute_aggs WHERE window_start >= now() - INTERVAL 3 DAY ORDER BY window_start DESC LIMIT 5

Corporate actions
- stocks_dividends: SELECT ticker, ex_dividend_date, id, cash_amount FROM stocks_dividends ORDER BY ex_dividend_date DESC LIMIT 5
- stocks_splits: SELECT ticker, execution_date, id, split_from FROM stocks_splits ORDER BY execution_date DESC LIMIT 5
- stocks_ipos: SELECT ticker, listing_date, issuer_name, ipo_status FROM stocks_ipos ORDER BY listing_date DESC LIMIT 5

Short data
- stocks_short_interest: SELECT ticker, settlement_date, short_interest, avg_daily_volume FROM stocks_short_interest ORDER BY settlement_date DESC LIMIT 5
- stocks_short_volume: SELECT ticker, date, short_volume, short_volume_ratio FROM stocks_short_volume ORDER BY date DESC LIMIT 5

Fundamentals
- stocks_income_statements: SELECT filing_date, period_end, cik, tickers FROM stocks_income_statements ORDER BY filing_date DESC LIMIT 5
- stocks_balance_sheets: SELECT filing_date, period_end, cik, tickers FROM stocks_balance_sheets ORDER BY filing_date DESC LIMIT 5
- stocks_cash_flow_statements: SELECT filing_date, period_end, cik, tickers FROM stocks_cash_flow_statements ORDER BY filing_date DESC LIMIT 5
- stocks_ratios: SELECT ticker, date, cik, price FROM stocks_ratios ORDER BY date DESC LIMIT 5

SEC filings
- stocks_sec_edgar_index: SELECT ticker, filing_date, cik, issuer_name FROM stocks_sec_edgar_index ORDER BY filing_date DESC LIMIT 5
- stocks_10k_sections: SELECT ticker, filing_date, cik, period_end FROM stocks_10k_sections ORDER BY filing_date DESC LIMIT 5
- stocks_8k_text: SELECT ticker, filing_date, cik, form_type FROM stocks_8k_text ORDER BY filing_date DESC LIMIT 5
- stocks_risk_factors: SELECT ticker, filing_date, cik, primary_category FROM stocks_risk_factors ORDER BY filing_date DESC LIMIT 5
- stocks_risk_categories: SELECT taxonomy, primary_category, secondary_category, tertiary_category FROM stocks_risk_categories LIMIT 5

News
- stocks_news: SELECT published_utc, id, title, author FROM stocks_news ORDER BY published_utc DESC LIMIT 5

Macro & rates
- treasury_yields: SELECT date, yield_1_month, yield_3_month, yield_6_month FROM treasury_yields ORDER BY date DESC LIMIT 5
- inflation: SELECT date, cpi, cpi_core, cpi_year_over_year FROM inflation ORDER BY date DESC LIMIT 5
- inflation_expectations: SELECT date, forward_years_5_to_10, market_5_year, market_10_year FROM inflation_expectations ORDER BY date DESC LIMIT 5
- labor_market: SELECT date, avg_hourly_earnings, job_openings, labor_force_participation_rate FROM labor_market ORDER BY date DESC LIMIT 5

Reference
- stocks_market_holidays: SELECT date, exchange, name, status FROM stocks_market_holidays LIMIT 5
- stocks_exchanges: SELECT id, type, asset_class, locale FROM stocks_exchanges LIMIT 5
- stocks_condition_codes: SELECT id, name, abbreviation, type FROM stocks_condition_codes LIMIT 5

Other
- stocks_13f_filings: SELECT accession_number, cusip, file_number, filer_cik FROM stocks_13f_filings LIMIT 5
- stocks_8k_disclosures: SELECT accession_number, cik, filing_date, filing_url FROM stocks_8k_disclosures LIMIT 5
- stocks_daily_aggs: SELECT ticker, date, open, close FROM stocks_daily_aggs LIMIT 5
- stocks_form3: SELECT accession_number, aff_10b5_one, date_of_original_submission, direct_or_indirect FROM stocks_form3 LIMIT 5
- stocks_form4: SELECT accession_number, aff_10b5_one, date_of_original_submission, deemed_execution_date FROM stocks_form4 LIMIT 5

### Or call a pre-built question
- Demo catalog (JSON, self-documenting): https://ai.strasmore.com/api/demo/catalog
- Example call, no key: https://ai.strasmore.com/api/demo?q=spy_qqq
- API documentation: https://www.strasmore.com/blog/free-stock-market-data-api
- The free SQL tier, explained: https://www.strasmore.com/blog/free-sql-api-stock-market-data
- Sign up and write SQL: https://ai.strasmore.com/
- Equity prices are delayed; options greeks/implied volatility are end-of-day.