比特币交易信号
(bitcoin_trade_signal)
数据描述：
比特币的交易信号是价格上下限，当市价超过价格上限时卖出，当市价跌破价格下限时买入。年化收益率超过100%。
用例
## `比特币预测市值和市值偏差图`
```
from bigcharts import Line
import dai
df1 = dai.query("SELECT date, marketcap_log, predicted_marketcap_log, marketcap_upper_limit, marketcap_lower_limit, marketcap_bias FROM bitcoin_trade_signal WHERE date > '2010-08-01' ").df()
df2 = df1.rename(columns={'date': 'date', 'marketcap_log': '市值对数', 'predicted_marketcap_log': '预测市值对数', 'marketcap_upper_limit': '市值上限对数', 'marketcap_lower_limit': '市值下限对数', 'marketcap_bias': '市值偏差'})
my_line = Line(df2, title='比特币预测市值和市值偏差')
my_line.yaxis("|:市值偏差,市值偏差")
my_line.render()
```
## 比特币价格上下限图
```
from bigcharts import Kline, Line
import dai
df1 = dai.query("SELECT date, price, predicted_price, price_upper_limit, price_lower_limit FROM bitcoin_trade_signal WHERE date > '2010-08-01' ").df()
df2 = df1.rename(columns = {'date': 'date', 'price': '价格', 'predicted_price': '预测价格', 'price_upper_limit': '价格上限', 'price_lower_limit': '价格下限'})
my_line = Line(df2)
my_line.render()
```
表结构
| 字段 |
字段类型 |
字段描述 |
| marketcap |
double |
-
|
| blocks_log |
double |
-
|
| day_of_month |
int64 |
-
|
| marketcap_log |
double |
-
|
| marketcap_bias |
double |
-
|
| predicted_price |
double |
-
|
| price_lower_limit |
double |
-
|
| price_upper_limit |
double |
-
|
| accumulated_blocks |
int64 |
-
|
| price |
double |
-
|
| date |
timestamp[ns] |
-
|
| predicted_marketcap_log |
double |
-
|
| marketcap_upper_limit |
double |
-
|
| weekday |
int64 |
-
|
| __PARTITION__ |
string |
-
|
| marketcap_lower_limit |
double |
-
|
| supply |
double |
-
|
| predicted_marketcap |
double |
-
|
表名bitcoin_trade_signal
起始时间：
最近更新时间：