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):
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