Welcome to Progyny's Engineering technical assessment challenge! Please read the instructions below, and once your ready to begin fork the repo to your personal GitHub account to complete the assignment.

To execute the code, Launch the docker container, and then run main.py once and will log transactions every hour.

python3 main.py

Cryptocurrencies are on the rise, and we want to get in on the action. Let's build a bot that watches the prices of certain coins and their prices, and places trades for us when they hit certain levels.

• Write an python application that will hit an API to get the top 3 cryptocurrency coins based on current market cap. (Please note the API call to get this data is in crypto_api.py).
• Store these results in a database table. (Please design this table as well as inserting records into it. The primary fields to include are the symbol, name and current price, but feel free to include any other data you believe is relevant). Please utilize MySQL or a similar relational database. (A MySQL docker container has been provided but you are welcome to use a similar one if so desired)
• Compare each coin and it's current price (in USD) against the average of the last 10 prices on a daily interval (Please note the API call to get this data is in crypto_api.py)
  • If the current price is lower than the average price, place an order for "1 coin" and assume it was filled at the current price. (Please use the fake function submit_order to mock this trade, there is no real network request to place a trade)
  • If the current price is equal to or higher than the average price, do nothing and move onto the next coin
• Log the results of the trades (if any were made)
• Log the results of our current portfolio (coins owned and percentage loss/gain on each one. Round the percentage to 2 decimal places.)
• When logging the results, make sure the information appears both in the console and an app.log file located at storage/logs/app.log
• This application should be scheduled to run every hour.

Be prepared to present your solutions and cover the following items:

• Submit you code for review via a public repo on your GitHub account (If you would like to make it private let us know and we can provide usernames to add for read access)
• Include some instructions on how to run it
• A technical walkthrough of the code and how it works
• Answer potential questions around design decisions
• What you would improve - this can be both from a code perspective and a business logic perspective

• Your goal with this application should be to have a working solution. If you find edge cases you believe should be handled, feel free to add some notes/comments about them instead of coding the full solution.
• Make sure you follow the local development setup steps below before writing any code.
• There is some initial python code located in app.py. You can use this as a jumping off point but if you want to reorganize how the code is structured feel free to do so.
• The docker container comes with poetry as a python dependency manager. If you need to add additional libraries, you can use this command similar to pip: poetry add. Ex. poetry add flask
• If you experience any downtime issues with the API, please contact us and we can review it & provide some additional time.

You will need the following installed on your local machine:

• Docker

Steps to get up and running

1. Copy the .env.example file to .env
2. Run make init to spin up the docker container. Note you will automatically be "ssh'ed" into the main docker container from which you can run your python code.

If you would like to access the database via a GUI such as Sequel Pro or Tableplus, you can use the following credentials:

Host: 127.0.0.1 User: docker Password: secret Database: crypto Port: 33060