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).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| by | No | year | |
| table | Yes | ||
| filters | No | ||
| sold_only | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |