{"id":124880,"recorded_at":"2026-10-26T14:40:25.386997Z","observed_at":"2026-10-26T14:40:25.386914Z","subject_kind":"source_record","subject":"x402_bazaar:https://x402-agent-tools.nerolabs.workers.dev/data/aggregate","kind":"listing","method":"baseline/1","body":{"endpoints":[["x402","https://x402-agent-tools.nerolabs.workers.dev/data/aggregate"]],"name":"Nero Labs Agent Tools","owner_address":"0xa969a3127dcc74b2989a4b4e45ae61b81093164a","raw":{"accepts":[{"amount":"3000","asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:8453","payTo":"0xA969a3127DcC74B2989a4b4e45Ae61B81093164A","scheme":"exact"}],"description":"Groups up to 500 JSON rows and works out totals per group: count, sum, average, min, max, median, distinct count, first and last, with date buckets (day, week, month, quarter, year), a pivot table, sorting, top N and a totals row. Returns one row per group plus a summary. $0.001 per row sent, $0.002 minimum. Same engine as nerolabs/dataset-aggregate-pivot.","extensions":{"bazaar":{"info":{"input":{"body":{"aggregations":[{"field":"sales","function":"sum"},{"function":"count"}],"groupByFields":["region"],"rows":[{"region":"North","sales":120},{"region":"South","sales":80},{"region":"North","sales":60}]},"bodyType":"json","method":"POST","type":"http"},"output":{"example":{"_example_note":"Real output, trimmed: long lists cut to their first items and long text shortened.","rows":[{"count":2,"region":"North","sum_sales":180},{"count":1,"region":"South","sum_sales":80}],"summary":{"aggregations":[{"alias":"sum_sales","field":"sales","function":"sum"},{"alias":"count","function":"count"}],"columns":["region","sum_sales","count"],"droppedByTopN":0,"groupByFields":["region"],"groupCount":2,"inputRowCount":3,"outputRowCount":2,"pivot":null,"skippedValues":{},"totalsRowIncluded":false,"warnings":[]}},"type":"json"}},"schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"additionalProperties":false,"properties":{"aggregations":{"description":"What to compute per group, for example [{\"function\":\"count\",\"alias\":\"orders\"}, {\"field\":\"amount\",\"function\":\"sum\",\"alias\":\"total_amount\"}]. Every function except count needs a field. alias is the output column name (defaults to function_field, or \"count\"). Omitted gives a plain row count per group. Up to 20.","items":{"properties":{"alias":{"description":"Output column name.","type":"string"},"field":{"description":"The field to aggregate. Optional for count, which then counts rows.","type":"string"},"function":{"enum":["count","countDistinct","sum","avg","min","max","median","first","last","list","listDistinct"],"type":"string"}},"required":["function"],"type":"object"},"type":"array"},"dateBucketField":{"description":"A date or timestamp field to group by time period, for example \"orderedAt\". Adds a group column named like \"orderedAt_month\". Unreadable dates land in an \"(invalid date)\" group.","type":"string"},"dateBucketGranularity":{"description":"Bucket size for dateBucketField: day (2026-08-19), week (2026-W34), month (2026-08, default), quarter (2026-Q3) or year.","enum":["day","week","month","quarter","year"],"type":"string"},"groupByFields":{"description":"One output row per distinct combination of these field values, like SQL GROUP BY, for example [\"region\"] or [\"city\", \"category\"]. Dot paths like \"address.city\" work. Empty or omitted aggregates every row into a single row.","items":{"type":"string"},"type":"array"},"groupMatching":{"description":"normalized (default) ignores letter case and extra whitespace when grouping, so \"South\" and \"south \" are one group. exact requires identical values.","enum":["normalized","exact"],"type":"string"},"includeTotalsRow":{"description":"Appends a grand-total row labelled \"(total)\" and adds a _rowType column (\"group\" or \"total\").","type":"boolean"},"lenientNumbers":{"description":"On by default: \"$1,234.50\", \"49 USD\", \"12%\" and \"(300)\" count as numbers for sum, avg, min, max and median. Set false to accept only real numbers and plain numeric strings.","type":"boolean"},"pivotField":{"description":"Turns this field's distinct values into columns, pivot-table style: group by \"region\" and pivot on \"product\" for one row per region with a column per product. Must not also be a group-by field. At most 50 distinct values.","type":"string"},"pivotFunction":{"description":"How pivot cell values are combined. Defaults to sum when pivotValueField is set; ignored (row count) without one.","enum":["count","countDistinct","sum","avg","min","max","median","first","last","list","listDistinct"],"type":"string"},"pivotValueField":{"description":"The field whose values fill the pivot cells, for example \"amount\". Omitted fills each cell with a row count.","type":"string"},"rows":{"description":"The records to aggregate, up to 500. Each row is a JSON object; keys may differ between rows.","items":{"type":"object"},"type":"array"},"sortBy":{"description":"An output column to sort by: a group field, an aggregation alias such as \"total_amount\", or a pivot column. Omitted sorts by the group fields.","type":"string"},"sortDirection":{"description":"asc (default) or desc. Use desc with topN for \"top N by\" questions.","enum":["asc","desc"],"type":"string"},"topN":{"description":"After sorting, keep only the first N groups. The totals row still covers every input row.","minimum":1,"type":"integer"}},"required":["rows"],"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"properties":{"_example_note":{"type":"string"},"rows":{"items":{"properties":{"count":{"type":"number"},"region":{"type":"string"},"sum_sales":{"type":"number"}},"type":"object"},"type":"array"},"summary":{"properties":{"aggregations":{"items":{"type":"object"},"type":"array"},"columns":{"items":{"type":"string"},"type":"array"},"droppedByTopN":{"type":"number"},"groupByFields":{"items":{"type":"string"},"type":"array"},"groupCount":{"type":"number"},"inputRowCount":{"type":"number"},"outputRowCount":{"type":"number"},"pivot":{},"skippedValues":{"properties":{},"type":"object"},"totalsRowIncluded":{"type":"boolean"},"warnings":{"type":"array"}},"type":"object"}},"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"}}},"iconUrl":"https://res.cloudinary.com/bdb-prod/image/upload/c_fill,ar_1:1,w_256,h_256,f_auto,q_auto/v1792616069/bazaar-icons/0a5b056fde952fc0.png","lastUpdated":"2026-10-21T21:25:20.124Z","quality":{"l30DaysTotalCalls":3,"l30DaysUniquePayers":2,"lastCalledAt":"2026-10-21T21:25:19.965Z"},"resource":"https://x402-agent-tools.nerolabs.workers.dev/data/aggregate","serviceName":"Nero Labs Agent Tools","tags":["data","aggregate","group by","pivot","analytics"],"type":"http","x402Version":2},"source":"x402_bazaar","summary":"Groups up to 500 JSON rows and works out totals per group: count, sum, average, min, max, median, distinct count, first and last, with date buckets (day, week, month, quarter, year), a pivot table, sorting, top N and a totals row. Returns one row per group plus a summary. $0.001 per row sent, $0.002 minimum. Same engine as nerolabs/dataset-aggregate-pivot."},"body_sha256":"88dac964bddc7d8758901e42caf569ac945dc8d188654787834adb28a3242218","prev_id":null,"leaf":"0xf341efe350548fcf3039782c203d42dd000b06ae528baa400d50643db8b4344d","leaf_text":"{\"body\":\"88dac964bddc7d8758901e42caf569ac945dc8d188654787834adb28a3242218\",\"id\":124880,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025625386914,\"prev\":null,\"subject\":\"x402_bazaar:https://x402-agent-tools.nerolabs.workers.dev/data/aggregate\",\"subject_kind\":\"source_record\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0xf341c95faf298cae5939c035d4909a861724dbfaa30168ae331abada67cde07e","0x17d9d8f4ffffb503b25a663cb51ace350a8c3ead3a2377ef7b8fc5515e0b8322","0x1c7b98f7412150518035853b24d15584d06d869291f8d5c0bc75928f59f29c83","0xa9f95edc8578d01fe7f092bd2093cd11232282c9dcfe0411e1877673c605f54a","0x3b79dd3c7c2843b011b01174e22b7104cc03f7853e12c245e3493048b05ca91b","0xb23317aafa1bd33475d7caa214333619ada93c47d990ccd575e88e4b3f6dc797","0x77dd0ef1422257b63a13d93dcb51538a6ae85c3ca580c026c8f3e3dbb0663dd6","0x3d20c550e579768190c2211182be64075d3234962b6a6048c723b4fe509d241a","0x488da1831238d58942e96bb67705d58874d3df058d0910bd6904259ce950417a","0x99d8731791d25cbf46b06609ddccbc89c11d0e501cf96838a0656d4362666008","0xc50899a255d8f2b1b1fc55129b98f94521e73c5252d7c947abcfcdde2955260c","0x3e439c99553dde4ddc1a9189bc043fa92a4b6b41e39e7e6b21c10148f9558a78","0xa26f0437cba4d7d64f1cf98bf4f490e1ebb6f66a5e2331537b7ba8b3061084e0","0xd769d41500075835c3b2f9184d223699fb983fd05c29fbcb44d964abc7ee380d","0x68d296b1e00b4899fb83c3fba36fffaefa311eac2903067dbebfe776a12b4a9a","0x5fb5dda563336cd1bc1b9f44c52b76237ae72ed2145cb9290f39f304ca7dd678","0x74a0a08e4e7ab9aa5bfbead33dec7e1c7e8e364cff69a63720d764bbe987aadc"]}