Is the heatwave almost over?

After a hot, humid week and recent thunderstorms, are we in for a cooler spell of weather?