import json
import csv

file_name = "AFSI"
with open('nasdaq/AFSI.csv') as f:
	reader = csv.reader(f)
	your_list = list(reader)

# print your_list
dict_list = []
for row in your_list:
	d = {'id':
			{'date': row[0],
			'sym': file_name},
		'open':row[1],
		'high':row[2],
		'low':row[3],
		'close':row[4],
		'volume':row[5]}
	dict_list.append(d)

with open('data.json', 'w') as f:
	json.dump(dict_list, f)
print json.dumps(dict_list)