Strasmore US market data

Runs read-only ClickHouse SQL over US stock and options market data — daily and minute bars, trades and quotes, options greeks, dividends, splits, fundamentals, SEC filings, news, macro — and returns the rows as JSON. No key, no signup; every reply states the limit it met.

Skills

• Run SQL
  Send ONE read-only ClickHouse SELECT as the message text; tables are global_markets.<table>. Returns columns and rows as a JSON data part, and a text part with the row count and what a paid plan would add.
  market-datasqlstocksoptionsclickhouse
• Describe the schema
  Send any message that is not SQL to get the table list and how to query.
  schemamarket-data
• Options NBBO snapshots
  A clean options NBBO per contract per interval, in one HTTP call, no SQL: GET https://ai.strasmore.com/v1/demo/options/quote-snapshots?contract=O:SPY261016C00500000&date=YYYY-MM-DD&interval=60 — one row per contract per bucket from 09:30 to 16:00 ET with bid, ask, sizes, mid and the time of the quote, carried forward across buckets with no update. List what is quoted first: GET https://ai.strasmore.com/v1/demo/options/contracts?underlying=SPY&date=YYYY-MM-DD. Add &format=csv for CSV. The quote tape encodes expiry, type and strike in the OCC ticker and has no underlying column, which is why these exist.
  market-dataoptionsnbboquotes

How to call

https://ai.strasmore.com/a2a

Listed in

Directories this entry was found in.