An automated data analytics pipeline designed to extract, parse, and format live blockchain market data into business-ready spreadsheets.
This tool upgrades standard API fetching by implementing a multi-target extraction loop. It queries the CoinGecko API for specific financial metrics across multiple digital assets simultaneously. Once the JSON payload is parsed, the engine utilizes Python's built-in csv library to automatically generate a cleanly formatted .csv report containing the targets' Price, 24-Hour Volume, and Market Capitalization.
- Data Pipeline Engineering: Automating the flow of data from a raw REST API endpoint to a formatted local file.
- JSON to CSV Conversion: Structuring nested dictionary data (
.items()) into readable spreadsheet rows and columns. - Batch Processing: Using string manipulation (
.join) to query multiple assets in a single, efficient HTTP request. - File Handling: Securely opening, writing, and formatting local system files (
mode="w").
- Python 3
requests(API Integration)csv(Data Export & Formatting)