Daily Stock Prices (FinBridge DB)
get_stock_pricesGet daily OHLCV price history from the local finbridge database (populated by the nightly ingest jobs). Rows are returned newest first.
Price coverage by market — we only store what we have redistribution rights to:
Korea (DART + Financial Services Commission): full daily history, corporate-action adjusted. SERVED.
Taiwan (TWSE OpenAPI, Open Government Data License): daily history. SERVED.
US (Databento EQUS.SUMMARY): daily history from 2023-03-28. SERVED. Split-adjusted; dividend-adjusted closes exist where SEC-reported dividends do (adj_close).
Japan: NOT served. EDINET publishes disclosure documents, not prices, so we hold Japanese filings and the company master but no quotes.
Args:
company: a ticker (US 'AAPL', TW/JP 4-digit '2330'), a KR 6-digit stock code ('005930'), or a company name in the local language or English ('TSMC', 'Toyota', '삼성전자'). Resolution priority: exact ticker > 6-digit KR code > exact name (name or English name) > partial name (multiple partial matches return a candidate list error).
from / to: optional YYYY-MM-DD range bounds (inclusive)
limit: max rows, 1-500 (default 60)
response_format: 'markdown' (default) or 'json'
Plan note: the free plan serves the most recent 130 trading sessions of each name; paid plans serve the full stored history. When the window is trimmed the response carries a plan_limit field saying so.
Returns: {company: {name, source, ticker|stock_code}, count, truncated, prices: [{date, open, high, low, close, volume}]} — newest date first; truncated=true means older rows exist beyond 'limit'.
Examples:
{company: '005930', limit: 30} -> last 30 KR trading days for Samsung Electronics
{company: '005930', from: '2026-01-01', to: '2026-06-30'} -> Samsung Electronics H1 2026
Use when: historical closes/volumes for charting or return calculations from ingested data. Don't use for real-time quotes (use live-source tools) or crypto (get_crypto_ohlcv). Errors: unknown company -> no-match or candidate-list error; JP/EU company -> no-prices error (those markets carry statements only); no price rows -> a market-specific hint (new listing, delisted, nightly lag).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End date YYYY-MM-DD (inclusive) | |
| from | No | Start date YYYY-MM-DD (inclusive) | |
| limit | No | Max rows, 1-500 (default 60), newest first | |
| company | Yes | KR 6-digit stock code (e.g. '005930') or company name | |
| response_format | No | 'markdown' for a table, 'json' for compact machine-readable output | markdown |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | ||
| prices | Yes | ||
| company | Yes | ||
| truncated | No |