conn = sqlite3.connect(dbfilename,
detect_types=sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES)
sql = "SELECT symbol, date as \'date [datetime]\', open, high, low, " \\
"close, volume, adjclose from stocks where symbol=\'%s\' and " \\
"date>=%s and date<=%s" % (symbol, startdate, enddate)
qry = conn.execute(sql)