FAQ
What is TickerDB?
TickerDB is a categorical-first market intelligence database covering 10,000+ active US stocks, ETFs, and supported crypto pairs with up to 5 years of history. It packages market-state calculations into named bands your agent can work with directly, and responses include supporting metadata like durations, percentiles, and support/resistance context. Query it via the plain HTTP API, MCP, or an SDK when you want derived market state and context without rebuilding that classification layer yourself.
Who is TickerDB for?
Developers building with AI agents, MCP, or OpenClaw who need financial market context. Trading bots, stock analysis tools, portfolio assistants — any project where an LLM needs to reason about market conditions. Whether you're vibe-coding a side project or shipping a production agent.
What are the core endpoints?
Summary (/v1/summary/AAPL) ? full market-state snapshot for one ticker, with optional date range and event lookups. Search (/v1/search) ? arbitrary multi-field filtering across all 10,000+ assets. Schema (/v1/schema/fields) ? discover all queryable fields. Watchlist (/v1/watchlist) ? monitor your saved tickers with state change detection. Watchlist changes, webhooks, and account endpoints round out monitoring and account management.
How does search work?
The search endpoint accepts an array of filters ? each with a field name, operator, and value. For example: momentum_rsi_zone = oversold AND sector = Technology AND volume_ratio_band IN (high, extremely_high). You can sort server-side, select specific fields to return (reducing token usage), and paginate. Call /v1/schema/fields first to discover all 140+ queryable fields. SDKs include a Supabase-style query builder.
What assets does TickerDB cover?
10,000+ active assets across US stocks, ETFs, and supported crypto pairs. Pass any ticker to /v1/summary/TICKER ? if it returns data, it's covered. If not, you get a 404. No separate assets list endpoint needed.
How often is the data updated?
Daily end-of-day data only. Stocks and ETFs usually refresh by approximately 00:30 America/New_York (Eastern time, EST/EDT), while crypto usually refreshes by approximately 00:10 UTC, including weekends. Every response includes "data_status": "eod" for the freshness mode and "as_of_date" for the exact session date represented by the snapshot. No intraday data - TickerDB is end-of-day only. See Data Quality for the full freshness notes.
How does TickerDB handle data quality and corporate actions?
Public snapshots are built from adjusted historical market data so stock splits and similar corporate actions do not create false technical state changes. The serving dataset also goes through a staged publish flow with integrity checks before new snapshots replace the active tables. For the full coverage and reliability notes, see Data Quality.
What does "categorical" mean?
A categorical field turns an underlying calculation into a named band your app or agent can reason about directly. For example, RSI is exposed as zones like "momentum_rsi_zone": "oversold" while supporting context such as duration_days, condition_percentile, or support/resistance state stays explicit when it adds value. TickerDB is categorical-first, not categorical-only: the focus is derived state and context for screening, monitoring, and agent workflows.
How much historical data is available?
Up to 5 years depending on your plan. Starter tier gets 30 days of historical access. Plus gets 2 years. Pro gets the full 5-year history. Use the summary endpoint with ?start=2024-01-01&end=2024-12-31 for date ranges, or ?field=momentum_rsi_zone&band=deep_oversold for historical event lookups with aftermath performance data.
Does TickerDB work with MCP and OpenClaw?
Yes — all endpoints are exposed as MCP tools. Connect to Claude Desktop, Cursor, Windsurf, or any MCP client. OpenClaw has a native TickerDB skill. The categorical response format maps directly into tool results with no transformation needed.
Are there SDKs?
Python, Node.js, and Go. All three include a Supabase-style query builder for search: .select('ticker', 'sector').eq('momentum_rsi_zone', 'oversold').sort('extremes_condition_percentile', 'asc').limit(10).execute(). Or just use curl — the API is simple GET requests with a Bearer token.
Do crypto tickers require special formatting?
Yes — crypto tickers use a USD suffix: BTCUSD, ETHUSD, SOLUSD. Stocks and ETFs use standard symbols.
Are fundamentals available for crypto and ETFs?
No. Fundamentals (valuation, growth, earnings, analyst consensus) are stocks only. Crypto and ETF responses omit those fields entirely. Technical data (trend, momentum, volatility, volume) is available for all asset classes.
What are the rate limits?
The standard individual plan limits are Starter: 250 credits/day, 100/hour. Plus: 50K/day, 5K/hour. Pro: 100K/day, 10K/hour. Business plans are coming soon and go higher. During beta, every signed-in user is provisioned on Individual Pro for free. Most requests cost 1 credit. Watchlist GET costs 1 per ticker. Summary event lookups with cross-asset context cost 2 credits. Schema is always free (0 credits). Every response includes rate limit headers.
How does the search filter limit work?
Starter tier allows up to 3 filters per search query. Plus allows 5. Pro allows 10. This is the primary upgrade lever — you start with simple queries, then need more filters as you build more sophisticated screening logic.
Is the data predictive?
No. The output is descriptive, not predictive. Facts like "the RSI zone is oversold" or "the stock has been in a downtrend for 12 days." No forecasts, no recommendations, no predictions. What your agent does with those facts is up to you.
What's the difference between Starter and paid data?
Those are the standard post-beta plan differences. Starter gets core technical data (trend, momentum, volatility, volume), 30 days of historical summary/search/event access, and 3 search filters. Plus adds 2-year history, fundamentals, events with aftermath data, cross-asset correlation, and 5 search filters. Pro gets the full 5-year database with 10 search filters and all fields including stability metadata. During beta, every signed-in user is provisioned on Individual Pro for free.
Can I use TickerDB in a customer-facing app or AI assistant?
No. Standard plans are internal use only. You can use TickerDB in your own research workflows, internal tools, trading systems, and internal agents used by you or your team. You cannot expose TickerDB-backed outputs to customers or other third parties, even if the output is rewritten, summarized, scored, or otherwise transformed. If you need customer-facing or redistribution rights, contact support.
What happens if I exceed my rate limit?
HTTP 429 with a reset timestamp and an upgrade URL. Daily limits reset at midnight UTC. Hourly limits reset at the top of each hour. Build rate-aware logic using the X-Requests-Remaining headers in every response.