I've published a couple of example StreamInsight queries, input adapters and output adapters on CodePlex.
These examples use sample stock market historical data from 2009 and show how to run StreamInsight in Explicit, Implicit and Observable mode as well as hosting it in an external process.
Link: http://streaminsightexample.codeplex.com