I think you would need two separate object types, one that has the full change history where the primary key might be something like store name + start date, and then one that just has the latest store details, where the primary key would just be the store name.