Bitcoin Blockchain Historical Data

### Context

Blockchain technology, first implemented by [Satoshi Nakamoto in 2009][1] as a core component of Bitcoin, is a distributed, public ledger recording transactions. Its usage allows secure peer-to-peer communication by linking blocks containing hash pointers to a previous block, a timestamp, and transaction data. Bitcoin is a decentralized digital currency (cryptocurrency) which leverages the Blockchain to store transactions in a distributed manner in order to mitigate against flaws in the financial industry.

Nearly ten years after its inception, Bitcoin and other cryptocurrencies experienced an explosion in popular awareness. The value of Bitcoin, on the other hand, has experienced more volatility. Meanwhile, as use cases of Bitcoin and Blockchain grow, mature, and expand, hype and controversy have swirled.

### Content

In this dataset, you will have access to information about blockchain blocks and transactions. All historical data are in the `bigquery-public-data:crypto_bitcoin` dataset. It’s updated it every 10 minutes. The data can be joined with historical prices in kernels. See available similar datasets here: https://www.kaggle.com/datasets?search=bitcoin.

## Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at `bigquery-public-data.crypto_bitcoin.[TABLENAME]`. **[Fork this kernel to get started][2]**.

### Method & Acknowledgements

Allen Day ([Twitter][3] | [Medium][4]), Google Cloud Developer Advocate & Colin Bookman, Google Cloud Customer Engineer retrieve data from the Bitcoin network using a [custom client available on GitHub][5] that they built with the [`bitcoinj`][6] Java library. Historical data from the origin block to 2018-01-31 were loaded in bulk to two BigQuery tables, blocks_raw and transactions. These tables contain fresh data, as they are now appended when new blocks are broadcast to the Bitcoin network. For additional information visit the Google Cloud Big Data and Machine Learning Blog post ["Bitcoin in BigQuery: Blockchain analytics on public data"][7].

Photo by [Andre Francois][8] on [Unsplash][9].

### Inspiration

* How many bitcoins are sent each day?
* How many addresses receive bitcoin each day?
* Compare transaction volume to historical prices by joining with [other available data sources][10]

[1]: https://en.wikipedia.org/wiki/Blockchain
[2]: https://www.kaggle.com/mrisdal/visualizing-daily-bitcoin-recipients
[3]: https://twitter.com/allenday
[4]: https://medium.com/@allenday
[5]: https://github.com/cobookman/blockchainToAvro
[6]: https://bitcoinj.github.io/
[7]: https://cloud.google.com/blog/big-data/2018/02/bitcoin-in-bigquery-blockchain-analytics-on-public-data
[8]: https://unsplash.com/photos/JrjhtBJ-pGU?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText
[9]: https://unsplash.com/search/photos/bitcoin?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText
[10]: https://www.kaggle.com/datasets?search=bitcoin

区块链技术，首次由 [中本聪于2009年实施][1] 作为比特币的核心组件，是一种分布式、公开的账本，记录交易信息。其应用允许通过将包含哈希指针的区块与前一区块、时间戳和交易数据相链接，实现安全的点对点通信。比特币是一种去中心化的数字货币（加密货币），利用区块链技术以分布式的方式存储交易，旨在减轻金融行业中的缺陷。

自其诞生近十年后，比特币及其他加密货币在公众认知度上经历了爆发式增长。然而，比特币的价值却表现出更大的波动性。与此同时，随着比特币和区块链用例的不断发展、成熟和扩展，炒作与争议也随之弥漫。

### 数据内容

在本数据集中，您将能够获取有关区块链区块和交易的信息。所有历史数据均位于 `bigquery-public-data:crypto_bitcoin` 数据集中，该数据集每10分钟更新一次。数据可以与历史价格在内核中进行连接。有关可用的类似数据集，请参阅此处：https://www.kaggle.com/datasets?search=bitcoin。

## 查询BigQuery表

您可以使用BigQuery Python客户端库在内核中查询此数据集中的表。请注意，内核中可用的方法仅限于查询数据。表位于 `bigquery-public-data.crypto_bitcoin.[TABLENAME]`。**[从内核中获取开始][2]**。

### 方法与致谢

艾伦·戴（[Twitter][3] | [Medium][4]），谷歌云开发者倡导者，以及科林·布克曼，谷歌云客户工程师，通过GitHub上可用的[自定义客户端][5]，使用 `bitcoinj` [6] Java库从比特币网络中检索数据。从创世区块到2018年1月31日的历史数据已批量加载到两个BigQuery表中，即 blocks_raw 和 transactions。这些表包含最新数据，因为它们会在新的区块广播到比特币网络时进行追加。有关更多信息，请访问谷歌云大数据和机器学习博客文章 ["Bitcoin in BigQuery：公共数据中的区块链分析"][7]。

照片由 [安德烈·弗朗索瓦][8] 在 [Unsplash][9] 上提供。

### 灵感

* 每天发送多少比特币？
* 每天有多少地址接收比特币？
* 通过与其他可用的数据源[10]连接，比较交易量与历史价格。

[1]: https://en.wikipedia.org/wiki/Blockchain
[2]: https://www.kaggle.com/mrisdal/visualizing-daily-bitcoin-recipients
[3]: https://twitter.com/allenday
[4]: https://medium.com/@allenday
[5]: https://github.com/cobookman/blockchainToAvro
[6]: https://bitcoinj.github.io/
[7]: https://cloud.google.com/blog/big-data/2018/02/bitcoin-in-bigquery-blockchain-analytics-on-public-data
[8]: https://unsplash.com/photos/JrjhtBJ-pGU?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText
[9]: https://unsplash.com/search/photos/bitcoin?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText
[10]: https://www.kaggle.com/datasets?search=bitcoin