Vantage Points

Recall that Yahoo Finance’s CSV exports stopped working in the middle of Problem Set 7, and so we distributed a newer version of helpers.py that queries Alpha Vantage’s API instead. Per the API’s documentation, not only does Alpha Vantage provide data in CSV format (like Yahoo once did), it also provides data in JSON format.

Answer the below in vantage.md.

Questions

5.1 (1 point)

In no more than two sentences, what’s one advantage that CSV offers over JSON, independent of Alpha Vantage’s own API?

5.2 (1 point)

In no more than two sentences, what’s one advantage that JSON offers over CSV, independent of Alpha Vantage’s own API?

5.3 (1 point)

Via what URL could you download Netflix’s latest close price (among other values) from Alpha Vantage’s TIME_SERIES_INTRADAY API in CSV format, using an interval of 1min? Assume that your apikey is NAJXWIA8D6VN6A3K. And recall that Netflix’s symbol is NFLX.

5.4 (2 points)

In no more than two sentences, critique the design of the TIME_SERIES_INTRADAY API’s JSON format, as seen in https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=1min&apikey=demo, identifying one way in which it could be improved. Be sure to explain your reasoning.

Debrief

  1. Which resources, if any, did you find helpful in answering this problem’s questions?

  2. About how long, in minutes, did you spend on this problem’s questions?