Stock_Time_Series
In this real life's example, we will work with an API that returns daily time series (date, daily open, daily high, daily low, daily close, daily volume, daily adjusted close, and split/dividend events) of the global equity specified, covering 20+ years of historical data.
In [1]:
import json
In [2]:
from urllib.request import urlopen
In [3]:
#Getting the response from the website
with urlopen("https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol=IBM&apikey=5V9JHOJQ903COLKS")as response:
source = response.read()
In [4]:
print(source)
b'{\n "Meta Data": {\n "1. Information": "Daily Time Series with Splits and Dividend Events",\n "2. Symbol": "IBM",\n "3. Last Refreshed": "2020-07-02",\n "4. Output Size": "Compact",\n "5. Time Zone": "US/Eastern"\n },\n "Time Series (Daily)": {\n "2020-07-02": {\n "1. open": "119.6900",\n "2. high": "121.4200",\n "3. low": "119.2600",\n "4. close": "119.7000",\n "5. adjusted close": "119.7000",\n "6. volume": "3745663",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-07-01": {\n "1. open": "120.2700",\n "2. high": "121.2250",\n "3. low": "118.3700",\n "4. close": "118.5400",\n "5. adjusted close": "118.5400",\n "6. volume": "4657168",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-30": {\n "1. open": "119.1900",\n "2. high": "121.2000",\n "3. low": "119.0000",\n "4. close": "120.7700",\n "5. adjusted close": "120.7700",\n "6. volume": "3916381",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-29": {\n "1. open": "117.9800",\n "2. high": "119.7800",\n "3. low": "117.3700",\n "4. close": "119.7500",\n "5. adjusted close": "119.7500",\n "6. volume": "4157205",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-26": {\n "1. open": "118.2600",\n "2. high": "118.9900",\n "3. low": "116.2600",\n "4. close": "117.1900",\n "5. adjusted close": "117.1900",\n "6. volume": "10749166",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-25": {\n "1. open": "116.7600",\n "2. high": "119.2100",\n "3. low": "116.1000",\n "4. close": "119.0300",\n "5. adjusted close": "119.0300",\n "6. volume": "6128720",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-24": {\n "1. open": "118.3200",\n "2. high": "118.3200",\n "3. low": "115.8800",\n "4. close": "116.4200",\n "5. adjusted close": "116.4200",\n "6. volume": "6747421",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-23": {\n "1. open": "122.0100",\n "2. high": "122.9000",\n "3. low": "119.2300",\n "4. close": "119.4100",\n "5. adjusted close": "119.4100",\n "6. volume": "6628278",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-22": {\n "1. open": "122.1200",\n "2. high": "122.5000",\n "3. low": "120.5300",\n "4. close": "121.0700",\n "5. adjusted close": "121.0700",\n "6. volume": "4762601",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-19": {\n "1. open": "126.1700",\n "2. high": "126.8200",\n "3. low": "122.2500",\n "4. close": "122.4700",\n "5. adjusted close": "122.4700",\n "6. volume": "8098994",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-18": {\n "1. open": "123.0000",\n "2. high": "124.4000",\n "3. low": "122.3300",\n "4. close": "124.1600",\n "5. adjusted close": "124.1600",\n "6. volume": "2860286",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-17": {\n "1. open": "125.8300",\n "2. high": "126.2500",\n "3. low": "123.4000",\n "4. close": "124.1500",\n "5. adjusted close": "124.1500",\n "6. volume": "3153862",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-16": {\n "1. open": "125.0000",\n "2. high": "127.5000",\n "3. low": "123.1600",\n "4. close": "125.1500",\n "5. adjusted close": "125.1500",\n "6. volume": "5605791",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-15": {\n "1. open": "119.1900",\n "2. high": "122.3670",\n "3. low": "118.2900",\n "4. close": "121.6500",\n "5. adjusted close": "121.6500",\n "6. volume": "5148756",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-12": {\n "1. open": "121.2500",\n "2. high": "123.1200",\n "3. low": "119.2800",\n "4. close": "121.9100",\n "5. adjusted close": "121.9100",\n "6. volume": "6218003",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-11": {\n "1. open": "126.0300",\n "2. high": "126.1000",\n "3. low": "117.8352",\n "4. close": "118.0100",\n "5. adjusted close": "118.0100",\n "6. volume": "11753674",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-10": {\n "1. open": "132.1500",\n "2. high": "132.2300",\n "3. low": "129.8000",\n "4. close": "129.8700",\n "5. adjusted close": "129.8700",\n "6. volume": "4725055",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-09": {\n "1. open": "133.5200",\n "2. high": "133.6000",\n "3. low": "131.0200",\n "4. close": "131.8700",\n "5. adjusted close": "131.8700",\n "6. volume": "5391520",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-08": {\n "1. open": "132.2700",\n "2. high": "135.8800",\n "3. low": "132.2700",\n "4. close": "135.7500",\n "5. adjusted close": "135.7500",\n "6. volume": "5368387",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-05": {\n "1. open": "133.8850",\n "2. high": "134.2300",\n "3. low": "131.7500",\n "4. close": "132.0600",\n "5. adjusted close": "132.0600",\n "6. volume": "5892718",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-04": {\n "1. open": "127.7800",\n "2. high": "128.9500",\n "3. low": "127.0200",\n "4. close": "128.8900",\n "5. adjusted close": "128.8900",\n "6. volume": "3864131",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-03": {\n "1. open": "127.1500",\n "2. high": "129.5950",\n "3. low": "127.0000",\n "4. close": "129.0500",\n "5. adjusted close": "129.0500",\n "6. volume": "3913804",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-02": {\n "1. open": "125.6700",\n "2. high": "126.0000",\n "3. low": "124.6600",\n "4. close": "126.0000",\n "5. adjusted close": "126.0000",\n "6. volume": "2976908",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-06-01": {\n "1. open": "124.6400",\n "2. high": "125.7500",\n "3. low": "124.0300",\n "4. close": "124.8900",\n "5. adjusted close": "124.8900",\n "6. volume": "2867306",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-29": {\n "1. open": "123.6700",\n "2. high": "125.1300",\n "3. low": "122.2400",\n "4. close": "124.9000",\n "5. adjusted close": "124.9000",\n "6. volume": "7929905",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-28": {\n "1. open": "126.8700",\n "2. high": "126.9700",\n "3. low": "124.2200",\n "4. close": "124.5300",\n "5. adjusted close": "124.5300",\n "6. volume": "3915224",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-27": {\n "1. open": "123.9400",\n "2. high": "125.8300",\n "3. low": "123.4700",\n "4. close": "125.5400",\n "5. adjusted close": "125.5400",\n "6. volume": "5725163",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-26": {\n "1. open": "121.3000",\n "2. high": "122.6200",\n "3. low": "121.0101",\n "4. close": "121.7600",\n "5. adjusted close": "121.7600",\n "6. volume": "5467436",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-22": {\n "1. open": "119.3700",\n "2. high": "119.4650",\n "3. low": "117.5900",\n "4. close": "118.3900",\n "5. adjusted close": "118.3900",\n "6. volume": "4179906",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-21": {\n "1. open": "120.9900",\n "2. high": "121.7200",\n "3. low": "118.9700",\n "4. close": "119.1200",\n "5. adjusted close": "119.1200",\n "6. volume": "4018329",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-20": {\n "1. open": "120.9300",\n "2. high": "122.4659",\n "3. low": "120.6000",\n "4. close": "121.3800",\n "5. adjusted close": "121.3800",\n "6. volume": "3840563",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-19": {\n "1. open": "121.1900",\n "2. high": "122.1700",\n "3. low": "120.1400",\n "4. close": "120.2900",\n "5. adjusted close": "120.2900",\n "6. volume": "3239964",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-18": {\n "1. open": "119.8800",\n "2. high": "122.3600",\n "3. low": "119.7500",\n "4. close": "121.5600",\n "5. adjusted close": "121.5600",\n "6. volume": "4205425",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-15": {\n "1. open": "115.9300",\n "2. high": "117.3900",\n "3. low": "115.2500",\n "4. close": "116.9800",\n "5. adjusted close": "116.9800",\n "6. volume": "4785773",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-14": {\n "1. open": "114.5700",\n "2. high": "117.0900",\n "3. low": "111.8100",\n "4. close": "116.9500",\n "5. adjusted close": "116.9500",\n "6. volume": "5255607",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-13": {\n "1. open": "119.9500",\n "2. high": "119.9900",\n "3. low": "114.8500",\n "4. close": "115.7300",\n "5. adjusted close": "115.7300",\n "6. volume": "5874676",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-12": {\n "1. open": "123.0100",\n "2. high": "124.3200",\n "3. low": "120.2600",\n "4. close": "120.2600",\n "5. adjusted close": "120.2600",\n "6. volume": "4779635",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-11": {\n "1. open": "121.8100",\n "2. high": "123.4500",\n "3. low": "120.6700",\n "4. close": "122.5900",\n "5. adjusted close": "122.5900",\n "6. volume": "3533382",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-08": {\n "1. open": "122.6700",\n "2. high": "123.2300",\n "3. low": "121.0600",\n "4. close": "122.9900",\n "5. adjusted close": "122.9900",\n "6. volume": "5002450",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-07": {\n "1. open": "122.9800",\n "2. high": "123.2600",\n "3. low": "120.8500",\n "4. close": "121.2300",\n "5. adjusted close": "121.2300",\n "6. volume": "4412047",\n "7. dividend amount": "1.6300",\n "8. split coefficient": "1.0000"\n },\n "2020-05-06": {\n "1. open": "123.2400",\n "2. high": "124.0500",\n "3. low": "122.4100",\n "4. close": "123.1700",\n "5. adjusted close": "121.5359",\n "6. volume": "3861081",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-05": {\n "1. open": "123.3900",\n "2. high": "124.3200",\n "3. low": "122.4700",\n "4. close": "122.5800",\n "5. adjusted close": "120.9537",\n "6. volume": "3897761",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-04": {\n "1. open": "120.8200",\n "2. high": "121.9700",\n "3. low": "119.3910",\n "4. close": "121.6800",\n "5. adjusted close": "120.0657",\n "6. volume": "4016551",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-05-01": {\n "1. open": "123.1900",\n "2. high": "123.4700",\n "3. low": "121.3900",\n "4. close": "121.8700",\n "5. adjusted close": "120.2531",\n "6. volume": "4923913",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-30": {\n "1. open": "126.5200",\n "2. high": "127.2700",\n "3. low": "125.2200",\n "4. close": "125.5600",\n "5. adjusted close": "123.8942",\n "6. volume": "6630032",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-29": {\n "1. open": "128.8800",\n "2. high": "129.3100",\n "3. low": "127.5300",\n "4. close": "128.6900",\n "5. adjusted close": "126.9827",\n "6. volume": "5252734",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-28": {\n "1. open": "128.0300",\n "2. high": "128.2000",\n "3. low": "125.3800",\n "4. close": "126.2700",\n "5. adjusted close": "124.5948",\n "6. volume": "4775867",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-27": {\n "1. open": "125.5600",\n "2. high": "126.9900",\n "3. low": "125.4700",\n "4. close": "125.9200",\n "5. adjusted close": "124.2494",\n "6. volume": "4920443",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-24": {\n "1. open": "122.4100",\n "2. high": "125.0000",\n "3. low": "120.7634",\n "4. close": "124.7200",\n "5. adjusted close": "123.0653",\n "6. volume": "4985575",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-23": {\n "1. open": "119.5700",\n "2. high": "123.0300",\n "3. low": "119.1200",\n "4. close": "121.3500",\n "5. adjusted close": "119.7400",\n "6. volume": "6873899",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-22": {\n "1. open": "119.8700",\n "2. high": "120.3300",\n "3. low": "117.5500",\n "4. close": "119.3100",\n "5. adjusted close": "117.7271",\n "6. volume": "7085901",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-21": {\n "1. open": "114.0000",\n "2. high": "117.1450",\n "3. low": "112.0600",\n "4. close": "116.7600",\n "5. adjusted close": "115.2109",\n "6. volume": "14341304",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-20": {\n "1. open": "119.1500",\n "2. high": "122.8635",\n "3. low": "118.1400",\n "4. close": "120.4100",\n "5. adjusted close": "118.8125",\n "6. volume": "7965530",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-17": {\n "1. open": "119.3000",\n "2. high": "120.3900",\n "3. low": "117.9200",\n "4. close": "120.1200",\n "5. adjusted close": "118.5264",\n "6. volume": "4964018",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-16": {\n "1. open": "119.0100",\n "2. high": "119.7500",\n "3. low": "114.4200",\n "4. close": "115.7300",\n "5. adjusted close": "114.1946",\n "6. volume": "6438128",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-15": {\n "1. open": "119.1200",\n "2. high": "120.1852",\n "3. low": "116.7600",\n "4. close": "118.6900",\n "5. adjusted close": "117.1153",\n "6. volume": "5632156",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-14": {\n "1. open": "123.4600",\n "2. high": "125.1800",\n "3. low": "122.6200",\n "4. close": "123.9100",\n "5. adjusted close": "122.2661",\n "6. volume": "5087292",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-13": {\n "1. open": "121.6300",\n "2. high": "121.8000",\n "3. low": "118.0400",\n "4. close": "121.1500",\n "5. adjusted close": "119.5427",\n "6. volume": "5118777",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-09": {\n "1. open": "120.4800",\n "2. high": "122.9200",\n "3. low": "120.1672",\n "4. close": "121.5000",\n "5. adjusted close": "119.8880",\n "6. volume": "5576210",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-08": {\n "1. open": "116.3100",\n "2. high": "119.9600",\n "3. low": "115.0742",\n "4. close": "119.2900",\n "5. adjusted close": "117.7074",\n "6. volume": "5155987",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-07": {\n "1. open": "118.8000",\n "2. high": "119.5700",\n "3. low": "114.8700",\n "4. close": "114.9400",\n "5. adjusted close": "113.4151",\n "6. volume": "5592463",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-06": {\n "1. open": "110.3500",\n "2. high": "115.6300",\n "3. low": "110.1300",\n "4. close": "114.8200",\n "5. adjusted close": "113.2967",\n "6. volume": "7026457",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-03": {\n "1. open": "108.9200",\n "2. high": "110.0700",\n "3. low": "104.9200",\n "4. close": "106.3400",\n "5. adjusted close": "104.9292",\n "6. volume": "4538113",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-02": {\n "1. open": "105.3700",\n "2. high": "110.3200",\n "3. low": "105.1400",\n "4. close": "110.0000",\n "5. adjusted close": "108.5406",\n "6. volume": "6327540",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-04-01": {\n "1. open": "106.3600",\n "2. high": "109.9200",\n "3. low": "104.5210",\n "4. close": "105.1400",\n "5. adjusted close": "103.7451",\n "6. volume": "6111890",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-31": {\n "1. open": "112.0000",\n "2. high": "113.8100",\n "3. low": "110.1700",\n "4. close": "110.9300",\n "5. adjusted close": "109.4583",\n "6. volume": "6342167",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-30": {\n "1. open": "108.0900",\n "2. high": "113.4600",\n "3. low": "107.8100",\n "4. close": "112.9300",\n "5. adjusted close": "111.4317",\n "6. volume": "5562501",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-27": {\n "1. open": "108.5800",\n "2. high": "111.5000",\n "3. low": "107.6450",\n "4. close": "108.0300",\n "5. adjusted close": "106.5968",\n "6. volume": "6421470",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-26": {\n "1. open": "106.9100",\n "2. high": "113.1500",\n "3. low": "105.5700",\n "4. close": "112.8900",\n "5. adjusted close": "111.3923",\n "6. volume": "7153135",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-25": {\n "1. open": "105.4800",\n "2. high": "112.4779",\n "3. low": "102.8300",\n "4. close": "105.8500",\n "5. adjusted close": "104.4457",\n "6. volume": "8646557",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-24": {\n "1. open": "99.9900",\n "2. high": "106.0400",\n "3. low": "99.2600",\n "4. close": "105.4800",\n "5. adjusted close": "104.0806",\n "6. volume": "7967768",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-23": {\n "1. open": "94.6000",\n "2. high": "97.7400",\n "3. low": "90.5600",\n "4. close": "94.7700",\n "5. adjusted close": "93.5127",\n "6. volume": "9718602",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-20": {\n "1. open": "100.9200",\n "2. high": "100.9900",\n "3. low": "94.7100",\n "4. close": "95.3900",\n "5. adjusted close": "94.1244",\n "6. volume": "10543213",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-19": {\n "1. open": "102.3300",\n "2. high": "103.6900",\n "3. low": "98.2350",\n "4. close": "100.3400",\n "5. adjusted close": "99.0088",\n "6. volume": "8391294",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-18": {\n "1. open": "99.4100",\n "2. high": "106.9345",\n "3. low": "99.4000",\n "4. close": "103.5500",\n "5. adjusted close": "102.1762",\n "6. volume": "8751994",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-17": {\n "1. open": "100.6100",\n "2. high": "107.3950",\n "3. low": "97.1000",\n "4. close": "106.6500",\n "5. adjusted close": "105.2351",\n "6. volume": "8887501",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-16": {\n "1. open": "98.0000",\n "2. high": "107.4100",\n "3. low": "95.0000",\n "4. close": "99.0800",\n "5. adjusted close": "97.7655",\n "6. volume": "10564044",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-13": {\n "1. open": "108.6800",\n "2. high": "109.1600",\n "3. low": "100.8100",\n "4. close": "107.9500",\n "5. adjusted close": "106.5178",\n "6. volume": "12493419",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-12": {\n "1. open": "109.6500",\n "2. high": "109.8000",\n "3. low": "102.2800",\n "4. close": "102.8100",\n "5. adjusted close": "101.4460",\n "6. volume": "12485925",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-11": {\n "1. open": "121.0100",\n "2. high": "122.5800",\n "3. low": "116.3838",\n "4. close": "117.9700",\n "5. adjusted close": "116.4049",\n "6. volume": "8446480",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-10": {\n "1. open": "122.7800",\n "2. high": "124.8800",\n "3. low": "115.7600",\n "4. close": "124.7700",\n "5. adjusted close": "123.1147",\n "6. volume": "11403865",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-09": {\n "1. open": "120.1600",\n "2. high": "122.4100",\n "3. low": "117.2800",\n "4. close": "117.8100",\n "5. adjusted close": "116.2470",\n "6. volume": "10750357",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-06": {\n "1. open": "126.7000",\n "2. high": "128.3300",\n "3. low": "124.5200",\n "4. close": "127.7300",\n "5. adjusted close": "126.0354",\n "6. volume": "8192525",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-05": {\n "1. open": "130.5000",\n "2. high": "132.2900",\n "3. low": "128.4500",\n "4. close": "129.5500",\n "5. adjusted close": "127.8312",\n "6. volume": "5445193",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-04": {\n "1. open": "131.5800",\n "2. high": "134.2800",\n "3. low": "129.0000",\n "4. close": "134.2200",\n "5. adjusted close": "132.4393",\n "6. volume": "4994682",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-03": {\n "1. open": "134.4800",\n "2. high": "136.0950",\n "3. low": "127.8000",\n "4. close": "128.9000",\n "5. adjusted close": "127.1899",\n "6. volume": "7893390",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-03-02": {\n "1. open": "130.7500",\n "2. high": "134.4400",\n "3. low": "127.9500",\n "4. close": "134.3000",\n "5. adjusted close": "132.5182",\n "6. volume": "8528971",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-28": {\n "1. open": "129.9800",\n "2. high": "131.0900",\n "3. low": "126.3600",\n "4. close": "130.1500",\n "5. adjusted close": "128.4233",\n "6. volume": "13009236",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-27": {\n "1. open": "137.2400",\n "2. high": "138.6900",\n "3. low": "133.0100",\n "4. close": "133.1100",\n "5. adjusted close": "131.3440",\n "6. volume": "8404903",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-26": {\n "1. open": "142.9000",\n "2. high": "144.0600",\n "3. low": "139.6000",\n "4. close": "139.7500",\n "5. adjusted close": "137.8959",\n "6. volume": "5407690",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-25": {\n "1. open": "146.5100",\n "2. high": "147.0700",\n "3. low": "141.2610",\n "4. close": "141.7100",\n "5. adjusted close": "139.8299",\n "6. volume": "6210878",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-24": {\n "1. open": "145.5100",\n "2. high": "148.0500",\n "3. low": "145.3800",\n "4. close": "146.4300",\n "5. adjusted close": "144.4873",\n "6. volume": "5447948",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-21": {\n "1. open": "151.0400",\n "2. high": "151.0400",\n "3. low": "148.8400",\n "4. close": "149.8400",\n "5. adjusted close": "147.8521",\n "6. volume": "3536740",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-20": {\n "1. open": "150.8100",\n "2. high": "151.6200",\n "3. low": "149.5100",\n "4. close": "151.2200",\n "5. adjusted close": "149.2137",\n "6. volume": "2880483",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-19": {\n "1. open": "151.5400",\n "2. high": "151.8900",\n "3. low": "150.3100",\n "4. close": "150.8600",\n "5. adjusted close": "148.8585",\n "6. volume": "2732905",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-18": {\n "1. open": "149.7900",\n "2. high": "151.3800",\n "3. low": "149.6400",\n "4. close": "151.1000",\n "5. adjusted close": "149.0953",\n "6. volume": "3343038",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-14": {\n "1. open": "154.4200",\n "2. high": "154.5600",\n "3. low": "149.7700",\n "4. close": "150.7000",\n "5. adjusted close": "148.7006",\n "6. volume": "6095081",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-13": {\n "1. open": "154.3700",\n "2. high": "154.8300",\n "3. low": "153.4100",\n "4. close": "154.3100",\n "5. adjusted close": "152.2627",\n "6. volume": "3819757",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-12": {\n "1. open": "153.7500",\n "2. high": "155.6000",\n "3. low": "153.5200",\n "4. close": "155.3100",\n "5. adjusted close": "153.2495",\n "6. volume": "4437792",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n },\n "2020-02-11": {\n "1. open": "155.1200",\n "2. high": "155.2200",\n "3. low": "152.7304",\n "4. close": "153.4800",\n "5. adjusted close": "151.4438",\n "6. volume": "3833574",\n "7. dividend amount": "0.0000",\n "8. split coefficient": "1.0000"\n }\n }\n}'
Since the content above is not very readable, we will load this response into a python object using the JSON module:
In [5]:
stock_data = json.loads(source)
In [6]:
print(json.dumps(stock_data, indent=2))
{
"Meta Data": {
"1. Information": "Daily Time Series with Splits and Dividend Events",
"2. Symbol": "IBM",
"3. Last Refreshed": "2020-07-02",
"4. Output Size": "Compact",
"5. Time Zone": "US/Eastern"
},
"Time Series (Daily)": {
"2020-07-02": {
"1. open": "119.6900",
"2. high": "121.4200",
"3. low": "119.2600",
"4. close": "119.7000",
"5. adjusted close": "119.7000",
"6. volume": "3745663",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-07-01": {
"1. open": "120.2700",
"2. high": "121.2250",
"3. low": "118.3700",
"4. close": "118.5400",
"5. adjusted close": "118.5400",
"6. volume": "4657168",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-30": {
"1. open": "119.1900",
"2. high": "121.2000",
"3. low": "119.0000",
"4. close": "120.7700",
"5. adjusted close": "120.7700",
"6. volume": "3916381",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-29": {
"1. open": "117.9800",
"2. high": "119.7800",
"3. low": "117.3700",
"4. close": "119.7500",
"5. adjusted close": "119.7500",
"6. volume": "4157205",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-26": {
"1. open": "118.2600",
"2. high": "118.9900",
"3. low": "116.2600",
"4. close": "117.1900",
"5. adjusted close": "117.1900",
"6. volume": "10749166",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-25&##34;: {
"1. open": "116.7600",
"2. high": "119.2100",
"3. low": "116.1000",
"4. close": "119.0300",
"5. adjusted close": "119.0300",
"6. volume": "6128720",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-24": {
"1. open": "118.3200",
"2. high": "118.3200",
"3. low": "115.8800",
"4. close": "116.4200",
"5. adjusted close": "116.4200",
"6. volume": "6747421",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-23": {
"1. open": "122.0100",
"2. high": "122.9000",
"3. low": "119.2300",
"4. close": "119.4100",
"5. adjusted close": "119.4100",
"6. volume": "6628278",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-22": {
"1. open": "122.1200",
"2. high": "122.5000",
"3. low": "120.5300",
"4. close": "121.0700",
"5. adjusted close": "121.0700",
"6. volume": "4762601",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-19": {
"1. open": "126.1700",
"2. high": "126.8200",
"3. low": "122.2500",
"4. close": "122.4700",
"5. adjusted close": "122.4700",
"6. volume": "8098994",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-18": {
"1. open": "123.0000",
"2. high": "124.4000",
"3. low": "122.3300",
"4. close": "124.1600",
"5. adjusted close": "124.1600",
"6. volume": "2860286",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-17": {
"1. open": "125.8300",
"2. high": "126.2500",
"3. low": "123.4000",
"4. close": "124.1500",
"5. adjusted close": "124.1500",
"6. volume": "3153862",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-16": {
"1. open": "125.0000",
"2. high": "127.5000",
"3. low": "123.1600",
"4. close": "125.1500",
"5. adjusted close": "125.1500",
"6. volume": "5605791",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-15": {
"1. open": "119.1900",
"2. high": "122.3670",
"3. low": "118.2900",
"4. close": "121.6500",
"5. adjusted close": "121.6500",
"6. volume": "5148756",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-12": {
"1. open": "121.2500",
"2. high": "123.1200",
"3. low": "119.2800",
"4. close": "121.9100",
"5. adjusted close": "121.9100",
"6. volume": "6218003",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-11": {
"1. open": "126.0300",
"2. high": "126.1000",
"3. low": "117.8352",
"4. close": "118.0100",
"5. adjusted close": "118.0100",
"6. volume": "11753674",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-10": {
"1. open": "132.1500",
"2. high": "132.2300",
"3. low": "129.8000",
"4. close": "129.8700",
"5. adjusted close": "129.8700",
"6. volume": "4725055",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-09": {
"1. open": "133.5200",
"2. high": "133.6000",
"3. low": "131.0200",
"4. close": "131.8700",
"5. adjusted close": "131.8700",
"6. volume": "5391520",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-08": {
"1. open": "132.2700",
"2. high": "135.8800",
"3. low": "132.2700",
"4. close": "135.7500",
"5. adjusted close": "135.7500",
"6. volume": "5368387",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-05": {
"1. open": "133.8850",
"2. high": "134.2300",
"3. low": "131.7500",
"4. close": "132.0600",
"5. adjusted close": "132.0600",
"6. volume": "5892718",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-04": {
"1. open": "127.7800",
"2. high": "128.9500",
"3. low": "127.0200",
"4. close": "128.8900",
"5. adjusted close": "128.8900",
"6. volume": "3864131",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-03": {
"1. open": "127.1500",
"2. high": "129.5950",
"3. low": "127.0000",
"4. close": "129.0500",
"5. adjusted close": "129.0500",
"6. volume": "3913804",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-02": {
"1. open": "125.6700",
"2. high": "126.0000",
"3. low": "124.6600",
"4. close": "126.0000",
"5. adjusted close": "126.0000",
"6. volume": "2976908",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-06-01": {
"1. open": "124.6400",
"2. high": "125.7500",
"3. low": "124.0300",
"4. close": "124.8900",
"5. adjusted close": "124.8900",
"6. volume": "2867306",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-29": {
"1. open": "123.6700",
"2. high": "125.1300",
"3. low": "122.2400",
"4. close": "124.9000",
"5. adjusted close": "124.9000",
"6. volume": "7929905",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-28": {
"1. open": "126.8700",
"2. high": "126.9700",
"3. low": "124.2200",
"4. close": "124.5300",
"5. adjusted close": "124.5300",
"6. volume": "3915224",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-27": {
"1. open": "123.9400",
"2. high": "125.8300",
"3. low": "123.4700",
"4. close": "125.5400",
"5. adjusted close": "125.5400",
"6. volume": "5725163",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-26": {
"1. open": "121.3000",
"2. high": "122.6200",
"3. low": "121.0101",
"4. close": "121.7600",
"5. adjusted close": "121.7600",
"6. volume": "5467436",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-22": {
"1. open": "119.3700",
"2. high": "119.4650",
"3. low": "117.5900",
"4. close": "118.3900",
"5. adjusted close": "118.3900",
"6. volume": "4179906",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-21": {
"1. open": "120.9900",
"2. high": "121.7200",
"3. low": "118.9700",
"4. close": "119.1200",
"5. adjusted close": "119.1200",
"6. volume": "4018329",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-20": {
"1. open": "120.9300",
"2. high": "122.4659",
"3. low": "120.6000",
"4. close": "121.3800",
"5. adjusted close": "121.3800",
"6. volume": "3840563",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-19": {
"1. open": "121.1900",
"2. high": "122.1700",
"3. low": "120.1400",
"4. close": "120.2900",
"5. adjusted close": "120.2900",
"6. volume": "3239964",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-18": {
"1. open": "119.8800",
"2. high": "122.3600",
"3. low": "119.7500",
"4. close": "121.5600",
"5. adjusted close": "121.5600",
"6. volume": "4205425",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-15": {
"1. open": "115.9300",
"2. high": "117.3900",
"3. low": "115.2500",
"4. close": "116.9800",
"5. adjusted close": "116.9800",
"6. volume": "4785773",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-14": {
"1. open": "114.5700",
"2. high": "117.0900",
"3. low": "111.8100",
"4. close": "116.9500",
"5. adjusted close": "116.9500",
"6. volume": "5255607",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-13": {
"1. open": "119.9500",
"2. high": "119.9900",
"3. low": "114.8500",
"4. close": "115.7300",
"5. adjusted close": "115.7300",
"6. volume": "5874676",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-12": {
"1. open": "123.0100",
"2. high": "124.3200",
"3. low": "120.2600",
"4. close": "120.2600",
"5. adjusted close": "120.2600",
"6. volume": "4779635",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-11": {
"1. open": "121.8100",
"2. high": "123.4500",
"3. low": "120.6700",
"4. close": "122.5900",
"5. adjusted close": "122.5900",
"6. volume": "3533382",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-08": {
"1. open": "122.6700",
"2. high": "123.2300",
"3. low": "121.0600",
"4. close": "122.9900",
"5. adjusted close": "122.9900",
"6. volume": "5002450",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-07": {
"1. open": "122.9800",
"2. high": "123.2600",
"3. low": "120.8500",
"4. close": "121.2300",
"5. adjusted close": "121.2300",
"6. volume": "4412047",
"7. dividend amount": "1.6300",
"8. split coefficient": "1.0000"
},
"2020-05-06": {
"1. open": "123.2400",
"2. high": "124.0500",
"3. low": "122.4100",
"4. close": "123.1700",
"5. adjusted close": "121.5359",
"6. volume": "3861081",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-05": {
"1. open": "123.3900",
"2. high": "124.3200",
"3. low": "122.4700",
"4. close": "122.5800",
"5. adjusted close": "120.9537",
"6. volume": "3897761",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-04": {
"1. open": "120.8200",
"2. high": "121.9700",
"3. low": "119.3910",
"4. close": "121.6800",
"5. adjusted close": "120.0657",
"6. volume": "4016551",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-05-01": {
"1. open": "123.1900",
"2. high": "123.4700",
"3. low": "121.3900",
"4. close": "121.8700",
"5. adjusted close": "120.2531",
"6. volume": "4923913",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-30": {
"1. open": "126.5200",
"2. high": "127.2700",
"3. low": "125.2200",
"4. close": "125.5600",
"5. adjusted close": "123.8942",
"6. volume": "6630032",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-29": {
"1. open": "128.8800",
"2. high": "129.3100",
"3. low": "127.5300",
"4. close": "128.6900",
"5. adjusted close": "126.9827",
"6. volume": "5252734",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-28": {
"1. open": "128.0300",
"2. high": "128.2000",
"3. low": "125.3800",
"4. close": "126.2700",
"5. adjusted close": "124.5948",
"6. volume": "4775867",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-27": {
"1. open": "125.5600",
"2. high": "126.9900",
"3. low": "125.4700",
"4. close": "125.9200",
"5. adjusted close": "124.2494",
"6. volume": "4920443",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-24": {
"1. open": "122.4100",
"2. high": "125.0000",
"3. low": "120.7634",
"4. close": "124.7200",
"5. adjusted close": "123.0653",
"6. volume": "4985575",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-23": {
"1. open": "119.5700",
"2. high": "123.0300",
"3. low": "119.1200",
"4. close": "121.3500",
"5. adjusted close": "119.7400",
"6. volume": "6873899",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-22": {
"1. open": "119.8700",
"2. high": "120.3300",
"3. low": "117.5500",
"4. close": "119.3100",
"5. adjusted close": "117.7271",
"6. volume": "7085901",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-21": {
"1. open": "114.0000",
"2. high": "117.1450",
"3. low": "112.0600",
"4. close": "116.7600",
"5. adjusted close": "115.2109",
"6. volume": "14341304",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-20": {
"1. open": "119.1500",
"2. high": "122.8635",
"3. low": "118.1400",
"4. close": "120.4100",
"5. adjusted close": "118.8125",
"6. volume": "7965530",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-17": {
"1. open": "119.3000",
"2. high": "120.3900",
"3. low": "117.9200",
"4. close": "120.1200",
"5. adjusted close": "118.5264",
"6. volume": "4964018",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-16": {
"1. open": "119.0100",
"2. high": "119.7500",
"3. low": "114.4200",
"4. close": "115.7300",
"5. adjusted close": "114.1946",
"6. volume": "6438128",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-15": {
"1. open": "119.1200",
"2. high": "120.1852",
"3. low": "116.7600",
"4. close": "118.6900",
"5. adjusted close": "117.1153",
"6. volume": "5632156",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-14": {
"1. open": "123.4600",
"2. high": "125.1800",
"3. low": "122.6200",
"4. close": "123.9100",
"5. adjusted close": "122.2661",
"6. volume": "5087292",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-13": {
"1. open": "121.6300",
"2. high": "121.8000",
"3. low": "118.0400",
"4. close": "121.1500",
"5. adjusted close": "119.5427",
"6. volume": "5118777",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-09": {
"1. open": "120.4800",
"2. high": "122.9200",
"3. low": "120.1672",
"4. close": "121.5000",
"5. adjusted close": "119.8880",
"6. volume": "5576210",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-08": {
"1. open": "116.3100",
"2. high": "119.9600",
"3. low": "115.0742",
"4. close": "119.2900",
"5. adjusted close": "117.7074",
"6. volume": "5155987",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-07": {
"1. open": "118.8000",
"2. high": "119.5700",
"3. low": "114.8700",
"4. close": "114.9400",
"5. adjusted close": "113.4151",
"6. volume": "5592463",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-06": {
"1. open": "110.3500",
"2. high": "115.6300",
"3. low": "110.1300",
"4. close": "114.8200",
"5. adjusted close": "113.2967",
"6. volume": "7026457",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-03": {
"1. open": "108.9200",
"2. high": "110.0700",
"3. low": "104.9200",
"4. close": "106.3400",
"5. adjusted close": "104.9292",
"6. volume": "4538113",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-02": {
"1. open": "105.3700",
"2. high": "110.3200",
"3. low": "105.1400",
"4. close": "110.0000",
"5. adjusted close": "108.5406",
"6. volume": "6327540",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-04-01": {
"1. open": "106.3600",
"2. high": "109.9200",
"3. low": "104.5210",
"4. close": "105.1400",
"5. adjusted close": "103.7451",
"6. volume": "6111890",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-31": {
"1. open": "112.0000",
"2. high": "113.8100",
"3. low": "110.1700",
"4. close": "110.9300",
"5. adjusted close": "109.4583",
"6. volume": "6342167",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-30": {
"1. open": "108.0900",
"2. high": "113.4600",
"3. low": "107.8100",
"4. close": "112.9300",
"5. adjusted close": "111.4317",
"6. volume": "5562501",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-27": {
"1. open": "108.5800",
"2. high": "111.5000",
"3. low": "107.6450",
"4. close": "108.0300",
"5. adjusted close": "106.5968",
"6. volume": "6421470",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-26": {
"1. open": "106.9100",
"2. high": "113.1500",
"3. low": "105.5700",
"4. close": "112.8900",
"5. adjusted close": "111.3923",
"6. volume": "7153135",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-25": {
"1. open": "105.4800",
"2. high": "112.4779",
"3. low": "102.8300",
"4. close": "105.8500",
"5. adjusted close": "104.4457",
"6. volume": "8646557",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-24": {
"1. open": "99.9900",
"2. high": "106.0400",
"3. low": "99.2600",
"4. close": "105.4800",
"5. adjusted close": "104.0806",
"6. volume": "7967768",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-23": {
"1. open": "94.6000",
"2. high": "97.7400",
"3. low": "90.5600",
"4. close": "94.7700",
"5. adjusted close": "93.5127",
"6. volume": "9718602",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-20": {
"1. open": "100.9200",
"2. high": "100.9900",
"3. low": "94.7100",
"4. close": "95.3900",
"5. adjusted close": "94.1244",
"6. volume": "10543213",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-19": {
"1. open": "102.3300",
"2. high": "103.6900",
"3. low": "98.2350",
"4. close": "100.3400",
"5. adjusted close": "99.0088",
"6. volume": "8391294",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-18": {
"1. open": "99.4100",
"2. high": "106.9345",
"3. low": "99.4000",
"4. close": "103.5500",
"5. adjusted close": "102.1762",
"6. volume": "8751994",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-17": {
"1. open": "100.6100",
"2. high": "107.3950",
"3. low": "97.1000",
"4. close": "106.6500",
"5. adjusted close": "105.2351",
"6. volume": "8887501",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-16": {
"1. open": "98.0000",
"2. high": "107.4100",
"3. low": "95.0000",
"4. close": "99.0800",
"5. adjusted close": "97.7655",
"6. volume": "10564044",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-13": {
"1. open": "108.6800",
"2. high": "109.1600",
"3. low": "100.8100",
"4. close": "107.9500",
"5. adjusted close": "106.5178",
"6. volume": "12493419",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-12": {
"1. open": "109.6500",
"2. high": "109.8000",
"3. low": "102.2800",
"4. close": "102.8100",
"5. adjusted close": "101.4460",
"6. volume": "12485925",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-11": {
"1. open": "121.0100",
"2. high": "122.5800",
"3. low": "116.3838",
"4. close": "117.9700",
"5. adjusted close": "116.4049",
"6. volume": "8446480",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-10": {
"1. open": "122.7800",
"2. high": "124.8800",
"3. low": "115.7600",
"4. close": "124.7700",
"5. adjusted close": "123.1147",
"6. volume": "11403865",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-09": {
"1. open": "120.1600",
"2. high": "122.4100",
"3. low": "117.2800",
"4. close": "117.8100",
"5. adjusted close": "116.2470",
"6. volume": "10750357",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-06": {
"1. open": "126.7000",
"2. high": "128.3300",
"3. low": "124.5200",
"4. close": "127.7300",
"5. adjusted close": "126.0354",
"6. volume": "8192525",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-05": {
"1. open": "130.5000",
"2. high": "132.2900",
"3. low": "128.4500",
"4. close": "129.5500",
"5. adjusted close": "127.8312",
"6. volume": "5445193",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-04": {
"1. open": "131.5800",
"2. high": "134.2800",
"3. low": "129.0000",
"4. close": "134.2200",
"5. adjusted close": "132.4393",
"6. volume": "4994682",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-03": {
"1. open": "134.4800",
"2. high": "136.0950",
"3. low": "127.8000",
"4. close": "128.9000",
"5. adjusted close": "127.1899",
"6. volume": "7893390",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-03-02": {
"1. open": "130.7500",
"2. high": "134.4400",
"3. low": "127.9500",
"4. close": "134.3000",
"5. adjusted close": "132.5182",
"6. volume": "8528971",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-28": {
"1. open": "129.9800",
"2. high": "131.0900",
"3. low": "126.3600",
"4. close": "130.1500",
"5. adjusted close": "128.4233",
"6. volume": "13009236",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-27": {
"1. open": "137.2400",
"2. high": "138.6900",
"3. low": "133.0100",
"4. close": "133.1100",
"5. adjusted close": "131.3440",
"6. volume": "8404903",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-26": {
"1. open": "142.9000",
"2. high": "144.0600",
"3. low": "139.6000",
"4. close": "139.7500",
"5. adjusted close": "137.8959",
"6. volume": "5407690",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-25": {
"1. open": "146.5100",
"2. high": "147.0700",
"3. low": "141.2610",
"4. close": "141.7100",
"5. adjusted close": "139.8299",
"6. volume": "6210878",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-24": {
"1. open": "145.5100",
"2. high": "148.0500",
"3. low": "145.3800",
"4. close": "146.4300",
"5. adjusted close": "144.4873",
"6. volume": "5447948",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-21": {
"1. open": "151.0400",
"2. high": "151.0400",
"3. low": "148.8400",
"4. close": "149.8400",
"5. adjusted close": "147.8521",
"6. volume": "3536740",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-20": {
"1. open": "150.8100",
"2. high": "151.6200",
"3. low": "149.5100",
"4. close": "151.2200",
"5. adjusted close": "149.2137",
"6. volume": "2880483",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-19": {
"1. open": "151.5400",
"2. high": "151.8900",
"3. low": "150.3100",
"4. close": "150.8600",
"5. adjusted close": "148.8585",
"6. volume": "2732905",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-18": {
"1. open": "149.7900",
"2. high": "151.3800",
"3. low": "149.6400",
"4. close": "151.1000",
"5. adjusted close": "149.0953",
"6. volume": "3343038",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-14": {
"1. open": "154.4200",
"2. high": "154.5600",
"3. low": "149.7700",
"4. close": "150.7000",
"5. adjusted close": "148.7006",
"6. volume": "6095081",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-13": {
"1. open": "154.3700",
"2. high": "154.8300",
"3. low": "153.4100",
"4. close": "154.3100",
"5. adjusted close": "152.2627",
"6. volume": "3819757",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-12": {
"1. open": "153.7500",
"2. high": "155.6000",
"3. low": "153.5200",
"4. close": "155.3100",
"5. adjusted close": "153.2495",
"6. volume": "4437792",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
},
"2020-02-11": {
"1. open": "155.1200",
"2. high": "155.2200",
"3. low": "152.7304",
"4. close": "153.4800",
"5. adjusted close": "151.4438",
"6. volume": "3833574",
"7. dividend amount": "0.0000",
"8. split coefficient": "1.0000"
}
}
}
To start to work with this data, first we will extract all the dates contained in the "Time Series (Daily)" dictionary.
In [7]:
for item in stock_data['Time Series (Daily)']:
print(item)
2020-07-02 2020-07-01 2020-06-30 2020-06-29 2020-06-26 2020-06-25 2020-06-24 2020-06-23 2020-06-22 2020-06-19 2020-06-18 2020-06-17 2020-06-16 2020-06-15 2020-06-12 2020-06-11 2020-06-10 2020-06-09 2020-06-08 2020-06-05 2020-06-04 2020-06-03 2020-06-02 2020-06-01 2020-05-29 2020-05-28 2020-05-27 2020-05-26 2020-05-22 2020-05-21 2020-05-20 2020-05-19 2020-05-18 2020-05-15 2020-05-14 2020-05-13 2020-05-12 2020-05-11 2020-05-08 2020-05-07 2020-05-06 2020-05-05 2020-05-04 2020-05-01 2020-04-30 2020-04-29 2020-04-28 2020-04-27 2020-04-24 2020-04-23 2020-04-22 2020-04-21 2020-04-20 2020-04-17 2020-04-16 2020-04-15 2020-04-14 2020-04-13 2020-04-09 2020-04-08 2020-04-07 2020-04-06 2020-04-03 2020-04-02 2020-04-01 2020-03-31 2020-03-30 2020-03-27 2020-03-26 2020-03-25 2020-03-24 2020-03-23 2020-03-20 2020-03-19 2020-03-18 2020-03-17 2020-03-16 2020-03-13 2020-03-12 2020-03-11 2020-03-10 2020-03-09 2020-03-06 2020-03-05 2020-03-04 2020-03-03 2020-03-02 2020-02-28 2020-02-27 2020-02-26 2020-02-25 2020-02-24 2020-02-21 2020-02-20 2020-02-19 2020-02-18 2020-02-14 2020-02-13 2020-02-12 2020-02-11
Our next task, will be print out all the information contained on this date: 2020-06-30:
In [8]:
time_series = stock_data['Time Series (Daily)']
In [9]:
time_series
Out[9]:
{'2020-07-02': {'1. open': '119.6900',
'2. high': '121.4200',
'3. low': '119.2600',
'4. close': '119.7000',
'5. adjusted close': '119.7000',
'6. volume': '3745663',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-07-01': {'1. open': '120.2700',
'2. high': '121.2250',
'3. low': '118.3700',
'4. close': '118.5400',
'5. adjusted close': '118.5400',
'6. volume': '4657168',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-30': {'1. open': '119.1900',
'2. high': '121.2000',
'3. low': '119.0000',
'4. close': '120.7700',
'5. adjusted close': '120.7700',
'6. volume': '3916381',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-29': {'1. open': '117.9800',
'2. high': '119.7800',
'3. low': '117.3700',
'4. close': '119.7500',
'5. adjusted close': '119.7500',
'6. volume': '4157205',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-26': {'1. open': '118.2600',
'2. high': '118.9900',
'3. low': '116.2600',
'4. close': '117.1900',
'5. adjusted close': '117.1900',
'6. volume': '10749166',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-25': {'1. open': '116.7600',
'2. high': '119.2100',
'3. low': '116.1000',
'4. close': '119.0300',
'5. adjusted close': '119.0300',
'6. volume': '6128720',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-24': {'1. open': '118.3200',
'2. high': '118.3200',
'3. low': '115.8800',
'4. close': '116.4200',
'5. adjusted close': '116.4200',
'6. volume': '6747421',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-23': {'1. open': '122.0100',
'2. high': '122.9000',
'3. low': '119.2300',
'4. close': '119.4100',
'5. adjusted close': '119.4100',
'6. volume': '6628278',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-22': {'1. open': '122.1200',
'2. high': '122.5000',
'3. low': '120.5300',
'4. close': '121.0700',
'5. adjusted close': '121.0700',
'6. volume': '4762601',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-19': {'1. open': '126.1700',
'2. high': '126.8200',
'3. low': '122.2500',
'4. close': '122.4700',
'5. adjusted close': '122.4700',
'6. volume': '8098994',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-18': {'1. open': '123.0000',
'2. high': '124.4000',
'3. low': '122.3300',
'4. close': '124.1600',
'5. adjusted close': '124.1600',
'6. volume': '2860286',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-17': {'1. open': '125.8300',
'2. high': '126.2500',
'3. low': '123.4000',
'4. close': '124.1500',
'5. adjusted close': '124.1500',
'6. volume': '3153862',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-16': {'1. open': '125.0000',
'2. high': '127.5000',
'3. low': '123.1600',
'4. close': '125.1500',
'5. adjusted close': '125.1500',
'6. volume': '5605791',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-15': {'1. open': '119.1900',
'2. high': '122.3670',
'3. low': '118.2900',
'4. close': '121.6500',
'5. adjusted close': '121.6500',
'6. volume': '5148756',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-12': {'1. open': '121.2500',
'2. high': '123.1200',
'3. low': '119.2800',
'4. close': '121.9100',
'5. adjusted close': '121.9100',
'6. volume': '6218003',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-11': {'1. open': '126.0300',
'2. high': '126.1000',
'3. low': '117.8352',
'4. close': '118.0100',
'5. adjusted close': '118.0100',
'6. volume': '11753674',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-10': {'1. open': '132.1500',
'2. high': '132.2300',
'3. low': '129.8000',
'4. close': '129.8700',
'5. adjusted close': '129.8700',
'6. volume': '4725055',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-09': {'1. open': '133.5200',
'2. high': '133.6000',
'3. low': '131.0200',
'4. close': '131.8700',
'5. adjusted close': '131.8700',
'6. volume': '5391520',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-08': {'1. open': '132.2700',
'2. high': '135.8800',
'3. low': '132.2700',
'4. close': '135.7500',
'5. adjusted close': '135.7500',
'6. volume': '5368387',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-05': {'1. open': '133.8850',
'2. high': '134.2300',
'3. low': '131.7500',
'4. close': '132.0600',
'5. adjusted close': '132.0600',
'6. volume': '5892718',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-04': {'1. open': '127.7800',
'2. high': '128.9500',
'3. low': '127.0200',
'4. close': '128.8900',
'5. adjusted close': '128.8900',
'6. volume': '3864131',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-03': {'1. open': '127.1500',
'2. high': '129.5950',
'3. low': '127.0000',
'4. close': '129.0500',
'5. adjusted close': '129.0500',
'6. volume': '3913804',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-02': {'1. open': '125.6700',
'2. high': '126.0000',
'3. low': '124.6600',
'4. close': '126.0000',
'5. adjusted close': '126.0000',
'6. volume': '2976908',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-06-01': {'1. open': '124.6400',
'2. high': '125.7500',
'3. low': '124.0300',
'4. close': '124.8900',
'5. adjusted close': '124.8900',
'6. volume': '2867306',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-29': {'1. open': '123.6700',
'2. high': '125.1300',
'3. low': '122.2400',
'4. close': '124.9000',
'5. adjusted close': '124.9000',
'6. volume': '7929905',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-28': {'1. open': '126.8700',
'2. high': '126.9700',
'3. low': '124.2200',
'4. close': '124.5300',
'5. adjusted close': '124.5300',
'6. volume': '3915224',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-27': {'1. open': '123.9400',
'2. high': '125.8300',
'3. low': '123.4700',
'4. close': '125.5400',
'5. adjusted close': '125.5400',
'6. volume': '5725163',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-26': {'1. open': '121.3000',
'2. high': '122.6200',
'3. low': '121.0101',
'4. close': '121.7600',
'5. adjusted close': '121.7600',
'6. volume': '5467436',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-22': {'1. open': '119.3700',
'2. high': '119.4650',
'3. low': '117.5900',
'4. close': '118.3900',
'5. adjusted close': '118.3900',
'6. volume': '4179906',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-21': {'1. open': '120.9900',
'2. high': '121.7200',
'3. low': '118.9700',
'4. close': '119.1200',
'5. adjusted close': '119.1200',
'6. volume': '4018329',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-20': {'1. open': '120.9300',
'2. high': '122.4659',
'3. low': '120.6000',
'4. close': '121.3800',
'5. adjusted close': '121.3800',
'6. volume': '3840563',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-19': {'1. open': '121.1900',
'2. high': '122.1700',
'3. low': '120.1400',
'4. close': '120.2900',
'5. adjusted close': '120.2900',
'6. volume': '3239964',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-18': {'1. open': '119.8800',
'2. high': '122.3600',
'3. low': '119.7500',
'4. close': '121.5600',
'5. adjusted close': '121.5600',
'6. volume': '4205425',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-15': {'1. open': '115.9300',
'2. high': '117.3900',
'3. low': '115.2500',
'4. close': '116.9800',
'5. adjusted close': '116.9800',
'6. volume': '4785773',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-14': {'1. open': '114.5700',
'2. high': '117.0900',
'3. low': '111.8100',
'4. close': '116.9500',
'5. adjusted close': '116.9500',
'6. volume': '5255607',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-13': {'1. open': '119.9500',
'2. high': '119.9900',
'3. low': '114.8500',
'4. close': '115.7300',
'5. adjusted close': '115.7300',
'6. volume': '5874676',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-12': {'1. open': '123.0100',
'2. high': '124.3200',
'3. low': '120.2600',
'4. close': '120.2600',
'5. adjusted close': '120.2600',
'6. volume': '4779635',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-11': {'1. open': '121.8100',
'2. high': '123.4500',
'3. low': '120.6700',
'4. close': '122.5900',
'5. adjusted close': '122.5900',
'6. volume': '3533382',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-08': {'1. open': '122.6700',
'2. high': '123.2300',
'3. low': '121.0600',
'4. close': '122.9900',
'5. adjusted close': '122.9900',
'6. volume': '5002450',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-07': {'1. open': '122.9800',
'2. high': '123.2600',
'3. low': '120.8500',
'4. close': '121.2300',
'5. adjusted close': '121.2300',
'6. volume': '4412047',
'7. dividend amount': '1.6300',
'8. split coefficient': '1.0000'},
'2020-05-06': {'1. open': '123.2400',
'2. high': '124.0500',
'3. low': '122.4100',
'4. close': '123.1700',
'5. adjusted close': '121.5359',
'6. volume': '3861081',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-05': {'1. open': '123.3900',
'2. high': '124.3200',
'3. low': '122.4700',
'4. close': '122.5800',
'5. adjusted close': '120.9537',
'6. volume': '3897761',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-04': {'1. open': '120.8200',
'2. high': '121.9700',
'3. low': '119.3910',
'4. close': '121.6800',
'5. adjusted close': '120.0657',
'6. volume': '4016551',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-05-01': {'1. open': '123.1900',
'2. high': '123.4700',
'3. low': '121.3900',
'4. close': '121.8700',
'5. adjusted close': '120.2531',
'6. volume': '4923913',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-30': {'1. open': '126.5200',
'2. high': '127.2700',
'3. low': '125.2200',
'4. close': '125.5600',
'5. adjusted close': '123.8942',
'6. volume': '6630032',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-29': {'1. open': '128.8800',
'2. high': '129.3100',
'3. low': '127.5300',
'4. close': '128.6900',
'5. adjusted close': '126.9827',
'6. volume': '5252734',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-28': {'1. open': '128.0300',
'2. high': '128.2000',
'3. low': '125.3800',
'4. close': '126.2700',
'5. adjusted close': '124.5948',
'6. volume': '4775867',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-27': {'1. open': '125.5600',
'2. high': '126.9900',
'3. low': '125.4700',
'4. close': '125.9200',
'5. adjusted close': '124.2494',
'6. volume': '4920443',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-24': {'1. open': '122.4100',
'2. high': '125.0000',
'3. low': '120.7634',
'4. close': '124.7200',
'5. adjusted close': '123.0653',
'6. volume': '4985575',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-23': {'1. open': '119.5700',
'2. high': '123.0300',
'3. low': '119.1200',
'4. close': '121.3500',
'5. adjusted close': '119.7400',
'6. volume': '6873899',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-22': {'1. open': '119.8700',
'2. high': '120.3300',
'3. low': '117.5500',
'4. close': '119.3100',
'5. adjusted close': '117.7271',
'6. volume': '7085901',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-21': {'1. open': '114.0000',
'2. high': '117.1450',
'3. low': '112.0600',
'4. close': '116.7600',
'5. adjusted close': '115.2109',
'6. volume': '14341304',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-20': {'1. open': '119.1500',
'2. high': '122.8635',
'3. low': '118.1400',
'4. close': '120.4100',
'5. adjusted close': '118.8125',
'6. volume': '7965530',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-17': {'1. open': '119.3000',
'2. high': '120.3900',
'3. low': '117.9200',
'4. close': '120.1200',
'5. adjusted close': '118.5264',
'6. volume': '4964018',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-16': {'1. open': '119.0100',
'2. high': '119.7500',
'3. low': '114.4200',
'4. close': '115.7300',
'5. adjusted close': '114.1946',
'6. volume': '6438128',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-15': {'1. open': '119.1200',
'2. high': '120.1852',
'3. low': '116.7600',
'4. close': '118.6900',
'5. adjusted close': '117.1153',
'6. volume': '5632156',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-14': {'1. open': '123.4600',
'2. high': '125.1800',
'3. low': '122.6200',
'4. close': '123.9100',
&##39;5. adjusted close': '122.2661',
'6. volume': '5087292',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-13': {'1. open': '121.6300',
'2. high': '121.8000',
'3. low': '118.0400',
'4. close': '121.1500',
'5. adjusted close': '119.5427',
'6. volume': '5118777',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-09': {'1. open': '120.4800',
'2. high': '122.9200',
'3. low': '120.1672',
'4. close': '121.5000',
'5. adjusted close': '119.8880',
'6. volume': '5576210',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-08': {'1. open': '116.3100',
'2. high': '119.9600',
'3. low': '115.0742',
'4. close': '119.2900',
'5. adjusted close': '117.7074',
'6. volume': '5155987',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-07': {'1. open': '118.8000',
'2. high': '119.5700',
'3. low': '114.8700',
'4. close': '114.9400',
'5. adjusted close': '113.4151',
'6. volume': '5592463',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-06': {'1. open': '110.3500',
'2. high': '115.6300',
'3. low': '110.1300',
'4. close': '114.8200',
'5. adjusted close': '113.2967',
'6. volume': '7026457',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-03': {'1. open': '108.9200',
'2. high': '110.0700',
'3. low': '104.9200',
'4. close': '106.3400',
'5. adjusted close': '104.9292',
'6. volume': '4538113',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-02': {'1. open': '105.3700',
'2. high': '110.3200',
'3. low': '105.1400',
'4. close': '110.0000',
'5. adjusted close': '108.5406',
'6. volume': '6327540',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-04-01': {'1. open': '106.3600',
'2. high': '109.9200',
'3. low': '104.5210',
'4. close': '105.1400',
'5. adjusted close': '103.7451',
'6. volume': '6111890',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-31': {'1. open': '112.0000',
'2. high': '113.8100',
'3. low': '110.1700',
'4. close': '110.9300',
'5. adjusted close': '109.4583',
'6. volume': '6342167',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-30': {'1. open': '108.0900',
'2. high': '113.4600',
'3. low': '107.8100',
'4. close': '112.9300',
'5. adjusted close': '111.4317',
'6. volume': '5562501',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-27': {'1. open': '108.5800',
'2. high': '111.5000',
'3. low': '107.6450',
'4. close': '108.0300',
'5. adjusted close': '106.5968',
'6. volume': '6421470',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-26': {'1. open': '106.9100',
'2. high': '113.1500',
'3. low': '105.5700',
'4. close': '112.8900',
'5. adjusted close': '111.3923',
'6. volume': '7153135',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-25': {'1. open': '105.4800',
'2. high': '112.4779',
'3. low': '102.8300',
'4. close': '105.8500',
'5. adjusted close': '104.4457',
'6. volume': '8646557',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-24': {'1. open': '99.9900',
'2. high': '106.0400',
'3. low': '99.2600',
'4. close': '105.4800',
'5. adjusted close': '104.0806',
'6. volume': '7967768',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-23': {'1. open': '94.6000',
'2. high': '97.7400',
'3. low': '90.5600',
'4. close': '94.7700',
'5. adjusted close': '93.5127',
'6. volume': '9718602',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-20': {'1. open': '100.9200',
'2. high': '100.9900',
'3. low': '94.7100',
'4. close': '95.3900',
'5. adjusted close': '94.1244',
'6. volume': '10543213',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-19': {'1. open': '102.3300',
'2. high': '103.6900',
'3. low': '98.2350',
'4. close': '100.3400',
'5. adjusted close': '99.0088',
'6. volume': '8391294',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-18': {'1. open': '99.4100',
'2. high': '106.9345',
'3. low': '99.4000',
'4. close': '103.5500',
'5. adjusted close': '102.1762',
'6. volume': '8751994',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-17': {'1. open': '100.6100',
'2. high': '107.3950',
'3. low': '97.1000',
'4. close': '106.6500',
'5. adjusted close': '105.2351',
'6. volume': '8887501',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-16': {'1. open': '98.0000',
'2. high': '107.4100',
'3. low': '95.0000',
'4. close': '99.0800',
'5. adjusted close': '97.7655',
'6. volume': '10564044',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-13': {'1. open': '108.6800',
'2. high': '109.1600',
'3. low': '100.8100',
'4. close': '107.9500',
'5. adjusted close': '106.5178',
'6. volume': '12493419',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-12': {'1. open': '109.6500',
'2. high': '109.8000',
'3. low': '102.2800',
'4. close': '102.8100',
'5. adjusted close': '101.4460',
'6. volume': '12485925',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-11': {'1. open': '121.0100',
'2. high': '122.5800',
'3. low': '116.3838',
'4. close': '117.9700',
'5. adjusted close': '116.4049',
'6. volume': '8446480',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-10': {'1. open': '122.7800',
'2. high': '124.8800',
'3. low': '115.7600',
'4. close': '124.7700',
'5. adjusted close': '123.1147',
'6. volume': '11403865',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-09': {'1. open': '120.1600',
'2. high': '122.4100',
'3. low': '117.2800',
'4. close': '117.8100',
'5. adjusted close': '116.2470',
'6. volume': '10750357',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-06': {'1. open': '126.7000',
'2. high': '128.3300',
'3. low': '124.5200',
'4. close': '127.7300',
'5. adjusted close': '126.0354',
'6. volume': '8192525',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-05': {'1. open': '130.5000',
'2. high': '132.2900',
'3. low': '128.4500',
'4. close': '129.5500',
'5. adjusted close': '127.8312',
'6. volume': '5445193',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-04': {'1. open': '131.5800',
'2. high': '134.2800',
'3. low': '129.0000',
'4. close': '134.2200',
'5. adjusted close': '132.4393',
'6. volume': '4994682',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-03': {'1. open': '134.4800',
'2. high': '136.0950',
'3. low': '127.8000',
'4. close': '128.9000',
'5. adjusted close': '127.1899',
'6. volume': '7893390',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-03-02': {'1. open': '130.7500',
'2. high': '134.4400',
'3. low': '127.9500',
'4. close': '134.3000',
'5. adjusted close': '132.5182',
'6. volume': '8528971',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-28': {'1. open': '129.9800',
'2. high': '131.0900',
'3. low': '126.3600',
'4. close': '130.1500',
'5. adjusted close': '128.4233',
'6. volume': '13009236',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-27': {'1. open': '137.2400',
'2. high': '138.6900',
'3. low': '133.0100',
'4. close': '133.1100',
'5. adjusted close': '131.3440',
'6. volume': '8404903',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-26': {'1. open': '142.9000',
'2. high': '144.0600',
'3. low': '139.6000',
'4. close': '139.7500',
'5. adjusted close': '137.8959',
'6. volume': '5407690',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-25': {'1. open': '146.5100',
'2. high': '147.0700',
'3. low': '141.2610',
'4. close': '141.7100',
'5. adjusted close': '139.8299',
'6. volume': '6210878',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-24': {'1. open': '145.5100',
'2. high': '148.0500',
'3. low': '145.3800',
'4. close': '146.4300',
'5. adjusted close': '144.4873',
'6. volume': '5447948',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-21': {'1. open': '151.0400',
'2. high': '151.0400',
'3. low': '148.8400',
'4. close': '149.8400',
'5. adjusted close': '147.8521',
'6. volume': '3536740',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-20': {'1. open': '150.8100',
'2. high': '151.6200',
'3. low': '149.5100',
'4. close': '151.2200',
'5. adjusted close': '149.2137',
'6. volume': '2880483',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-19': {'1. open': '151.5400',
'2. high': '151.8900',
'3. low': '150.3100',
'4. close': '150.8600',
'5. adjusted close': '148.8585',
'6. volume': '2732905',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-18': {'1. open': '149.7900',
'2. high': '151.3800',
'3. low': '149.6400',
'4. close': '151.1000',
'5. adjusted close': '149.0953',
'6. volume': '3343038',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-14': {'1. open': '154.4200',
'2. high': '154.5600',
'3. low': '149.7700',
'4. close': '150.7000',
'5. adjusted close': '148.7006',
'6. volume': '6095081',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-13': {'1. open': '154.3700',
'2. high': '154.8300',
'3. low': '153.4100',
'4. close': '154.3100',
'5. adjusted close': '152.2627',
'6. volume': '3819757',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-12': {'1. open': '153.7500',
'2. high': '155.6000',
'3. low': '153.5200',
'4. close': '155.3100',
'5. adjusted close': '153.2495',
'6. volume': '4437792',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'},
'2020-02-11': {'1. open': '155.1200',
'2. high': '155.2200',
'3. low': '152.7304',
'4. close': '153.4800',
'5. adjusted close': '151.4438',
'6. volume': '3833574',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'}}
In [10]:
type(time_series)
Out[10]:
dict
In [11]:
time_series['2020-06-30']
Out[11]:
{'1. open': '119.1900',
'2. high': '121.2000',
'3. low': '119.0000',
'4. close': '120.7700',
'5. adjusted close': '120.7700',
'6. volume': '3916381',
'7. dividend amount': '0.0000',
'8. split coefficient': '1.0000'}
Now, we will be extracting a more specific information: the daily high and daily low values from the correspondent date:
In [12]:
daily_high = time_series['2020-06-30']['2. high']
In [13]:
daily_high
Out[13]:
'121.2000'
In [14]:
low_high = time_series['2020-06-30']['3. low']
In [15]:
low_high
Out[15]:
'119.0000'
Obtaining the complete information about this date:2020-06-17:
In [16]:
for key, value in time_series["2020-06-17"].items():
print(key + ': ' + value + '.')
1. open: 125.8300. 2. high: 126.2500. 3. low: 123.4000. 4. close: 124.1500. 5. adjusted close: 124.1500. 6. volume: 3153862. 7. dividend amount: 0.0000. 8. split coefficient: 1.0000.
- Get link
- X
- Other Apps
Comments
Post a Comment