Python - websocket client to API subscription to save data to mysql

Implement websocket client in python with api subscription to Websocket endpoint as specified

in below definition and save received messages to mysql database.

Websocket endpoint:

wss://[login to view URL]

Channel: live_trades_BTCUSD


- The assignment will be accepted if the client is not disconnectd and runs forever.

- In case client is disconnected it has to reconnect and has to report disconnect error to log.

The mysql table definition has to be provided in DDL.

- The code has to be provided in python and work under version 3.6

API definition:

Live Ticker description:

Channel: live_trades_BTCUSD

[login to view URL]

Live trades example:

[login to view URL]

{"event": "bts:subscribe","data": {"channel": "live_trades_btcusd"}}

Data structure:

id Trade unique ID.

amount Trade amount.

amount_str Trade amount represented in string format.

price Trade price.

price_str Trade price represented in string format.

type Trade type (0 - buy; 1 - sell).

timestamp Trade timestamp.

microtimestamp Trade microtimestamp.

buy_order_id Trade buy order ID.


Data output:

{"data": {"microtimestamp": "1562518746063052", "amount": 0.0071539899999999998, "buy_order_id": 3698872410, "sell_order_id": 3698855240, "amount_str": "0.00715399", "price_str": "11203.58", "timestamp": "1562518746", "price": 11203.58, "type": 0, "id": 93107634}, "event": "trade", "channel": "live_trades_btcusd"}

Testing the data feed:

You can test subscription to undertand correctly using in chrome:

Install Simple websocket client.

In server location url: wss://[login to view URL]

in request enter: {"event": "bts:subscribe","data": {"channel": "live_trades_btcusd"}}

in Message log you will see the data arrive.

Kemahiran: Python, MySQL

Lihat lagi: facileforms form save data mysql, web crawler save data mysql, ivr save data mysql, flash save data mysql, save data mysql vbnet, can java save data mysql, php script parse email save data mysql, nicedit save data mysql, save data mysql, as3 save data mysql, dojo save data mysql, multiple image upload save data mysql ajax, rss feed save data mysql, adwords api php sync data mysql database, html jquery save data mysql, android save data mysql, facebook connect save data mysql

Tentang Majikan:
( 9 ulasan ) Bucuresti, Romania

ID Projek: #20243915

Dianugerahkan kepada:


I will createing this app in 1-5 days. Relevant Skills and Experience I have 4 year exp in building Python appps and 2 year exp in creating websocket apps for cryptocurrency places.

€14 EUR dalam 4 hari
(0 Ulasan)

5 pekerja bebas membida secara purata €26 untuk pekerjaan ini


~~~ Very interested to me! ~~~ Hi, dear! Feel contact me for these kinds of projects. I will provide you the best result on time. I am waiting for your message to have a detail discussion. Thanks.@~@

€50 EUR dalam 7 hari
(10 Ulasan)

Hi, I read the description of your project thoroughly. I understand your requirements basically, and I have experiences of similar project. I am professional Web app and Mobile App developer, and talented Angular/Nodej Lagi

€19 EUR dalam 7 hari
(14 Ulasan)

Greetings! I'm a full-stack software developer specializing in modern Web. I have just read your description & project details and I am very interested in your job. I can show you my experience. I am always working wi Lagi

€30 EUR dalam 7 hari
(2 Ulasan)

Dear client I saw your requirements regarding to develop an application for websocket connection from bitstamp exchange. I can develop this application with in a 1 or 2 hours maximum. Because I developed many applica Lagi

€15 EUR dalam sehari
(0 Ulasan)