Glossary
Point-in-time data
Data stored as it was known on each past date, with later revisions, additions and removals kept apart.
Point-in-time data records what was known on each date: the index members of that day, accounting figures before later restatement, and securities that traded then. A table that holds only the latest version of history uses facts that were not available at the time, so past decisions look better informed than they were.
Check that every record has the date it became known, not only the date it refers to.
Example: a company reports a profit of 100 for a quarter in April and restates it to 80 in October. A test run in June must see 100, not 80.