SQLite Forum

A newbie's question about database structure design
The suggestion is exactly what is usually being done by "materialized views", that is, physical table which have a statement to refresh them.

But of course you can use ordinary tables and store the end-of-day stock quotes there, resulting in exactly one row per stock and day.

After a while, the intra-day quotes are of no interest any more, so you may as well keep them elsewhere or totally delete them.