Uncover easy methods to leverage public knowledge to investigate Bitcoin transactions, UTXOs, and coin age
The Bitcoin blockchain isn’t only a buzzword; it’s a publicly accessible ledger filled with invaluable knowledge, simply ready to be explored. As a result of it’s open to all, we now have the distinctive capacity to immediately faucet into and question the very coronary heart of the Bitcoin community.
There are a lot of other ways to do it, nonetheless, my most popular means is utilizing a public dataset in Google BigQuery.
SELECT
COUNT(*) as transactions
FROM `bigquery-public-data.crypto_bitcoin.transactions`
There’s a bit of catch although, BigQuery is simply free as much as 1TB of knowledge learn, and the present measurement of the transactions desk is 2TB (as of Feb. twenty fifth, 2025). Think about this honest warning as some warning is required to keep away from incurring prices one won’t count on.
Now, BigQuery’s pricing is usually a little scary when coping with such a big dataset. To keep away from any surprising payments, right here’s a trick I’ve used: I export all the transactions desk from BigQuery to Google Cloud Storage (GCS). The great thing about that is that exporting out of BigQuery is totally free! Plus, I put it aside as…