A 10-second piece of footage of President John F Kennedy's motorcade speeding towards hospital after he was shot in 1963 has been sold at auction.