Weapons, a horror movie about the disappearance of a group of children, has topped the North American box office in its opening weekend.