BrainTrust Investment Lab › SS5 — Error Event Schema › prices
BrainTrust Investment Lab

prices — the SS5 walk

The daily tape — 13.6 million closing prices and the bars behind them. The last close is what everything else revolves around, so this lane is measured before anything downstream is allowed to lean on it.

One source per sheet; every step CERTIFIED or OWED by BrainTrust Staff, matched against the book’s page.

steps certified
8 of 8
step schema · the star EXISTS, measured against Figure 19-1 -- and its DDL of record is named ✓ CERTIFIED · p.458
step screen_dim · every declared screen has ONE dimension row -- closed BOTH directions against… ✓ CERTIFIED · p.459
step batch · the run is ONE batch row, and the batch ENDS ✓ CERTIFIED · p.458
step date_key · the calendar date RESOLVES -- to a dimension that exists ✓ CERTIFIED · p.458-459
step grain · EXACTLY ONE ROW PER ERROR THROWN -- and every counted defect has its row ✓ CERTIFIED · p.458
step detail_grain · the LOWER grain -- one field, in one record, per detail row ✓ CERTIFIED · p.459-460
step populate · THIS LANE'S SCREENS WRITE -- in THIS run, by a writer that exists ✓ CERTIFIED · p.460
step tables · the lane's tables measured ✓ CERTIFIED · p.[house]