Video
Pre-rendered video and audio is normally played via the FFmpeg Producer directly from the file system.
An alternative is to embed audio and/or video in an FT file and play with the Flash Producer.
Video Codecs
The FFmpeg Producer can play all the codecs that FFmpeg supports.
Sample Videos
The CasparCG download page has links to several packages with sample video files.