Concepts › Signals › Fundamentals › Balance sheet
inventory
Inventory on hand. NULL for service and financial companies that don't carry inventory.
Watch this signal live on real tickers: Open in Explore →
At a glance
| Type | bigint |
| Group | Fundamentals |
| Category | Balance sheet |
| Unit | USD |
| Update cadence | post-close daily |
| Intervals | 1d |
| Universe | all tickers |
| History | full · since 2009 |
| Nullable | yes — NULL where not applicable |
Balance-sheet lines as reported.
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 →
Live — every ticker with inventory above a cutoff
curl -G "https://api.tickerbot.io/v2/signals/inventory" \
--data-urlencode "condition=> 5847000000" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-08-18T00:24:18.256Z",
"signal": "inventory",
"condition": "> 5847000000",
"universe": null,
"count": 2,
"results": [
{
"ticker": "BA",
"name": "Boeing Company",
"value": 88388000000
},
{
"ticker": "BApA",
"name": "The Boeing Company Depositary Shares, each representing a 1/20th interest in a share of 6.00% Series A Mandatory Convertible Preferred Stock, par value $1.00",
"value": 88388000000
}
]
}As-of — the same read at a past date
curl -G "https://api.tickerbot.io/v2/signals/inventory" \
--data-urlencode "condition=> 5847000000" \
-d "asof=2026-05-20" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-05-20",
"signal": "inventory",
"condition": "> 5847000000",
"universe": null,
"count": 2,
"results": [
{
"ticker": "WMT",
"name": "Walmart Inc. Common Stock",
"value": 65354000000
},
{
"ticker": "AMZN",
"name": "Amazon.Com Inc",
"value": 41494000000
}
]
}Subscribe — webhook when a ticker starts matching
curl -X POST "https://api.tickerbot.io/v2/signals/inventory/subscribe" \
-H "Content-Type: application/json" \
-H "Authorization: Bearer YOUR_KEY" \
-d '{"condition": "> 5847000000", "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 →
Live — the whole market, ranked by this column
curl -G "https://api.tickerbot.io/v2/scan" \
--data-urlencode "q=inventory IS NOT NULL" \
-d "order=inventory" -d "columns=inventory" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-08-18T00:24:20.625Z",
"query": {
"q": "inventory IS NOT NULL",
"limit": 2,
"order": "inventory",
"dir": "desc",
"fields": [
"inventory"
],
"full": false,
"universe": null,
"asset_class": null
},
"count": 2,
"results": [
{
"ticker": "BA",
"name": "Boeing Company",
"asset_class": "stocks",
"asset_type": "CS",
"price": 226.654,
"day_change_pct": -0.0217,
"gap_pct": -0.0057,
"relative_volume": null,
"market_cap": 183105022533,
"inventory": 88388000000
},
{
"ticker": "BApA",
"name": "The Boeing Company Depositary Shares, each representing a 1/20th interest in a share of 6.00% Series A Mandatory Convertible Preferred Stock, par value $1.00",
"asset_class": "stocks",
"asset_type": "SP",
"price": 69.51,
"day_change_pct": -0.0233,
"gap_pct": 0.0007,
"relative_volume": null,
"market_cap": null,
"inventory": 88388000000
}
]
}As-of — the same scan at a past date
curl -G "https://api.tickerbot.io/v2/scan" \
--data-urlencode "q=inventory IS NOT NULL" \
-d "order=inventory" -d "columns=inventory" \
-d "asof=2026-05-20" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-05-20",
"query": {
"q": "inventory IS NOT NULL",
"asof": "2026-05-20",
"interval": "auto",
"limit": 2,
"order": "inventory",
"dir": "desc",
"fields": [
"inventory"
],
"full": false,
"universe": null,
"asset_class": null
},
"count": 2,
"results": [
{
"ticker": "WMT",
"name": "Walmart Inc. Common Stock",
"asset_class": "stocks",
"asset_type": "CS",
"price": 130.85,
"day_change_pct": -2.496274217585689,
"gap_pct": -0.9649776453055049,
"relative_volume": 1.6940623942312982,
"market_cap": 1048239350000,
"inventory": 65354000000
},
{
"ticker": "AMZN",
"name": "Amazon.Com Inc",
"asset_class": "stocks",
"asset_type": "CS",
"price": 265.01,
"day_change_pct": 2.1863191177604753,
"gap_pct": 0.2737718824709017,
"relative_volume": 0.7489812843985376,
"market_cap": 2874033450000,
"inventory": 41494000000
}
]
}Subscribe — webhook on a market-wide condition
curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
-H "Content-Type: application/json" \
-H "Authorization: Bearer YOUR_KEY" \
-d '{"q": "inventory > 5847000000", "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. Docs →
History — the column on an aligned time grid
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,inventory" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-08-18T00:24:22.695Z",
"interval": "1d",
"tickers": [
"AAPL",
"MSFT"
],
"columns": [
"close",
"inventory"
],
"count": 6,
"series": {
"AAPL": [
{
"t": "2026-08-12",
"close": 302.25,
"inventory": 6747000000
},
{
"t": "2026-08-13",
"close": 305.26,
"inventory": 6747000000
},
{
"t": "2026-08-14",
"close": 305.93,
"inventory": 6747000000
}
],
"MSFT": [
{
"t": "2026-08-12",
"close": 492.43,
"inventory": 1397000000
},
{
"t": "2026-08-13",
"close": 496.88,
"inventory": 1397000000
},
{
"t": "2026-08-14",
"close": 495.4,
"inventory": 1397000000
}
]
}
}Same grammar on scan, series, and webhooks; state reads take ?asof= for point-in-time answers.