import sqlite3

conn = sqlite3.connect(":memory:")
conn.row_factory = sqlite3.Row
c = conn.cursor()
c.execute('''create table stocks
(date text, trans text, symbol text,
 qty real, price real)''')
c.execute("""insert into stocks
          values ('2006-01-05','BUY','RHAT',100,35.14)""")
conn.commit()
c.execute('select * from stocks')
r = c.fetchone()
c.close()

print(r[0:2:1])
print(r[1::2])