Strasmore market data

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.

{'type': 'object', 'required': ['table'], 'properties': {'table': {'type': 'string', 'description': 'Table name, e.g. stocks_daily_aggs'}}, 'additionalProperties': False}

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.

{'type': 'object', 'properties': {}, 'additionalProperties': False}

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.

{'type': 'object', 'properties': {}, 'additionalProperties': False}

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).

{'type': 'object', 'required': ['sql'], 'properties': {'sql': {'type': 'string', 'description': 'A single SELECT statement.'}}, 'additionalProperties': False}