load_price_history
Fetch historical stock price data and load it into a SQL database for analysis. Use this tool to prepare market data for SQL queries, enabling detailed financial analysis of price trends and patterns.
Instructions
Fetch price history and load into SQL database for querying. Use this instead of get_price_history when you need to analyze the data with SQL. After loading, use query_market_data to run SQL queries.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| symbol | Yes | Stock ticker symbol | |
| period_type | No | Type of period (default: year) | year |
| period | No | Number of periods (default: 1) | |
| frequency_type | No | Frequency of data points (default: daily) | daily |
| frequency | No | Frequency interval (default: 1) | |
| start_date | No | Start date (YYYY-MM-DD), alternative to period | |
| end_date | No | End date (YYYY-MM-DD) | |
| extended_hours | No | Include extended hours data (default: false) |