程序员的量化交易之路（14）--Cointrader数据表（2）

minimicall minimicall 博客等级 墨衍会员 · AI 创作全网分发 墨衍智能分发 本文由作者通过墨衍一键同步至各平台 1分发平台 2k累计阅读 2k平均单平台 已同步平台 优快云 微信公众号 微博 知乎 掘金 百家号 博客园 抖音 小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网 我也要 码龄18年
关注
原创 最新推荐文章于 2026-04-15 09:57:52 发布 2k 阅读 AI 写同款· GEO 优化 ›
彩票预测的可能性与算法分析 彩票作为一种以随机数为基础的赌博形式，吸引了大量希望一夜暴富的参与者。尽管许多人希望通过某种方式预测彩票结果，以增加中奖几率，但彩票预测的可能性依然是一个充满争议和误解的话题。本文将探讨彩票是否能够预测的理论依据，分析可能的预测算法，并解释这些算法为何在实际应用中难以奏效。 阅读详情


Cointrader表结构

转载须注明出处：http://blog.youkuaiyun.com/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

You're 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)

 

收录于
量化交易

当前文章被收录于：

量化交易
39 篇文章 8 人学习
订阅专栏 查看详情
标签
#量化交易 #esper #cointrader #CEP
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
微信小程序：errno: 1500104, errCode: 10008, errMsg: “writeBLECharacteristicValue:fail:system error, status 微信小程序errno: 1500104, errCode: 10008, errMsg: "writeBLECharacteristicValue:fail:system error, status: UNKNOWN (239)"微信小程序调用蓝牙API，wx.writeBLECharacteristicValue()报错，微信小程序蓝牙写入错误，在开发uniapp微信小程序蓝牙通信功能时报错，蓝牙开发设备控制核心api，微信小程序调用蓝牙API “wx.writeBLECharacteristicValu 阅读详情

相关推荐

matlab 图像合成_用MATLAB做图像合成加雾的处理

众所周知，现在有很多算法来对图像进行去雾处理。但反之，对图像增加雾的代码却少之又少，本代码就是基于Matlab实现了对图像的加雾处理。该方法可用做雾天图像的合成数据集。代码公开如下：clear;clc; % close all; %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%i...

weixin_35719260的博客 2060

程序员的量化交易之路（13）--Cointrader类图（1）

转载须注明出处：http://blog.youkuaiyun.com/minimicall?viewmode=contents， htpp://cloudtrader.top 今天开始正式切入到Cointrader的源码分析学习中，其主页为：https://github.com/timolson/cointrader. 它是基于Esper的一个比特币云交易托管平...

weixin_34342578的博客 198

SAP-ML章＜＜＜＜第二节：物料账报错处理ABAP编程错误：RAISE_EXCEPTION＞＞＞＞

#SAP-ML章<<<<第一节：物料账报错处理ABAP编程错误：RAISE_EXCEPTION>>>> 1.物料账报错提示： ABAP编程错误：RAISE_EXCEPTION ABAP程序：SAPLFCML4H_RUN_PRICES应用组件CO-PC-ACT 2. 物料账报错背景： CKMLCP运行结算时 3. 解决方案: 通过DEBUG查看错误的地方 OKTZ：分析原因为：可能打包或者配置传输时弄错 ...

SAP.David.Gao的博客 1858

程序员的量化交易之路（18）--Cointrader之Event实体（6）

转载需注明： 事件，是Esper的重要概念。这里我们定义个事件类，它是Temporal实体的派生类。 仅仅是对Temporal简单的包装。其代码如下： package org.cryptocoinpartners.schema; import org.joda.time.Instant; import javax.persistence.Map...

weixin_33739541的博客 117

FoundationPose实战：从零部署到Demo运行全记录

本文详细记录了FoundationPose从零部署到Demo运行的全过程，包括Ubuntu环境配置、项目部署、依赖安装及常见问题解决方案。特别针对复现过程中的关键步骤如CUDA版本选择、Eigen3安装等提供了实用技巧，帮助开发者高效完成FoundationPose的部署与调试。

weixin_27102543的博客 269

保姆级教程：用AdGuard DNS代理实现全设备广告过滤（含Win/Mac/安卓/iOS配置）

本文提供了一份详尽的AdGuard DNS代理配置指南，帮助用户在全设备（Win/Mac/安卓/iOS）上实现广告过滤。通过系统级DNS设置，AdGuard能有效拦截广告、跟踪器和恶意网站，提升隐私保护和浏览效率。教程涵盖原理说明、各平台配置步骤及高级优化技巧，适合不同技术水平的用户。

weixin_42656416的博客 824

[Mysql] Decimal用法

mysql-Decimal理论说明：转载自：http://www.linuxidc.com/Linux/2013-07/88032.htm1.首先，对于精度比较高的东西，比如money，我会用decimal类型，不会考虑float,double,因为他们容易产生误差，numeric和decimal同义，numeric将自动转成decimal。DECIMAL从MySQL 5.1引入，列的声明语法是DE

Danny Chen的专栏 8055

Davinci配置临界区Exclusive Area

在Exclusive Area专属区域内的代码段执行不会被中断，可以用于保护多个Runnable间的共享资源。Exclusive Area会对RTE的调度策略和配置进行约束。如果两个或多个Runnable指向同一个Exclusive Area，那么只有其中一个Runnable被允许在该Exclusive Area内执行。即这些Runnable在ExlcusiveArea内执行时不能并发运行（相互抢占）。：在完整执行期间，整个runnable都在临界区运行。：执行期间可以进入临界区。

qq_42851449的博客 506

程序员的量化交易之路（27）--Cointrader之PriceData价格数据（14）

转载须注明出处：http://blog.youkuaiyun.com/minimicall?viewmode=contents，http://cloudtrade.top/ PriceData：价格数据。价格数据是市场数据的子类。 具体代码如下： package org.cryptocoinpartners.schema; import java.math.B...

weixin_34375251的博客 188

全志V3S嵌入式驱动开发（编译器升级到7.5）

【 声明：版权所有，欢迎转载，请勿用于商业用途。 联系信箱：feixiaoxing @163.com】 看过我们文章的朋友都知道，前面为了做v3s的驱动，对linux kernel进行了两次升级。第一次升级时从4.10.y升级到4.14.y，另外一次升级是从4.14.y升级到5.2.y。这中间最主要的原因，就是为了驱动适配的需要，更新的内核可以对硬件驱动有更好的支持，架构也更合理。 如果说内核升级尚且可以理解，那为什么要对编译器升级呢？这里面，最重要的一点就是语言的升

嵌入式-老费，一个分享专业嵌入式知识的blog 1167

基于YOLOv11的仓库机器人导航系统设计与实现：Amazon Robotics Challenge解决方案

本文将详细介绍一个基于YOLOv11目标检测算法的仓库机器人导航系统，该系统能够准确识别托盘(pallet)和箱子(box)，为机器人提供精确的导航信息。而基于深度学习的视觉导航系统能够实时识别环境中的关键物体，如托盘和箱子，从而实现更智能的路径规划和货物搬运。YOLOv11作为YOLO系列的最新演进版本，在检测精度和速度上都有显著提升，非常适合仓储环境中的实时物体检测任务。YOLOv11在保持实时性的同时，提高了对小物体和密集物体的检测能力，这对仓储环境中的托盘和箱子检测尤为重要。

YOLO 303

程序员的量化交易之路（24）--Cointrader之RemoteEvent远程事件实体（11）

转载需注明出处：http://blog.youkuaiyun.com/minimicall,http://cloudtrader.top/ 在量化交易系统中，有些事件是远端传来的，比如股票的价格数据等。所以，在这一节我们定义了一个远端事件实体。 它是一个基类，并不单独生成数据表。具体代码如下： package org.cryptocoinpartners.schema; import javax.an

MiniMicall的专栏 2048

CKS-CN考试之路----02

其实我们根据题目也可以知道秘钥是叫clever-cactus。稍作等待后,确认pod的状态,如果是1/1基本就没问题了。这步不一定做.目的是确定秘钥的名字。

Q先生 654

程序猿的量化交易之路（14）--Cointrader数据表（2）

Cointrader表结构 转载须注明出处：http://blog.youkuaiyun.com/minimicall?viewmode=contents，http://cloudtrader.top 设置（setup) Install Java Install Maven Install MySql Create a database using mysql -u roo...

weixin_33755649的博客 106

温度PID控制PLC程序

温度PID稳定控制程序，适用于欧姆龙PLC，对其他PLC也具有很大参考价值

Outlook Express 6 (OE6) for Win7/Win8/Win10

英文版 Outlook Express6.0， 兼容Win7/Win10/WinXP，解压就可用。

程序员的量化交易之路（33）--QuantConnect之案例1

转载需注明：http://blog.youkuaiyun.com/minimicall，http://cloudtrade.top/ 分析Cointrader有一定层度了，发现它毕竟不是一个产品，没有得到验证。在架构、编码等方面都非常的不规范。 想编写一个云交易平台，任道而重远。我们需要参照一些成熟的架构。 Quantopian的zipline不行，因为我就是看...

weixin_34364135的博客 4493

老版QQ原生表情gif动态

这是老版的QQ表情，不过全是动态的的，Windows照片查看器是不会动的，可以右击用浏览器打开查看，再说一遍是老版的，只是分享给宁愿用老版也要动态的人。

程序员的量化交易之路（21）--Cointrader之Currency货币实体（9）

转载须注明出自：http://blog.youkuaiyun.com/minimicall?viewmode=contents，http://cloudtrader.top 货币，Cointrader中基本实体。我们通过代码来学习该实体： package org.cryptocoinpartners.schema; import java.util.List; import javax.per

MiniMicall的专栏 2727

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

程序猿的量化交易之路（18）--Cointrader之Event实体（6）

程序猿的量化交易之路（18）--Cointrader之Event实体（6） 转载需注明： 事件，是Esper的重要概念。这里我们定义个事件类。它是Temporal实体的派生类。 不过对Temporal简单的包装。其代码例如以下： package org.cryptocoinpartners.schema; import ...

weixin_30235225的博客 117

程序员的量化交易之路（29）--Cointrader之Tick实体（16）

转载需注明出处：http://blog.youkuaiyun.com/minimicall，http://cloudtrade.top Tick：什么是Tick，在交易平台中非常常见，其实就 单笔交易时某只证券的基本数据。 我们通过代码来学习吧： package org.cryptocoinpartners.schema; import javax.annotation.Nullable; impor

MiniMicall的专栏 2374

程序员的量化交易之路（19）--Cointrader之Bar实体（7）

转载需注明出处：http://blog.youkuaiyun.com/minimicall，http://cloudtrader.top 1. 代码 package org.cryptocoinpartners.schema; import org.joda.time.format.DateTimeFormat; import org.joda.time.format.DateTimeFormatter

MiniMicall的专栏 2564

程序猿的量化交易之路（21）--Cointrader之Currency货币实体（9）

转载须注明出自：http://blog.youkuaiyun.com/minimicall?viewmode=contents，http://cloudtrader.top 货币，Cointrader中基本实体。我们通过代码来学习该实体： package org.cryptocoinpartners.schema; import java.util.List; import javax...

weixin_33860722的博客 180

程序员的量化交易之路（20）--Cointrader之Assert实体（8）

转载需说明出处：http://blog.youkuaiyun.com/minimicall, http://cloudtrade.top 任何可交易的都可以称之为Assert，资产。其类代码如下： package org.cryptocoinpartners.schema; import javax.persistence.Basic; import javax.persistence.Cacheab

MiniMicall的专栏 2199
上一篇： 程序员的量化交易之路（13）--Cointrader类图（1）
下一篇： 程序员的量化交易之路（15）--Cointrader之EntityBase类（3）
点赞 0
评论 0
书签 书签 0
minimicall
minimicall
博客等级 码龄18年 407粉丝 174原创
+ 关注 专栏目录 订阅专栏
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值