Skip to content
TheChatArchiveThe Chat Archive
Human-written demonstration (OpenAssistant volunteers)· OpenAssistant (human-written)Hugging Face OpenAssistant Conversations (oasst2)

write python to store data from coinbase api in sqlite database using sqlalchemy

In OpenAssistant data, “assistant” turns were written by human volunteers as demonstrations. They are not model outputs.
  1. User

    write python to store data from coinbase api in sqlite database using sqlalchemy

  2. Assistant

    Sure! Here's an example Python script that retrieves data from the Coinbase API and stores it in a SQLite database using the SQLAlchemy library:

    import requests
    import json
    from sqlalchemy import create_engine, Column, Integer, Float, String
    from sqlalchemy.ext.declarative import declarative_base
    from sqlalchemy.orm import sessionmaker
    
    # Define the SQLAlchemy engine and session
    engine = create_engine('sqlite:///coinbase.db')
    Session = sessionmaker(bind=engine)
    Base = declarative_base()
    
    # Define the class that will map to the database table
    class Trade(Base):
        __tablename__ = 'trades'
    
        id = Column(Integer, primary_key=True)
        price = Column(Float)
        size = Column(Float)
        time = Column(String)
    
    # Define the Coinbase API URL and parameters
    url = 'https://api.coinbase.com/v2/trades/BTC-USD'
    params = {'limit': 10}
    
    # Make a request to the Coinbase API and parse the JSON response
    response = requests.get(url, params=params)
    trades = json.loads(response.text)['data']
    
    # Create a new session and add the trades to the database
    session = Session()
    for trade in trades:
        new_trade = Trade(
            price=float(trade['price']),
            size=float(trade['size']),
            time=trade['time']
        )
        session.add(new_trade)
    session.commit()
    
    # Query the database and print the trades
    trades = session.query(Trade).all()
    for trade in trades:
        print(f"Trade: {trade.id}, Price: {trade.price}, Size: {trade.size}, Time: {trade.time}")
    

    This script defines a Trade class that maps to a database table, uses the requests library to make a request to the Coinbase API, and stores the retrieved data in the trades table using the SQLAlchemy Session object. Finally, the script queries the database and prints the trades. You can customize this script to retrieve data for different currencies and time intervals, as well as modify the Trade class to include additional columns as needed.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.