gadgedbridge simple data exploration

grph.py

import sqlite3
import matplotlib.pyplot as plt
import datetime
import numpy as np

conn = sqlite3.connect('Gadgetbridge')
c = conn.cursor()
a=c.execute("select strftime('%Y.%m.%d', datetime(timestamp, 'unixepoch')) as d,sum(STEPS) from MI_BAND_ACTIVITY_SAMPLE group by d").fetchall()

b={x[0]:x[1] for x in a}

fig, ax = plt.subplots()
plt.bar(
    np.arange(len(b)),
    list(b.values()),
    0.3,
    tick_label=list(b.keys()),
    label="steps",
    color="#ff7f0e",
)
plt.legend()
plt.tight_layout()
plt.xticks(rotation=60)
plt.show()
c.close()

that results in:

One can also group by say week:

a=c.execute("select strftime('%W', datetime(timestamp, 'unixepoch')) as d,sum(STEPS) from MI_BAND_ACTIVITY_SAMPLE group by d").fetchall()