I've written some queries on analyzing BTC transactions data here.

This is a broader project of mine to analyze many other publicly available datasets with Google's Big Query.

Go take a look.