binance websocket python or c
Budget: €30 – €250 EUR
now i extract data from 200 currencies in 3 seconds throught binance api
whith the next comand from every currencie .
in this case hard/usdt
https://api.binance.com/api/v3/ticker/24hr?symbol=HARDUSDT
and extract the result to a file called MKV_HARDUSDT.csv and import this to his table in sql server
MKV_HARDUSDT
{"symbol":"POLSUSDT","priceChange":"0.11500000","priceChangePercent":"5.474","weightedAvgPrice":"2.17810078","prevClosePrice":"2.10100000","lastPrice":"2.21600000","lastQty":"137.10000000","bidPrice":"2.21300000","bidQty":"430.40000000","askPrice":"2.21700000","askQty":"42.80000000","openPrice":"2.10100000","highPrice":"2.23800000","lowPrice":"2.09900000","volume":"503707.50000000","quoteVolume":"1097125.69940000","openTime":1641827920239,"closeTime":1641914320239,"firstId":5774583,"lastId":5780433,"count":5851}
REaly only i use is ","lastPrice":"2.21600000","and volume":"503707.50000000","
I want a process the export this data for every altcoin to a csv file every 0.5 second throught websocket. and import the data to a sql server table
but is better foe me if you import the altcoin data ","lastPrice":"2.21600000","and volume":"503707.50000000"," to sql server table
¡ikokkkkkkkkkkkkk
This can do with "multiple websocket streams in parallel".
i add a video :
https://www.youtube.com/watch?v=Q4c2wCACRL8
like in this video in the minute 4:44 seconds , he run multiple python windows with diferent currencies , i want the same but whit every currencie Instead of displaying the result on the screen, that copy it to the file MKV_HARDUSDT.csv , the file only can have the last result , 1 line whit the last data .
the code from the video is here
https://github.com/TechDivisions/python-binance-multi-streamer-sqliteDb
the project is only pass the result to a csv file instead of in a window .
i need this csv file to import later in a table in sql server .
but is better foe me if you import the altcoin data ","lastPrice":"2.21600000","and volume":"503707.50000000"," to sql server table
more info;
https://steemit.com/utopian-io/@steempytutorials/part-3-connecting-and-managing-multiple-websocket-streams-in-parallel
https://dev.binance.vision/t/a-couple-of-questions-about-websocket-limits/2777
https://bitcoden.com/answers/how-can-i-open-multiple-websocket-streams
note :
I use nvram disc for this fast read /write job in disk.
Also 2 more python process : 1 process that buy and anther that sell .
buy
i want a python process that buy 500 or 1000 dolars in market price through websocket,
later , check if it is bought and if it don't buyed , try buy again retry it for 30 seconds until is buyed.
sell
Pyton process that sells everything that i have in my binance portfolio for that coin at market price quickly .Then check if it is selled , if not try again until is selled.
example;
1 buyhardusdt.py
buy 500 dolars or 1000 dolars at market prrice of hard altcoin in usdt in hardusdt spot
2 sellhardusdt.py
sell at market price , all i have in binance wallet of hard in hardusdt spot
whith the next comand from every currencie .
in this case hard/usdt
https://api.binance.com/api/v3/ticker/24hr?symbol=HARDUSDT
and extract the result to a file called MKV_HARDUSDT.csv and import this to his table in sql server
MKV_HARDUSDT
{"symbol":"POLSUSDT","priceChange":"0.11500000","priceChangePercent":"5.474","weightedAvgPrice":"2.17810078","prevClosePrice":"2.10100000","lastPrice":"2.21600000","lastQty":"137.10000000","bidPrice":"2.21300000","bidQty":"430.40000000","askPrice":"2.21700000","askQty":"42.80000000","openPrice":"2.10100000","highPrice":"2.23800000","lowPrice":"2.09900000","volume":"503707.50000000","quoteVolume":"1097125.69940000","openTime":1641827920239,"closeTime":1641914320239,"firstId":5774583,"lastId":5780433,"count":5851}
REaly only i use is ","lastPrice":"2.21600000","and volume":"503707.50000000","
I want a process the export this data for every altcoin to a csv file every 0.5 second throught websocket. and import the data to a sql server table
but is better foe me if you import the altcoin data ","lastPrice":"2.21600000","and volume":"503707.50000000"," to sql server table
¡ikokkkkkkkkkkkkk
This can do with "multiple websocket streams in parallel".
i add a video :
https://www.youtube.com/watch?v=Q4c2wCACRL8
like in this video in the minute 4:44 seconds , he run multiple python windows with diferent currencies , i want the same but whit every currencie Instead of displaying the result on the screen, that copy it to the file MKV_HARDUSDT.csv , the file only can have the last result , 1 line whit the last data .
the code from the video is here
https://github.com/TechDivisions/python-binance-multi-streamer-sqliteDb
the project is only pass the result to a csv file instead of in a window .
i need this csv file to import later in a table in sql server .
but is better foe me if you import the altcoin data ","lastPrice":"2.21600000","and volume":"503707.50000000"," to sql server table
more info;
https://steemit.com/utopian-io/@steempytutorials/part-3-connecting-and-managing-multiple-websocket-streams-in-parallel
https://dev.binance.vision/t/a-couple-of-questions-about-websocket-limits/2777
https://bitcoden.com/answers/how-can-i-open-multiple-websocket-streams
note :
I use nvram disc for this fast read /write job in disk.
Also 2 more python process : 1 process that buy and anther that sell .
buy
i want a python process that buy 500 or 1000 dolars in market price through websocket,
later , check if it is bought and if it don't buyed , try buy again retry it for 30 seconds until is buyed.
sell
Pyton process that sells everything that i have in my binance portfolio for that coin at market price quickly .Then check if it is selled , if not try again until is selled.
example;
1 buyhardusdt.py
buy 500 dolars or 1000 dolars at market prrice of hard altcoin in usdt in hardusdt spot
2 sellhardusdt.py
sell at market price , all i have in binance wallet of hard in hardusdt spot