If you’re reading each post as quickly, I’m glad you’re not wasting your time replying 
Using DB Browser for SQLite I’ve found the table names.
Getting there:
#!/usr/bin/python
import sqlite3
from sqlite3 import Error
def select_all_tasks(conn):
"""
Query all rows in the tasks table
:param conn: the Connection object
:return:
"""
cur = conn.cursor()
cur.execute("SELECT * FROM SpotData")
rows = cur.fetchall()
for row in rows:
print(row)
def main():
database = "SBFspot.db"
# create a database connection
conn = create_connection(database)
with conn:
print(". Query all data within table: SpotData")
select_all_tasks(conn)
if __name__ == '__main__':
main()
prints:
. Query all data within table: SpotData
(1534325149, 304991661, 1154, 1390, 5.033, 5.538, 229.46, 251.13, 828, 833, 831, 3.509, 3.508, 3.507, 236.01, 237.54, 237.17, 4437, 13844060, 49.99, 12077.6, 11648.3, 0.0, u'OK', u'Closed', 72.53)
(1534326202, 304991661, 927, 1104, 4.038, 4.443, 229.81, 248.57, 667, 660, 670, 2.824, 2.822, 2.818, 236.45, 233.8, 237.84, 5115, 13844737, 49.99, 12077.9, 11648.6, 0.0, u'OK', u'Closed', 72.93)
and so on! …
Very exciting.
