# 专项指标(保险) # # 总投资收益率 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)