# 专项指标(保险)
#
# 总投资收益率
insurance_roi = Column(Float)
# 净投资收益率
insurance_net_investment_yield = Column(Float)
# 已赚保费
insurance_earned_premium = Column(Float)
# 赔付支出
insurance_payout = Column(Float)
# 退保率
insurance_surrender_rate = Column(Float)
# 偿付能力充足率
insurance_solvency_adequacy_ratio = Column(Float)
# 专项指标(券商)
#
# 净资本
broker_net_capital = Column(Float)
# 净资产
broker_net_assets = Column(Float)
# 净资本/净资产
broker_net_capital_assets_ratio = Column(Float)
# 自营固定收益类证券规模/净资本
broker_self_operated_fixed_income_securities_net_capital_ratio = Column(
Float)
register_schema(providers=['eastmoney'],
db_name='finance',
schema_base=FinanceBase)
orderType = Column(String(length=32))
# kdata schema rule
# 1)name:{entity_type}{level}Kdata
# 2)one db file for one schema
Stock1mKdataBase = declarative_base()
class Stock1mKdata(Stock1mKdataBase, StockKdataCommon):
__tablename__ = 'stock_1m_kdata'
register_schema(providers=['joinquant'],
db_name='stock_1m_kdata',
schema_base=Stock1mKdataBase)
Stock5MKdataBase = declarative_base()
class Stock5mKdata(Stock5MKdataBase, StockKdataCommon):
__tablename__ = 'stock_5m_kdata'
register_schema(providers=['joinquant'],
db_name='stock_5m_kdata',
schema_base=Stock5MKdataBase)
Stock15MKdataBase = declarative_base()
# 数字货币
from sqlalchemy.ext.declarative import declarative_base
from zvdata.domain import register_schema, register_entity
from zvdata.structs import EntityMixin
CoinMetaBase = declarative_base()
@register_entity(entity_type='coin')
class Coin(CoinMetaBase, EntityMixin):
__tablename__ = 'coin'
register_schema(providers=['ccxt'],
db_name='coin_meta',
schema_base=CoinMetaBase)
change = Column(Float)
# 变动比例
change_ratio = Column(Float)
@register_api(provider='eastmoney')
class InstitutionalInvestorHolder(HolderBase, Mixin):
__tablename__ = 'institutional_investor_holder'
provider = Column(String(length=32))
code = Column(String(length=32))
report_period = Column(String(length=32))
report_date = Column(DateTime)
# 机构类型
institutional_investor_type = Column(String(length=64))
# 股东代码
holder_code = Column(String(length=32))
# 股东名称
holder_name = Column(String(length=32))
# 持股数
shareholding_numbers = Column(Float)
# 持股比例
shareholding_ratio = Column(Float)
register_schema(providers=['eastmoney'],
db_name='holder',
schema_base=HolderBase)
# 交易类型(0代表T+0,1代表T+1)
trading_t = Column(Integer)
class Order(BusinessBase):
__tablename__ = 'order'
id = Column(String(length=128), primary_key=True)
# 时间
timestamp = Column(DateTime)
# 机器人名字
trader_name = Column(String(length=128))
# 证券id
entity_id = Column(String(length=128))
# 订单价格
order_price = Column(Float)
# 订单数量
order_amount = Column(Float)
# 订单类型
order_type = Column(String(length=64))
# 订单状态
status = Column(String(length=64))
# 产生订单的selector/factor level
level = Column(String(length=32))
register_schema(providers=['zvt'],
db_name='business',
schema_base=BusinessBase)
# 卖出营业部
net_out_dep1 = Column(String(length=128))
net_out_dep1_money_in = Column(Float)
net_out_dep1_money_out = Column(Float)
net_out_dep1_rate = Column(Float)
net_out_dep2 = Column(String(length=128))
net_out_dep2_money_in = Column(Float)
net_out_dep2_money_out = Column(Float)
net_out_dep2_rate = Column(Float)
net_out_dep3 = Column(String(length=128))
net_out_dep3_money_in = Column(Float)
net_out_dep3_money_out = Column(Float)
net_out_dep3_rate = Column(Float)
net_out_dep4 = Column(String(length=128))
net_out_dep4_money_in = Column(Float)
net_out_dep4_money_out = Column(Float)
net_out_dep4_rate = Column(Float)
net_out_dep5 = Column(String(length=128))
net_out_dep5_money_in = Column(Float)
net_out_dep5_money_out = Column(Float)
net_out_dep5_rate = Column(Float)
register_schema(providers=['eastmoney'],
db_name='trading',
schema_base=TradingBase)
# 方案
dividend = Column(String(length=128))
@register_api(provider='eastmoney')
class SpoDetail(DividendFinancingBase, Mixin):
__tablename__ = "spo_detail"
provider = Column(String(length=32))
code = Column(String(length=32))
spo_issues = Column(Float)
spo_price = Column(Float)
spo_raising_fund = Column(Float)
@register_api(provider='eastmoney')
class RightsIssueDetail(DividendFinancingBase, Mixin):
__tablename__ = "rights_issue_detail"
provider = Column(String(length=32))
code = Column(String(length=32))
# 配股
rights_issues = Column(Float)
rights_issue_price = Column(Float)
rights_raising_fund = Column(Float)
register_schema(providers=['eastmoney'], db_name='dividend_financing', schema_base=DividendFinancingBase)
close = Column(Float)
change_pct = Column(Float)
turnover_rate = Column(Float)
# 净流入
net_inflows = Column(Float)
# 净流入率
net_inflow_rate = Column(Float)
# 主力=超大单+大单
net_main_inflows = Column(Float)
net_main_inflow_rate = Column(Float)
# 超大单
net_huge_inflows = Column(Float)
net_huge_inflow_rate = Column(Float)
# 大单
net_big_inflows = Column(Float)
net_big_inflow_rate = Column(Float)
# 中单
net_medium_inflows = Column(Float)
net_medium_inflow_rate = Column(Float)
# 小单
net_small_inflows = Column(Float)
net_small_inflow_rate = Column(Float)
register_schema(providers=['sina'],
db_name='money_flow',
schema_base=MoneyFlowBase)
is_delisted = Column(Boolean)
industries = Column(String)
industry_indices = Column(String)
concept_indices = Column(String)
area_indices = Column(String)
indices = relationship('StockIndex', back_populates='stocks')
# 成立日期
date_of_establishment = Column(DateTime)
# 公司简介
profile = Column(String(length=1024))
# 主营业务
main_business = Column(String(length=512))
# 上市日期
list_date = Column(DateTime)
# 发行量(股)
issues = Column(BigInteger)
# 发行价格
price = Column(Float)
# 募资净额(元)
raising_fund = Column(Float)
# 发行市盈率
issue_pe = Column(Float)
# 网上中签率
net_winning_rate = Column(Float)
register_schema(providers=['eastmoney', 'exchange', 'sina'],
db_name='stock_meta',
schema_base=StockMetaBase)
# 买入额
margin_buy = Column(Float)
# 融券余额
short_value = Column(Float)
# 卖出量
short_volume = Column(Float)
# 融资融券余额
total_value = Column(Float)
# 北向/南向成交概况
class CrossMarketSummary(MacroBase, Mixin):
__tablename__ = 'cross_market_summary'
provider = Column(String(length=32))
code = Column(String(length=32))
name = Column(String(length=32))
buy_amount = Column(Float)
buy_volume = Column(Float)
sell_amount = Column(Float)
sell_volume = Column(Float)
quota_daily = Column(Float)
quota_daily_balance = Column(Float)
register_schema(providers=['exchange', 'joinquant'],
db_name='macro',
schema_base=MacroBase)
following = Column(Integer)
class GithubRepo(GithubRepoBase, NormalMixin):
__tablename__ = 'github_repo'
code = Column(String(length=64))
node_id = Column(String(length=128))
name = Column(String(length=128))
full_name = Column(String(length=128))
private = Column(Boolean)
language = Column(String(length=512))
forks_count = Column(Integer)
stargazers_count = Column(Integer)
watchers_count = Column(Integer)
size = Column(Integer)
open_issues_count = Column(Integer)
topics = Column(String(length=512))
pushed_at = Column(DateTime)
created_at = Column(DateTime)
updated_at = Column(DateTime)
subscribers_count = Column(Integer)
network_count = Column(Integer)
license = Column(String(512))
register_schema(providers=['github'], db_name='github_user', schema_base=GithubUserBase, entity_type='github_user')
register_schema(providers=['github'], db_name='github_repo', schema_base=GithubRepoBase, entity_type='github_user')
# define the db
MetaBase = declarative_base()
api_tmp_path = os.path.abspath(os.path.join(os.path.dirname(__file__)))
# define the schema
@register_api(provider='sina', api_dir=api_tmp_path)
@register_entity(entity_type='stock')
class Stock(MetaBase, EntityMixin):
__tablename__ = domain_name_to_table_name('Stock')
# 上市日期
list_date = Column(DateTime)
register_schema(providers=['eastmoney', 'sina'], db_name='meta', schema_base=MetaBase)
# define the db
MetaBase = declarative_base()
api_tmp_path = os.path.abspath(os.path.join(os.path.dirname(__file__)))
class StockKdataCommon(Mixin):
provider = Column(String(length=32))
code = Column(String(length=32))
name = Column(String(length=32))
# level = Column(Enum(TradingLevel, values_callable=enum_value))
level = Column(String(length=32))
open = Column(Float)