Agent skill · data analytics · aradotso
crypto-etl-analytics-core
End-to-end Python and MySQL data engineering pipeline with OOP analytics library for cryptocurrency price data
Why this skill is useful
Adds a complete ETL pipeline and OOP analytics library for cryptocurrency data that includes specific MySQL schema and financial calculations not commonly found in public resources.
What it needs
Requires matplotlib, mysql-connector-python installed locally. About 6k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
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 Database Setup 1. Execute the schema creation script in your MySQL instance: 2. Create environment variables for database credentials: Core Architecture 1. Database Schema The crypto1dcandles table enforces strict data integrity: 2. Candle Object (OOP Model) The core data structure encapsulating OHLCV data: 3. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/crypto-etl-analytics-core