Automated pipeline for the collection and filtering of crypto tokens MEXC

Developed a scalable Python pipeline for the automatic collection, filtering, and enrichment of data on crypto tokens from the MEXC exchange for further use in outreach campaigns.

- Collected a complete list of active spot tokens from MEXC via API
- Implemented aggregation of trading volumes at the token level (combining all pairs)
- Introduced a filter: only tokens with a 24h volume < 200,000 USD remain
- Added "exchange footprint" verification through external sources (CoinGecko / CoinMarketCap)
- Implemented logic for counting unique exchanges (CEX + DEX), excluding duplicate pairs
- Only tokens with ≤ 5 unique exchanges remain
- Conducted data enrichment: website, list of exchanges, Telegram, Twitter/X
- Built an export system into two files:
- final list of relevant tokens
- complete audit with reasons for rejection
- Ensured the absence of duplicates and correct validation of all fields
- Implemented a reproducible pipeline for regular data updates

As a result, the client received a ready-made system for finding low-listed tokens with low liquidity, suitable for automated outreach, without manual data processing.

Technologies:
- Python,
- REST API (MEXC, CoinGecko, CoinMarketCap),
- pandas,
- asyncio,
- Google Sheets integration