{"id":376,"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.","card_url":"https://ai.strasmore.com/.well-known/agent-card.json","endpoint":"https://ai.strasmore.com/a2a","protocol_version":"1.0","first_seen":"2026-10-07T08:50:38.657996+00:00","last_verified":"2026-11-21T17:22:06.558064+00:00","card":{"url":"https://ai.strasmore.com/a2a","name":"Strasmore US market data","skills":[{"id":"run_sql","name":"Run SQL","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"],"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."},{"id":"describe_schema","name":"Describe the schema","tags":["schema","market-data"],"description":"Send any message that is not SQL to get the table list and how to query."},{"id":"options_quote_snapshots","name":"Options NBBO snapshots","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"],"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."}],"iconUrl":"https://www.strasmore.com/apple-touch-icon.png","version":"1.0.0","provider":{"url":"https://www.strasmore.com","organization":"Strasmore, Inc."},"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.","capabilities":{"streaming":false,"pushNotifications":false},"protocolVersion":"0.3","documentationUrl":"https://ai.strasmore.com/llms.txt","defaultInputModes":["text/plain"],"defaultOutputModes":["text/plain","application/json"],"preferredTransport":"JSONRPC","supportedInterfaces":[{"url":"https://ai.strasmore.com/a2a","protocolBinding":"JSONRPC","protocolVersion":"1.0"},{"url":"https://ai.strasmore.com/a2a","protocolBinding":"JSONRPC","protocolVersion":"0.3"}]},"status":"verified","publisher_domain":"strasmore.com","signature_status":"unsigned","signature_detail":"No card signature supplied","signature_key_url":null,"signature_checked_at":"2026-11-21T17:22:06.558064+00:00","domain_claimed_at":null,"domain_proof_checked_at":null,"source_name":"Publisher Agent Card","source_url":"https://ai.strasmore.com/.well-known/agent-card.json","last_check":{"checked_at":"2026-11-21T17:22:06.558064+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},"also_published_at":[],"history_urls":["https://ai.strasmore.com/.well-known/agent-card.json"],"skills":[{"skill_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"],"quality_warning":false},{"skill_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"],"quality_warning":false},{"skill_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"],"quality_warning":false}],"quality_flags":[],"check_history":{"checks":113,"passed":113},"recent_checks":[{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-21T17:22:06.558064+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-21T05:21:09.833849+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-20T17:19:48.751718+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-20T05:19:03.563510+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-19T17:18:44.043987+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-19T05:18:18.040599+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-18T17:17:46.688584+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-18T05:17:24.732479+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-17T17:16:54.230324+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-17T05:15:37.536723+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-16T17:14:21.377044+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},{"card_url":"https://ai.strasmore.com/.well-known/agent-card.json","checked_at":"2026-11-16T04:53:22.327551+00:00","success":true,"http_status":200,"detail":"Agent Card validated"}],"endpoint_tls_check":{"checked_at":"2026-11-21T17:22:06.558064+00:00","success":true,"detail":"Valid TLS connection to advertised endpoint host; no A2A request sent"},"protocol_check":{"checked_at":"2026-11-21T17:22:06.558064+00:00","endpoint":"https://ai.strasmore.com/a2a","protocol_binding":"JSONRPC","protocol_version":"1.0","state":"a2a_response","http_status":200,"detail":"A2A task-not-found response to a read-only task lookup","request_diagnostics":{"requests":[{"path":"/a2a","allow":[],"method":"POST","status":200,"version_header":"1.0","protocol_method":"GetTask","redirect_followed":false}],"capture_version":1}},"declared_primary_endpoint":"https://ai.strasmore.com/a2a","selected_connection_interface":{"url":"https://ai.strasmore.com/a2a","protocolBinding":"JSONRPC","protocolVersion":"1.0"},"protocol_interface_checks":[{"endpoint":"https://ai.strasmore.com/a2a","protocol_binding":"JSONRPC","protocol_version":"1.0","selected":true,"state":"a2a_response","checked_at":"2026-11-21T17:22:06.558064+00:00","http_status":200,"detail":"A2A task-not-found response to a read-only task lookup","binding_recorded":true},{"endpoint":"https://ai.strasmore.com/a2a","protocol_binding":"JSONRPC","protocol_version":"0.3","selected":false,"state":"a2a_response","checked_at":"2026-11-21T17:22:06.558064+00:00","http_status":200,"detail":"A2A task-not-found response to a read-only task lookup","binding_recorded":true}],"connection_selection_note":"The selected connection uses an address advertised in the publisher card. Read-only observations do not establish task quality or safety.","x402_price_check":null,"events":[{"observed_at":"2026-10-08T11:13:18.435890+00:00","event_type":"card_changed","detail":"Published card changed: skills; fingerprint c1ea5e9b5af8"}],"relationships":[],"verification":{"agent_card_url":"https://ai.strasmore.com/.well-known/agent-card.json","last_successful_card_check":"2026-11-21T17:22:06.558064+00:00","latest_card_check":{"checked_at":"2026-11-21T17:22:06.558064+00:00","success":true,"http_status":200,"detail":"Agent Card validated"},"signature_status":"unsigned","signature_checked_at":"2026-11-21T17:22:06.558064+00:00","task_endpoint_tested":true,"task_execution_tested":false,"endpoint_tls_checked_at":"2026-11-21T17:22:06.558064+00:00","endpoint_tls_reachable":true,"protocol_check_state":"a2a_response","protocol_checked_at":"2026-11-21T17:22:06.558064+00:00","provider_identity_verified":false,"domain_claimed_at":null,"domain_proof_checked_at":null},"synthetic_capability_tests":{"agent_id":376,"status":"not_tested","reason_code":"not_yet_tested","consent_status":"not_confirmed","latest_observation_status":null,"last_checked_at":null,"fixture_version":"1","reference_demonstration":false,"scope":"A publisher-authorized synthetic test of a dedicated free test endpoint. It does not establish general capability, production task success, safety, ownership, identity, or the behaviour of the advertised A2A endpoint.","methodology_url":"https://localmark.ai/capability-tests","history":[]},"repair_links":{"agent_repair_url":"https://localmark.ai/agents/376/repair","publisher_report_url":"https://localmark.ai/publishers/strasmore.com/repair","diagnostics_json_url":"https://localmark.ai/publishers/strasmore.com/repair/diagnostics.json","diagnostics_csv_url":"https://localmark.ai/publishers/strasmore.com/repair/diagnostics.csv"},"_localmark":{"contribution":{"optional":true,"directory_access":"free","operator_authorization_required":true,"affects_rankings":false,"message":"LocalMark is free. Optional contributions help fund ongoing checks.","support_url":"https://localmark.ai/support","metadata_url":"https://localmark.ai/api/v1/support/contributions"}}}