API_alphavantage.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "API_alphavantage.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "xwBys8ohQraR",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import csv\n",
        "import requests\n",
        "import json"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZfSxbQ6_KQ8H",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "response = requests.get(\"https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=8601.T&apikey=ＡＰＩキー\")\n",
        "data = json.loads(response.text)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rx2S86EzPmNo",
        "colab_type": "code",
        "outputId": "b21a4aa4-161e-497c-ae8f-a01891080c49",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "data"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'Meta Data': {'1. Information': 'Monthly Prices (open, high, low, close) and Volumes',\n",
              "  '2. Symbol': '8601.T',\n",
              "  '3. Last Refreshed': '2019-12-03',\n",
              "  '4. Time Zone': 'US/Eastern'},\n",
              " 'Monthly Time Series': {'2000-02-29': {'1. open': '1745.0000',\n",
              "   '2. high': '2115.0000',\n",
              "   '3. low': '1661.0000',\n",
              "   '4. close': '1745.0000',\n",
              "   '5. volume': '111929000'},\n",
              "  '2000-03-31': {'1. open': '1805.0000',\n",
              "   '2. high': '1985.0000',\n",
              "   '3. low': '1517.0000',\n",
              "   '4. close': '1930.0000',\n",
              "   '5. volume': '122858000'},\n",
              "  '2000-04-28': {'1. open': '1921.0000',\n",
              "   '2. high': '1950.0000',\n",
              "   '3. low': '1432.0000',\n",
              "   '4. close': '1650.0000',\n",
              "   '5. volume': '83441000'},\n",
              "  '2000-05-31': {'1. open': '1625.0000',\n",
              "   '2. high': '1696.0000',\n",
              "   '3. low': '1166.0000',\n",
              "   '4. close': '1310.0000',\n",
              "   '5. volume': '89260000'},\n",
              "  '2000-06-30': {'1. open': '1329.0000',\n",
              "   '2. high': '1535.0000',\n",
              "   '3. low': '1310.0000',\n",
              "   '4. close': '1400.0000',\n",
              "   '5. volume': '62164000'},\n",
              "  '2000-07-31': {'1. open': '1450.0000',\n",
              "   '2. high': '1505.0000',\n",
              "   '3. low': '1116.0000',\n",
              "   '4. close': '1194.0000',\n",
              "   '5. volume': '66493000'},\n",
              "  '2000-08-31': {'1. open': '1214.0000',\n",
              "   '2. high': '1432.0000',\n",
              "   '3. low': '1150.0000',\n",
              "   '4. close': '1330.0000',\n",
              "   '5. volume': '64761000'},\n",
              "  '2000-09-29': {'1. open': '1370.0000',\n",
              "   '2. high': '1398.0000',\n",
              "   '3. low': '1215.0000',\n",
              "   '4. close': '1267.0000',\n",
              "   '5. volume': '40550000'},\n",
              "  '2000-10-31': {'1. open': '1241.0000',\n",
              "   '2. high': '1344.0000',\n",
              "   '3. low': '1192.0000',\n",
              "   '4. close': '1209.0000',\n",
              "   '5. volume': '48324000'},\n",
              "  '2000-11-30': {'1. open': '1258.0000',\n",
              "   '2. high': '1405.0000',\n",
              "   '3. low': '1133.0000',\n",
              "   '4. close': '1165.0000',\n",
              "   '5. volume': '59853000'},\n",
              "  '2000-12-29': {'1. open': '1125.0000',\n",
              "   '2. high': '1302.0000',\n",
              "   '3. low': '1067.0000',\n",
              "   '4. close': '1193.0000',\n",
              "   '5. volume': '61280000'},\n",
              "  '2001-01-31': {'1. open': '1193.0000',\n",
              "   '2. high': '1301.0000',\n",
              "   '3. low': '1098.0000',\n",
              "   '4. close': '1189.0000',\n",
              "   '5. volume': '61523000'},\n",
              "  '2001-02-28': {'1. open': '1169.0000',\n",
              "   '2. high': '1224.0000',\n",
              "   '3. low': '1028.0000',\n",
              "   '4. close': '1071.0000',\n",
              "   '5. volume': '61321000'},\n",
              "  '2001-03-30': {'1. open': '1051.0000',\n",
              "   '2. high': '1240.0000',\n",
              "   '3. low': '860.0000',\n",
              "   '4. close': '1187.0000',\n",
              "   '5. volume': '107978000'},\n",
              "  '2001-04-30': {'1. open': '1167.0000',\n",
              "   '2. high': '1417.0000',\n",
              "   '3. low': '1142.0000',\n",
              "   '4. close': '1400.0000',\n",
              "   '5. volume': '75979000'},\n",
              "  '2001-05-31': {'1. open': '1400.0000',\n",
              "   '2. high': '1480.0000',\n",
              "   '3. low': '1295.0000',\n",
              "   '4. close': '1298.0000',\n",
              "   '5. volume': '51670180'},\n",
              "  '2001-06-29': {'1. open': '1310.0000',\n",
              "   '2. high': '1329.0000',\n",
              "   '3. low': '1191.0000',\n",
              "   '4. close': '1305.0000',\n",
              "   '5. volume': '60497000'},\n",
              "  '2001-07-31': {'1. open': '1325.0000',\n",
              "   '2. high': '1338.0000',\n",
              "   '3. low': '1062.0000',\n",
              "   '4. close': '1085.0000',\n",
              "   '5. volume': '71654000'},\n",
              "  '2001-08-31': {'1. open': '1100.0000',\n",
              "   '2. high': '1182.0000',\n",
              "   '3. low': '975.0000',\n",
              "   '4. close': '1006.0000',\n",
              "   '5. volume': '70308000'},\n",
              "  '2001-09-28': {'1. open': '1015.0000',\n",
              "   '2. high': '1025.0000',\n",
              "   '3. low': '806.0000',\n",
              "   '4. close': '830.0000',\n",
              "   '5. volume': '62716000'},\n",
              "  '2001-10-31': {'1. open': '836.0000',\n",
              "   '2. high': '965.0000',\n",
              "   '3. low': '800.0000',\n",
              "   '4. close': '800.0000',\n",
              "   '5. volume': '87419000'},\n",
              "  '2001-11-30': {'1. open': '799.0000',\n",
              "   '2. high': '879.0000',\n",
              "   '3. low': '709.0000',\n",
              "   '4. close': '827.0000',\n",
              "   '5. volume': '112376000'},\n",
              "  '2001-12-31': {'1. open': '825.0000',\n",
              "   '2. high': '825.0000',\n",
              "   '3. low': '679.0000',\n",
              "   '4. close': '689.0000',\n",
              "   '5. volume': '89906000'},\n",
              "  '2002-01-31': {'1. open': '689.0000',\n",
              "   '2. high': '745.0000',\n",
              "   '3. low': '579.0000',\n",
              "   '4. close': '597.0000',\n",
              "   '5. volume': '90450000'},\n",
              "  '2002-02-28': {'1. open': '617.0000',\n",
              "   '2. high': '835.0000',\n",
              "   '3. low': '512.0000',\n",
              "   '4. close': '811.0000',\n",
              "   '5. volume': '168257000'},\n",
              "  '2002-03-29': {'1. open': '801.0000',\n",
              "   '2. high': '947.0000',\n",
              "   '3. low': '760.0000',\n",
              "   '4. close': '768.0000',\n",
              "   '5. volume': '141766000'},\n",
              "  '2002-04-30': {'1. open': '770.0000',\n",
              "   '2. high': '903.0000',\n",
              "   '3. low': '739.0000',\n",
              "   '4. close': '881.0000',\n",
              "   '5. volume': '81394000'},\n",
              "  '2002-05-31': {'1. open': '900.0000',\n",
              "   '2. high': '1009.0000',\n",
              "   '3. low': '798.0000',\n",
              "   '4. close': '913.0000',\n",
              "   '5. volume': '181374000'},\n",
              "  '2002-06-28': {'1. open': '913.0000',\n",
              "   '2. high': '957.0000',\n",
              "   '3. low': '710.0000',\n",
              "   '4. close': '777.0000',\n",
              "   '5. volume': '138443000'},\n",
              "  '2002-07-31': {'1. open': '784.0000',\n",
              "   '2. high': '842.0000',\n",
              "   '3. low': '618.0000',\n",
              "   '4. close': '643.0000',\n",
              "   '5. volume': '161785000'},\n",
              "  '2002-08-30': {'1. open': '643.0000',\n",
              "   '2. high': '654.0000',\n",
              "   '3. low': '573.0000',\n",
              "   '4. close': '616.0000',\n",
              "   '5. volume': '114317000'},\n",
              "  '2002-09-30': {'1. open': '608.0000',\n",
              "   '2. high': '696.0000',\n",
              "   '3. low': '546.0000',\n",
              "   '4. close': '672.0000',\n",
              "   '5. volume': '139928000'},\n",
              "  '2002-10-31': {'1. open': '642.0000',\n",
              "   '2. high': '658.0000',\n",
              "   '3. low': '524.0000',\n",
              "   '4. close': '572.0000',\n",
              "   '5. volume': '138522000'},\n",
              "  '2002-11-29': {'1. open': '569.0000',\n",
              "   '2. high': '604.0000',\n",
              "   '3. low': '411.0000',\n",
              "   '4. close': '561.0000',\n",
              "   '5. volume': '155878000'},\n",
              "  '2002-12-31': {'1. open': '561.0000',\n",
              "   '2. high': '561.0000',\n",
              "   '3. low': '490.0000',\n",
              "   '4. close': '527.0000',\n",
              "   '5. volume': '84160000'},\n",
              "  '2003-01-31': {'1. open': '527.0000',\n",
              "   '2. high': '618.0000',\n",
              "   '3. low': '505.0000',\n",
              "   '4. close': '568.0000',\n",
              "   '5. volume': '117980000'},\n",
              "  '2003-02-28': {'1. open': '558.0000',\n",
              "   '2. high': '655.0000',\n",
              "   '3. low': '558.0000',\n",
              "   '4. close': '571.0000',\n",
              "   '5. volume': '130045000'},\n",
              "  '2003-03-31': {'1. open': '572.0000',\n",
              "   '2. high': '595.0000',\n",
              "   '3. low': '485.0000',\n",
              "   '4. close': '487.0000',\n",
              "   '5. volume': '150953000'},\n",
              "  '2003-04-30': {'1. open': '490.0000',\n",
              "   '2. high': '504.0000',\n",
              "   '3. low': '432.0000',\n",
              "   '4. close': '469.0000',\n",
              "   '5. volume': '121761000'},\n",
              "  '2003-05-30': {'1. open': '470.0000',\n",
              "   '2. high': '534.0000',\n",
              "   '3. low': '461.0000',\n",
              "   '4. close': '527.0000',\n",
              "   '5. volume': '113417000'},\n",
              "  '2003-06-30': {'1. open': '540.0000',\n",
              "   '2. high': '704.0000',\n",
              "   '3. low': '539.0000',\n",
              "   '4. close': '690.0000',\n",
              "   '5. volume': '192878000'},\n",
              "  '2003-07-31': {'1. open': '693.0000',\n",
              "   '2. high': '833.0000',\n",
              "   '3. low': '667.0000',\n",
              "   '4. close': '698.0000',\n",
              "   '5. volume': '218350000'},\n",
              "  '2003-08-29': {'1. open': '711.0000',\n",
              "   '2. high': '821.0000',\n",
              "   '3. low': '641.0000',\n",
              "   '4. close': '753.0000',\n",
              "   '5. volume': '171143000'},\n",
              "  '2003-09-30': {'1. open': '773.0000',\n",
              "   '2. high': '849.0000',\n",
              "   '3. low': '755.0000',\n",
              "   '4. close': '755.0000',\n",
              "   '5. volume': '200390000'},\n",
              "  '2003-10-31': {'1. open': '755.0000',\n",
              "   '2. high': '995.0000',\n",
              "   '3. low': '743.0000',\n",
              "   '4. close': '804.0000',\n",
              "   '5. volume': '362310000'},\n",
              "  '2003-11-28': {'1. open': '804.0000',\n",
              "   '2. high': '823.0000',\n",
              "   '3. low': '639.0000',\n",
              "   '4. close': '705.0000',\n",
              "   '5. volume': '170459000'},\n",
              "  '2003-12-31': {'1. open': '675.0000',\n",
              "   '2. high': '741.0000',\n",
              "   '3. low': '634.0000',\n",
              "   '4. close': '729.0000',\n",
              "   '5. volume': '157524000'},\n",
              "  '2004-01-30': {'1. open': '729.0000',\n",
              "   '2. high': '796.0000',\n",
              "   '3. low': '705.0000',\n",
              "   '4. close': '744.0000',\n",
              "   '5. volume': '151606000'},\n",
              "  '2004-02-27': {'1. open': '731.0000',\n",
              "   '2. high': '735.0000',\n",
              "   '3. low': '653.0000',\n",
              "   '4. close': '734.0000',\n",
              "   '5. volume': '170372000'},\n",
              "  '2004-03-31': {'1. open': '750.0000',\n",
              "   '2. high': '873.0000',\n",
              "   '3. low': '749.0000',\n",
              "   '4. close': '850.0000',\n",
              "   '5. volume': '254081000'},\n",
              "  '2004-04-30': {'1. open': '865.0000',\n",
              "   '2. high': '933.0000',\n",
              "   '3. low': '818.0000',\n",
              "   '4. close': '830.0000',\n",
              "   '5. volume': '227945000'},\n",
              "  '2004-05-31': {'1. open': '830.0000',\n",
              "   '2. high': '843.0000',\n",
              "   '3. low': '683.0000',\n",
              "   '4. close': '774.0000',\n",
              "   '5. volume': '162930000'},\n",
              "  '2004-06-30': {'1. open': '769.0000',\n",
              "   '2. high': '826.0000',\n",
              "   '3. low': '721.0000',\n",
              "   '4. close': '784.0000',\n",
              "   '5. volume': '179732000'},\n",
              "  '2004-07-30': {'1. open': '791.0000',\n",
              "   '2. high': '792.0000',\n",
              "   '3. low': '713.0000',\n",
              "   '4. close': '731.0000',\n",
              "   '5. volume': '154438000'},\n",
              "  '2004-08-31': {'1. open': '739.0000',\n",
              "   '2. high': '760.0000',\n",
              "   '3. low': '672.0000',\n",
              "   '4. close': '710.0000',\n",
              "   '5. volume': '150358000'},\n",
              "  '2004-09-30': {'1. open': '720.0000',\n",
              "   '2. high': '748.0000',\n",
              "   '3. low': '673.0000',\n",
              "   '4. close': '698.0000',\n",
              "   '5. volume': '105514000'},\n",
              "  '2004-10-29': {'1. open': '693.0000',\n",
              "   '2. high': '735.0000',\n",
              "   '3. low': '640.0000',\n",
              "   '4. close': '650.0000',\n",
              "   '5. volume': '99190000'},\n",
              "  '2004-11-30': {'1. open': '647.0000',\n",
              "   '2. high': '717.0000',\n",
              "   '3. low': '640.0000',\n",
              "   '4. close': '704.0000',\n",
              "   '5. volume': '111300000'},\n",
              "  '2004-12-31': {'1. open': '694.0000',\n",
              "   '2. high': '743.0000',\n",
              "   '3. low': '684.0000',\n",
              "   '4. close': '740.0000',\n",
              "   '5. volume': '108419000'},\n",
              "  '2005-01-31': {'1. open': '740.0000',\n",
              "   '2. high': '744.0000',\n",
              "   '3. low': '686.0000',\n",
              "   '4. close': '702.0000',\n",
              "   '5. volume': '93105000'},\n",
              "  '2005-02-28': {'1. open': '698.0000',\n",
              "   '2. high': '754.0000',\n",
              "   '3. low': '678.0000',\n",
              "   '4. close': '713.0000',\n",
              "   '5. volume': '145264000'},\n",
              "  '2005-03-31': {'1. open': '713.0000',\n",
              "   '2. high': '749.0000',\n",
              "   '3. low': '694.0000',\n",
              "   '4. close': '706.0000',\n",
              "   '5. volume': '124568000'},\n",
              "  '2005-04-29': {'1. open': '707.0000',\n",
              "   '2. high': '726.0000',\n",
              "   '3. low': '650.0000',\n",
              "   '4. close': '665.0000',\n",
              "   '5. volume': '103703000'},\n",
              "  '2005-05-31': {'1. open': '666.0000',\n",
              "   '2. high': '690.0000',\n",
              "   '3. low': '641.0000',\n",
              "   '4. close': '690.0000',\n",
              "   '5. volume': '93140000'},\n",
              "  '2005-06-30': {'1. open': '680.0000',\n",
              "   '2. high': '700.0000',\n",
              "   '3. low': '663.0000',\n",
              "   '4. close': '686.0000',\n",
              "   '5. volume': '96060000'},\n",
              "  '2005-07-29': {'1. open': '687.0000',\n",
              "   '2. high': '688.0000',\n",
              "   '3. low': '650.0000',\n",
              "   '4. close': '660.0000',\n",
              "   '5. volume': '93586000'},\n",
              "  '2005-08-31': {'1. open': '659.0000',\n",
              "   '2. high': '749.0000',\n",
              "   '3. low': '646.0000',\n",
              "   '4. close': '749.0000',\n",
              "   '5. volume': '190710000'},\n",
              "  '2005-09-30': {'1. open': '762.0000',\n",
              "   '2. high': '904.0000',\n",
              "   '3. low': '725.0000',\n",
              "   '4. close': '887.0000',\n",
              "   '5. volume': '206508000'},\n",
              "  '2005-10-31': {'1. open': '888.0000',\n",
              "   '2. high': '949.0000',\n",
              "   '3. low': '810.0000',\n",
              "   '4. close': '949.0000',\n",
              "   '5. volume': '202167000'},\n",
              "  '2005-11-30': {'1. open': '959.0000',\n",
              "   '2. high': '1216.0000',\n",
              "   '3. low': '951.0000',\n",
              "   '4. close': '1169.0000',\n",
              "   '5. volume': '306545000'},\n",
              "  '2005-12-30': {'1. open': '1160.0000',\n",
              "   '2. high': '1379.0000',\n",
              "   '3. low': '1144.0000',\n",
              "   '4. close': '1337.0000',\n",
              "   '5. volume': '266339000'},\n",
              "  '2006-01-31': {'1. open': '1337.0000',\n",
              "   '2. high': '1441.0000',\n",
              "   '3. low': '1140.0000',\n",
              "   '4. close': '1377.0000',\n",
              "   '5. volume': '229251000'},\n",
              "  '2006-02-28': {'1. open': '1374.0000',\n",
              "   '2. high': '1430.0000',\n",
              "   '3. low': '1223.0000',\n",
              "   '4. close': '1400.0000',\n",
              "   '5. volume': '195641000'},\n",
              "  '2006-03-31': {'1. open': '1372.0000',\n",
              "   '2. high': '1598.0000',\n",
              "   '3. low': '1357.0000',\n",
              "   '4. close': '1579.0000',\n",
              "   '5. volume': '227756000'},\n",
              "  '2006-04-28': {'1. open': '1572.0000',\n",
              "   '2. high': '1645.0000',\n",
              "   '3. low': '1503.0000',\n",
              "   '4. close': '1579.0000',\n",
              "   '5. volume': '155598000'},\n",
              "  '2006-05-31': {'1. open': '1579.0000',\n",
              "   '2. high': '1672.0000',\n",
              "   '3. low': '1353.0000',\n",
              "   '4. close': '1378.0000',\n",
              "   '5. volume': '221955000'},\n",
              "  '2006-06-30': {'1. open': '1418.0000',\n",
              "   '2. high': '1471.0000',\n",
              "   '3. low': '1241.0000',\n",
              "   '4. close': '1364.0000',\n",
              "   '5. volume': '218143000'},\n",
              "  '2006-07-31': {'1. open': '1370.0000',\n",
              "   '2. high': '1452.0000',\n",
              "   '3. low': '1170.0000',\n",
              "   '4. close': '1281.0000',\n",
              "   '5. volume': '227320000'},\n",
              "  '2006-08-31': {'1. open': '1278.0000',\n",
              "   '2. high': '1486.0000',\n",
              "   '3. low': '1250.0000',\n",
              "   '4. close': '1399.0000',\n",
              "   '5. volume': '186642000'},\n",
              "  '2006-09-29': {'1. open': '1396.0000',\n",
              "   '2. high': '1454.0000',\n",
              "   '3. low': '1280.0000',\n",
              "   '4. close': '1378.0000',\n",
              "   '5. volume': '138934000'},\n",
              "  '2006-10-31': {'1. open': '1366.0000',\n",
              "   '2. high': '1462.0000',\n",
              "   '3. low': '1304.0000',\n",
              "   '4. close': '1327.0000',\n",
              "   '5. volume': '212296000'},\n",
              "  '2006-11-30': {'1. open': '1321.0000',\n",
              "   '2. high': '1342.0000',\n",
              "   '3. low': '1190.0000',\n",
              "   '4. close': '1327.0000',\n",
              "   '5. volume': '218280000'},\n",
              "  '2006-12-29': {'1. open': '1315.0000',\n",
              "   '2. high': '1347.0000',\n",
              "   '3. low': '1281.0000',\n",
              "   '4. close': '1335.0000',\n",
              "   '5. volume': '138681000'},\n",
              "  '2007-01-31': {'1. open': '1344.0000',\n",
              "   '2. high': '1483.0000',\n",
              "   '3. low': '1307.0000',\n",
              "   '4. close': '1476.0000',\n",
              "   '5. volume': '150058000'},\n",
              "  '2007-02-28': {'1. open': '1471.0000',\n",
              "   '2. high': '1673.0000',\n",
              "   '3. low': '1424.0000',\n",
              "   '4. close': '1501.0000',\n",
              "   '5. volume': '217353000'},\n",
              "  '2007-03-30': {'1. open': '1510.0000',\n",
              "   '2. high': '1541.0000',\n",
              "   '3. low': '1375.0000',\n",
              "   '4. close': '1423.0000',\n",
              "   '5. volume': '217998000'},\n",
              "  '2007-04-27': {'1. open': '1435.0000',\n",
              "   '2. high': '1449.0000',\n",
              "   '3. low': '1308.0000',\n",
              "   '4. close': '1347.0000',\n",
              "   '5. volume': '161843000'},\n",
              "  '2007-05-31': {'1. open': '1360.0000',\n",
              "   '2. high': '1437.0000',\n",
              "   '3. low': '1264.0000',\n",
              "   '4. close': '1401.0000',\n",
              "   '5. volume': '182529000'},\n",
              "  '2007-06-29': {'1. open': '1423.0000',\n",
              "   '2. high': '1432.0000',\n",
              "   '3. low': '1290.0000',\n",
              "   '4. close': '1313.0000',\n",
              "   '5. volume': '163127000'},\n",
              "  '2007-07-31': {'1. open': '1315.0000',\n",
              "   '2. high': '1363.0000',\n",
              "   '3. low': '1242.0000',\n",
              "   '4. close': '1274.0000',\n",
              "   '5. volume': '161453000'},\n",
              "  '2007-08-31': {'1. open': '1260.0000',\n",
              "   '2. high': '1270.0000',\n",
              "   '3. low': '1052.0000',\n",
              "   '4. close': '1148.0000',\n",
              "   '5. volume': '255413000'},\n",
              "  '2007-09-28': {'1. open': '1143.0000',\n",
              "   '2. high': '1166.0000',\n",
              "   '3. low': '967.0000',\n",
              "   '4. close': '1094.0000',\n",
              "   '5. volume': '208139000'},\n",
              "  '2007-10-31': {'1. open': '1085.0000',\n",
              "   '2. high': '1248.0000',\n",
              "   '3. low': '1052.0000',\n",
              "   '4. close': '1098.0000',\n",
              "   '5. volume': '212160000'},\n",
              "  '2007-11-30': {'1. open': '1098.0000',\n",
              "   '2. high': '1117.0000',\n",
              "   '3. low': '935.0000',\n",
              "   '4. close': '1114.0000',\n",
              "   '5. volume': '191200000'},\n",
              "  '2007-12-28': {'1. open': '1114.0000',\n",
              "   '2. high': '1158.0000',\n",
              "   '3. low': '1000.0000',\n",
              "   '4. close': '1016.0000',\n",
              "   '5. volume': '132513000'},\n",
              "  '2008-01-31': {'1. open': '971.0000',\n",
              "   '2. high': '971.0000',\n",
              "   '3. low': '809.0000',\n",
              "   '4. close': '938.0000',\n",
              "   '5. volume': '199515000'},\n",
              "  '2008-02-29': {'1. open': '944.0000',\n",
              "   '2. high': '1040.0000',\n",
              "   '3. low': '890.0000',\n",
              "   '4. close': '989.0000',\n",
              "   '5. volume': '182663000'},\n",
              "  '2008-03-31': {'1. open': '938.0000',\n",
              "   '2. high': '961.0000',\n",
              "   '3. low': '838.0000',\n",
              "   '4. close': '864.0000',\n",
              "   '5. volume': '175073000'},\n",
              "  '2008-04-30': {'1. open': '864.0000',\n",
              "   '2. high': '1031.0000',\n",
              "   '3. low': '837.0000',\n",
              "   '4. close': '1031.0000',\n",
              "   '5. volume': '235765000'},\n",
              "  '2008-05-30': {'1. open': '1045.0000',\n",
              "   '2. high': '1105.2500',\n",
              "   '3. low': '984.0000',\n",
              "   '4. close': '1056.0000',\n",
              "   '5. volume': '182438000'},\n",
              "  '2008-06-30': {'1. open': '1056.0000',\n",
              "   '2. high': '1157.0000',\n",
              "   '3. low': '976.0000',\n",
              "   '4. close': '976.0000',\n",
              "   '5. volume': '179951000'},\n",
              "  '2008-07-31': {'1. open': '976.0000',\n",
              "   '2. high': '1024.0000',\n",
              "   '3. low': '871.0000',\n",
              "   '4. close': '946.0000',\n",
              "   '5. volume': '171015000'},\n",
              "  '2008-08-29': {'1. open': '947.0000',\n",
              "   '2. high': '947.0000',\n",
              "   '3. low': '817.0000',\n",
              "   '4. close': '853.0000',\n",
              "   '5. volume': '135860000'},\n",
              "  '2008-09-30': {'1. open': '853.0000',\n",
              "   '2. high': '854.0820',\n",
              "   '3. low': '681.0000',\n",
              "   '4. close': '738.0000',\n",
              "   '5. volume': '180967000'},\n",
              "  '2008-10-31': {'1. open': '738.0000',\n",
              "   '2. high': '763.0000',\n",
              "   '3. low': '471.0000',\n",
              "   '4. close': '539.0000',\n",
              "   '5. volume': '258249000'},\n",
              "  '2008-11-28': {'1. open': '539.0000',\n",
              "   '2. high': '651.0000',\n",
              "   '3. low': '397.0000',\n",
              "   '4. close': '489.0000',\n",
              "   '5. volume': '187628000'},\n",
              "  '2008-12-30': {'1. open': '489.0000',\n",
              "   '2. high': '536.0000',\n",
              "   '3. low': '428.0000',\n",
              "   '4. close': '526.0000',\n",
              "   '5. volume': '209568000'},\n",
              "  '2009-01-30': {'1. open': '556.0000',\n",
              "   '2. high': '559.0000',\n",
              "   '3. low': '453.0000',\n",
              "   '4. close': '504.0000',\n",
              "   '5. volume': '178907000'},\n",
              "  '2009-02-27': {'1. open': '504.0000',\n",
              "   '2. high': '504.0000',\n",
              "   '3. low': '342.0000',\n",
              "   '4. close': '342.0000',\n",
              "   '5. volume': '257426000'},\n",
              "  '2009-03-31': {'1. open': '342.0000',\n",
              "   '2. high': '464.0000',\n",
              "   '3. low': '332.0000',\n",
              "   '4. close': '428.0000',\n",
              "   '5. volume': '301094000'},\n",
              "  '2009-04-30': {'1. open': '428.0000',\n",
              "   '2. high': '548.0000',\n",
              "   '3. low': '428.0000',\n",
              "   '4. close': '511.0000',\n",
              "   '5. volume': '306244000'},\n",
              "  '2009-05-29': {'1. open': '514.0000',\n",
              "   '2. high': '638.0000',\n",
              "   '3. low': '514.0000',\n",
              "   '4. close': '598.0000',\n",
              "   '5. volume': '220951000'},\n",
              "  '2009-06-30': {'1. open': '616.0000',\n",
              "   '2. high': '730.0000',\n",
              "   '3. low': '563.0000',\n",
              "   '4. close': '575.0000',\n",
              "   '5. volume': '400033000'},\n",
              "  '2009-07-31': {'1. open': '572.0000',\n",
              "   '2. high': '589.0000',\n",
              "   '3. low': '496.0000',\n",
              "   '4. close': '560.0000',\n",
              "   '5. volume': '648082800'},\n",
              "  '2009-08-31': {'1. open': '565.0000',\n",
              "   '2. high': '579.0000',\n",
              "   '3. low': '525.0000',\n",
              "   '4. close': '574.0000',\n",
              "   '5. volume': '285186000'},\n",
              "  '2009-09-30': {'1. open': '552.0000',\n",
              "   '2. high': '555.0000',\n",
              "   '3. low': '447.0000',\n",
              "   '4. close': '463.0000',\n",
              "   '5. volume': '303741000'},\n",
              "  '2009-10-30': {'1. open': '459.0000',\n",
              "   '2. high': '505.0000',\n",
              "   '3. low': '422.0000',\n",
              "   '4. close': '491.0000',\n",
              "   '5. volume': '322503000'},\n",
              "  '2009-11-30': {'1. open': '480.0000',\n",
              "   '2. high': '481.0000',\n",
              "   '3. low': '424.0000',\n",
              "   '4. close': '465.0000',\n",
              "   '5. volume': '194703000'},\n",
              "  '2009-12-30': {'1. open': '460.0000',\n",
              "   '2. high': '513.0000',\n",
              "   '3. low': '455.0000',\n",
              "   '4. close': '465.0000',\n",
              "   '5. volume': '192921000'},\n",
              "  '2010-01-29': {'1. open': '466.0000',\n",
              "   '2. high': '519.0000',\n",
              "   '3. low': '453.0000',\n",
              "   '4. close': '453.0000',\n",
              "   '5. volume': '171310000'},\n",
              "  '2010-02-26': {'1. open': '456.0000',\n",
              "   '2. high': '461.0000',\n",
              "   '3. low': '428.0000',\n",
              "   '4. close': '439.0000',\n",
              "   '5. volume': '200946000'},\n",
              "  '2010-03-31': {'1. open': '439.0000',\n",
              "   '2. high': '502.0000',\n",
              "   '3. low': '430.0000',\n",
              "   '4. close': '492.0000',\n",
              "   '5. volume': '196918000'},\n",
              "  '2010-04-30': {'1. open': '494.0000',\n",
              "   '2. high': '520.0000',\n",
              "   '3. low': '481.0000',\n",
              "   '4. close': '490.0000',\n",
              "   '5. volume': '216970000'},\n",
              "  '2010-05-31': {'1. open': '480.0000',\n",
              "   '2. high': '480.0000',\n",
              "   '3. low': '396.0000',\n",
              "   '4. close': '408.0000',\n",
              "   '5. volume': '282266000'},\n",
              "  '2010-06-30': {'1. open': '408.0000',\n",
              "   '2. high': '414.0000',\n",
              "   '3. low': '372.0000',\n",
              "   '4. close': '378.0000',\n",
              "   '5. volume': '214340000'},\n",
              "  '2010-07-30': {'1. open': '379.0000',\n",
              "   '2. high': '405.0000',\n",
              "   '3. low': '355.0000',\n",
              "   '4. close': '374.0000',\n",
              "   '5. volume': '197268000'},\n",
              "  '2010-08-31': {'1. open': '377.0000',\n",
              "   '2. high': '379.0000',\n",
              "   '3. low': '338.0000',\n",
              "   '4. close': '341.0000',\n",
              "   '5. volume': '186739000'},\n",
              "  '2010-09-30': {'1. open': '343.0000',\n",
              "   '2. high': '373.0000',\n",
              "   '3. low': '336.0000',\n",
              "   '4. close': '337.0000',\n",
              "   '5. volume': '222425000'},\n",
              "  '2010-10-29': {'1. open': '339.0000',\n",
              "   '2. high': '359.0000',\n",
              "   '3. low': '320.0000',\n",
              "   '4. close': '328.0000',\n",
              "   '5. volume': '240214000'},\n",
              "  '2010-11-30': {'1. open': '325.0000',\n",
              "   '2. high': '407.0000',\n",
              "   '3. low': '320.0000',\n",
              "   '4. close': '380.0000',\n",
              "   '5. volume': '343436000'},\n",
              "  '2010-12-30': {'1. open': '377.0000',\n",
              "   '2. high': '432.0000',\n",
              "   '3. low': '372.0000',\n",
              "   '4. close': '418.0000',\n",
              "   '5. volume': '264079000'},\n",
              "  '2011-01-31': {'1. open': '426.0000',\n",
              "   '2. high': '452.0000',\n",
              "   '3. low': '403.0000',\n",
              "   '4. close': '405.0000',\n",
              "   '5. volume': '223874000'},\n",
              "  '2011-02-28': {'1. open': '407.0000',\n",
              "   '2. high': '472.0000',\n",
              "   '3. low': '406.0000',\n",
              "   '4. close': '440.0000',\n",
              "   '5. volume': '248835000'},\n",
              "  '2011-03-31': {'1. open': '440.0000',\n",
              "   '2. high': '446.0000',\n",
              "   '3. low': '335.0000',\n",
              "   '4. close': '382.0000',\n",
              "   '5. volume': '384607000'},\n",
              "  '2011-04-28': {'1. open': '379.0000',\n",
              "   '2. high': '385.0000',\n",
              "   '3. low': '336.0000',\n",
              "   '4. close': '348.0000',\n",
              "   '5. volume': '219281000'},\n",
              "  '2011-05-31': {'1. open': '350.0000',\n",
              "   '2. high': '359.0000',\n",
              "   '3. low': '311.0000',\n",
              "   '4. close': '333.0000',\n",
              "   '5. volume': '166131000'},\n",
              "  '2011-06-30': {'1. open': '338.0000',\n",
              "   '2. high': '354.0000',\n",
              "   '3. low': '319.0000',\n",
              "   '4. close': '353.0000',\n",
              "   '5. volume': '228856000'},\n",
              "  '2011-07-29': {'1. open': '358.0000',\n",
              "   '2. high': '368.0000',\n",
              "   '3. low': '336.0000',\n",
              "   '4. close': '336.0000',\n",
              "   '5. volume': '171769000'},\n",
              "  '2011-08-31': {'1. open': '340.0000',\n",
              "   '2. high': '347.0000',\n",
              "   '3. low': '294.0000',\n",
              "   '4. close': '306.0000',\n",
              "   '5. volume': '258037000'},\n",
              "  '2011-09-30': {'1. open': '310.0000',\n",
              "   '2. high': '313.0000',\n",
              "   '3. low': '271.0000',\n",
              "   '4. close': '292.0000',\n",
              "   '5. volume': '172950000'},\n",
              "  '2011-10-31': {'1. open': '284.0000',\n",
              "   '2. high': '298.0000',\n",
              "   '3. low': '258.0000',\n",
              "   '4. close': '279.0000',\n",
              "   '5. volume': '181535000'},\n",
              "  '2011-11-30': {'1. open': '276.0000',\n",
              "   '2. high': '280.0000',\n",
              "   '3. low': '233.0000',\n",
              "   '4. close': '252.0000',\n",
              "   '5. volume': '189958000'},\n",
              "  '2011-12-30': {'1. open': '265.0000',\n",
              "   '2. high': '266.0000',\n",
              "   '3. low': '235.0000',\n",
              "   '4. close': '240.0000',\n",
              "   '5. volume': '174418000'},\n",
              "  '2012-01-31': {'1. open': '245.0000',\n",
              "   '2. high': '284.0000',\n",
              "   '3. low': '238.0000',\n",
              "   '4. close': '274.0000',\n",
              "   '5. volume': '173588000'},\n",
              "  '2012-02-29': {'1. open': '270.0000',\n",
              "   '2. high': '348.0000',\n",
              "   '3. low': '268.0000',\n",
              "   '4. close': '337.0000',\n",
              "   '5. volume': '310227000'},\n",
              "  '2012-03-30': {'1. open': '337.0000',\n",
              "   '2. high': '361.0000',\n",
              "   '3. low': '321.0000',\n",
              "   '4. close': '327.0000',\n",
              "   '5. volume': '313942000'},\n",
              "  '2012-04-27': {'1. open': '331.0000',\n",
              "   '2. high': '338.0000',\n",
              "   '3. low': '297.0000',\n",
              "   '4. close': '304.0000',\n",
              "   '5. volume': '238008000'},\n",
              "  '2012-05-31': {'1. open': '298.0000',\n",
              "   '2. high': '299.0000',\n",
              "   '3. low': '245.0000',\n",
              "   '4. close': '248.0000',\n",
              "   '5. volume': '191342000'},\n",
              "  '2012-06-29': {'1. open': '244.0000',\n",
              "   '2. high': '300.0000',\n",
              "   '3. low': '235.0000',\n",
              "   '4. close': '297.0000',\n",
              "   '5. volume': '202429000'},\n",
              "  '2012-07-31': {'1. open': '302.0000',\n",
              "   '2. high': '303.0000',\n",
              "   '3. low': '254.0000',\n",
              "   '4. close': '294.7750',\n",
              "   '5. volume': '185434000'},\n",
              "  '2012-08-31': {'1. open': '289.0000',\n",
              "   '2. high': '312.0000',\n",
              "   '3. low': '278.0000',\n",
              "   '4. close': '283.0000',\n",
              "   '5. volume': '183724000'},\n",
              "  '2012-09-28': {'1. open': '286.0000',\n",
              "   '2. high': '320.0000',\n",
              "   '3. low': '273.0000',\n",
              "   '4. close': '297.0000',\n",
              "   '5. volume': '180835000'},\n",
              "  '2012-10-31': {'1. open': '295.0000',\n",
              "   '2. high': '321.0000',\n",
              "   '3. low': '286.0000',\n",
              "   '4. close': '318.0000',\n",
              "   '5. volume': '169122000'},\n",
              "  '2012-11-30': {'1. open': '319.0000',\n",
              "   '2. high': '377.0000',\n",
              "   '3. low': '301.0000',\n",
              "   '4. close': '365.0000',\n",
              "   '5. volume': '202377000'},\n",
              "  '2012-12-28': {'1. open': '368.0000',\n",
              "   '2. high': '482.0000',\n",
              "   '3. low': '363.0000',\n",
              "   '4. close': '475.0000',\n",
              "   '5. volume': '284133000'},\n",
              "  '2013-01-31': {'1. open': '497.0000',\n",
              "   '2. high': '533.0000',\n",
              "   '3. low': '434.0000',\n",
              "   '4. close': '531.0000',\n",
              "   '5. volume': '402523000'},\n",
              "  '2013-02-28': {'1. open': '544.0000',\n",
              "   '2. high': '584.0000',\n",
              "   '3. low': '522.0000',\n",
              "   '4. close': '573.0000',\n",
              "   '5. volume': '399398000'},\n",
              "  '2013-03-29': {'1. open': '575.0000',\n",
              "   '2. high': '692.0000',\n",
              "   '3. low': '574.0000',\n",
              "   '4. close': '656.0000',\n",
              "   '5. volume': '434982000'},\n",
              "  '2013-04-30': {'1. open': '646.0000',\n",
              "   '2. high': '869.0000',\n",
              "   '3. low': '600.0000',\n",
              "   '4. close': '863.0000',\n",
              "   '5. volume': '593979000'},\n",
              "  '2013-05-31': {'1. open': '850.0000',\n",
              "   '2. high': '1033.0000',\n",
              "   '3. low': '840.0000',\n",
              "   '4. close': '858.0000',\n",
              "   '5. volume': '542488000'},\n",
              "  '2013-06-28': {'1. open': '813.0000',\n",
              "   '2. high': '873.0000',\n",
              "   '3. low': '717.0000',\n",
              "   '4. close': '833.0000',\n",
              "   '5. volume': '514965000'},\n",
              "  '2013-07-31': {'1. open': '838.0000',\n",
              "   '2. high': '934.0000',\n",
              "   '3. low': '800.0000',\n",
              "   '4. close': '836.0000',\n",
              "   '5. volume': '448391000'},\n",
              "  '2013-08-30': {'1. open': '842.0000',\n",
              "   '2. high': '887.0000',\n",
              "   '3. low': '778.0000',\n",
              "   '4. close': '796.0000',\n",
              "   '5. volume': '280634000'},\n",
              "  '2013-09-30': {'1. open': '795.0000',\n",
              "   '2. high': '949.0000',\n",
              "   '3. low': '792.0000',\n",
              "   '4. close': '880.0000',\n",
              "   '5. volume': '231821000'},\n",
              "  '2013-10-31': {'1. open': '883.0000',\n",
              "   '2. high': '909.0000',\n",
              "   '3. low': '816.0000',\n",
              "   '4. close': '892.0000',\n",
              "   '5. volume': '263939000'},\n",
              "  '2013-11-29': {'1. open': '896.0000',\n",
              "   '2. high': '1040.0000',\n",
              "   '3. low': '873.0000',\n",
              "   '4. close': '995.0000',\n",
              "   '5. volume': '331673000'},\n",
              "  '2013-12-30': {'1. open': '995.0000',\n",
              "   '2. high': '1065.0000',\n",
              "   '3. low': '952.0000',\n",
              "   '4. close': '1050.0000',\n",
              "   '5. volume': '285723000'},\n",
              "  '2014-01-31': {'1. open': '1036.0000',\n",
              "   '2. high': '1059.0000',\n",
              "   '3. low': '961.0000',\n",
              "   '4. close': '970.0000',\n",
              "   '5. volume': '248091000'},\n",
              "  '2014-02-28': {'1. open': '965.0000',\n",
              "   '2. high': '977.0000',\n",
              "   '3. low': '876.0000',\n",
              "   '4. close': '916.0000',\n",
              "   '5. volume': '284291000'},\n",
              "  '2014-03-31': {'1. open': '902.0000',\n",
              "   '2. high': '964.0000',\n",
              "   '3. low': '845.0000',\n",
              "   '4. close': '898.0000',\n",
              "   '5. volume': '251869000'},\n",
              "  '2014-04-30': {'1. open': '901.0000',\n",
              "   '2. high': '930.0000',\n",
              "   '3. low': '764.0000',\n",
              "   '4. close': '765.0000',\n",
              "   '5. volume': '273320000'},\n",
              "  '2014-05-30': {'1. open': '774.0000',\n",
              "   '2. high': '832.0000',\n",
              "   '3. low': '743.0000',\n",
              "   '4. close': '821.0000',\n",
              "   '5. volume': '231240000'},\n",
              "  '2014-06-30': {'1. open': '827.0000',\n",
              "   '2. high': '897.0000',\n",
              "   '3. low': '825.0000',\n",
              "   '4. close': '877.0000',\n",
              "   '5. volume': '235379000'},\n",
              "  '2014-07-31': {'1. open': '877.0000',\n",
              "   '2. high': '907.0000',\n",
              "   '3. low': '828.0000',\n",
              "   '4. close': '876.6000',\n",
              "   '5. volume': '186604000'},\n",
              "  '2014-08-29': {'1. open': '865.0000',\n",
              "   '2. high': '877.0000',\n",
              "   '3. low': '809.5000',\n",
              "   '4. close': '846.1000',\n",
              "   '5. volume': '157039000'},\n",
              "  '2014-09-30': {'1. open': '844.4000',\n",
              "   '2. high': '902.0000',\n",
              "   '3. low': '844.1000',\n",
              "   '4. close': '868.9000',\n",
              "   '5. volume': '171604000'},\n",
              "  '2014-10-31': {'1. open': '864.7000',\n",
              "   '2. high': '869.6000',\n",
              "   '3. low': '738.0000',\n",
              "   '4. close': '861.0000',\n",
              "   '5. volume': '267900000'},\n",
              "  '2014-11-28': {'1. open': '981.0000',\n",
              "   '2. high': '988.8000',\n",
              "   '3. low': '927.3000',\n",
              "   '4. close': '953.9000',\n",
              "   '5. volume': '280022000'},\n",
              "  '2014-12-30': {'1. open': '954.1000',\n",
              "   '2. high': '1019.0000',\n",
              "   '3. low': '905.0000',\n",
              "   '4. close': '947.6000',\n",
              "   '5. volume': '217232000'},\n",
              "  '2015-01-30': {'1. open': '940.4000',\n",
              "   '2. high': '946.0000',\n",
              "   '3. low': '846.0000',\n",
              "   '4. close': '862.5000',\n",
              "   '5. volume': '194491000'},\n",
              "  '2015-02-27': {'1. open': '850.0000',\n",
              "   '2. high': '967.6000',\n",
              "   '3. low': '824.5000',\n",
              "   '4. close': '964.9000',\n",
              "   '5. volume': '192963000'},\n",
              "  '2015-03-31': {'1. open': '962.0000',\n",
              "   '2. high': '1007.5000',\n",
              "   '3. low': '922.5000',\n",
              "   '4. close': '946.0000',\n",
              "   '5. volume': '233483000'},\n",
              "  '2015-04-30': {'1. open': '942.1000',\n",
              "   '2. high': '1048.5000',\n",
              "   '3. low': '929.0000',\n",
              "   '4. close': '1000.0000',\n",
              "   '5. volume': '214432000'},\n",
              "  '2015-05-29': {'1. open': '978.0000',\n",
              "   '2. high': '1009.0000',\n",
              "   '3. low': '959.2000',\n",
              "   '4. close': '987.3000',\n",
              "   '5. volume': '140994000'},\n",
              "  '2015-06-30': {'1. open': '987.0000',\n",
              "   '2. high': '998.7000',\n",
              "   '3. low': '912.0000',\n",
              "   '4. close': '917.2000',\n",
              "   '5. volume': '178787000'},\n",
              "  '2015-07-31': {'1. open': '923.8000',\n",
              "   '2. high': '976.5000',\n",
              "   '3. low': '848.0000',\n",
              "   '4. close': '963.7000',\n",
              "   '5. volume': '190182000'},\n",
              "  '2015-08-31': {'1. open': '963.0000',\n",
              "   '2. high': '963.0000',\n",
              "   '3. low': '779.0000',\n",
              "   '4. close': '842.2000',\n",
              "   '5. volume': '191604000'},\n",
              "  '2015-09-30': {'1. open': '834.9000',\n",
              "   '2. high': '836.0000',\n",
              "   '3. low': '735.4000',\n",
              "   '4. close': '769.7000',\n",
              "   '5. volume': '182201000'},\n",
              "  '2015-10-30': {'1. open': '773.0000',\n",
              "   '2. high': '875.0000',\n",
              "   '3. low': '761.1000',\n",
              "   '4. close': '832.1000',\n",
              "   '5. volume': '154279000'},\n",
              "  '2015-11-30': {'1. open': '824.5000',\n",
              "   '2. high': '874.0000',\n",
              "   '3. low': '793.1000',\n",
              "   '4. close': '796.3000',\n",
              "   '5. volume': '151718000'},\n",
              "  '2015-12-30': {'1. open': '794.7000',\n",
              "   '2. high': '805.0000',\n",
              "   '3. low': '727.2000',\n",
              "   '4. close': '744.8000',\n",
              "   '5. volume': '199096000'},\n",
              "  '2016-01-29': {'1. open': '740.2000',\n",
              "   '2. high': '755.0000',\n",
              "   '3. low': '646.7000',\n",
              "   '4. close': '750.5000',\n",
              "   '5. volume': '209655000'},\n",
              "  '2016-02-29': {'1. open': '778.0000',\n",
              "   '2. high': '781.9000',\n",
              "   '3. low': '590.7000',\n",
              "   '4. close': '666.7000',\n",
              "   '5. volume': '283420000'},\n",
              "  '2016-03-31': {'1. open': '663.5000',\n",
              "   '2. high': '743.0000',\n",
              "   '3. low': '655.1000',\n",
              "   '4. close': '692.3000',\n",
              "   '5. volume': '202125000'},\n",
              "  '2016-04-28': {'1. open': '687.7000',\n",
              "   '2. high': '726.4000',\n",
              "   '3. low': '626.0000',\n",
              "   '4. close': '646.2000',\n",
              "   '5. volume': '170558000'},\n",
              "  '2016-05-31': {'1. open': '614.0000',\n",
              "   '2. high': '647.8000',\n",
              "   '3. low': '591.3000',\n",
              "   '4. close': '646.2000',\n",
              "   '5. volume': '121437000'},\n",
              "  '2016-06-30': {'1. open': '642.0000',\n",
              "   '2. high': '646.3000',\n",
              "   '3. low': '496.0000',\n",
              "   '4. close': '537.5000',\n",
              "   '5. volume': '191849000'},\n",
              "  '2016-07-29': {'1. open': '541.0000',\n",
              "   '2. high': '624.0000',\n",
              "   '3. low': '509.0000',\n",
              "   '4. close': '585.3000',\n",
              "   '5. volume': '174031000'},\n",
              "  '2016-08-31': {'1. open': '570.0000',\n",
              "   '2. high': '605.7000',\n",
              "   '3. low': '540.7000',\n",
              "   '4. close': '604.4000',\n",
              "   '5. volume': '127226000'},\n",
              "  '2016-09-30': {'1. open': '604.5000',\n",
              "   '2. high': '643.3000',\n",
              "   '3. low': '558.9000',\n",
              "   '4. close': '564.4000',\n",
              "   '5. volume': '151008000'},\n",
              "  '2016-10-31': {'1. open': '572.3000',\n",
              "   '2. high': '630.3000',\n",
              "   '3. low': '561.2000',\n",
              "   '4. close': '627.7000',\n",
              "   '5. volume': '151161000'},\n",
              "  '2016-11-30': {'1. open': '627.7000',\n",
              "   '2. high': '693.2000',\n",
              "   '3. low': '556.8000',\n",
              "   '4. close': '687.4000',\n",
              "   '5. volume': '213206000'},\n",
              "  '2016-12-30': {'1. open': '702.3000',\n",
              "   '2. high': '785.0000',\n",
              "   '3. low': '695.4000',\n",
              "   '4. close': '720.3000',\n",
              "   '5. volume': '215380000'},\n",
              "  '2017-01-31': {'1. open': '732.9000',\n",
              "   '2. high': '761.5000',\n",
              "   '3. low': '699.5000',\n",
              "   '4. close': '723.5000',\n",
              "   '5. volume': '127476000'},\n",
              "  '2017-02-28': {'1. open': '712.0000',\n",
              "   '2. high': '733.4000',\n",
              "   '3. low': '699.3000',\n",
              "   '4. close': '712.3000',\n",
              "   '5. volume': '142634000'},\n",
              "  '2017-03-31': {'1. open': '715.1000',\n",
              "   '2. high': '762.2000',\n",
              "   '3. low': '677.9000',\n",
              "   '4. close': '677.9000',\n",
              "   '5. volume': '190201000'},\n",
              "  '2017-04-28': {'1. open': '676.0000',\n",
              "   '2. high': '705.0000',\n",
              "   '3. low': '636.9000',\n",
              "   '4. close': '677.3000',\n",
              "   '5. volume': '181021000'},\n",
              "  '2017-05-31': {'1. open': '662.8000',\n",
              "   '2. high': '701.4000',\n",
              "   '3. low': '651.4000',\n",
              "   '4. close': '673.5000',\n",
              "   '5. volume': '144784000'},\n",
              "  '2017-06-30': {'1. open': '670.8000',\n",
              "   '2. high': '696.2000',\n",
              "   '3. low': '652.2000',\n",
              "   '4. close': '665.8000',\n",
              "   '5. volume': '160514000'},\n",
              "  '2017-07-31': {'1. open': '666.4000',\n",
              "   '2. high': '678.4000',\n",
              "   '3. low': '630.0000',\n",
              "   '4. close': '636.1000',\n",
              "   '5. volume': '140937000'},\n",
              "  '2017-08-31': {'1. open': '633.7000',\n",
              "   '2. high': '641.0000',\n",
              "   '3. low': '597.5000',\n",
              "   '4. close': '601.8000',\n",
              "   '5. volume': '182951000'},\n",
              "  '2017-09-29': {'1. open': '605.1000',\n",
              "   '2. high': '651.2000',\n",
              "   '3. low': '593.7000',\n",
              "   '4. close': '637.3000',\n",
              "   '5. volume': '170647000'},\n",
              "  '2017-10-31': {'1. open': '634.8000',\n",
              "   '2. high': '715.0000',\n",
              "   '3. low': '634.3000',\n",
              "   '4. close': '705.7000',\n",
              "   '5. volume': '196754000'},\n",
              "  '2017-11-30': {'1. open': '701.6000',\n",
              "   '2. high': '751.9000',\n",
              "   '3. low': '681.3000',\n",
              "   '4. close': '698.0000',\n",
              "   '5. volume': '204187000'},\n",
              "  '2017-12-29': {'1. open': '704.9000',\n",
              "   '2. high': '723.0000',\n",
              "   '3. low': '680.0000',\n",
              "   '4. close': '706.9000',\n",
              "   '5. volume': '167045000'},\n",
              "  '2018-01-31': {'1. open': '706.9000',\n",
              "   '2. high': '810.5000',\n",
              "   '3. low': '706.9000',\n",
              "   '4. close': '782.2000',\n",
              "   '5. volume': '181431000'},\n",
              "  '2018-02-28': {'1. open': '790.2000',\n",
              "   '2. high': '803.3000',\n",
              "   '3. low': '697.0000',\n",
              "   '4. close': '716.8000',\n",
              "   '5. volume': '169646000'},\n",
              "  '2018-03-30': {'1. open': '715.0000',\n",
              "   '2. high': '715.1000',\n",
              "   '3. low': '661.1000',\n",
              "   '4. close': '678.7000',\n",
              "   '5. volume': '169329000'},\n",
              "  '2018-04-30': {'1. open': '678.3000',\n",
              "   '2. high': '689.3000',\n",
              "   '3. low': '659.4000',\n",
              "   '4. close': '672.7000',\n",
              "   '5. volume': '143813000'},\n",
              "  '2018-05-31': {'1. open': '675.0000',\n",
              "   '2. high': '679.0000',\n",
              "   '3. low': '626.8000',\n",
              "   '4. close': '631.7000',\n",
              "   '5. volume': '148011000'},\n",
              "  '2018-06-29': {'1. open': '631.2000',\n",
              "   '2. high': '656.8000',\n",
              "   '3. low': '612.6000',\n",
              "   '4. close': '643.3000',\n",
              "   '5. volume': '123773200'},\n",
              "  '2018-07-31': {'1. open': '641.1000',\n",
              "   '2. high': '674.1000',\n",
              "   '3. low': '627.3000',\n",
              "   '4. close': '650.8000',\n",
              "   '5. volume': '118118800'},\n",
              "  '2018-08-31': {'1. open': '651.8000',\n",
              "   '2. high': '679.4000',\n",
              "   '3. low': '632.7000',\n",
              "   '4. close': '666.4000',\n",
              "   '5. volume': '136777900'},\n",
              "  '2018-09-28': {'1. open': '666.5000',\n",
              "   '2. high': '716.9000',\n",
              "   '3. low': '640.5000',\n",
              "   '4. close': '691.2000',\n",
              "   '5. volume': '143769200'},\n",
              "  '2018-10-31': {'1. open': '690.0000',\n",
              "   '2. high': '695.7000',\n",
              "   '3. low': '621.3000',\n",
              "   '4. close': '646.9000',\n",
              "   '5. volume': '150992500'},\n",
              "  '2018-11-30': {'1. open': '647.1000',\n",
              "   '2. high': '657.0000',\n",
              "   '3. low': '612.2000',\n",
              "   '4. close': '626.5000',\n",
              "   '5. volume': '113563500'},\n",
              "  '2018-12-31': {'1. open': '632.0000',\n",
              "   '2. high': '638.9000',\n",
              "   '3. low': '523.7000',\n",
              "   '4. close': '556.6000',\n",
              "   '5. volume': '138086200'},\n",
              "  '2019-01-31': {'1. open': '546.6000',\n",
              "   '2. high': '599.9000',\n",
              "   '3. low': '537.0000',\n",
              "   '4. close': '541.8000',\n",
              "   '5. volume': '123546100'},\n",
              "  '2019-02-28': {'1. open': '542.0000',\n",
              "   '2. high': '587.8000',\n",
              "   '3. low': '536.5000',\n",
              "   '4. close': '565.5000',\n",
              "   '5. volume': '120274800'},\n",
              "  '2019-03-29': {'1. open': '567.0000',\n",
              "   '2. high': '581.7000',\n",
              "   '3. low': '529.5000',\n",
              "   '4. close': '539.0000',\n",
              "   '5. volume': '127615300'},\n",
              "  '2019-04-26': {'1. open': '545.5000',\n",
              "   '2. high': '554.3000',\n",
              "   '3. low': '509.3000',\n",
              "   '4. close': '515.1000',\n",
              "   '5. volume': '72975100'},\n",
              "  '2019-05-31': {'1. open': '508.6000',\n",
              "   '2. high': '511.7000',\n",
              "   '3. low': '470.3000',\n",
              "   '4. close': '474.4000',\n",
              "   '5. volume': '98394500'},\n",
              "  '2019-06-28': {'1. open': '469.0000',\n",
              "   '2. high': '488.7000',\n",
              "   '3. low': '457.8000',\n",
              "   '4. close': '472.1000',\n",
              "   '5. volume': '95606100'},\n",
              "  '2019-07-31': {'1. open': '480.1000',\n",
              "   '2. high': '494.6000',\n",
              "   '3. low': '460.0000',\n",
              "   '4. close': '471.5000',\n",
              "   '5. volume': '109778500'},\n",
              "  '2019-08-30': {'1. open': '477.5000',\n",
              "   '2. high': '493.7000',\n",
              "   '3. low': '422.9000',\n",
              "   '4. close': '457.8000',\n",
              "   '5. volume': '125432800'},\n",
              "  '2019-09-30': {'1. open': '455.0000',\n",
              "   '2. high': '518.7000',\n",
              "   '3. low': '454.1000',\n",
              "   '4. close': '481.4000',\n",
              "   '5. volume': '142661100'},\n",
              "  '2019-10-31': {'1. open': '485.0000',\n",
              "   '2. high': '509.3000',\n",
              "   '3. low': '479.3000',\n",
              "   '4. close': '489.7000',\n",
              "   '5. volume': '145150200'},\n",
              "  '2019-11-29': {'1. open': '484.8000',\n",
              "   '2. high': '557.5000',\n",
              "   '3. low': '484.7000',\n",
              "   '4. close': '555.0000',\n",
              "   '5. volume': '119323000'},\n",
              "  '2019-12-03': {'1. open': '556.4000',\n",
              "   '2. high': '558.4000',\n",
              "   '3. low': '545.3000',\n",
              "   '4. close': '556.5000',\n",
              "   '5. volume': '5849800'}}}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "a_lNvw6RKboh",
        "colab_type": "code",
        "outputId": "c3a9aa03-900d-42b5-fee5-b3575edf8194",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "data.keys()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dict_keys(['Meta Data', 'Monthly Time Series'])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8wV6A7foPd_m",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "data = data[\"Monthly Time Series\"]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cjpfIfVmP5mJ",
        "colab_type": "code",
        "outputId": "dd4f398c-5d9f-4e9f-ac96-c43839e2ede4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "data"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'2000-02-29': {'1. open': '1745.0000',\n",
              "  '2. high': '2115.0000',\n",
              "  '3. low': '1661.0000',\n",
              "  '4. close': '1745.0000',\n",
              "  '5. volume': '111929000'},\n",
              " '2000-03-31': {'1. open': '1805.0000',\n",
              "  '2. high': '1985.0000',\n",
              "  '3. low': '1517.0000',\n",
              "  '4. close': '1930.0000',\n",
              "  '5. volume': '122858000'},\n",
              " '2000-04-28': {'1. open': '1921.0000',\n",
              "  '2. high': '1950.0000',\n",
              "  '3. low': '1432.0000',\n",
              "  '4. close': '1650.0000',\n",
              "  '5. volume': '83441000'},\n",
              " '2000-05-31': {'1. open': '1625.0000',\n",
              "  '2. high': '1696.0000',\n",
              "  '3. low': '1166.0000',\n",
              "  '4. close': '1310.0000',\n",
              "  '5. volume': '89260000'},\n",
              " '2000-06-30': {'1. open': '1329.0000',\n",
              "  '2. high': '1535.0000',\n",
              "  '3. low': '1310.0000',\n",
              "  '4. close': '1400.0000',\n",
              "  '5. volume': '62164000'},\n",
              " '2000-07-31': {'1. open': '1450.0000',\n",
              "  '2. high': '1505.0000',\n",
              "  '3. low': '1116.0000',\n",
              "  '4. close': '1194.0000',\n",
              "  '5. volume': '66493000'},\n",
              " '2000-08-31': {'1. open': '1214.0000',\n",
              "  '2. high': '1432.0000',\n",
              "  '3. low': '1150.0000',\n",
              "  '4. close': '1330.0000',\n",
              "  '5. volume': '64761000'},\n",
              " '2000-09-29': {'1. open': '1370.0000',\n",
              "  '2. high': '1398.0000',\n",
              "  '3. low': '1215.0000',\n",
              "  '4. close': '1267.0000',\n",
              "  '5. volume': '40550000'},\n",
              " '2000-10-31': {'1. open': '1241.0000',\n",
              "  '2. high': '1344.0000',\n",
              "  '3. low': '1192.0000',\n",
              "  '4. close': '1209.0000',\n",
              "  '5. volume': '48324000'},\n",
              " '2000-11-30': {'1. open': '1258.0000',\n",
              "  '2. high': '1405.0000',\n",
              "  '3. low': '1133.0000',\n",
              "  '4. close': '1165.0000',\n",
              "  '5. volume': '59853000'},\n",
              " '2000-12-29': {'1. open': '1125.0000',\n",
              "  '2. high': '1302.0000',\n",
              "  '3. low': '1067.0000',\n",
              "  '4. close': '1193.0000',\n",
              "  '5. volume': '61280000'},\n",
              " '2001-01-31': {'1. open': '1193.0000',\n",
              "  '2. high': '1301.0000',\n",
              "  '3. low': '1098.0000',\n",
              "  '4. close': '1189.0000',\n",
              "  '5. volume': '61523000'},\n",
              " '2001-02-28': {'1. open': '1169.0000',\n",
              "  '2. high': '1224.0000',\n",
              "  '3. low': '1028.0000',\n",
              "  '4. close': '1071.0000',\n",
              "  '5. volume': '61321000'},\n",
              " '2001-03-30': {'1. open': '1051.0000',\n",
              "  '2. high': '1240.0000',\n",
              "  '3. low': '860.0000',\n",
              "  '4. close': '1187.0000',\n",
              "  '5. volume': '107978000'},\n",
              " '2001-04-30': {'1. open': '1167.0000',\n",
              "  '2. high': '1417.0000',\n",
              "  '3. low': '1142.0000',\n",
              "  '4. close': '1400.0000',\n",
              "  '5. volume': '75979000'},\n",
              " '2001-05-31': {'1. open': '1400.0000',\n",
              "  '2. high': '1480.0000',\n",
              "  '3. low': '1295.0000',\n",
              "  '4. close': '1298.0000',\n",
              "  '5. volume': '51670180'},\n",
              " '2001-06-29': {'1. open': '1310.0000',\n",
              "  '2. high': '1329.0000',\n",
              "  '3. low': '1191.0000',\n",
              "  '4. close': '1305.0000',\n",
              "  '5. volume': '60497000'},\n",
              " '2001-07-31': {'1. open': '1325.0000',\n",
              "  '2. high': '1338.0000',\n",
              "  '3. low': '1062.0000',\n",
              "  '4. close': '1085.0000',\n",
              "  '5. volume': '71654000'},\n",
              " '2001-08-31': {'1. open': '1100.0000',\n",
              "  '2. high': '1182.0000',\n",
              "  '3. low': '975.0000',\n",
              "  '4. close': '1006.0000',\n",
              "  '5. volume': '70308000'},\n",
              " '2001-09-28': {'1. open': '1015.0000',\n",
              "  '2. high': '1025.0000',\n",
              "  '3. low': '806.0000',\n",
              "  '4. close': '830.0000',\n",
              "  '5. volume': '62716000'},\n",
              " '2001-10-31': {'1. open': '836.0000',\n",
              "  '2. high': '965.0000',\n",
              "  '3. low': '800.0000',\n",
              "  '4. close': '800.0000',\n",
              "  '5. volume': '87419000'},\n",
              " '2001-11-30': {'1. open': '799.0000',\n",
              "  '2. high': '879.0000',\n",
              "  '3. low': '709.0000',\n",
              "  '4. close': '827.0000',\n",
              "  '5. volume': '112376000'},\n",
              " '2001-12-31': {'1. open': '825.0000',\n",
              "  '2. high': '825.0000',\n",
              "  '3. low': '679.0000',\n",
              "  '4. close': '689.0000',\n",
              "  '5. volume': '89906000'},\n",
              " '2002-01-31': {'1. open': '689.0000',\n",
              "  '2. high': '745.0000',\n",
              "  '3. low': '579.0000',\n",
              "  '4. close': '597.0000',\n",
              "  '5. volume': '90450000'},\n",
              " '2002-02-28': {'1. open': '617.0000',\n",
              "  '2. high': '835.0000',\n",
              "  '3. low': '512.0000',\n",
              "  '4. close': '811.0000',\n",
              "  '5. volume': '168257000'},\n",
              " '2002-03-29': {'1. open': '801.0000',\n",
              "  '2. high': '947.0000',\n",
              "  '3. low': '760.0000',\n",
              "  '4. close': '768.0000',\n",
              "  '5. volume': '141766000'},\n",
              " '2002-04-30': {'1. open': '770.0000',\n",
              "  '2. high': '903.0000',\n",
              "  '3. low': '739.0000',\n",
              "  '4. close': '881.0000',\n",
              "  '5. volume': '81394000'},\n",
              " '2002-05-31': {'1. open': '900.0000',\n",
              "  '2. high': '1009.0000',\n",
              "  '3. low': '798.0000',\n",
              "  '4. close': '913.0000',\n",
              "  '5. volume': '181374000'},\n",
              " '2002-06-28': {'1. open': '913.0000',\n",
              "  '2. high': '957.0000',\n",
              "  '3. low': '710.0000',\n",
              "  '4. close': '777.0000',\n",
              "  '5. volume': '138443000'},\n",
              " '2002-07-31': {'1. open': '784.0000',\n",
              "  '2. high': '842.0000',\n",
              "  '3. low': '618.0000',\n",
              "  '4. close': '643.0000',\n",
              "  '5. volume': '161785000'},\n",
              " '2002-08-30': {'1. open': '643.0000',\n",
              "  '2. high': '654.0000',\n",
              "  '3. low': '573.0000',\n",
              "  '4. close': '616.0000',\n",
              "  '5. volume': '114317000'},\n",
              " '2002-09-30': {'1. open': '608.0000',\n",
              "  '2. high': '696.0000',\n",
              "  '3. low': '546.0000',\n",
              "  '4. close': '672.0000',\n",
              "  '5. volume': '139928000'},\n",
              " '2002-10-31': {'1. open': '642.0000',\n",
              "  '2. high': '658.0000',\n",
              "  '3. low': '524.0000',\n",
              "  '4. close': '572.0000',\n",
              "  '5. volume': '138522000'},\n",
              " '2002-11-29': {'1. open': '569.0000',\n",
              "  '2. high': '604.0000',\n",
              "  '3. low': '411.0000',\n",
              "  '4. close': '561.0000',\n",
              "  '5. volume': '155878000'},\n",
              " '2002-12-31': {'1. open': '561.0000',\n",
              "  '2. high': '561.0000',\n",
              "  '3. low': '490.0000',\n",
              "  '4. close': '527.0000',\n",
              "  '5. volume': '84160000'},\n",
              " '2003-01-31': {'1. open': '527.0000',\n",
              "  '2. high': '618.0000',\n",
              "  '3. low': '505.0000',\n",
              "  '4. close': '568.0000',\n",
              "  '5. volume': '117980000'},\n",
              " '2003-02-28': {'1. open': '558.0000',\n",
              "  '2. high': '655.0000',\n",
              "  '3. low': '558.0000',\n",
              "  '4. close': '571.0000',\n",
              "  '5. volume': '130045000'},\n",
              " '2003-03-31': {'1. open': '572.0000',\n",
              "  '2. high': '595.0000',\n",
              "  '3. low': '485.0000',\n",
              "  '4. close': '487.0000',\n",
              "  '5. volume': '150953000'},\n",
              " '2003-04-30': {'1. open': '490.0000',\n",
              "  '2. high': '504.0000',\n",
              "  '3. low': '432.0000',\n",
              "  '4. close': '469.0000',\n",
              "  '5. volume': '121761000'},\n",
              " '2003-05-30': {'1. open': '470.0000',\n",
              "  '2. high': '534.0000',\n",
              "  '3. low': '461.0000',\n",
              "  '4. close': '527.0000',\n",
              "  '5. volume': '113417000'},\n",
              " '2003-06-30': {'1. open': '540.0000',\n",
              "  '2. high': '704.0000',\n",
              "  '3. low': '539.0000',\n",
              "  '4. close': '690.0000',\n",
              "  '5. volume': '192878000'},\n",
              " '2003-07-31': {'1. open': '693.0000',\n",
              "  '2. high': '833.0000',\n",
              "  '3. low': '667.0000',\n",
              "  '4. close': '698.0000',\n",
              "  '5. volume': '218350000'},\n",
              " '2003-08-29': {'1. open': '711.0000',\n",
              "  '2. high': '821.0000',\n",
              "  '3. low': '641.0000',\n",
              "  '4. close': '753.0000',\n",
              "  '5. volume': '171143000'},\n",
              " '2003-09-30': {'1. open': '773.0000',\n",
              "  '2. high': '849.0000',\n",
              "  '3. low': '755.0000',\n",
              "  '4. close': '755.0000',\n",
              "  '5. volume': '200390000'},\n",
              " '2003-10-31': {'1. open': '755.0000',\n",
              "  '2. high': '995.0000',\n",
              "  '3. low': '743.0000',\n",
              "  '4. close': '804.0000',\n",
              "  '5. volume': '362310000'},\n",
              " '2003-11-28': {'1. open': '804.0000',\n",
              "  '2. high': '823.0000',\n",
              "  '3. low': '639.0000',\n",
              "  '4. close': '705.0000',\n",
              "  '5. volume': '170459000'},\n",
              " '2003-12-31': {'1. open': '675.0000',\n",
              "  '2. high': '741.0000',\n",
              "  '3. low': '634.0000',\n",
              "  '4. close': '729.0000',\n",
              "  '5. volume': '157524000'},\n",
              " '2004-01-30': {'1. open': '729.0000',\n",
              "  '2. high': '796.0000',\n",
              "  '3. low': '705.0000',\n",
              "  '4. close': '744.0000',\n",
              "  '5. volume': '151606000'},\n",
              " '2004-02-27': {'1. open': '731.0000',\n",
              "  '2. high': '735.0000',\n",
              "  '3. low': '653.0000',\n",
              "  '4. close': '734.0000',\n",
              "  '5. volume': '170372000'},\n",
              " '2004-03-31': {'1. open': '750.0000',\n",
              "  '2. high': '873.0000',\n",
              "  '3. low': '749.0000',\n",
              "  '4. close': '850.0000',\n",
              "  '5. volume': '254081000'},\n",
              " '2004-04-30': {'1. open': '865.0000',\n",
              "  '2. high': '933.0000',\n",
              "  '3. low': '818.0000',\n",
              "  '4. close': '830.0000',\n",
              "  '5. volume': '227945000'},\n",
              " '2004-05-31': {'1. open': '830.0000',\n",
              "  '2. high': '843.0000',\n",
              "  '3. low': '683.0000',\n",
              "  '4. close': '774.0000',\n",
              "  '5. volume': '162930000'},\n",
              " '2004-06-30': {'1. open': '769.0000',\n",
              "  '2. high': '826.0000',\n",
              "  '3. low': '721.0000',\n",
              "  '4. close': '784.0000',\n",
              "  '5. volume': '179732000'},\n",
              " '2004-07-30': {'1. open': '791.0000',\n",
              "  '2. high': '792.0000',\n",
              "  '3. low': '713.0000',\n",
              "  '4. close': '731.0000',\n",
              "  '5. volume': '154438000'},\n",
              " '2004-08-31': {'1. open': '739.0000',\n",
              "  '2. high': '760.0000',\n",
              "  '3. low': '672.0000',\n",
              "  '4. close': '710.0000',\n",
              "  '5. volume': '150358000'},\n",
              " '2004-09-30': {'1. open': '720.0000',\n",
              "  '2. high': '748.0000',\n",
              "  '3. low': '673.0000',\n",
              "  '4. close': '698.0000',\n",
              "  '5. volume': '105514000'},\n",
              " '2004-10-29': {'1. open': '693.0000',\n",
              "  '2. high': '735.0000',\n",
              "  '3. low': '640.0000',\n",
              "  '4. close': '650.0000',\n",
              "  '5. volume': '99190000'},\n",
              " '2004-11-30': {'1. open': '647.0000',\n",
              "  '2. high': '717.0000',\n",
              "  '3. low': '640.0000',\n",
              "  '4. close': '704.0000',\n",
              "  '5. volume': '111300000'},\n",
              " '2004-12-31': {'1. open': '694.0000',\n",
              "  '2. high': '743.0000',\n",
              "  '3. low': '684.0000',\n",
              "  '4. close': '740.0000',\n",
              "  '5. volume': '108419000'},\n",
              " '2005-01-31': {'1. open': '740.0000',\n",
              "  '2. high': '744.0000',\n",
              "  '3. low': '686.0000',\n",
              "  '4. close': '702.0000',\n",
              "  '5. volume': '93105000'},\n",
              " '2005-02-28': {'1. open': '698.0000',\n",
              "  '2. high': '754.0000',\n",
              "  '3. low': '678.0000',\n",
              "  '4. close': '713.0000',\n",
              "  '5. volume': '145264000'},\n",
              " '2005-03-31': {'1. open': '713.0000',\n",
              "  '2. high': '749.0000',\n",
              "  '3. low': '694.0000',\n",
              "  '4. close': '706.0000',\n",
              "  '5. volume': '124568000'},\n",
              " '2005-04-29': {'1. open': '707.0000',\n",
              "  '2. high': '726.0000',\n",
              "  '3. low': '650.0000',\n",
              "  '4. close': '665.0000',\n",
              "  '5. volume': '103703000'},\n",
              " '2005-05-31': {'1. open': '666.0000',\n",
              "  '2. high': '690.0000',\n",
              "  '3. low': '641.0000',\n",
              "  '4. close': '690.0000',\n",
              "  '5. volume': '93140000'},\n",
              " '2005-06-30': {'1. open': '680.0000',\n",
              "  '2. high': '700.0000',\n",
              "  '3. low': '663.0000',\n",
              "  '4. close': '686.0000',\n",
              "  '5. volume': '96060000'},\n",
              " '2005-07-29': {'1. open': '687.0000',\n",
              "  '2. high': '688.0000',\n",
              "  '3. low': '650.0000',\n",
              "  '4. close': '660.0000',\n",
              "  '5. volume': '93586000'},\n",
              " '2005-08-31': {'1. open': '659.0000',\n",
              "  '2. high': '749.0000',\n",
              "  '3. low': '646.0000',\n",
              "  '4. close': '749.0000',\n",
              "  '5. volume': '190710000'},\n",
              " '2005-09-30': {'1. open': '762.0000',\n",
              "  '2. high': '904.0000',\n",
              "  '3. low': '725.0000',\n",
              "  '4. close': '887.0000',\n",
              "  '5. volume': '206508000'},\n",
              " '2005-10-31': {'1. open': '888.0000',\n",
              "  '2. high': '949.0000',\n",
              "  '3. low': '810.0000',\n",
              "  '4. close': '949.0000',\n",
              "  '5. volume': '202167000'},\n",
              " '2005-11-30': {'1. open': '959.0000',\n",
              "  '2. high': '1216.0000',\n",
              "  '3. low': '951.0000',\n",
              "  '4. close': '1169.0000',\n",
              "  '5. volume': '306545000'},\n",
              " '2005-12-30': {'1. open': '1160.0000',\n",
              "  '2. high': '1379.0000',\n",
              "  '3. low': '1144.0000',\n",
              "  '4. close': '1337.0000',\n",
              "  '5. volume': '266339000'},\n",
              " '2006-01-31': {'1. open': '1337.0000',\n",
              "  '2. high': '1441.0000',\n",
              "  '3. low': '1140.0000',\n",
              "  '4. close': '1377.0000',\n",
              "  '5. volume': '229251000'},\n",
              " '2006-02-28': {'1. open': '1374.0000',\n",
              "  '2. high': '1430.0000',\n",
              "  '3. low': '1223.0000',\n",
              "  '4. close': '1400.0000',\n",
              "  '5. volume': '195641000'},\n",
              " '2006-03-31': {'1. open': '1372.0000',\n",
              "  '2. high': '1598.0000',\n",
              "  '3. low': '1357.0000',\n",
              "  '4. close': '1579.0000',\n",
              "  '5. volume': '227756000'},\n",
              " '2006-04-28': {'1. open': '1572.0000',\n",
              "  '2. high': '1645.0000',\n",
              "  '3. low': '1503.0000',\n",
              "  '4. close': '1579.0000',\n",
              "  '5. volume': '155598000'},\n",
              " '2006-05-31': {'1. open': '1579.0000',\n",
              "  '2. high': '1672.0000',\n",
              "  '3. low': '1353.0000',\n",
              "  '4. close': '1378.0000',\n",
              "  '5. volume': '221955000'},\n",
              " '2006-06-30': {'1. open': '1418.0000',\n",
              "  '2. high': '1471.0000',\n",
              "  '3. low': '1241.0000',\n",
              "  '4. close': '1364.0000',\n",
              "  '5. volume': '218143000'},\n",
              " '2006-07-31': {'1. open': '1370.0000',\n",
              "  '2. high': '1452.0000',\n",
              "  '3. low': '1170.0000',\n",
              "  '4. close': '1281.0000',\n",
              "  '5. volume': '227320000'},\n",
              " '2006-08-31': {'1. open': '1278.0000',\n",
              "  '2. high': '1486.0000',\n",
              "  '3. low': '1250.0000',\n",
              "  '4. close': '1399.0000',\n",
              "  '5. volume': '186642000'},\n",
              " '2006-09-29': {'1. open': '1396.0000',\n",
              "  '2. high': '1454.0000',\n",
              "  '3. low': '1280.0000',\n",
              "  '4. close': '1378.0000',\n",
              "  '5. volume': '138934000'},\n",
              " '2006-10-31': {'1. open': '1366.0000',\n",
              "  '2. high': '1462.0000',\n",
              "  '3. low': '1304.0000',\n",
              "  '4. close': '1327.0000',\n",
              "  '5. volume': '212296000'},\n",
              " '2006-11-30': {'1. open': '1321.0000',\n",
              "  '2. high': '1342.0000',\n",
              "  '3. low': '1190.0000',\n",
              "  '4. close': '1327.0000',\n",
              "  '5. volume': '218280000'},\n",
              " '2006-12-29': {'1. open': '1315.0000',\n",
              "  '2. high': '1347.0000',\n",
              "  '3. low': '1281.0000',\n",
              "  '4. close': '1335.0000',\n",
              "  '5. volume': '138681000'},\n",
              " '2007-01-31': {'1. open': '1344.0000',\n",
              "  '2. high': '1483.0000',\n",
              "  '3. low': '1307.0000',\n",
              "  '4. close': '1476.0000',\n",
              "  '5. volume': '150058000'},\n",
              " '2007-02-28': {'1. open': '1471.0000',\n",
              "  '2. high': '1673.0000',\n",
              "  '3. low': '1424.0000',\n",
              "  '4. close': '1501.0000',\n",
              "  '5. volume': '217353000'},\n",
              " '2007-03-30': {'1. open': '1510.0000',\n",
              "  '2. high': '1541.0000',\n",
              "  '3. low': '1375.0000',\n",
              "  '4. close': '1423.0000',\n",
              "  '5. volume': '217998000'},\n",
              " '2007-04-27': {'1. open': '1435.0000',\n",
              "  '2. high': '1449.0000',\n",
              "  '3. low': '1308.0000',\n",
              "  '4. close': '1347.0000',\n",
              "  '5. volume': '161843000'},\n",
              " '2007-05-31': {'1. open': '1360.0000',\n",
              "  '2. high': '1437.0000',\n",
              "  '3. low': '1264.0000',\n",
              "  '4. close': '1401.0000',\n",
              "  '5. volume': '182529000'},\n",
              " '2007-06-29': {'1. open': '1423.0000',\n",
              "  '2. high': '1432.0000',\n",
              "  '3. low': '1290.0000',\n",
              "  '4. close': '1313.0000',\n",
              "  '5. volume': '163127000'},\n",
              " '2007-07-31': {'1. open': '1315.0000',\n",
              "  '2. high': '1363.0000',\n",
              "  '3. low': '1242.0000',\n",
              "  '4. close': '1274.0000',\n",
              "  '5. volume': '161453000'},\n",
              " '2007-08-31': {'1. open': '1260.0000',\n",
              "  '2. high': '1270.0000',\n",
              "  '3. low': '1052.0000',\n",
              "  '4. close': '1148.0000',\n",
              "  '5. volume': '255413000'},\n",
              " '2007-09-28': {'1. open': '1143.0000',\n",
              "  '2. high': '1166.0000',\n",
              "  '3. low': '967.0000',\n",
              "  '4. close': '1094.0000',\n",
              "  '5. volume': '208139000'},\n",
              " '2007-10-31': {'1. open': '1085.0000',\n",
              "  '2. high': '1248.0000',\n",
              "  '3. low': '1052.0000',\n",
              "  '4. close': '1098.0000',\n",
              "  '5. volume': '212160000'},\n",
              " '2007-11-30': {'1. open': '1098.0000',\n",
              "  '2. high': '1117.0000',\n",
              "  '3. low': '935.0000',\n",
              "  '4. close': '1114.0000',\n",
              "  '5. volume': '191200000'},\n",
              " '2007-12-28': {'1. open': '1114.0000',\n",
              "  '2. high': '1158.0000',\n",
              "  '3. low': '1000.0000',\n",
              "  '4. close': '1016.0000',\n",
              "  '5. volume': '132513000'},\n",
              " '2008-01-31': {'1. open': '971.0000',\n",
              "  '2. high': '971.0000',\n",
              "  '3. low': '809.0000',\n",
              "  '4. close': '938.0000',\n",
              "  '5. volume': '199515000'},\n",
              " '2008-02-29': {'1. open': '944.0000',\n",
              "  '2. high': '1040.0000',\n",
              "  '3. low': '890.0000',\n",
              "  '4. close': '989.0000',\n",
              "  '5. volume': '182663000'},\n",
              " '2008-03-31': {'1. open': '938.0000',\n",
              "  '2. high': '961.0000',\n",
              "  '3. low': '838.0000',\n",
              "  '4. close': '864.0000',\n",
              "  '5. volume': '175073000'},\n",
              " '2008-04-30': {'1. open': '864.0000',\n",
              "  '2. high': '1031.0000',\n",
              "  '3. low': '837.0000',\n",
              "  '4. close': '1031.0000',\n",
              "  '5. volume': '235765000'},\n",
              " '2008-05-30': {'1. open': '1045.0000',\n",
              "  '2. high': '1105.2500',\n",
              "  '3. low': '984.0000',\n",
              "  '4. close': '1056.0000',\n",
              "  '5. volume': '182438000'},\n",
              " '2008-06-30': {'1. open': '1056.0000',\n",
              "  '2. high': '1157.0000',\n",
              "  '3. low': '976.0000',\n",
              "  '4. close': '976.0000',\n",
              "  '5. volume': '179951000'},\n",
              " '2008-07-31': {'1. open': '976.0000',\n",
              "  '2. high': '1024.0000',\n",
              "  '3. low': '871.0000',\n",
              "  '4. close': '946.0000',\n",
              "  '5. volume': '171015000'},\n",
              " '2008-08-29': {'1. open': '947.0000',\n",
              "  '2. high': '947.0000',\n",
              "  '3. low': '817.0000',\n",
              "  '4. close': '853.0000',\n",
              "  '5. volume': '135860000'},\n",
              " '2008-09-30': {'1. open': '853.0000',\n",
              "  '2. high': '854.0820',\n",
              "  '3. low': '681.0000',\n",
              "  '4. close': '738.0000',\n",
              "  '5. volume': '180967000'},\n",
              " '2008-10-31': {'1. open': '738.0000',\n",
              "  '2. high': '763.0000',\n",
              "  '3. low': '471.0000',\n",
              "  '4. close': '539.0000',\n",
              "  '5. volume': '258249000'},\n",
              " '2008-11-28': {'1. open': '539.0000',\n",
              "  '2. high': '651.0000',\n",
              "  '3. low': '397.0000',\n",
              "  '4. close': '489.0000',\n",
              "  '5. volume': '187628000'},\n",
              " '2008-12-30': {'1. open': '489.0000',\n",
              "  '2. high': '536.0000',\n",
              "  '3. low': '428.0000',\n",
              "  '4. close': '526.0000',\n",
              "  '5. volume': '209568000'},\n",
              " '2009-01-30': {'1. open': '556.0000',\n",
              "  '2. high': '559.0000',\n",
              "  '3. low': '453.0000',\n",
              "  '4. close': '504.0000',\n",
              "  '5. volume': '178907000'},\n",
              " '2009-02-27': {'1. open': '504.0000',\n",
              "  '2. high': '504.0000',\n",
              "  '3. low': '342.0000',\n",
              "  '4. close': '342.0000',\n",
              "  '5. volume': '257426000'},\n",
              " '2009-03-31': {'1. open': '342.0000',\n",
              "  '2. high': '464.0000',\n",
              "  '3. low': '332.0000',\n",
              "  '4. close': '428.0000',\n",
              "  '5. volume': '301094000'},\n",
              " '2009-04-30': {'1. open': '428.0000',\n",
              "  '2. high': '548.0000',\n",
              "  '3. low': '428.0000',\n",
              "  '4. close': '511.0000',\n",
              "  '5. volume': '306244000'},\n",
              " '2009-05-29': {'1. open': '514.0000',\n",
              "  '2. high': '638.0000',\n",
              "  '3. low': '514.0000',\n",
              "  '4. close': '598.0000',\n",
              "  '5. volume': '220951000'},\n",
              " '2009-06-30': {'1. open': '616.0000',\n",
              "  '2. high': '730.0000',\n",
              "  '3. low': '563.0000',\n",
              "  '4. close': '575.0000',\n",
              "  '5. volume': '400033000'},\n",
              " '2009-07-31': {'1. open': '572.0000',\n",
              "  '2. high': '589.0000',\n",
              "  '3. low': '496.0000',\n",
              "  '4. close': '560.0000',\n",
              "  '5. volume': '648082800'},\n",
              " '2009-08-31': {'1. open': '565.0000',\n",
              "  '2. high': '579.0000',\n",
              "  '3. low': '525.0000',\n",
              "  '4. close': '574.0000',\n",
              "  '5. volume': '285186000'},\n",
              " '2009-09-30': {'1. open': '552.0000',\n",
              "  '2. high': '555.0000',\n",
              "  '3. low': '447.0000',\n",
              "  '4. close': '463.0000',\n",
              "  '5. volume': '303741000'},\n",
              " '2009-10-30': {'1. open': '459.0000',\n",
              "  '2. high': '505.0000',\n",
              "  '3. low': '422.0000',\n",
              "  '4. close': '491.0000',\n",
              "  '5. volume': '322503000'},\n",
              " '2009-11-30': {'1. open': '480.0000',\n",
              "  '2. high': '481.0000',\n",
              "  '3. low': '424.0000',\n",
              "  '4. close': '465.0000',\n",
              "  '5. volume': '194703000'},\n",
              " '2009-12-30': {'1. open': '460.0000',\n",
              "  '2. high': '513.0000',\n",
              "  '3. low': '455.0000',\n",
              "  '4. close': '465.0000',\n",
              "  '5. volume': '192921000'},\n",
              " '2010-01-29': {'1. open': '466.0000',\n",
              "  '2. high': '519.0000',\n",
              "  '3. low': '453.0000',\n",
              "  '4. close': '453.0000',\n",
              "  '5. volume': '171310000'},\n",
              " '2010-02-26': {'1. open': '456.0000',\n",
              "  '2. high': '461.0000',\n",
              "  '3. low': '428.0000',\n",
              "  '4. close': '439.0000',\n",
              "  '5. volume': '200946000'},\n",
              " '2010-03-31': {'1. open': '439.0000',\n",
              "  '2. high': '502.0000',\n",
              "  '3. low': '430.0000',\n",
              "  '4. close': '492.0000',\n",
              "  '5. volume': '196918000'},\n",
              " '2010-04-30': {'1. open': '494.0000',\n",
              "  '2. high': '520.0000',\n",
              "  '3. low': '481.0000',\n",
              "  '4. close': '490.0000',\n",
              "  '5. volume': '216970000'},\n",
              " '2010-05-31': {'1. open': '480.0000',\n",
              "  '2. high': '480.0000',\n",
              "  '3. low': '396.0000',\n",
              "  '4. close': '408.0000',\n",
              "  '5. volume': '282266000'},\n",
              " '2010-06-30': {'1. open': '408.0000',\n",
              "  '2. high': '414.0000',\n",
              "  '3. low': '372.0000',\n",
              "  '4. close': '378.0000',\n",
              "  '5. volume': '214340000'},\n",
              " '2010-07-30': {'1. open': '379.0000',\n",
              "  '2. high': '405.0000',\n",
              "  '3. low': '355.0000',\n",
              "  '4. close': '374.0000',\n",
              "  '5. volume': '197268000'},\n",
              " '2010-08-31': {'1. open': '377.0000',\n",
              "  '2. high': '379.0000',\n",
              "  '3. low': '338.0000',\n",
              "  '4. close': '341.0000',\n",
              "  '5. volume': '186739000'},\n",
              " '2010-09-30': {'1. open': '343.0000',\n",
              "  '2. high': '373.0000',\n",
              "  '3. low': '336.0000',\n",
              "  '4. close': '337.0000',\n",
              "  '5. volume': '222425000'},\n",
              " '2010-10-29': {'1. open': '339.0000',\n",
              "  '2. high': '359.0000',\n",
              "  '3. low': '320.0000',\n",
              "  '4. close': '328.0000',\n",
              "  '5. volume': '240214000'},\n",
              " '2010-11-30': {'1. open': '325.0000',\n",
              "  '2. high': '407.0000',\n",
              "  '3. low': '320.0000',\n",
              "  '4. close': '380.0000',\n",
              "  '5. volume': '343436000'},\n",
              " '2010-12-30': {'1. open': '377.0000',\n",
              "  '2. high': '432.0000',\n",
              "  '3. low': '372.0000',\n",
              "  '4. close': '418.0000',\n",
              "  '5. volume': '264079000'},\n",
              " '2011-01-31': {'1. open': '426.0000',\n",
              "  '2. high': '452.0000',\n",
              "  '3. low': '403.0000',\n",
              "  '4. close': '405.0000',\n",
              "  '5. volume': '223874000'},\n",
              " '2011-02-28': {'1. open': '407.0000',\n",
              "  '2. high': '472.0000',\n",
              "  '3. low': '406.0000',\n",
              "  '4. close': '440.0000',\n",
              "  '5. volume': '248835000'},\n",
              " '2011-03-31': {'1. open': '440.0000',\n",
              "  '2. high': '446.0000',\n",
              "  '3. low': '335.0000',\n",
              "  '4. close': '382.0000',\n",
              "  '5. volume': '384607000'},\n",
              " '2011-04-28': {'1. open': '379.0000',\n",
              "  '2. high': '385.0000',\n",
              "  '3. low': '336.0000',\n",
              "  '4. close': '348.0000',\n",
              "  '5. volume': '219281000'},\n",
              " '2011-05-31': {'1. open': '350.0000',\n",
              "  '2. high': '359.0000',\n",
              "  '3. low': '311.0000',\n",
              "  '4. close': '333.0000',\n",
              "  '5. volume': '166131000'},\n",
              " '2011-06-30': {'1. open': '338.0000',\n",
              "  '2. high': '354.0000',\n",
              "  '3. low': '319.0000',\n",
              "  '4. close': '353.0000',\n",
              "  '5. volume': '228856000'},\n",
              " '2011-07-29': {'1. open': '358.0000',\n",
              "  '2. high': '368.0000',\n",
              "  '3. low': '336.0000',\n",
              "  '4. close': '336.0000',\n",
              "  '5. volume': '171769000'},\n",
              " '2011-08-31': {'1. open': '340.0000',\n",
              "  '2. high': '347.0000',\n",
              "  '3. low': '294.0000',\n",
              "  '4. close': '306.0000',\n",
              "  '5. volume': '258037000'},\n",
              " '2011-09-30': {'1. open': '310.0000',\n",
              "  '2. high': '313.0000',\n",
              "  '3. low': '271.0000',\n",
              "  '4. close': '292.0000',\n",
              "  '5. volume': '172950000'},\n",
              " '2011-10-31': {'1. open': '284.0000',\n",
              "  '2. high': '298.0000',\n",
              "  '3. low': '258.0000',\n",
              "  '4. close': '279.0000',\n",
              "  '5. volume': '181535000'},\n",
              " '2011-11-30': {'1. open': '276.0000',\n",
              "  '2. high': '280.0000',\n",
              "  '3. low': '233.0000',\n",
              "  '4. close': '252.0000',\n",
              "  '5. volume': '189958000'},\n",
              " '2011-12-30': {'1. open': '265.0000',\n",
              "  '2. high': '266.0000',\n",
              "  '3. low': '235.0000',\n",
              "  '4. close': '240.0000',\n",
              "  '5. volume': '174418000'},\n",
              " '2012-01-31': {'1. open': '245.0000',\n",
              "  '2. high': '284.0000',\n",
              "  '3. low': '238.0000',\n",
              "  '4. close': '274.0000',\n",
              "  '5. volume': '173588000'},\n",
              " '2012-02-29': {'1. open': '270.0000',\n",
              "  '2. high': '348.0000',\n",
              "  '3. low': '268.0000',\n",
              "  '4. close': '337.0000',\n",
              "  '5. volume': '310227000'},\n",
              " '2012-03-30': {'1. open': '337.0000',\n",
              "  '2. high': '361.0000',\n",
              "  '3. low': '321.0000',\n",
              "  '4. close': '327.0000',\n",
              "  '5. volume': '313942000'},\n",
              " '2012-04-27': {'1. open': '331.0000',\n",
              "  '2. high': '338.0000',\n",
              "  '3. low': '297.0000',\n",
              "  '4. close': '304.0000',\n",
              "  '5. volume': '238008000'},\n",
              " '2012-05-31': {'1. open': '298.0000',\n",
              "  '2. high': '299.0000',\n",
              "  '3. low': '245.0000',\n",
              "  '4. close': '248.0000',\n",
              "  '5. volume': '191342000'},\n",
              " '2012-06-29': {'1. open': '244.0000',\n",
              "  '2. high': '300.0000',\n",
              "  '3. low': '235.0000',\n",
              "  '4. close': '297.0000',\n",
              "  '5. volume': '202429000'},\n",
              " '2012-07-31': {'1. open': '302.0000',\n",
              "  '2. high': '303.0000',\n",
              "  '3. low': '254.0000',\n",
              "  '4. close': '294.7750',\n",
              "  '5. volume': '185434000'},\n",
              " '2012-08-31': {'1. open': '289.0000',\n",
              "  '2. high': '312.0000',\n",
              "  '3. low': '278.0000',\n",
              "  '4. close': '283.0000',\n",
              "  '5. volume': '183724000'},\n",
              " '2012-09-28': {'1. open': '286.0000',\n",
              "  '2. high': '320.0000',\n",
              "  '3. low': '273.0000',\n",
              "  '4. close': '297.0000',\n",
              "  '5. volume': '180835000'},\n",
              " '2012-10-31': {'1. open': '295.0000',\n",
              "  '2. high': '321.0000',\n",
              "  '3. low': '286.0000',\n",
              "  '4. close': '318.0000',\n",
              "  '5. volume': '169122000'},\n",
              " '2012-11-30': {'1. open': '319.0000',\n",
              "  '2. high': '377.0000',\n",
              "  '3. low': '301.0000',\n",
              "  '4. close': '365.0000',\n",
              "  '5. volume': '202377000'},\n",
              " '2012-12-28': {'1. open': '368.0000',\n",
              "  '2. high': '482.0000',\n",
              "  '3. low': '363.0000',\n",
              "  '4. close': '475.0000',\n",
              "  '5. volume': '284133000'},\n",
              " '2013-01-31': {'1. open': '497.0000',\n",
              "  '2. high': '533.0000',\n",
              "  '3. low': '434.0000',\n",
              "  '4. close': '531.0000',\n",
              "  '5. volume': '402523000'},\n",
              " '2013-02-28': {'1. open': '544.0000',\n",
              "  '2. high': '584.0000',\n",
              "  '3. low': '522.0000',\n",
              "  '4. close': '573.0000',\n",
              "  '5. volume': '399398000'},\n",
              " '2013-03-29': {'1. open': '575.0000',\n",
              "  '2. high': '692.0000',\n",
              "  '3. low': '574.0000',\n",
              "  '4. close': '656.0000',\n",
              "  '5. volume': '434982000'},\n",
              " '2013-04-30': {'1. open': '646.0000',\n",
              "  '2. high': '869.0000',\n",
              "  '3. low': '600.0000',\n",
              "  '4. close': '863.0000',\n",
              "  '5. volume': '593979000'},\n",
              " '2013-05-31': {'1. open': '850.0000',\n",
              "  '2. high': '1033.0000',\n",
              "  '3. low': '840.0000',\n",
              "  '4. close': '858.0000',\n",
              "  '5. volume': '542488000'},\n",
              " '2013-06-28': {'1. open': '813.0000',\n",
              "  '2. high': '873.0000',\n",
              "  '3. low': '717.0000',\n",
              "  '4. close': '833.0000',\n",
              "  '5. volume': '514965000'},\n",
              " '2013-07-31': {'1. open': '838.0000',\n",
              "  '2. high': '934.0000',\n",
              "  '3. low': '800.0000',\n",
              "  '4. close': '836.0000',\n",
              "  '5. volume': '448391000'},\n",
              " '2013-08-30': {'1. open': '842.0000',\n",
              "  '2. high': '887.0000',\n",
              "  '3. low': '778.0000',\n",
              "  '4. close': '796.0000',\n",
              "  '5. volume': '280634000'},\n",
              " '2013-09-30': {'1. open': '795.0000',\n",
              "  '2. high': '949.0000',\n",
              "  '3. low': '792.0000',\n",
              "  '4. close': '880.0000',\n",
              "  '5. volume': '231821000'},\n",
              " '2013-10-31': {'1. open': '883.0000',\n",
              "  '2. high': '909.0000',\n",
              "  '3. low': '816.0000',\n",
              "  '4. close': '892.0000',\n",
              "  '5. volume': '263939000'},\n",
              " '2013-11-29': {'1. open': '896.0000',\n",
              "  '2. high': '1040.0000',\n",
              "  '3. low': '873.0000',\n",
              "  '4. close': '995.0000',\n",
              "  '5. volume': '331673000'},\n",
              " '2013-12-30': {'1. open': '995.0000',\n",
              "  '2. high': '1065.0000',\n",
              "  '3. low': '952.0000',\n",
              "  '4. close': '1050.0000',\n",
              "  '5. volume': '285723000'},\n",
              " '2014-01-31': {'1. open': '1036.0000',\n",
              "  '2. high': '1059.0000',\n",
              "  '3. low': '961.0000',\n",
              "  '4. close': '970.0000',\n",
              "  '5. volume': '248091000'},\n",
              " '2014-02-28': {'1. open': '965.0000',\n",
              "  '2. high': '977.0000',\n",
              "  '3. low': '876.0000',\n",
              "  '4. close': '916.0000',\n",
              "  '5. volume': '284291000'},\n",
              " '2014-03-31': {'1. open': '902.0000',\n",
              "  '2. high': '964.0000',\n",
              "  '3. low': '845.0000',\n",
              "  '4. close': '898.0000',\n",
              "  '5. volume': '251869000'},\n",
              " '2014-04-30': {'1. open': '901.0000',\n",
              "  '2. high': '930.0000',\n",
              "  '3. low': '764.0000',\n",
              "  '4. close': '765.0000',\n",
              "  '5. volume': '273320000'},\n",
              " '2014-05-30': {'1. open': '774.0000',\n",
              "  '2. high': '832.0000',\n",
              "  '3. low': '743.0000',\n",
              "  '4. close': '821.0000',\n",
              "  '5. volume': '231240000'},\n",
              " '2014-06-30': {'1. open': '827.0000',\n",
              "  '2. high': '897.0000',\n",
              "  '3. low': '825.0000',\n",
              "  '4. close': '877.0000',\n",
              "  '5. volume': '235379000'},\n",
              " '2014-07-31': {'1. open': '877.0000',\n",
              "  '2. high': '907.0000',\n",
              "  '3. low': '828.0000',\n",
              "  '4. close': '876.6000',\n",
              "  '5. volume': '186604000'},\n",
              " '2014-08-29': {'1. open': '865.0000',\n",
              "  '2. high': '877.0000',\n",
              "  '3. low': '809.5000',\n",
              "  '4. close': '846.1000',\n",
              "  '5. volume': '157039000'},\n",
              " '2014-09-30': {'1. open': '844.4000',\n",
              "  '2. high': '902.0000',\n",
              "  '3. low': '844.1000',\n",
              "  '4. close': '868.9000',\n",
              "  '5. volume': '171604000'},\n",
              " '2014-10-31': {'1. open': '864.7000',\n",
              "  '2. high': '869.6000',\n",
              "  '3. low': '738.0000',\n",
              "  '4. close': '861.0000',\n",
              "  '5. volume': '267900000'},\n",
              " '2014-11-28': {'1. open': '981.0000',\n",
              "  '2. high': '988.8000',\n",
              "  '3. low': '927.3000',\n",
              "  '4. close': '953.9000',\n",
              "  '5. volume': '280022000'},\n",
              " '2014-12-30': {'1. open': '954.1000',\n",
              "  '2. high': '1019.0000',\n",
              "  '3. low': '905.0000',\n",
              "  '4. close': '947.6000',\n",
              "  '5. volume': '217232000'},\n",
              " '2015-01-30': {'1. open': '940.4000',\n",
              "  '2. high': '946.0000',\n",
              "  '3. low': '846.0000',\n",
              "  '4. close': '862.5000',\n",
              "  '5. volume': '194491000'},\n",
              " '2015-02-27': {'1. open': '850.0000',\n",
              "  '2. high': '967.6000',\n",
              "  '3. low': '824.5000',\n",
              "  '4. close': '964.9000',\n",
              "  '5. volume': '192963000'},\n",
              " '2015-03-31': {'1. open': '962.0000',\n",
              "  '2. high': '1007.5000',\n",
              "  '3. low': '922.5000',\n",
              "  '4. close': '946.0000',\n",
              "  '5. volume': '233483000'},\n",
              " '2015-04-30': {'1. open': '942.1000',\n",
              "  '2. high': '1048.5000',\n",
              "  '3. low': '929.0000',\n",
              "  '4. close': '1000.0000',\n",
              "  '5. volume': '214432000'},\n",
              " '2015-05-29': {'1. open': '978.0000',\n",
              "  '2. high': '1009.0000',\n",
              "  '3. low': '959.2000',\n",
              "  '4. close': '987.3000',\n",
              "  '5. volume': '140994000'},\n",
              " '2015-06-30': {'1. open': '987.0000',\n",
              "  '2. high': '998.7000',\n",
              "  '3. low': '912.0000',\n",
              "  '4. close': '917.2000',\n",
              "  '5. volume': '178787000'},\n",
              " '2015-07-31': {'1. open': '923.8000',\n",
              "  '2. high': '976.5000',\n",
              "  '3. low': '848.0000',\n",
              "  '4. close': '963.7000',\n",
              "  '5. volume': '190182000'},\n",
              " '2015-08-31': {'1. open': '963.0000',\n",
              "  '2. high': '963.0000',\n",
              "  '3. low': '779.0000',\n",
              "  '4. close': '842.2000',\n",
              "  '5. volume': '191604000'},\n",
              " '2015-09-30': {'1. open': '834.9000',\n",
              "  '2. high': '836.0000',\n",
              "  '3. low': '735.4000',\n",
              "  '4. close': '769.7000',\n",
              "  '5. volume': '182201000'},\n",
              " '2015-10-30': {'1. open': '773.0000',\n",
              "  '2. high': '875.0000',\n",
              "  '3. low': '761.1000',\n",
              "  '4. close': '832.1000',\n",
              "  '5. volume': '154279000'},\n",
              " '2015-11-30': {'1. open': '824.5000',\n",
              "  '2. high': '874.0000',\n",
              "  '3. low': '793.1000',\n",
              "  '4. close': '796.3000',\n",
              "  '5. volume': '151718000'},\n",
              " '2015-12-30': {'1. open': '794.7000',\n",
              "  '2. high': '805.0000',\n",
              "  '3. low': '727.2000',\n",
              "  '4. close': '744.8000',\n",
              "  '5. volume': '199096000'},\n",
              " '2016-01-29': {'1. open': '740.2000',\n",
              "  '2. high': '755.0000',\n",
              "  '3. low': '646.7000',\n",
              "  '4. close': '750.5000',\n",
              "  '5. volume': '209655000'},\n",
              " '2016-02-29': {'1. open': '778.0000',\n",
              "  '2. high': '781.9000',\n",
              "  '3. low': '590.7000',\n",
              "  '4. close': '666.7000',\n",
              "  '5. volume': '283420000'},\n",
              " '2016-03-31': {'1. open': '663.5000',\n",
              "  '2. high': '743.0000',\n",
              "  '3. low': '655.1000',\n",
              "  '4. close': '692.3000',\n",
              "  '5. volume': '202125000'},\n",
              " '2016-04-28': {'1. open': '687.7000',\n",
              "  '2. high': '726.4000',\n",
              "  '3. low': '626.0000',\n",
              "  '4. close': '646.2000',\n",
              "  '5. volume': '170558000'},\n",
              " '2016-05-31': {'1. open': '614.0000',\n",
              "  '2. high': '647.8000',\n",
              "  '3. low': '591.3000',\n",
              "  '4. close': '646.2000',\n",
              "  '5. volume': '121437000'},\n",
              " '2016-06-30': {'1. open': '642.0000',\n",
              "  '2. high': '646.3000',\n",
              "  '3. low': '496.0000',\n",
              "  '4. close': '537.5000',\n",
              "  '5. volume': '191849000'},\n",
              " '2016-07-29': {'1. open': '541.0000',\n",
              "  '2. high': '624.0000',\n",
              "  '3. low': '509.0000',\n",
              "  '4. close': '585.3000',\n",
              "  '5. volume': '174031000'},\n",
              " '2016-08-31': {'1. open': '570.0000',\n",
              "  '2. high': '605.7000',\n",
              "  '3. low': '540.7000',\n",
              "  '4. close': '604.4000',\n",
              "  '5. volume': '127226000'},\n",
              " '2016-09-30': {'1. open': '604.5000',\n",
              "  '2. high': '643.3000',\n",
              "  '3. low': '558.9000',\n",
              "  '4. close': '564.4000',\n",
              "  '5. volume': '151008000'},\n",
              " '2016-10-31': {'1. open': '572.3000',\n",
              "  '2. high': '630.3000',\n",
              "  '3. low': '561.2000',\n",
              "  '4. close': '627.7000',\n",
              "  '5. volume': '151161000'},\n",
              " '2016-11-30': {'1. open': '627.7000',\n",
              "  '2. high': '693.2000',\n",
              "  '3. low': '556.8000',\n",
              "  '4. close': '687.4000',\n",
              "  '5. volume': '213206000'},\n",
              " '2016-12-30': {'1. open': '702.3000',\n",
              "  '2. high': '785.0000',\n",
              "  '3. low': '695.4000',\n",
              "  '4. close': '720.3000',\n",
              "  '5. volume': '215380000'},\n",
              " '2017-01-31': {'1. open': '732.9000',\n",
              "  '2. high': '761.5000',\n",
              "  '3. low': '699.5000',\n",
              "  '4. close': '723.5000',\n",
              "  '5. volume': '127476000'},\n",
              " '2017-02-28': {'1. open': '712.0000',\n",
              "  '2. high': '733.4000',\n",
              "  '3. low': '699.3000',\n",
              "  '4. close': '712.3000',\n",
              "  '5. volume': '142634000'},\n",
              " '2017-03-31': {'1. open': '715.1000',\n",
              "  '2. high': '762.2000',\n",
              "  '3. low': '677.9000',\n",
              "  '4. close': '677.9000',\n",
              "  '5. volume': '190201000'},\n",
              " '2017-04-28': {'1. open': '676.0000',\n",
              "  '2. high': '705.0000',\n",
              "  '3. low': '636.9000',\n",
              "  '4. close': '677.3000',\n",
              "  '5. volume': '181021000'},\n",
              " '2017-05-31': {'1. open': '662.8000',\n",
              "  '2. high': '701.4000',\n",
              "  '3. low': '651.4000',\n",
              "  '4. close': '673.5000',\n",
              "  '5. volume': '144784000'},\n",
              " '2017-06-30': {'1. open': '670.8000',\n",
              "  '2. high': '696.2000',\n",
              "  '3. low': '652.2000',\n",
              "  '4. close': '665.8000',\n",
              "  '5. volume': '160514000'},\n",
              " '2017-07-31': {'1. open': '666.4000',\n",
              "  '2. high': '678.4000',\n",
              "  '3. low': '630.0000',\n",
              "  '4. close': '636.1000',\n",
              "  '5. volume': '140937000'},\n",
              " '2017-08-31': {'1. open': '633.7000',\n",
              "  '2. high': '641.0000',\n",
              "  '3. low': '597.5000',\n",
              "  '4. close': '601.8000',\n",
              "  '5. volume': '182951000'},\n",
              " '2017-09-29': {'1. open': '605.1000',\n",
              "  '2. high': '651.2000',\n",
              "  '3. low': '593.7000',\n",
              "  '4. close': '637.3000',\n",
              "  '5. volume': '170647000'},\n",
              " '2017-10-31': {'1. open': '634.8000',\n",
              "  '2. high': '715.0000',\n",
              "  '3. low': '634.3000',\n",
              "  '4. close': '705.7000',\n",
              "  '5. volume': '196754000'},\n",
              " '2017-11-30': {'1. open': '701.6000',\n",
              "  '2. high': '751.9000',\n",
              "  '3. low': '681.3000',\n",
              "  '4. close': '698.0000',\n",
              "  '5. volume': '204187000'},\n",
              " '2017-12-29': {'1. open': '704.9000',\n",
              "  '2. high': '723.0000',\n",
              "  '3. low': '680.0000',\n",
              "  '4. close': '706.9000',\n",
              "  '5. volume': '167045000'},\n",
              " '2018-01-31': {'1. open': '706.9000',\n",
              "  '2. high': '810.5000',\n",
              "  '3. low': '706.9000',\n",
              "  '4. close': '782.2000',\n",
              "  '5. volume': '181431000'},\n",
              " '2018-02-28': {'1. open': '790.2000',\n",
              "  '2. high': '803.3000',\n",
              "  '3. low': '697.0000',\n",
              "  '4. close': '716.8000',\n",
              "  '5. volume': '169646000'},\n",
              " '2018-03-30': {'1. open': '715.0000',\n",
              "  '2. high': '715.1000',\n",
              "  '3. low': '661.1000',\n",
              "  '4. close': '678.7000',\n",
              "  '5. volume': '169329000'},\n",
              " '2018-04-30': {'1. open': '678.3000',\n",
              "  '2. high': '689.3000',\n",
              "  '3. low': '659.4000',\n",
              "  '4. close': '672.7000',\n",
              "  '5. volume': '143813000'},\n",
              " '2018-05-31': {'1. open': '675.0000',\n",
              "  '2. high': '679.0000',\n",
              "  '3. low': '626.8000',\n",
              "  '4. close': '631.7000',\n",
              "  '5. volume': '148011000'},\n",
              " '2018-06-29': {'1. open': '631.2000',\n",
              "  '2. high': '656.8000',\n",
              "  '3. low': '612.6000',\n",
              "  '4. close': '643.3000',\n",
              "  '5. volume': '123773200'},\n",
              " '2018-07-31': {'1. open': '641.1000',\n",
              "  '2. high': '674.1000',\n",
              "  '3. low': '627.3000',\n",
              "  '4. close': '650.8000',\n",
              "  '5. volume': '118118800'},\n",
              " '2018-08-31': {'1. open': '651.8000',\n",
              "  '2. high': '679.4000',\n",
              "  '3. low': '632.7000',\n",
              "  '4. close': '666.4000',\n",
              "  '5. volume': '136777900'},\n",
              " '2018-09-28': {'1. open': '666.5000',\n",
              "  '2. high': '716.9000',\n",
              "  '3. low': '640.5000',\n",
              "  '4. close': '691.2000',\n",
              "  '5. volume': '143769200'},\n",
              " '2018-10-31': {'1. open': '690.0000',\n",
              "  '2. high': '695.7000',\n",
              "  '3. low': '621.3000',\n",
              "  '4. close': '646.9000',\n",
              "  '5. volume': '150992500'},\n",
              " '2018-11-30': {'1. open': '647.1000',\n",
              "  '2. high': '657.0000',\n",
              "  '3. low': '612.2000',\n",
              "  '4. close': '626.5000',\n",
              "  '5. volume': '113563500'},\n",
              " '2018-12-31': {'1. open': '632.0000',\n",
              "  '2. high': '638.9000',\n",
              "  '3. low': '523.7000',\n",
              "  '4. close': '556.6000',\n",
              "  '5. volume': '138086200'},\n",
              " '2019-01-31': {'1. open': '546.6000',\n",
              "  '2. high': '599.9000',\n",
              "  '3. low': '537.0000',\n",
              "  '4. close': '541.8000',\n",
              "  '5. volume': '123546100'},\n",
              " '2019-02-28': {'1. open': '542.0000',\n",
              "  '2. high': '587.8000',\n",
              "  '3. low': '536.5000',\n",
              "  '4. close': '565.5000',\n",
              "  '5. volume': '120274800'},\n",
              " '2019-03-29': {'1. open': '567.0000',\n",
              "  '2. high': '581.7000',\n",
              "  '3. low': '529.5000',\n",
              "  '4. close': '539.0000',\n",
              "  '5. volume': '127615300'},\n",
              " '2019-04-26': {'1. open': '545.5000',\n",
              "  '2. high': '554.3000',\n",
              "  '3. low': '509.3000',\n",
              "  '4. close': '515.1000',\n",
              "  '5. volume': '72975100'},\n",
              " '2019-05-31': {'1. open': '508.6000',\n",
              "  '2. high': '511.7000',\n",
              "  '3. low': '470.3000',\n",
              "  '4. close': '474.4000',\n",
              "  '5. volume': '98394500'},\n",
              " '2019-06-28': {'1. open': '469.0000',\n",
              "  '2. high': '488.7000',\n",
              "  '3. low': '457.8000',\n",
              "  '4. close': '472.1000',\n",
              "  '5. volume': '95606100'},\n",
              " '2019-07-31': {'1. open': '480.1000',\n",
              "  '2. high': '494.6000',\n",
              "  '3. low': '460.0000',\n",
              "  '4. close': '471.5000',\n",
              "  '5. volume': '109778500'},\n",
              " '2019-08-30': {'1. open': '477.5000',\n",
              "  '2. high': '493.7000',\n",
              "  '3. low': '422.9000',\n",
              "  '4. close': '457.8000',\n",
              "  '5. volume': '125432800'},\n",
              " '2019-09-30': {'1. open': '455.0000',\n",
              "  '2. high': '518.7000',\n",
              "  '3. low': '454.1000',\n",
              "  '4. close': '481.4000',\n",
              "  '5. volume': '142661100'},\n",
              " '2019-10-31': {'1. open': '485.0000',\n",
              "  '2. high': '509.3000',\n",
              "  '3. low': '479.3000',\n",
              "  '4. close': '489.7000',\n",
              "  '5. volume': '145150200'},\n",
              " '2019-11-29': {'1. open': '484.8000',\n",
              "  '2. high': '557.5000',\n",
              "  '3. low': '484.7000',\n",
              "  '4. close': '555.0000',\n",
              "  '5. volume': '119323000'},\n",
              " '2019-12-03': {'1. open': '556.4000',\n",
              "  '2. high': '558.4000',\n",
              "  '3. low': '545.3000',\n",
              "  '4. close': '556.5000',\n",
              "  '5. volume': '5849800'}}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "o9tUS6fOQUkE",
        "colab_type": "code",
        "outputId": "7adf895f-ed5b-4c0d-ae12-17f1f0b80749",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "print(type(data))\n",
        "print(len(data))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'dict'>\n",
            "239\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "y8CvzrxSSt2x",
        "colab_type": "code",
        "outputId": "ba8cccca-5c74-452c-c309-7ca6986ae008",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "source": [
        "data.keys()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dict_keys(['2019-12-03', '2019-11-29', '2019-10-31', '2019-09-30', '2019-08-30', '2019-07-31', '2019-06-28', '2019-05-31', '2019-04-26', '2019-03-29', '2019-02-28', '2019-01-31', '2018-12-31', '2018-11-30', '2018-10-31', '2018-09-28', '2018-08-31', '2018-07-31', '2018-06-29', '2018-05-31', '2018-04-30', '2018-03-30', '2018-02-28', '2018-01-31', '2017-12-29', '2017-11-30', '2017-10-31', '2017-09-29', '2017-08-31', '2017-07-31', '2017-06-30', '2017-05-31', '2017-04-28', '2017-03-31', '2017-02-28', '2017-01-31', '2016-12-30', '2016-11-30', '2016-10-31', '2016-09-30', '2016-08-31', '2016-07-29', '2016-06-30', '2016-05-31', '2016-04-28', '2016-03-31', '2016-02-29', '2016-01-29', '2015-12-30', '2015-11-30', '2015-10-30', '2015-09-30', '2015-08-31', '2015-07-31', '2015-06-30', '2015-05-29', '2015-04-30', '2015-03-31', '2015-02-27', '2015-01-30', '2014-12-30', '2014-11-28', '2014-10-31', '2014-09-30', '2014-08-29', '2014-07-31', '2014-06-30', '2014-05-30', '2014-04-30', '2014-03-31', '2014-02-28', '2014-01-31', '2013-12-30', '2013-11-29', '2013-10-31', '2013-09-30', '2013-08-30', '2013-07-31', '2013-06-28', '2013-05-31', '2013-04-30', '2013-03-29', '2013-02-28', '2013-01-31', '2012-12-28', '2012-11-30', '2012-10-31', '2012-09-28', '2012-08-31', '2012-07-31', '2012-06-29', '2012-05-31', '2012-04-27', '2012-03-30', '2012-02-29', '2012-01-31', '2011-12-30', '2011-11-30', '2011-10-31', '2011-09-30', '2011-08-31', '2011-07-29', '2011-06-30', '2011-05-31', '2011-04-28', '2011-03-31', '2011-02-28', '2011-01-31', '2010-12-30', '2010-11-30', '2010-10-29', '2010-09-30', '2010-08-31', '2010-07-30', '2010-06-30', '2010-05-31', '2010-04-30', '2010-03-31', '2010-02-26', '2010-01-29', '2009-12-30', '2009-11-30', '2009-10-30', '2009-09-30', '2009-08-31', '2009-07-31', '2009-06-30', '2009-05-29', '2009-04-30', '2009-03-31', '2009-02-27', '2009-01-30', '2008-12-30', '2008-11-28', '2008-10-31', '2008-09-30', '2008-08-29', '2008-07-31', '2008-06-30', '2008-05-30', '2008-04-30', '2008-03-31', '2008-02-29', '2008-01-31', '2007-12-28', '2007-11-30', '2007-10-31', '2007-09-28', '2007-08-31', '2007-07-31', '2007-06-29', '2007-05-31', '2007-04-27', '2007-03-30', '2007-02-28', '2007-01-31', '2006-12-29', '2006-11-30', '2006-10-31', '2006-09-29', '2006-08-31', '2006-07-31', '2006-06-30', '2006-05-31', '2006-04-28', '2006-03-31', '2006-02-28', '2006-01-31', '2005-12-30', '2005-11-30', '2005-10-31', '2005-09-30', '2005-08-31', '2005-07-29', '2005-06-30', '2005-05-31', '2005-04-29', '2005-03-31', '2005-02-28', '2005-01-31', '2004-12-31', '2004-11-30', '2004-10-29', '2004-09-30', '2004-08-31', '2004-07-30', '2004-06-30', '2004-05-31', '2004-04-30', '2004-03-31', '2004-02-27', '2004-01-30', '2003-12-31', '2003-11-28', '2003-10-31', '2003-09-30', '2003-08-29', '2003-07-31', '2003-06-30', '2003-05-30', '2003-04-30', '2003-03-31', '2003-02-28', '2003-01-31', '2002-12-31', '2002-11-29', '2002-10-31', '2002-09-30', '2002-08-30', '2002-07-31', '2002-06-28', '2002-05-31', '2002-04-30', '2002-03-29', '2002-02-28', '2002-01-31', '2001-12-31', '2001-11-30', '2001-10-31', '2001-09-28', '2001-08-31', '2001-07-31', '2001-06-29', '2001-05-31', '2001-04-30', '2001-03-30', '2001-02-28', '2001-01-31', '2000-12-29', '2000-11-30', '2000-10-31', '2000-09-29', '2000-08-31', '2000-07-31', '2000-06-30', '2000-05-31', '2000-04-28', '2000-03-31', '2000-02-29'])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zG4ZuZimQoCp",
        "colab_type": "code",
        "outputId": "f784e220-9eea-4401-aee9-8f202f109c61",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "new_date = sorted(data.keys())[-1]\n",
        "old_date = sorted(data.keys())[0]\n",
        "print(new_date)\n",
        "print(old_date)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "2019-12-03\n",
            "2000-02-29\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XGUAiCxpSfBO",
        "colab_type": "code",
        "outputId": "31a54c37-40d9-4682-cb90-365e11e030d6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "old_price = data[old_date][\"4. close\"]\n",
        "print(old_date + \"の株価: \" + old_price)\n",
        "new_price = data[new_date][\"4. close\"]\n",
        "print(new_date + \"の株価： \" + new_price)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "2000-02-29の株価: 1745.0000\n",
            "2019-12-03の株価： 556.5000\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NpA0FPvxTBoc",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "z-N-li80iCo0",
        "colab_type": "text"
      },
      "source": [
        "まとめコード\n",
        "```\n",
        "日経225の証券番号リストが入ったCSVファイルをセットする必要あり\n",
        "```"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KkGaS2H0gKRa",
        "colab_type": "code",
        "outputId": "94168ce8-c017-4fa8-e3ae-e71e6f66b20a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 331
        }
      },
      "source": [
        "import csv\n",
        "import requests\n",
        "import json\n",
        "import time\n",
        "\n",
        "API = \"ＡＰＩキー\"\n",
        "csvfile = \"225.csv\"\n",
        "\n",
        "count = 1\n",
        "\n",
        "with open(csvfile, \"r\") as f:\n",
        "    rows = csv.reader(f)\n",
        "    for row in rows:\n",
        "        print(\"ループ回数: \" + str(count))\n",
        "        row_str = str(\"\".join(row))\n",
        "\n",
        "        response = requests.get(\"https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=\" + row_str + \".T&apikey=\" + API)\n",
        "        data = json.loads(response.text)\n",
        "        data = data[\"Monthly Time Series\"]\n",
        "        new_date = sorted(data.keys())[-1]\n",
        "        old_date = sorted(data.keys())[0]\n",
        "        new_price = data[new_date][\"4. close\"]\n",
        "        old_price = data[old_date][\"4. close\"]\n",
        "        change_rate = float(new_price)/float(old_price)\n",
        "        change_rate = str('{:.2f}'.format(change_rate))\n",
        "    \n",
        "        with open(\"225_Stock_Price.csv\", \"a\") as csvFile:\n",
        "            writer = csv.writer(csvFile)\n",
        "            writer.writerow([row_str, old_date, old_price, new_date, new_price, change_rate])\n",
        "    \n",
        "            count = count + 1\n",
        "            time.sleep(1)\n",
        "\n"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "ループ回数: 1\n",
            "ループ回数: 2\n",
            "ループ回数: 3\n",
            "ループ回数: 4\n",
            "ループ回数: 5\n",
            "ループ回数: 6\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "error",
          "ename": "KeyError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-23-0582f2a4223b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     17\u001b[0m         \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mrequests\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mrow_str\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m\".T&apikey=\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mAPI\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     18\u001b[0m         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloads\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 19\u001b[0;31m         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Monthly Time Series\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     20\u001b[0m         \u001b[0mnew_date\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msorted\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mkeys\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     21\u001b[0m         \u001b[0mold_date\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msorted\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mkeys\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mKeyError\u001b[0m: 'Monthly Time Series'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "x08l55BtiRBo",
        "colab_type": "code",
        "outputId": "11b49ed5-b0b1-4c66-88d6-bfbb80d0659d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 152
        }
      },
      "source": [
        "!head 225.csv -n 8"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "4151\n",
            "4502\n",
            "4503\n",
            "4506\n",
            "4507\n",
            "4519\n",
            "4523\n",
            "4568\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GosdzbqJjVE-",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#4519\n",
        "\n",
        "response = requests.get(\"https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=4519.T&apikey=ＡＰＩキー\")\n",
        "data = json.loads(response.text)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mUVJgAsmkeCj",
        "colab_type": "code",
        "outputId": "7370796b-ac1f-4a5c-d6d0-18e856ee080e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "data.keys()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dict_keys(['Meta Data', 'Monthly Time Series'])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "S9Ux7z4ZkiR6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "data = data[\"Monthly Time Series\"]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VoJR7P2TknJq",
        "colab_type": "code",
        "outputId": "9189c7cc-6af6-4698-9ffc-64301290ec5e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "new_date = sorted(data.keys())[-1]\n",
        "old_date = sorted(data.keys())[0]\n",
        "print(new_date)\n",
        "print(old_date)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "2019-12-03\n",
            "2000-02-29\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ffVLsii9kpxh",
        "colab_type": "code",
        "outputId": "531c79eb-4787-4c8b-85ee-a6e7c04ee570",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "old_price = data[old_date][\"4. close\"]\n",
        "print(old_date + \"の株価: \" + old_price)\n",
        "new_price = data[new_date][\"4. close\"]\n",
        "print(new_date + \"の株価： \" + new_price)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "2000-02-29の株価: 1680.0000\n",
            "2019-12-03の株価： 9718.0000\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8bhpMYVIkr2F",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}