Uncover find out how to leverage public knowledge to research Bitcoin transactions, UTXOs, and coin age
The Bitcoin blockchain isn’t only a buzzword; it’s a publicly accessible ledger stuffed with helpful knowledge, simply ready to be explored. As a result of it’s open to all, we have now the distinctive capability to straight faucet into and question the very coronary heart of the Bitcoin community.
There are lots of alternative ways to do it, nonetheless, my most popular method is utilizing a public dataset in Google BigQuery.
SELECT COUNT(*) as transactionsFROM `bigquery-public-data.crypto_bitcoin.transactions`
There’s just a little catch although, BigQuery is simply free as much as 1TB of information learn, and the present measurement of the transactions desk is 2TB (as of Feb. twenty fifth, 2025). Take into account this truthful warning as some warning is required to keep away from incurring prices one may not count on.
Now, BigQuery’s pricing could be a little scary when coping with such a big dataset. To keep away from any sudden payments, right here’s a trick I’ve used: I export all the transactions desk from BigQuery to Google Cloud Storage (GCS). The fantastic thing about that is that exporting out of BigQuery is totally free! Plus, I reserve it as…
