def record(self, entity, start, end, size, timestamps): jq_code = code_map_jq.get(entity.code) q = query(finance.STK_EXCHANGE_TRADE_INFO).filter( finance.STK_EXCHANGE_TRADE_INFO.exchange_code == jq_code, finance.STK_EXCHANGE_TRADE_INFO.date >= to_time_str(start)).limit(2000) df = finance.run_query(q) print(df) json_results = [] for item in df.to_dict(orient='records'): result = { 'provider': self.provider, 'timestamp': item['date'], 'name': entity.name, 'pe': item['pe_average'], 'total_value': multiple_number(item['total_market_cap'], 100000000), 'total_tradable_vaule': multiple_number(item['circulating_market_cap'], 100000000), 'volume': multiple_number(item['volume'], 10000), 'turnover': multiple_number(item['money'], 100000000), 'turnover_rate': item['turnover_ratio'] } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results
def record(self, entity, start, end, size, timestamps): df = run_query(table='finance.STK_ML_QUOTA', conditions=f'link_id#=#{entity.code}&day#>=#{to_time_str(start)}') print(df) json_results = [] for item in df.to_dict(orient='records'): result = { 'provider': self.provider, 'timestamp': item['day'], 'name': entity.name, 'buy_amount': multiple_number(item['buy_amount'], 100000000), 'buy_volume': item['buy_volume'], 'sell_amount': multiple_number(item['sell_amount'], 100000000), 'sell_volume': item['sell_volume'], 'quota_daily': multiple_number(item['quota_daily'], 100000000), 'quota_daily_balance': multiple_number(item['quota_daily_balance'], 100000000) } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results
def record(self, entity, start, end, size, timestamps): df = run_query(table="finance.STK_ML_QUOTA", conditions=f"link_id#=#{entity.code}&day#>=#{to_time_str(start)}") print(df) json_results = [] for item in df.to_dict(orient="records"): result = { "provider": self.provider, "timestamp": item["day"], "name": entity.name, "buy_amount": multiple_number(item["buy_amount"], 100000000), "buy_volume": item["buy_volume"], "sell_amount": multiple_number(item["sell_amount"], 100000000), "sell_volume": item["sell_volume"], "quota_daily": multiple_number(item["quota_daily"], 100000000), "quota_daily_balance": multiple_number(item["quota_daily_balance"], 100000000), } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results
def record(self, entity, start, end, size, timestamps): jq_code = code_map_jq.get(entity.code) df = run_query( table="finance.STK_EXCHANGE_TRADE_INFO", conditions= f"exchange_code#=#{jq_code}&date#>=#{to_time_str(start)}", parse_dates=["date"], ) print(df) json_results = [] for item in df.to_dict(orient="records"): result = { "provider": self.provider, "timestamp": item["date"], "name": entity.name, "pe": item["pe_average"], "total_value": multiple_number(item["total_market_cap"], 100000000), "total_tradable_vaule": multiple_number(item["circulating_market_cap"], 100000000), "volume": multiple_number(item["volume"], 10000), "turnover": multiple_number(item["money"], 100000000), "turnover_rate": item["turnover_ratio"], } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results
def record(self, entity, start, end, size, timestamps): jq_code = code_map_jq.get(entity.code) df = run_query( table='finance.STK_EXCHANGE_TRADE_INFO', conditions= f'exchange_code#=#{jq_code}&date#>=#{to_time_str(start)}', parse_dates=['date']) print(df) json_results = [] for item in df.to_dict(orient='records'): result = { 'provider': self.provider, 'timestamp': item['date'], 'name': entity.name, 'pe': item['pe_average'], 'total_value': multiple_number(item['total_market_cap'], 100000000), 'total_tradable_vaule': multiple_number(item['circulating_market_cap'], 100000000), 'volume': multiple_number(item['volume'], 10000), 'turnover': multiple_number(item['money'], 100000000), 'turnover_rate': item['turnover_ratio'] } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results
def record(self, entity, start, end, size, timestamps): q = query(finance.STK_ML_QUOTA).filter( finance.STK_ML_QUOTA.link_id == entity.code, finance.STK_ML_QUOTA.day >= to_time_str(start)).limit(2000) df = finance.run_query(q) print(df) json_results = [] for item in df.to_dict(orient='records'): result = { 'provider': self.provider, 'timestamp': item['day'], 'name': entity.name, 'buy_amount': multiple_number(item['buy_amount'], 100000000), 'buy_volume': item['buy_volume'], 'sell_amount': multiple_number(item['sell_amount'], 100000000), 'sell_volume': item['sell_volume'], 'quota_daily': multiple_number(item['quota_daily'], 100000000), 'quota_daily_balance': multiple_number(item['quota_daily_balance'], 100000000) } json_results.append(result) if len(json_results) < 100: self.one_shot = True return json_results