How To Add All Time Max Price Calculated Field

Say we have a table like the following, with hundreds of symbols:

SYMBOL
DATE
OPEN
HIGH
LOW
CLOSE
VOLUME
ALLTIMEMAX

[code]....

and we need to add the ALLTIMEMAX column. This is the MAX CLOSE price for the symbol on SYMBOL till the date on DATE.I think that if we can take the first CLOSE for each symbol, then for the following date wed just need to check if the new CLOSE is bigger than the previous. If it is, use it and if not, just keep the old one.