Clues to our planet’s dramatic past are in the layers of rocks we might overlook. A great guide shows why they deserve our attention, says James Dinneen