MySQL Procedure for market data (stock market) time series compression

Đang Thực Hiện Đã đăng vào Aug 6, 2012 Thanh toán khi bàn giao
Đang Thực Hiện Thanh toán khi bàn giao

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.

Quản trị cơ sở dữ liệu MySQL Kiến trúc phần mềm

ID dự án: #2380094

Về dự án

5 đề xuất Dự án từ xa Aug 6, 2012 đang mở

5 freelancer chào giá trung bình$102 cho công việc này

waelfree

Hi, I can do that

$150 USD trong 1 ngày
(32 Nhận xét)
5.5
bistanil98

Hi, We have send you the price for 7 days and 1 days is for testing and bug fixing. And if you want the exact price, then we can let you know the price after the detail discussion. I want to introduce our sel Thêm

$225 USD trong 7 ngày
(9 Nhận xét)
5.1
itamarjp

please check pm.

$30 USD trong 0 ngày
(18 Nhận xét)
4.1
rakeskul

I will provide whole source code in MYSQL with 6 month maintaince of that Procedure on same cost

$70 USD trong 7 ngày
(0 Nhận xét)
0.0
Dulv

hi do you mean you want to create a store procedure in Mysql or a procedure (function in programming language)?

$35 USD trong 0 ngày
(0 Nhận xét)
0.0