I've written some queries on analyzing BTC transactions data https://sql-recipes.netlify.app/

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

Go take a look.