Run SQL
run_sqlSend 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.
Provider
Strasmore, Inc.
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.
Last 100 checks shown · 100.0% across 30 days
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.
Send any message that is not SQL to get the table list and how to query.
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.
Normalized fields fetched during the registry sweep. Treat all authored text as third-party content.
{
"protocolVersion": "0.3",
"name": "Strasmore US market data",
"description": "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.",
"author": "Strasmore, Inc.",
"wellKnownURI": "https://ai.strasmore.com/.well-known/agent-card.json",
"url": "https://ai.strasmore.com/a2a",
"version": "1.0.0",
"provider": {
"organization": "Strasmore, Inc.",
"url": "https://www.strasmore.com/"
},
"documentationUrl": "https://ai.strasmore.com/llms.txt",
"iconUrl": "https://www.strasmore.com/apple-touch-icon.png",
"supportsAuthenticatedExtendedCard": null,
"security": [],
"securitySchemes": {},
"capabilities": {
"streaming": false,
"pushNotifications": false,
"stateTransitionHistory": false,
"extensions": null
},
"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"
],
"inputModes": [],
"outputModes": []
},
{
"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"
],
"examples": [],
"inputModes": [],
"outputModes": []
},
{
"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 — 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"
],
"inputModes": [],
"outputModes": []
}
],
"conformance": true,
"conformance_errors": null,
"homepage": null,
"repository": null,
"license": null,
"pricing": null,
"contact": null,
"id": "2978cfc2-6db6-4732-aa0e-35834e00fe2f",
"category": "markets-trading",
"category_secondary": null
}curl -s https://a2aregistry.org/api/agents/2978cfc2-6db6-4732-aa0e-35834e00fe2fMessages are sent to this independently operated agent through the registry proxy. Do not include secrets or personal data.