I have a stock price database for all of the Australian Stock Exchange (ASX) stocks, and I want to be able to calculate the min & max price for each stock on a daily basis. There are currently around 300,000 records in the table, growing at roughly 10,000/wk. At this stage it does not need to work over a network.
The PRICES table:
I have another WATCHLIST table that has a subset of the ASX stocks I monitor closely, and I want to be able to view the current day's price with the last 90 days min & max price (not via a portal).
I have looked at using Self joins on the PRICES table, but cannot make it work.
Any help would be greatly appreciated.