S&P 500 companies by sector and by year added (version 1.0.0)
- Version
- 1.0.0
- Outcome
- succeeded
- Ran
- 2026-10-27 17:18 UTC
- Took
- 155 ms
- Cost
- No charge (no model, not billed)
Slipstream's own API on a Depot CI runner, inside the images/base.Dockerfile image as an unprivileged user. No model, no ContextStream, no credits.
What it ran on
Input
{
"data": {
"url": "https://raw.githubusercontent.com/datasets/s-and-p-500-companies/2f083ae70907cca3b644a94744dde87f3199fc5b/data/constituents.csv"
},
"questions": [
{
"id": "companies_by_sector",
"metric": {
"op": "count"
},
"group_by": [
"GICS Sector"
],
"filters": [],
"limit": 20,
"chart": "bar"
},
{
"id": "added_by_year",
"metric": {
"op": "count"
},
"time": {
"column": "Date added",
"unit": "year"
},
"group_by": [],
"filters": [],
"limit": 100,
"chart": "line"
},
{
"id": "headquarters_cities",
"metric": {
"op": "distinct",
"column": "Headquarters Location"
},
"group_by": [],
"filters": [],
"limit": 20,
"chart": "none"
}
],
"also_allow": []
}Result
Answered 3 of 3 questions over 503 rows of the table, every number recomputed a second way and in agreement.
number of rows by GICS Sector (checked twice: 11 groups compared, 0 mismatches)
| GICS Sector | value |
|---|---|
| Industrials | 83 |
| Financials | 76 |
| Information Technology | 75 |
| Health Care | 60 |
| Consumer Discretionary | 47 |
| Consumer Staples | 34 |
| Utilities | 31 |
| Real Estate | 30 |
| Materials | 24 |
| Communication Services | 22 |
| Energy | 21 |
number of rows by year of Date added (checked twice: 58 groups compared, 0 mismatches), first 12 of 58
| year | value |
|---|---|
| 1957 | 52 |
| 1964 | 1 |
| 1965 | 2 |
| 1969 | 2 |
| 1970 | 2 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 10 |
| 1978 | 1 |
| 1979 | 1 |
number of distinct Headquarters Location (checked twice: 1 groups compared, 0 mismatches)
| value |
|---|
| 250 |
Checks: 3 of 3 passed
- companies_by_sector: number of rows by GICS Sector: Industrials: 83; recomputed exactly, 11 group(s) agree.
- added_by_year: number of rows by year of Date added: 1957: 52; recomputed exactly, 58 group(s) agree.
- headquarters_cities: number of distinct Headquarters Location: 250; recomputed exactly, 1 group(s) agree.
- Run
- run_e4143cdbcea6c1337e
- Depot run
- 0zb9r381xr
- Image
- images/base.Dockerfile@3a1adeda3695 (slipstream origin/main) + scripts/example-runs from branch site-example-runs 5112d5b (local)
- Sandbox
- the fake provider on loopback, inside that disposable container