import database db = database.db cursor = db.cursor() query = """SELECT DISTINCT timestamp FROM stocks ORDER BY stocks.timestamp DESC LIMIT 1 OFFSET 1;""" cursor.execute(query) one_before_latest_entry_datetime = cursor.fetchone() query = """SELECT DISTINCT timestamp FROM stocks ORDER BY stocks.timestamp DESC LIMIT 1;""" cursor.execute(query) latest_entry_datetime = cursor.fetchone(query) cursor.close() db.close()