spb/firc0001_uqo

Public

33commits
2branches
0releases
6.2 MBon disk
maindefault branch
23 h agolast push

Thu, Nov 5, 2026 5

N13: export_stats.py (L1 revision) re-run read-only on M3U96b; 26/28 baseline CSV byte-identical, 2 identical up to tie order; stats.json 41 keys + 4 new exports

…

Items: FIRC0001-AI_C-11 DATA-01 DATA-08 ECON-09 ECON-13 EDIT-14 EDIT-17 THEO-13.
44 s; cross-checks vs the audits agree (gate 703,737; backfill 154,964 / 1,070; outage 5.25 h; 0.600 count 3,278; MD&A median 9,905; annual_panel 2,499).
Flagged for the owner of export_stats.py: amount_raw_deviations 0 (NULL-blind <>, should be 584), october_wall_clock_hours 22.05 / 16.0 per s
(measured from the backfill timestamp; 13.68 h / 31.9 rows/s), sp500_run.sections_logged 4,271 (should be 153,894); non-deterministic row order in two dumps.

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

Simon-Pierre Boucher yesterday · 5 files +407 −19

N10: universe artefacts shipped with SHA-256; holdings CSV / company_tickers.json not archived; 2,573 -> 2,555 reconciled; missing filings; annual_panel = 2,499 CIKs

…

Items: FIRC0001-ADVE-15 AI_C-12 DATA-01 ECON-10 EDIT-16 LITE-09 THEO-14 (THEO-07, ECON-18).
data/metadata/{universe,russell3000_constituents,sp500_constituents}.json + SHA256SUMS; 18 dual-class CIKs explain 2,573 lines -> 2,555 CIKs;
7 unmatched tickers absent from ticker_to_cik (10,430 entries); 2,587 and the 14/21 drop counts not reconstructible;
2 filings missing on disk (XEL 10-K 2014, LNT 10-Q 2012) + 14 parse errors; annual_panel/quarterly_panel carry 2,499 CIKs (paper: 2,501).

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

Simon-Pierre Boucher yesterday · 4 files +68,281

L1 (follow-up): figure PNGs written by make_tables.py (dpi documented input) — orphan PNGs of FIRC0001-DATA-15 now generated
…
```
Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>
```
Simon-Pierre Boucher yesterday · 1 file +5

L1: de-literalise make_tables.py/export_stats.py; generated notes, macros (numbers.tex), prompt/regex from the snapshot, Table 12 longtable, figures (integer ticks, y from 0, per-issuer panel); stats.json never rewritten

…

Items: FIRC0001-AI_C-11, FIRC0001-ECON-09, FIRC0001-EDIT-17, FIRC0001-DATA-15, FIRC0001-ECON-13, FIRC0001-EDIT-14, FIRC0001-ADVE-13, FIRC0001-DATA-10, FIRC0001-EDIT-23, FIRC0001-ADVE-16, FIRC0001-AI_C-17, FIRC0001-ECON-18, FIRC0001-LITE-12, FIRC0001-DATA-01, FIRC0001-THEO-13; L2/L3 fragments: FIRC0001-ADVE-10, FIRC0001-AI_C-10, FIRC0001-DATA-06, FIRC0001-ECON-07, FIRC0001-EDIT-13, FIRC0001-LITE-08, FIRC0001-THEO-11, FIRC0001-THEO-12, FIRC0001-AI_C-15, FIRC0001-DATA-07, FIRC0001-EDIT-21, FIRC0001-AI_C-16, FIRC0001-EDIT-22, FIRC0001-EDIT-24, FIRC0001-LITE-07, FIRC0001-ADVE-06.
export_stats.py edited only (run by N13 on M3U96b): run parameters from logs/ledger, new keys and dumps, read_only + threads=4.

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

Simon-Pierre Boucher yesterday · 3 files +46

FIRC-0001 v1.0 (2026-10-28): Russell 3000 Strategic Project Database — baseline import before peer review

Simon-Pierre Boucher yesterday · 29 files +447