TOOL API

query_data

Analyze financial market data using SQL. Queries DataFrames stored via call_api's store_as parameter. Uses SQLite SQL engine — supports standard SQL including scalar subqueries, CTEs, ILIKE, window functions, and complex expressions. Special commands: 'SHOW TABLES' lists stored tables, 'DESCRIBE <table>' shows table schema, 'DROP TABLE <table>' removes a table. Tables auto-expire after 1 hour. Optionally set apply to a list of function steps to post-process query results — each step is {"function": "name", "inputs": {"param": value}, "output": "col_name"}. Use search_endpoints with scope="functions" to discover available functions.

finance1 credits

Call information

Tool slug: smg-massive.query_data
Provider: Massive
Average response: 89 ms
Calls in 7 days: 1

Input parameters

sqlrequired

SQL query or special command (SHOW TABLES, DESCRIBE <table>, DROP TABLE <table>)

apply

List of function steps to post-process query results