crypto_bot/shema.sql at master · IvanProtchenko/crypto_bot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
use crypto;

CREATE TABLE `items` (
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
)  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `history` (
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'DEFAULT',
`price` double(16,8) NOT NULL DEFAULT '0.0',
`amount` double(16,8) NOT NULL DEFAULT '0.0',
`time` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `history_depth` (
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'DEFAULT',
`amount` double(16,8) NOT NULL DEFAULT '0.0',
`time` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `history_1m` (
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'DEFAULT',
`price_min` double(16,8) NOT NULL DEFAULT '0.0',
`price_max` double(16,8) NOT NULL DEFAULT '0.0',
`amount` double(16,8) NOT NULL DEFAULT '0.0',
`time` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin


{"globalTradeID":390237812,"tradeID":25457603,
"date":"2018-09-15 10:44:58","type":"buy",
"rate":"6524.00000000","amount":"0.00100000","total":"6.52400000"}

time.mktime(time.strptime('2018-09-15 10:44:58', '%Y-%m-%d %H:%M:%S'))

текущий курс для всех
https://bitforex.com/server/market.act?cmd=searchTickers&type=all


https://bitforex.com/napi/getCurTradeCoinInfoData?tradeType=1&commodityCode=BTC&currencyCode=USDT


#
Информация о том какие пары торгуются
https://api.bitforex.com/api/v1/market/symbols

#
Ticker Information
https://api.bitforex.com/api/v1/market/ticker

symbol 	String 	Description 	- 	Trading pairs such as coin-usd-btc, coin-usd-eth, etc.

Depth information
https://api.bitforex.com/api/v1/market/depth?symbol=coin-usdt-btc&size=600
symbol 	String 	Yes 	- 	Trading pairs such as coin-usd-btc, coin-usd-eth, etc.
size 	int 	No (defaults to 5) 	- 	Orders Depth Quantity 1-200


https://api.bitforex.com/api/v1/market/trades?symbol=coin-usdt-btc&size=600

symbol 	String 	Yes 	- 	Trading pairs such as coin-usd-btc, coin-usd-eth, etc.
size 	int 	No (default is 1) 	- 	The number of transactions is 1-600