Then transcoding to 640x360 using an iPod preset in Compressor. You could also use MPEG Streamclip (free app) for this.
The resulting file is a small MP4 file using the H.264 codec.
Keep in mind that the biggest influence on the final compressed file is definitely the original footage. If you start with great looking video, it's easier to end with great looking video.