Bitcoin blockchain in BigQuery

Two BigQuery tables covering the chain, one row per block and one per transaction, with each transaction's inputs and outputs nested alongside their addresses, script, type and value, plus views that flatten them. Google's public dataset program hosts it, loaded by the open source Blockchain ETL pipeline from a node. Useful for SQL analysis of the whole chain without running an indexer; querying needs a Google Cloud project.

Category
Transactions
Format
CSV, JSON Lines, Parquet
Period
2009-01-03 – present
License
Not specified (bitcoin-etl extraction code is MIT)
Author
Google Cloud Public Dataset Program
Tags
Links