Hi, All. Supposing that selects are much more often in such
applications than data changing, I usually support "stored aggregates"
of this kind by triggers, in this case table like "Last_Prices". There
is some risk of lock conflicts, but it can be easyly solved on
application level.

Best regads.