market_stats
Compute realized-price statistics—median, quartiles, average, min/max, sales count, date span, and top vendors—for an auction table or filtered segment.
Instructions
Summarize the realized-price market for a table or a filtered segment.
Returns count of sales, median, 25th/75th percentiles, average, min/max of
usd_price_decimal, the sale-date span, and the top vendors by volume — all
computed server-side over the full matching set (not a sample).
Args: table: Table alias (call list_tables first). "gems" = LOOSE, unmounted stones (use for a gemstone-market read); "jewelry" = FINISHED, mounted pieces. A loose-stone question can span both. filters: Optional list of filter dicts, same shape as query_table (field/op/value). Narrow to a segment, e.g. [{"field": "designer", "op": "eq", "value": "Patek Philippe"}]. sold_only: When true (default), restricts to sold lots with a positive USD price so the stats reflect realized transactions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| filters | No | ||
| sold_only | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |