This repository contains code and instructions for analyzing the Bitcoin Cash blockchain using Google Cloud tools. The project materializes a staging table from the transactions raw table, selects the last three months of data from it, and materializes a data mart table that gives the current balance for all addresses and excludes addresses that had at least one transaction on Coinbase. Finally, a graph is plotted that shows the amount of daily transactions over time. I was made during a challenge provided by Astrafy.
To run this project, you will need a Google Cloud account and access to the Bitcoin Cash dataset on BigQuery.
- Clone this repository to your local machine using :
git clone https://github.com/AlexisGuillotin/Bitcoin-Cash-Challenge- Create a new Google Cloud project
- Use dbt cloud to materialize the two tables mentioned above.
- Open the bitcoin-cash-graph.ipynb notebook using Google Colab.
- Follow the instructions in the notebook to plot the chart of daily transactions.
Before running this project, you need to have the following:
- A Google Cloud account with billing enabled
- Access to the Bitcoin Cash dataset on BigQuery
- Python 3.x installed
- Jupyter Notebook or Google Colab installed
The following Python libraries are required to run this project:
- pandas
- matplotlib
- seaborn
- bigquery
You can install these libraries using pip:
pip install pandas matplotlib seabornTo run this project, follow the steps in the Getting Started section above.
Alexis Guillotin
This project is licensed under the GPL-3.0 license - see the LICENSE file for details.