crypto-etl-analytics-core

Skill by ara.so — Data Skills collection

A foundational data engineering pipeline and object-oriented analytics library for cryptocurrency market data. This project demonstrates pure Python financial calculations (without Pandas/NumPy) using MySQL as the data warehouse, OHLCV candlestick objects, and computed metrics like returns, drawdowns, and volatility.

What It Does

• ETL Pipeline: Extracts crypto price data, transforms via staging tables, loads into strict MySQL schema
• Data Validation: Enforces integrity constraints (no negative volumes, valid wicks, chronological order)
• OOP Design: Encapsulates OHLCV data in Candle objects with built-in validation
• Financial Analytics: Calculates simple/log returns, drawdowns, rolling volatility without external math libraries
• Visualization: Generates matplotlib charts for price action and computed metrics

Installation