A meteor was reported to have lit up skies over Massachusetts and other US states and was captured on a residential CCTV camera.