Structure database(s) dealing with different time points
Sounds like a single table in a single database.  It sounds like you need three columns: account, date, score.  The PRIMARY KEY might be (account, date).

10K rows is "small" for a table.