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