import urllib, config, time, sys
sleeptime = 300
while True:
	stocks = config.update()
	cursor = config.cursor()
	if time.localtime()[6] > 5 or time.localtime()[3] > 15 or time.localtime()[3] < 10:
		time.sleep(3600)
	else:
		for symbol in stocks:
			data = urllib.urlopen("http://finance.yahoo.com/d/quotes.csv?s="+str(symbol)+"&f=sl1d1t1c1ohgv&e=.csv").read().split(",")
			cursor.execute("INSERT INTO stockData SET symbol=\""+symbol+"\", time="+str(time.time()).split(".")[0]+", price=\""+data[1]+"\"")
			print symbol,data[1]
		time.sleep(sleeptime)