The missile launch and nuclear explosion I picked up from the Pond5.com web site for royalty free HD stock footage. Their prices are cheaper than other web sites and they have good variety. One of the big considerations for shooting in HD is the availability of science fiction stock footage and stock after effects stuff that is available over RED.
If anyone can give us links to stock footage for science fiction stuff in RED, please share. Science Fiction in HD is easy on Google. Pond5.com is a good resource with great pricing.