price_trend
Track realized auction price trends over time for a table or filtered segment, with sales counts, median, and average USD price per year, quarter, or month.
Instructions
Show how realized prices moved over time for a table or filtered segment.
Buckets sold lots by sale period and reports, per period, the number of
sales, the median, and the average usd_price_decimal.
Args: table: Table alias (call list_tables first). Gems = loose stones; jewelry = mounted pieces. filters: Optional filter dicts (field/op/value), same shape as query_table. by: Time bucket — "year" (default), "quarter", or "month". sold_only: Restrict to sold lots with a positive USD price (default true).
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": {
"table": "<table>"
},
"name": "price_trend"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| by | No | year | |
| table | Yes | ||
| filters | No | ||
| sold_only | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |