column_str = "ticker, instrument, name, sector, currency, created_date, last_updated_date" insert_str = ("%s, " * 7)[:-2] final_str = "INSERT INTO SYMBOL (%s) VALUES (%s);" % (column_str, insert_str) try: con = connectToDatabase() logging.info(str(now) + " Connected!") except: logging.exception(str(now) + " Unable to connect to Database. Exiting.") exit() cursor = con.cursor(); for i in range(0, int(ceil(len(symbols) / 100.0))): cursor.executemany(final_str, symbols[i*100:(i+1)*100-1])