# consolidation

Price is range-bound — the last 5 sessions span less than 5%.

A boolean signal (flag) column on the Tickerbot computed state table (20,798+ ticker rows) — computed by the platform, queryable by bare name across the API. Values are NULL on rows the signal doesn't apply to.

Definition: `(max(high) − min(low)) / midpoint < 0.05 over 5 bars`

- Group: Price action
- Category: Ranges & reversals
- Type: state
- Update cadence: 1 min · mkt hrs
- Intervals: 1d
- Universe: all tickers
- History: recent only (forward-only from first computation)
- Firing: continuous

## Query it

Every applicable form factor, grouped by endpoint family. Response payloads are real captures, sampled 2026-08-18 and trimmed; your run's values and dates will differ.

### Use signals — `/v2/signals/{signal}`

One signal across the market: who matches now, who matched then, and a push when someone starts. (https://tickerbot.io/docs/endpoints/signals.md)

#### Live — every ticker where it fires now

```bash
curl "https://api.tickerbot.io/v2/signals/consolidation" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:10.858Z",
 "signal": "consolidation",
 "condition": null,
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "A",
   "name": "Agilent Technologies Inc.",
   "value": true
  },
  {
   "ticker": "AAA",
   "name": "Alternative Access First Priority CLO Bond ETF",
   "value": true
  }
 ]
}
```

#### As-of — the same read at a past date

```bash
curl "https://api.tickerbot.io/v2/signals/consolidation?asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-05-20",
 "signal": "consolidation",
 "condition": null,
 "universe": null,
 "count": 0,
 "results": []
}
```

#### Subscribe — webhook when a ticker starts matching

```bash
curl -X POST "https://api.tickerbot.io/v2/signals/consolidation/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"target_url": "https://example.com/hooks/tickerbot"}'
```

Returns 201 with the created webhook — the same shape as GET /v2/webhooks/{id}, plus a one-time signing_secret for HMAC verification.

### Use scan — `/v2/scan`

The whole market through a WHERE clause — this signal composed freely with any other column. (https://tickerbot.io/docs/endpoints/scan.md)

#### Live — the whole market, filtered on this signal

```bash
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=consolidation" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:14.074Z",
 "query": {
  "q": "consolidation",
  "limit": 2,
  "order": "day_change_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "MTRX",
   "name": "Matrix Service Co",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 12.825,
   "day_change_pct": 0.0768,
   "gap_pct": -0.0042,
   "relative_volume": null,
   "market_cap": 335074153
  },
  {
   "ticker": "GSJY",
   "name": "Goldman Sachs ActiveBeta Japan Equity ETF",
   "asset_class": "stocks",
   "asset_type": "ETF",
   "price": 60.08,
   "day_change_pct": 0.0703,
   "gap_pct": -0.0026,
   "relative_volume": null,
   "market_cap": null
  }
 ]
}
```

#### As-of — the same scan at a past date

```bash
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=consolidation" \
  -d "asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-05-20",
 "query": {
  "q": "consolidation",
  "asof": "2026-05-20",
  "interval": "auto",
  "limit": 2,
  "order": "day_change_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 0,
 "results": []
}
```

#### Subscribe — webhook on a market-wide condition

```bash
curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"q": "consolidation", "target_url": "https://example.com/hooks/tickerbot"}'
```

Returns 201 with the created webhook object; deliveries carry the tickers matching the condition at each evaluation.

### Use series — `/v2/series`

Its history over time, on one aligned grid. (https://tickerbot.io/docs/endpoints/series.md)

#### History — the column on an aligned time grid

```bash
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,consolidation" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:16.787Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "consolidation"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-08-12",
    "close": 302.25,
    "consolidation": true
   },
   {
    "t": "2026-08-13",
    "close": 305.26,
    "consolidation": true
   },
   {
    "t": "2026-08-14",
    "close": 305.93,
    "consolidation": true
   }
  ],
  "MSFT": [
   {
    "t": "2026-08-12",
    "close": 492.43,
    "consolidation": false
   },
   {
    "t": "2026-08-13",
    "close": 496.88,
    "consolidation": true
   },
   {
    "t": "2026-08-14",
    "close": 495.4,
    "consolidation": true
   }
  ]
 }
}
```

### Use events — `/v2/events`

The flag as a timeline: each edge as a point event, and the spans it stayed true. (https://tickerbot.io/docs/endpoints/events.md)

#### Firings — every enter edge as a point event

```bash
curl -G "https://api.tickerbot.io/v2/events" \
  -d "kind=signal" -d "signal=consolidation" -d "transition=enter" -d "since=2026-01-10" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:17.158Z",
 "query": {
  "kind": "signal",
  "tickers": null,
  "universe": null,
  "since": "2026-01-10T00:00:00.000Z",
  "until": null,
  "limit": 2,
  "signal": "consolidation",
  "transition": "enter"
 },
 "count": 2,
 "results": [
  {
   "ticker": "ZOOZ",
   "ts": "2026-08-14T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "consolidation",
    "transition": "enter",
    "price": 5.405,
    "definition_version": 6
   }
  },
  {
   "ticker": "ZDGE",
   "ts": "2026-08-14T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "consolidation",
    "transition": "enter",
    "price": 2.945,
    "definition_version": 6
   }
  }
 ]
}
```

#### Spans — when it was true for one ticker (ZOOZ)

```bash
curl "https://api.tickerbot.io/v2/signals/consolidation/ZOOZ/events" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:17.292Z",
 "ticker": "ZOOZ",
 "signal": "consolidation",
 "count": 1,
 "events": [
  {
   "started_at": "2026-08-14T20:00:00.000Z",
   "ended_at": "2026-08-15T20:00:00.000Z",
   "start_price": 5.405,
   "end_price": 5.405,
   "definition_version": 6
  }
 ]
}
```

## Related signals (Ranges & reversals)

- [above_opening_range](https://tickerbot.io/docs/signals/above_opening_range.md)
- [below_opening_range](https://tickerbot.io/docs/signals/below_opening_range.md)
- [consolidating_15m](https://tickerbot.io/docs/signals/consolidating_15m.md)
- [expanded_hourly_range](https://tickerbot.io/docs/signals/expanded_hourly_range.md)
- [hourly_reversal_bearish](https://tickerbot.io/docs/signals/hourly_reversal_bearish.md)
- [hourly_reversal_bullish](https://tickerbot.io/docs/signals/hourly_reversal_bullish.md)
- [in_opening_range](https://tickerbot.io/docs/signals/in_opening_range.md)
- [narrow_hourly_range](https://tickerbot.io/docs/signals/narrow_hourly_range.md)
- [pullback](https://tickerbot.io/docs/signals/pullback.md)
- [range_break_15m_down](https://tickerbot.io/docs/signals/range_break_15m_down.md)
- [range_break_15m_up](https://tickerbot.io/docs/signals/range_break_15m_up.md)
- [range_expansion](https://tickerbot.io/docs/signals/range_expansion.md)
- [repeated_test_of_high](https://tickerbot.io/docs/signals/repeated_test_of_high.md)
- [repeated_test_of_low](https://tickerbot.io/docs/signals/repeated_test_of_low.md)
- [sticky_breakout](https://tickerbot.io/docs/signals/sticky_breakout.md)

---

Full catalog: https://tickerbot.io/docs/signals.md · Schema: https://tickerbot.io/docs/schema.md · Interactive: https://tickerbot.io/explore?signal=consolidation · HTML: https://tickerbot.io/docs/signals/consolidation/