程序员的量化交易之路(14)--Cointrader数据表(2)
转载须注明出处:http://blog.csdn.net/minimicall?viewmode=contents,http://cloudtrader.top
设置(setup)
Install Java
Install Maven
Install MySql
Create a database using
mysql -u root -e `create database cointrader;`
This is mysql root not system root
git clone https://github.com/timolson/cointrader.git
cd cointrader
Build with Maven
mvn
Optional: Create a file cointrader.properties in the current directory. You may configure additional settings here, like a database username and password. See cointrader-default.properties.
Initialize the database with:
./cointrader.sh reset-database
Youre done! Now you might want to:
Start a process to save market data in the db:
./cointrader.sh save-data
Run the Console
./cointrader.sh console
登入数据库:
$ mysql -u root -p
查看database:
mysql show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cointrader |
| db_test |
| mysql |
| openfire |
| performance_schema |
| xoops |
+--------------------+
7 rows in set (0.00 sec)
切入cointrader:
mysql use cointrader;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
查看表格:
mysql show tables;
+--------------------------+
| Tables_in_cointrader |
+--------------------------+
| adjustment |
| adjustment_deltas |
| authorization |
| book |
| currency |
| exchange |
| fill |
| fill_children |
| general_order |
| listing |
| market |
| market_data_gap_error |
| offer |
| order_children |
| order_update |
| owner |
| owner_stakes |
| portfolio |
| portfolio_manager |
| portfolio_stakes |
| position |
| position_fills |
| position_update |
| prompt |
| specific_order |
| stake |
| strategy_instance |
| strategy_instance_config |
| tick |
| trade |
| transaction |
+--------------------------+
31 rows in set (0.01 sec)
查看每一个表的表结构
mysql desc adjustment;
+---------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time_applied | tinyblob | YES | | NULL | |
| authorization | binary(16) | NO | UNI | NULL | |
+---------------+------------+------+-----+---------+-------+
mysql desc adjustment_deltas;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| adjustment | binary(16) | NO | MUL | NULL | |
| deltas | binary(16) | NO | PRI | NULL | |
+------------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc authorization ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| notes | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql desc authorization ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| notes | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql desc book ;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | MUL | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | MUL | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| ask_deletions_blob | longblob | YES | | NULL | |
| ask_insertions_blob | longblob | YES | | NULL | |
| ask_price_as_double | double | YES | | NULL | |
| ask_volume_as_double | double | YES | | NULL | |
| bid_deletions_blob | longblob | YES | | NULL | |
| bid_insertions_blob | longblob | YES | | NULL | |
| bid_price_as_double | double | YES | | NULL | |
| bid_volume_as_double | double | YES | | NULL | |
| parent | binary(16) | YES | MUL | NULL | |
+----------------------+--------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
mysql desc currency ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| basis | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
| fiat | bit(1) | NO | | NULL | |
+---------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql desc exchange ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| fee_method | int(11) | YES | | NULL | |
| fee_rate | double | NO | | NULL | |
| margin | int(11) | NO | | NULL | |
| margin_fee_method | int(11) | YES | | NULL | |
| margin_fee_rate | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql desc fill ;
+--------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| open_volume_count | bigint(20) | NO | | NULL | |
| price_count | bigint(20) | NO | | NULL | |
| stop_price_count | bigint(20) | NO | | NULL | |
| target_price_count | bigint(20) | NO | | NULL | |
| volume_count | bigint(20) | NO | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| order | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+--------------------+--------------+------+-----+---------+-------+
13 rows in set (0.01 sec)
mysql desc fill_children ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| fill | binary(16) | NO | MUL | NULL | |
| children | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc general_order ;
+-----------------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+---------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| comment | varchar(255) | YES | | NULL | |
| emulation | bit(1) | NO | | NULL | |
| entry_time | bigint(20) | YES | | NULL | |
| expiration | tinyblob | YES | | NULL | |
| fill_type | int(11) | YES | MUL | NULL | |
| margin_type | int(11) | YES | | NULL | |
| panic_force | bit(1) | NO | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| parent_order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
| limit_price_decimal | decimal(19,2) | YES | | NULL | |
| stop_amount_decimal | decimal(19,2) | YES | | NULL | |
| stop_price_decimal | decimal(19,2) | YES | | NULL | |
| target_amount_decimal | decimal(19,2) | YES | | NULL | |
| target_price_decimal | decimal(19,2) | YES | | NULL | |
| trailing_stop_price_decimal | decimal(19,2) | YES | | NULL | |
| volume_decimal | decimal(19,2) | YES | | NULL | |
| listing | binary(16) | NO | MUL | NULL | |
+-----------------------------+---------------+------+-----+---------+-------+
22 rows in set (0.00 sec)
mysql desc listing ;
+---------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| base | binary(16) | NO | MUL | NULL | |
| prompt | binary(16) | YES | MUL | NULL | |
| quote | binary(16) | NO | MUL | NULL | |
+---------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql desc market ;
+--------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| active | bit(1) | NO | MUL | NULL | |
| price_basis | double | NO | | NULL | |
| volume_basis | double | NO | | NULL | |
| exchange | binary(16) | NO | MUL | NULL | |
| listing | binary(16) | NO | MUL | NULL | |
+--------------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql desc market_data_gap_error;
+--------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| exception | tinyblob | YES | | NULL | |
| gap_interval_start | datetime | YES | | NULL | |
| gap_interval_end | datetime | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
+--------------------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql desc offer ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql desc order_children ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| order | binary(16) | NO | | NULL | |
| children | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc order_update ;
+------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+----------------+
| sequence | int(11) | NO | PRI | NULL | auto_increment |
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| last_state | int(11) | YES | | NULL | |
| state | int(11) | YES | MUL | NULL | |
| order | binary(16) | YES | | NULL | |
+------------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql desc owner ;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
| name | varchar(255) | NO | | NULL | |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql desc owner_stakes ;
+--------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------+------+-----+---------+-------+
| owner | binary(16) | NO | MUL | NULL | |
| stakes | binary(16) | NO | PRI | NULL | |
+--------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc portfolio ;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| base_asset | binary(16) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql desc portfolio_manager ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql desc portfolio_stakes ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| portfolio | binary(16) | NO | MUL | NULL | |
| stakes | binary(16) | NO | PRI | NULL | |
+-----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc position ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| asset | binary(16) | YES | | NULL | |
| exchange | binary(16) | YES | MUL | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql desc position_fills ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| position | binary(16) | NO | MUL | NULL | |
| fills | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql desc position_update;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| last_type | int(11) | YES | | NULL | |
| type | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| position | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql desc prompt ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| contract_size | double | NO | | NULL | |
| fee_method | int(11) | YES | | NULL | |
| fee_rate | double | NO | | NULL | |
| margin | int(11) | NO | | NULL | |
| margin_fee_method | int(11) | YES | | NULL | |
| margin_method | int(11) | YES | | NULL | |
| price_basis | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
| tick_size | double | NO | | NULL | |
| tick_value | double | NO | | NULL | |
| volume_basis | double | NO | | NULL | |
| traded_currency | binary(16) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
14 rows in set (0.01 sec)
mysql desc specific_order ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| comment | varchar(255) | YES | | NULL | |
| emulation | bit(1) | NO | | NULL | |
| entry_time | bigint(20) | YES | | NULL | |
| expiration | tinyblob | YES | | NULL | |
| fill_type | int(11) | YES | MUL | NULL | |
| margin_type | int(11) | YES | | NULL | |
| panic_force | bit(1) | NO | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| parent_order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
| limit_price_count | bigint(20) | NO | | NULL | |
| placement_count | int(11) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
19 rows in set (0.01 sec)
mysql desc stake ;
+-----------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| stake | decimal(30,15) | YES | | NULL | |
| owner | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+-----------+----------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql desc strategy_instance ;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
| module_name | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql desc strategy_instance_config;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| strategy_instance | binary(16) | NO | PRI | NULL | |
| config | varchar(255) | YES | | NULL | |
| config_key | varchar(255) | NO | PRI | | |
+-------------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql desc tick ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
| start_instant | tinyblob | YES | | NULL | |
| last_book | binary(16) | YES | MUL | NULL | |
+---------------+--------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
mysql desc trade ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | MUL | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | MUL | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql desc transaction ;
+---------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| amount_count | bigint(20) | YES | | NULL | |
| commission_count | bigint(20) | YES | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| type | int(11) | YES | MUL | NULL | |
| asset | binary(16) | YES | | NULL | |
| commission_currency | binary(16) | YES | | NULL | |
| currency | binary(16) | NO | | NULL | |
| exchange | binary(16) | YES | MUL | NULL | |
| fill | binary(16) | YES | MUL | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+---------------------+------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
相关文章
- 程序员的量化交易之路(37)--Lean之DataStream数据流5
- 程序员的量化交易之路(22)--Cointrader值货币集合Currencies(10)
- 程序员的量化交易之路(19)--Cointrader之Bar实体(7)
- 程序员的量化交易之路(15)--Cointrader之EntityBase类(3)
- 程序员的最大挑战--没时间学习新知识(转)
- 程序员的算法趣题Q55: 平分蛋糕
- 程序员的算法趣题Q43: 让玻璃杯水量减半
- 程序员的算法趣题Q28: 社团活动的最优分配方案
- Atitit 工程师程序员技术级别对应表与主要特征 P1--p6 说明 类别 职称 对应技术标志 P5 高级工程师 工程师类 一般四五年 P6 资深开发 工程师类 78年经历 P7 P7
- 程序员——令人喷饭的代码注释
- 使用Python开发小说下载器,不再为下载小说而发愁 #华为云·寻找黑马程序员#
- 对程序员非常重要的24个软技能
- 没有学历文凭,如何成为一名优秀的 Java 程序员?
- 程序员的傲慢从何说起?
- 想成为合格的程序员,首先你得学会……
- 程序员转型技术管理,这几本书不能错过
- 程序员修神之路--redis做分布式锁可能不那么简单
- 一个跨界程序员:不务正业的这几年,我如何让自己的收入翻了十倍(转)
- 演讲预告:一个月的住院经历,我悟到了哪些和程序员职场发展相关的心得
- 程序员如何用Python科学炒股
- Scratch3.0——助力新进程序员理解程序(案例一十一、大象吃苹果)
- 程序员过关斩将--你的面向接口编程一定对吗?