Get all positions with cost basis, quantity, market value, and gain/loss for an account

Get real-time quote for a stock symbol including price, bid/ask, volume, and fundamentals

Get real-time quotes for multiple symbols at once

Search for instruments by symbol or description, or get fundamental data for a symbol

Get top movers (gainers or losers) for an index by percent or value change

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.

Fetch option chain and load into SQL database for querying. Use this instead of get_option_chain when you need to analyze the data with SQL. After loading, use query_market_data to run SQL queries.

Run SQL query against loaded market data (price_history and options tables). First use load_price_history or load_option_chain to load data, then query it. Only SELECT queries are allowed. Use get_data_schema to see table schemas and example queries.

Get schema information for market data tables including column definitions, available data, and example SQL queries for common analyses like volume profile.