Hi all - I need a procedure to compress tick data into a time series. The tick data is being stored in MySQL with the following columns: tradeDate (DATE), tradeTime (TIME), price(DECIMAL), volume(INT). The times stamps exist on a frequency in milliseconds, and I need to compress the data into SECONDS, where each row represents one second of data that includes the OPEN, HIGH, LOW, and LAST price of all the prices in that second of data. I have this compression algo built in both C# and Java, as I use it for flat file dbs, but I'm moving all of my data into MySQL so I can build out a higher performing data cache when pulling data into my analytics software. I am familiar with SQL and have written simple procedures, but I do not have the time to flesh this out and am willing to pay for the correct solution. I need this as soon as possible.