A read-only view of the Postgres database in data/: exchange-listed securities and their identifiers, SEC Form N-PORT portfolio holdings, and a hand-curated classification taxonomy — plus the two bridges that connect a fund series to something you can actually buy.
meta.load_run — first stop when a number looks wrong
| Started | Source | Status | Fetched | Ins / Upd | Failed |
|---|---|---|---|---|---|
| 2026-08-14 20:49 | massive:/v3/reference | SUCCESS | 13,106 | 0 / 0 | 0 |
| 2026-08-14 20:42 | massive:/v3/reference | SUCCESS | 13,106 | 7,597 / 0 | 0 |
| 2026-08-14 16:29 | massive:/v3/reference | SUCCESS | 5,509 | 0 / 0 | 0 |
| 2026-08-14 16:23 | massive:/v3/reference | SUCCESS | 5,509 | 5,458 / 0 | 0 |
| 2026-08-14 16:23 | massive:/v3/reference | SUCCESS | 51 | 0 / 0 | 0 |
| 2026-08-14 16:23 | massive:/v3/reference | SUCCESS | 51 | 51 / 0 | 0 |
Assignments by asset class
The crosswalk that turns a filed position into a master security
Active securities by venue and type, with per-field fill rates
| Venue | Type | Count | Enriched | CIK | FIGI |
|---|---|---|---|---|---|
| NASDAQ | CS | 3,331 | 100% | 100% | 74% |
| NYSE | ETF | 2,521 | 100% | 75% | 100% |
| NYSE | CS | 1,988 | 100% | 100% | 87% |
| Cboe | ETF | 1,590 | 100% | 61% | 100% |
| NASDAQ | ETF | 1,257 | 100% | 62% | 100% |
| NASDAQ | WARRANT | 378 | 100% | 99% | 41% |
| NYSE | PFD | 357 | 100% | 100% | 0% |
| NYSE | FUND | 329 | 100% | 100% | 100% |
| NASDAQ | UNIT | 249 | 100% | 99% | 2% |
| NASDAQ | ADRC | 189 | 100% | 99% | 98% |
| NYSE | ADRC | 187 | 100% | 99% | 100% |
| NYSE | SP | 159 | 100% | 100% | 0% |
| NYSE | ETS | 111 | 100% | 41% | 100% |
| NASDAQ | RIGHT | 101 | 100% | 98% | 6% |
| NYSE | ETV | 90 | 100% | 100% | 99% |
| NASDAQ | PFD | 73 | 100% | 88% | 0% |
| NYSE | WARRANT | 65 | 100% | 100% | 42% |
| NYSE | UNIT | 58 | 100% | 100% | 16% |
| NYSE | ETN | 51 | 100% | 98% | 100% |
| NYSE | RIGHT | 18 | 100% | 100% | 11% |
| NASDAQ | FUND | 3 | 100% | 100% | 100% |
| Cboe | CS | 1 | 100% | 100% | 100% |
| 22 venue × type combinations | 13,106 | ||||
How much of the master can be reached from a fund series, and vice versa
What the N-PORT load actually contains, month by month
| Report date | Filings | Funds | Positions | |
|---|---|---|---|---|
| 2026-05-31 | 3 | 3 | 109 | |
| 2026-04-30 | 4,146 | 3,994 | 1,330,256 | |
| 2026-03-31 | 6,894 | 6,351 | 2,418,385 | |
| 2026-02-28 | 2,490 | 2,414 | 1,309,477 | |
| 2026-02-27 | 197 | 174 | 66,070 | |
| 2026-01-31 | 417 | 410 | 80,743 | |
| 2026-01-30 | 14 | 10 | 2,835 | |
| 2025-12-31 | 52 | 49 | 17,099 | |
| 2025-11-30 | 94 | 87 | 35,936 | |
| 2025-11-28 | 4 | 4 | 3,082 | |
| 2025-10-31 | 24 | 24 | 19,592 | |
| 2025-09-30 | 22 | 22 | 14,599 | |
| 2025-08-31 | 3 | 3 | 212 | |
| 2025-08-29 | 3 | 3 | 248 |