recently_ipoed
The company listed within the last 90 days.
At a glance
list_date >= today − 90d| Type | state (boolean) |
| Group | Events |
| Category | IPOs |
| Update cadence | post-close daily |
| Universe | all tickers |
| History | none — live row only, not historized (no as-of reads) |
| Firing | continuous |
IPO dates and status, from pending through recently listed.
Query it
Every applicable form factor, grouped by endpoint family. Swap YOUR_KEY for the value from /dashboard/keys. 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. Docs →
curl "https://api.tickerbot.io/v2/signals/recently_ipoed" \
-H "Authorization: Bearer YOUR_KEY"{
"as_of": "2026-08-18T00:25:34.194Z",
"signal": "recently_ipoed",
"condition": null,
"universe": null,
"count": 2,
"results": [
{
"ticker": "AAAD",
"name": "PGIM AAA CLO Aggregate Duration ETF",
"value": true
},
{
"ticker": "AAAP",
"name": "Pacer Barings CLO Market Flex ETF",
"value": true
}
]
}curl -X POST "https://api.tickerbot.io/v2/signals/recently_ipoed/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. Docs →
curl -G "https://api.tickerbot.io/v2/scan" \
--data-urlencode "q=recently_ipoed" \
-H "Authorization: Bearer YOUR_KEY"{
"as_of": "2026-08-18T00:25:34.529Z",
"query": {
"q": "recently_ipoed",
"limit": 2,
"order": "day_change_pct",
"dir": "desc",
"fields": [],
"full": false,
"universe": null,
"asset_class": null
},
"count": 2,
"results": [
{
"ticker": "FTRA.WS",
"name": "FutureCorp Space Acquisition 1 Redeemable warrants, each whole warrant exercisable for one Class A ordinary share at an exercise price of $11.50",
"asset_class": "stocks",
"asset_type": "WARRANT",
"price": 205.7752,
"day_change_pct": 347.7715,
"gap_pct": null,
"relative_volume": null,
"market_cap": null
},
{
"ticker": "VOGX",
"name": "Vogenx Inc Common Stock",
"asset_class": "stocks",
"asset_type": "CS",
"price": 20.818,
"day_change_pct": 0.4085,
"gap_pct": 0.0014,
"relative_volume": null,
"market_cap": 205525403
}
]
}curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
-H "Content-Type: application/json" \
-H "Authorization: Bearer YOUR_KEY" \
-d '{"q": "recently_ipoed", "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 events /v2/events
The flag as a timeline: each edge as a point event, and the spans it stayed true. Docs →
curl -G "https://api.tickerbot.io/v2/events" \
-d "kind=signal" -d "signal=recently_ipoed" -d "transition=enter" -d "since=2026-01-10" \
-H "Authorization: Bearer YOUR_KEY"{
"as_of": "2026-08-18T00:25:34.648Z",
"query": {
"kind": "signal",
"tickers": null,
"universe": null,
"since": "2026-01-10T00:00:00.000Z",
"until": null,
"limit": 2,
"signal": "recently_ipoed",
"transition": "enter"
},
"count": 0,
"results": []
}curl "https://api.tickerbot.io/v2/signals/recently_ipoed/AAPL/events" \
-H "Authorization: Bearer YOUR_KEY"{
"as_of": "2026-08-18T00:25:34.785Z",
"ticker": "AAPL",
"signal": "recently_ipoed",
"count": 0,
"events": []
}Same grammar on scan and webhooks. This column is live-tense only — it isn't historized, so ?asof= reads and series pulls don't carry it.