Strasmore US market data

{
  "name": "Strasmore US market data",
  "description": "Runs read-only ClickHouse SQL over US stock and options market data \u2014 daily and minute bars, trades and quotes, options greeks, dividends, splits, fundamentals, SEC filings, news, macro \u2014 and returns the rows as JSON. No key, no signup; every reply states the limit it met.",
  "supportedInterfaces": [
    {
      "url": "https://ai.strasmore.com/a2a",
      "protocolBinding": "JSONRPC",
      "protocolVersion": "1.0"
    },
    {
      "url": "https://ai.strasmore.com/a2a",
      "protocolBinding": "JSONRPC",
      "protocolVersion": "0.3"
    }
  ],
  "provider": {
    "organization": "Strasmore, Inc.",
    "url": "https://www.strasmore.com"
  },
  "version": "1.0.0",
  "documentationUrl": "https://ai.strasmore.com/llms.txt",
  "iconUrl": "https://www.strasmore.com/apple-touch-icon.png",
  "capabilities": {
    "streaming": false,
    "pushNotifications": false
  },
  "defaultInputModes": [
    "text/plain"
  ],
  "defaultOutputModes": [
    "text/plain",
    "application/json"
  ],
  "skills": [
    {
      "id": "run_sql",
      "name": "Run SQL",
      "description": "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.",
      "tags": [
        "market-data",
        "sql",
        "stocks",
        "options",
        "clickhouse"
      ],
      "examples": [
        "SELECT date, close FROM global_markets.stocks_daily_aggs WHERE ticker = 'AAPL' ORDER BY date DESC LIMIT 5"
      ]
    },
    {
      "id": "describe_schema",
      "name": "Describe the schema",
      "description": "Send any message that is not SQL to get the table list and how to query.",
      "tags": [
        "schema",
        "market-data"
      ]
    },
    {
      "id": "options_quote_snapshots",
      "name": "Options NBBO snapshots",
      "description": "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 \u2014 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.",
      "tags": [
        "market-data",
        "options",
        "nbbo",
        "quotes"
      ],
      "examples": [
        "List the SPY contracts quoted on 2026-10-06",
        "One-minute NBBO for O:SPY261016C00500000 on 2026-10-06"
      ]
    }
  ],
  "protocolVersion": "0.3",
  "url": "https://ai.strasmore.com/a2a",
  "preferredTransport": "JSONRPC"
}