This project was developed independently as a personal data engineering and analytics project — combining API integration, database management, and data visualization in Python.
It collects and analyzes Bitcoin market, on-chain, and sentiment data using public APIs. All data is stored locally in an SQLite database, processed using Python, and visualized with Plotly.
- Fetches Bitcoin market data (price, volume, market cap) from the CoinGecko API
- Retrieves sentiment data (Fear & Greed Index) from Alternative.me
- Stores all data in a local SQLite database (
btc_analysis.db) - Computes daily averages and indicators
- Generates readable reports and interactive visualizations using Plotly
- Python 3.11+ (https://img.shields.io/badge/Python-3.11+-blue)
- SQLite (Local Database) (https://img.shields.io/badge/Database-SQLite-lightgrey) – lightweight and built into Python
- DB Browser for SQLite – recommended GUI for exploring data
- APIs: CoinGecko, Alternative.me (https://img.shields.io/badge/Data-API-green)
- Libraries:
requests,pandas,plotly,humanize
-
Clone the repository
git clone https://github.com/<your-username>/BTC_ANALYSIS.git cd BTC_ANALYSIS
-
Install dependencies
pip install -r requirements.txt
-
Run the main pipeline
python btc_data_pipeline.py
The script will automatically:
- Create the SQLite database file (
btc_analysis.db) in the project folder - Create tables if they don’t exist
- Fetch and insert live data from the APIs
You can explore and query your local database visually using DB Browser for SQLite.
Steps:
- Open DB Browser for SQLite
- Go to File → Open Database… and select
btc_analysis.db - Use the Browse Data tab to inspect tables (
btc_indicators,btc_onchain, etc.) - Use the Execute SQL tab to run custom queries or test calculations
- Add on-chain metric correlation analysis (price vs. network activity)
- Migrate SQLite to a cloud-hosted MySQL database for multi-user access
- Build a Streamlit or Dash dashboard for real-time visualization
Jimmy Perron Analyst – Technical Systems | Industrial IT & Data Engineering GitHub Profile