Free Python

Use Python to Query Coinbase API to Find Available Cryptocurrencies

Mar 23, 2022 · by CryptoDataDownload

Are you trying to find out what cryptocurrencies are available on Coinbase with their API? We provide the Python code below to do this in less than 25 lines of actual code! It is extremely simple to follow along with our example. By the way, All of our code is extensively documented line by line so you know exactly what is going on! If you do end up with questions, please contact us and we are happy to respond. The Python code is ready to run right away on Python versions 3.4+

Some of the functions and steps involved include:
(1) Using the requests library to access the API endpoint
(2) Loading the API's response to a Pandas Dataframe
(3) Saving the dataframe to a CSV file

Live codebase Python

#CryptoDataDownload
# No Express Warranty
# Consult Coinbase API Terms of Service
import pandas as pd
import json
import requests

if __name__ == "__main__":
    """Simple script to query the Coinbase API and determine what cryptocurrency pairs are available.

Will Save results to a CSV file.
    """
    # Set up our variables.
    # https://docs.cloud.coinbase.com/exchange/reference/exchangerestapi_getproducts -->  DOCUMENTATION
    endpoint = 'https://api.exchange.coinbase.com/products'  # this is the coinbase API endpoint for the data
    response = requests.get(endpoint)
    if response.status_code == 200:  # checks if API says our request was OK
        data = json.loads(response.text)  # loads API data response
        # next we create and store the JSON result into a Pandas Dataframe
        data_pd = pd.DataFrame(data)
        data_pd.rename(columns={'id': 'Symbol'}, inplace=True)  # rename one column to be unix
        data_pd.sort_values('Symbol', inplace=True)   # lets sort our results alphabetically
        # Give it a filename and output our results to a CSV!
        OUTPUT_FILENAME = "Coinbase_Available_Tradeable_Products.csv"
        data_pd.to_csv(OUTPUT_FILENAME, index=False)
    else:
        print(f"Oops. Bad Response from server. \n {response.status_code}")  # display our error message

Notice: Information contained herein is not and should not be construed as an offer, solicitation, or recommendation to buy or sell securities. The information has been obtained from sources we believe to be reliable; however no guarantee is made or implied with respect to its accuracy, timeliness, or completeness. Author does not own the any crypto currency discussed. The information and content are subject to change without notice. CryptoDataDownload and its affiliates do not provide investment, tax, legal or accounting advice.

This material has been prepared for informational purposes only and is the opinion of the author, and is not intended to provide, and should not be relied on for, investment, tax, legal, accounting advice. You should consult your own investment, tax, legal and accounting advisors before engaging in any transaction. All content published by CryptoDataDownload is not an endorsement whatsoever. CryptoDataDownload was not compensated to submit this article. Please also visit our Privacy policy; disclaimer; and terms and conditions page for further information.

THE PERFORMANCE OF TRADING SYSTEMS IS BASED ON THE USE OF COMPUTERIZED SYSTEM LOGIC. IT IS HYPOTHETICAL. PLEASE NOTE THE FOLLOWING DISCLAIMER. CFTC RULE 4.41: HYPOTHETICAL OR SIMULATED PERFORMANCE RESULTS HAVE CERTAIN LIMITATIONS. UNLIKE AN ACTUAL PERFORMANCE RECORD, SIMULATED RESULTS DO NOT REPRESENT ACTUAL TRADING. ALSO, SINCE THE TRADES HAVE NOT BEEN EXECUTED, THE RESULTS MAY HAVE UNDER-OR-OVER COMPENSATED FOR THE IMPACT, IF ANY, OF CERTAIN MARKET FACTORS, SUCH AS LACK OF LIQUIDITY. SIMULATED TRADING PROGRAMS IN GENERAL ARE ALSO SUBJECT TO THE FACT THAT THEY ARE DESIGNED WITH THE BENEFIT OF HINDSIGHT. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFIT OR LOSSES SIMILAR TO THOSE SHOWN. U.S. GOVERNMENT REQUIRED DISCLAIMER: COMMODITY FUTURES TRADING COMMISSION. FUTURES AND OPTIONS TRADING HAS LARGE POTENTIAL REWARDS, BUT ALSO LARGE POTENTIAL RISK. YOU MUST BE AWARE OF THE RISKS AND BE WILLING TO ACCEPT THEM IN ORDER TO INVEST IN THE FUTURES AND OPTIONS MARKETS. DON’T TRADE WITH MONEY YOU CAN’T AFFORD TO LOSE. THIS IS NEITHER A SOLICITATION NOR AN OFFER TO BUY/SELL FUTURES OR OPTIONS. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFITS OR LOSSES SIMILAR TO THOSE DISCUSSED ON THIS WEBSITE. THE PAST PERFORMANCE OF ANY TRADING SYSTEM OR METHODOLOGY IS NOT NECESSARILY INDICATIVE OF FUTURE RESULTS.