History: keep every version

An UPDATE forgets what was true before. Keep a row per version instead: ask what anything cost on any date, and let the database keep exactly one current price.

Checking your access…