VeighNa量化社区
你的开源社区量化交易平台
zxb222278's Avatar
Member
离线
8 帖子
声望: 0

description
s_bar的超级表没问题

description

这个tdengine的语法找半天没看到哪里有问题,求救
附vnpy_taos源码

# 创建bar超级表
CREATE_BAR_TABLE_SCRIPT = """
CREATE STABLE IF NOT EXISTS s_bar (
    datetime TIMESTAMP,
    volume DOUBLE,
    turnover DOUBLE,
    open_interest DOUBLE,
    open_price DOUBLE,
    high_price DOUBLE,
    low_price DOUBLE,
    close_price DOUBLE
    )
TAGS(
    symbol BINARY(20),
    exchange BINARY(10),
    interval_ BINARY(5),
    start_time TIMESTAMP,
    end_time TIMESTAMP,
    count DOUBLE
    )
"""
# 创建tick超级表
CREATE_TICK_TABLE_SCRIPT = """
CREATE STABLE IF NOT EXISTS s_tick (
    datetime TIMESTAMP,
    name NCHAR(20),
    volume DOUBLE,
    turnover DOUBLE,
    open_interest DOUBLE,
    last_price DOUBLE,
    last_volume DOUBLE,
    limit_up DOUBLE,
    limit_down DOUBLE,
    open_price DOUBLE,
    high_price DOUBLE,
    low_price DOUBLE,
    pre_close DOUBLE,
    bid_price_1 DOUBLE,
    bid_price_2 DOUBLE,
    bid_price_3 DOUBLE,
    bid_price_4 DOUBLE,
    bid_price_5 DOUBLE,
    ask_price_1 DOUBLE,
    ask_price_2 DOUBLE,
    ask_price_3 DOUBLE,
    ask_price_4 DOUBLE,
    ask_price_5 DOUBLE,
    bid_volume_1 DOUBLE,
    bid_volume_2 DOUBLE,
    bid_volume_3 DOUBLE,
    bid_volume_4 DOUBLE,
    bid_volume_5 DOUBLE,
    ask_volume_1 DOUBLE,
    ask_volume_2 DOUBLE,
    ask_volume_3 DOUBLE,
    ask_volume_4 DOUBLE,
    ask_volume_5 DOUBLE,
    localtime TIMESTAMP
    )
TAGS(
    symbol BINARY(20),
    exchange BINARY(10)
    )
"""

请教一下,批量回测为啥全是返回第一条回测的结果?

© 2015-2022 微信 18391752892
备案服务号:沪ICP备18006526号

沪公网安备 31011502017034号

【用户协议】
【隐私政策】
【免责条款】