# ipo_date

Date of the company's IPO, when known.

A date signal 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.

- Group: Events
- Category: IPOs
- Type: date
- Update cadence: end of day
- Universe: all tickers
- History: none — live row only, not historized (no as-of reads for this column)
- Nullable: yes

## 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 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, ranked by this column

```bash
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=ipo_date IS NOT NULL" \
  -d "order=ipo_date" -d "columns=ipo_date" \
  -H "Authorization: Bearer YOUR_KEY"
```

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

```json
{
 "as_of": "2026-08-18T00:24:18.793Z",
 "query": {
  "q": "ipo_date IS NOT NULL",
  "limit": 2,
  "order": "ipo_date",
  "dir": "desc",
  "fields": [
   "ipo_date"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "LYNX",
   "name": "Lyntris Inc",
   "asset_class": "stocks",
   "asset_type": null,
   "price": null,
   "day_change_pct": null,
   "gap_pct": null,
   "relative_volume": null,
   "market_cap": null,
   "ipo_date": "2026-08-19T00:00:00.000Z"
  },
  {
   "ticker": "SCATU",
   "name": "Southern Cross Acquisition II Corp. Units",
   "asset_class": "stocks",
   "asset_type": "UNIT",
   "price": null,
   "day_change_pct": null,
   "gap_pct": null,
   "relative_volume": null,
   "market_cap": null,
   "ipo_date": "2026-08-12T00:00:00.000Z"
  }
 ]
}
```

## Related signals (IPOs)

- [ipo_in_7d](https://tickerbot.io/docs/signals/ipo_in_7d.md)
- [pending_ipo](https://tickerbot.io/docs/signals/pending_ipo.md)
- [recently_ipoed](https://tickerbot.io/docs/signals/recently_ipoed.md)

---

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