CoinGecko Crypto Coin Exchange Rates To CSV

rates.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

# CoinGecko Crypto Coin Exchange Rates To CSV

# Version: 1.00

# Description:
#   Get all crypto coins exchange rates in CSV file
#   Uses CoinGecko free API, no need to register

# Requirements:
#   python3
#   pip3 install pycoingecko

# Usage:
#   Run without arguments
#   Output file is rates.csv in current folder.

# Author: KrisWebDev

# Licenses:
#   MIT: https://opensource.org/licenses/MIT
#   CoinGecko API Terms of Service: https://www.coingecko.com/api_terms

import time
from pycoingecko import CoinGeckoAPI

filename_out = r'rates.csv'

cg = CoinGeckoAPI()
page = 0
mks = []

print('CoinGecko Coin Rate Crawler')

while True:
    start = time.time()
    mk = cg.get_coins_markets(vs_currency='usd',per_page=250,page=page)
    mkl = len(mk)
    if mkl > 0:
        mks += mk
    print('Page ' + str(page) + ' done: +' + str(mkl) + ' coins')
    if mkl != 250:
        break
    page += 1
    end = time.time()
    wait = max(0,start+1-end)
    time.sleep(wait) # API query rate limiter: Wait 1 second between API requests, including loop execution time

print('Crawl done: Total', len(mks), 'coins')

with open(filename_out,'w') as file_out:
    for item in mks:
        file_out.write(item['symbol'] + ';' + str(item['current_price']) + '\n')

    print('Rates written to '+filename_out)