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