Koen, i am not very familiar with windowing functions. If you could give me the select query would be of great help..

These are stock tickers, i am actually trying to generate candlestick chart using these data. The user would choose whether he wants to see a 5min chart or whatever time...