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.