Strasmore market data
US stocks and options data via SQL: bars, ticks, greeks, fundamentals, filings. No key.
- 1.0.0
- Version
- remote
- Transport
- 4
- Tools
Security review
Review passedReviewed 1d ago.
- tools: 4 tools scanned
- metadata: scanned
No findings.
Tools (4)
list_tables
List every table in the Strasmore US market-data warehouse (equities, options, corporate actions, fundamentals, SEC filings, news, macro) with a one-line description, the column its history window filters on, and whether this no-key access can read it. Call this first.
describe_table
Columns of one table with their ClickHouse types, plus notes on columns whose meaning is not obvious from the name and known data caveats. Call before writing SQL against a table.
run_sql
Run one read-only ClickHouse SELECT against the global_markets database and get the rows back. No key needed. Limits on this access: 500 rows and 20 seconds per query, history from 2025-01-01, and some tick-level tables excluded — each result states which limit, if any, it ran into. Connected with an API key, it runs at that key's plan instead. Docs: https://ai.strasmore.com/llms.txt (tables and limits), https://api.strasmore.com/docs (API reference).
get_plans
What this no-key access includes, what a free account and each paid plan add (history depth, datasets, row limits, price), and the link to start each one.