How to loop over values in JSON data?

I took json_data['Time Series (Daily)'] and assigned it to its own variable to make it easier to reference in the for loop.

Then when looping through you have to reference that variable to access values inside the date keys.

data = json_data['Time Series (Daily)']

for item in data:
    print(item)
    print("open", data[item]["1. open"])
    print("high", data[item]["2. high"])
    print("low", data[item]["3. low"])
    print("close", data[item]["4. close"])
    print("vloume", data[item]["5. volume"])
    print()

Hy, well the major subject here isn't JSON's itself, but dictionaries, a built-in type in Python. I don't know exactlly what you want to do with this data, but a way to acess then is by acessing the methods that comes with dictionaries. Like dict.keys(), dict.items() and dict.values(), you could look up for some of the documentation for this. I will let an example for how to acess the data, hope it helps.

url=requests.get('https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TGT&apikey=RYFJGY3O92BUEVW4')
url_json = url.json() # This data is actually of dict type
for k,j in url_json['Time Series (Daily)'].items():
    print(k)
    for m, n in j.items(): # This data are a nested dictionary
        print('{} : {}'.format(m, n))

Going really ahead of this, you could write a function that prints the value if isn't a dict, like:

def print_values(dictionary):
    if isinstance(dictionary, dict):
        for k, v in dictionary.items():
            print(k)
            print_values(v)
    else:
        print(dictionary)

See ya!

This may be just my style, but I prefer this approach:

for item in json_data['Time Series (Daily)']:
    open, high, low, close, volume = sorted(item).values()
    print('\n\t'.join([item.keys()[0], open, high, low, close, volume]))

This way, you've already assigned values to the open, high, low... in one line and it's easy to use moving forward.

I also made it print all the values on newlines (with indents) in one line of code, this makes for less code spaghetti than doing a print() for each value. Although this is limited in it's uses but pretty efficient for debugging if you know the structure.

I like to write code that is what is called data-driven because that often makes it easier to change later on.

Here's how that could be done in this situation:

SERIES_KEY = 'Time Series (Daily)'
VALUE_KEYS = '1. open', '2. high', '3. low', '4. close', '5. volume'
longest_key = max(len(key) for key in VALUE_KEYS)

daily = json_data[SERIES_KEY]
for date, values in sorted(daily.items()):
    print(date)
    for key in VALUE_KEYS:
        print('  {:{width}} :  {}'.format(key, values[key], width=longest_key))
    print()

Output:

2018-11-19
  1. open   :  79.9300
  2. high   :  80.4000
  3. low    :  77.5607
  4. close  :  77.7900
  5. volume :  9126929

2018-11-20
  1. open   :  67.9900
  2. high   :  71.5000
  3. low    :  66.1500
  4. close  :  69.6800
  5. volume :  15573611