get_timeseries
Read-onlyIdempotent
Fetch historical time series data (e.g., OHLCV bars, macro indicators) for multiple tickers from various sources and return it as a CSV table per ticker.
Instructions
Fetch historical data from AuraStream and return it as a CSV table per ticker (timestamp,Open,High,Low,Close,Volume for market bars; source-specific fields otherwise, see list_sources). Long results are cut to the most recent max_rows rows per ticker, with the total row count noted. Each call uses one unit of the user's monthly AuraStream allowance. Provider credentials come from the server's environment; never ask the user to paste them.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"source": "<source>",
"tickers": "<tickers>",
"start": "<start>",
"end": "<end>"
},
"name": "get_timeseries"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No | sdmx (required): provider ID, e.g. BIS, ECB, ESTAT, IMF, OECD. | |
| end | Yes | End date, YYYY-MM-DD. | |
| top | No | edgar nport only: keep the largest N positions of each filing. | |
| feed | No | alpaca stocks only: iex (default) or sip (consolidated tape). | |
| mode | No | gdelt search queries only: share of coverage (default), article count, or tone. | |
| as_of | No | cftc: release (default, stamped at Friday publication, no look-ahead) or report (Tuesday position date). fred: realtime_start (default, stamped at publication) or date (period described). | |
| dtype | No | 'bars' everywhere; binance also 'funding' (futures); oanda also 'orderbook'/'positionbook'; alpaca also 'trades'/'quotes'; yahoo also 'earnings'. | bars |
| index | No | nasdaq only: date column used as the index (default date). | |
| items | No | edgar events only: 8-K item numbers, e.g. ['5.02']. | |
| level | No | nemeton only: order book depth the metric is computed over (default 1000). | |
| start | Yes | Start date, YYYY-MM-DD. | |
| state | No | warn only: CA and/or NJ (default both). | |
| holder | No | netshort only: keep positions whose holder contains this text. | |
| issuer | No | edgar npx only: company whose votes to return (CUSIP, ISIN or name). | |
| metric | No | nemeton (required): signal name, e.g. cumulative-depth, orderbook-pressure, spread (list_sources has all). | |
| period | No | edgar financials only: quarter (default) or annual. | |
| report | No | cftc only; default depends on the symbol. | |
| source | Yes | Data source id, see list_sources. | |
| bartype | No | cityindex only: bar (default) or tick. | |
| country | No | netshort only: FR, NL and/or ES (default all). | |
| dataset | No | edgar: insider (default), financials, earnings, events, ftd, 13dg, 144, 13f, nport or npx. usaspending: monthly (default) or awards. signals: crypto_leverage (default), fed_tone, event_flags, insider_conviction, fund_flow_pressure, gov_contracts, layoffs or energy_ag. uscensus: trade (default) or retail. gdelt: themes. | |
| filters | No | nasdaq only: column filters per table, e.g. {"QDL/FON": {"contract_code": "967654"}}. | |
| options | No | cftc only: include options (futures-equivalent). | |
| speaker | No | fedtext speeches only: speaker's last name, e.g. powell. | |
| tickers | Yes | Tickers in the source's own format, e.g. ['BTCUSDT'] for binance, ['EUR_USD'] for oanda, ['SPY'] for yahoo, ['GC'] for cftc, ['gold:CH'] for hmrc; weather sources take 'latitude,longitude', e.g. ['48.85,2.35']. Batch several tickers in one call. | |
| weights | No | degreedays only: population (default); gas, electricity, fuel_oil for heating by division or US. | |
| adjusted | No | uscensus retail only: seasonally adjusted (default true). | |
| assetcol | No | nasdaq only: one series per value of this column, e.g. contract_code. | |
| category | No | bybit only: linear (default) or inverse. | |
| concepts | No | edgar financials only: XBRL concepts, e.g. ['Revenues']. | |
| interval | No | Bar size: upper-case M is minutes, lower-case m is months (15M = 15 minutes, 1m = one month). Support varies by source (list_sources shows each source's intervals). | 1d |
| max_rows | No | Max rows returned per ticker; the most recent rows are kept. | |
| reporter | No | comext only: EU27_2020 (default) or a member state, e.g. DE. | |
| ticktype | No | kraken futures only: trade (default), mark or spot (index) price. | |
| timezone | No | openmeteo only: IANA time zone, e.g. Europe/Paris (default GMT). | |
| frequency | No | bea only: M, Q or A (default: the series' own). | |
| indicator | No | tradingeconomics (required): indicator name, e.g. 'gdp', 'inflation rate'. | |
| variables | No | openmeteo (required): weather variables, e.g. ['temperature_2m'] with 1h, ['temperature_2m_max'] with 1d. visualcrossing: only these fields. | |
| adjustment | No | alpaca stock bars only: raw (default), split, dividend or all. | |
| assetclass | No | alpaca only. | |
| award_type | No | usaspending only: contracts (default) or grants. | |
| instrument | No | binance: spot (default) or futures (USD-M perpetuals). kraken: futures (default) or spot. firstrate: stock (default), etf, futures, fx, index, crypto or options. lyra: option (default) or perp. | |
| min_amount | No | usaspending awards only: minimum award size in US dollars. | |
| price_type | No | oanda: M mid (default), A ask, B bid. cityindex: MID (default), BID or ASK. | |
| unit_group | No | visualcrossing only: units (default us). | |
| closed_only | No | tradestation only: leave out the bar still forming (default true). | |
| vs_currency | No | coingecko only: quote currency (default USD). | |
| sessiontemplate | No | tradestation only: trading session, e.g. Default or USEQPreAndPost. | |
| continuous_contracts | No | firstrate futures only: true (default) for continuous series, false for one series per contract. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |