Another option that I prefer, when you expect to update the data with regular intervals, is to add another column with a timestamp and simply create a new copy

Another option that I prefer, when you expect to update the data with regular intervals, is to add another column with a timestamp and simply create a new copy of the table contents with the updated data for a new timestamp. That way you can always go back in time. And storage is often cheap.