En cours

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

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.

Compétences : Administration de Bases de données, MySQL, Architecture Logicielle

en voir plus : need for market, c for int, algo data, i do not exist, market prices, time series, stock market data, flat m, data pulling, data compression, compression, sql analytics, mysql flat file, mysql time series, market data mysql, stock prices mysql, java stock data, frequency data, stock data mysql, mysql time series data procedures, software market, data data sql, compress file, mysql exist, frequency time java

Concernant l'employeur :
( 0 commentaires ) Austin, United States

Nº du projet : #2380094

5 freelance font une offre moyenne de $102 pour ce travail


Hi, I can do that

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)

please check pm.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(18 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)