◈

fetch_top100_coingecko

Data PipelineDataCoinGecko

INSTALLATION

$python -c "exec(open('fetch_top100_coingecko.py').read())"

#or paste directly into your Claude Code terminal

[ ABOUT ]

Retrieves the top 100 cryptocurrencies sorted by market capitalization from CoinGecko's markets endpoint. Returns a list of coin dictionaries containing market cap rank, current price, 24-hour price change, image URL, and coin ID — all fields used by the MCPTrade coin_analysis Supabase table.

Market cap ordering is dynamic — coins move in and out of the top 100 daily. Run this function at the start of each batch analysis session to get a fresh list before fetching individual OHLCV data. The `coin_id` field in each result maps directly to the `coin_id` parameter accepted by `fetch_ohlcv_coingecko`.

[ USAGE EXAMPLE ]

example.py

coins = fetch_top100()
ids = [c["id"] for c in coins]
# → ["bitcoin", "ethereum", "tether", ...]

[ FULL CODE ]

fetch_top100_coingecko.py

def fetch_top100(): url = "https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc&per_page=100&page=1" return requests.get(url).json()

[ METADATA ]

CategoryData Pipeline

ComplexityIntermediate

LanguagePython 3.10+

TagsData, CoinGecko

[ ASK CLAUDE ]

Ask AI about this skill before installing it.

[ RELATED SKILLS ]

fetch_ohlcv_coingecko

Fetch OHLCV data for any coin from CoinGecko API

data

cache_to_supabase

Store Claude analysis results to Supabase PostgreSQL database

data

run_batch_analysis

Process all 100 coins in parallel and aggregate analysis results

data