datacenter_datasdk
Project description
datacenter_datasdk
INSTALL
step.1
pip install datacenter-datasdk
step.2 add auth(token, password) (ask for admin) before query data
USAGE
from datacenter_datasdk import auth, get_price, get_trade_days, get_security_info
from datacenter_datasdk import CN_JQ_SUMMARY, query
from datacenter_datasdk import query_by_sql
auth(token, password)
data = get_price('600033.XSHG', 'cn', 'm1', start_date='2010-01-01', end_date='2021-01-01')
trade_days = get_trade_days('cn', start_date='2021-01-01', count=10)
info = get_security_info('cn', '600033.XSHG')
d = query(CN_JQ_SUMMARY).filter(
CN_JQ_SUMMARY.code=='000001.XSHE').order_by(
CN_JQ_SUMMARY.date.desc()).all()
df = query_by_sql('cn_jq_summary',
condition='code = \'000004.XSHE\' and date= \'2021-01-11\'',
columns=['date', 'code', 'industry_name']
)
API
get_price()
get kline data, include daily, minute and tick
params
code(required): str or list, single code or multi code as list
region(required): str, 'cn' or 'us'
frequency(required): str, represent frequency of kline, 'd1', 'm1', 'm5', 'm15', 'm30', 'm60' and 'tick'(only in cn), 'd1_post'(only in cn), 'd1_raw'(only in cn)
start_date(optional), datetime.datetime or datetime.date or str, start time of data, default '2005-01-01'
end_date(optional), datetime.datetime or datetime.date or str, end time of data, default 0 o'clock of today
return
dataframe
get_trade_days()
get trade days
params
region(required): str, 'cn' or 'us'
start_date(optional), datetime.datetime or datetime.date or str, start time of data, default None
end_date(optional), datetime.datetime or datetime.date or str, end time of data, default None
count(optional), int, default None
return
list of date
get_security_info()
get security info
params
region(required): str, 'cn' or 'us'
types(optional): list, values in ('etf', 'stock', 'index'), default ['etf', 'stock', 'index']
code(optional): str, default None (get all code info), default None
date(optional), datetime.datetime or datetime.date or str, not exit market until this date, default None
return
dataframe
query()
is also query object in sqlalchemy
params
table(required): object, import from given list of table object, the given table list ask for admin
return
list of table object or table object
query_by_sql()
get data by defining 'where' condition in sql, max rows of one return is 100w
params
table_name(required): str, table name
condition(optional): str, 'where' condition str in sql, to filter data, default None
columns(optional): list, the return columns, default None and return all columns
return
dataframe
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for datacenter_datasdk-0.2.21.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3d5aa7568faa4a109ab4c04a0114b34d330682c5eb77c5e909deb1de7c925e79 |
|
MD5 | a117509436682f0607ca17dc00963fd7 |
|
BLAKE2b-256 | 67184e859df1abfcf20d71dcd047f300b6b90556d4ebeed5f486a86c0edf3a35 |
Hashes for datacenter_datasdk-0.2.21-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ea96890d2843fe32af0bf5f9d2f5e31e94b52120f6c9d7a88e35a10d3e487f5a |
|
MD5 | 2e3cb4452bf24d3ce70651e4efd9af19 |
|
BLAKE2b-256 | 8e43c20fb2d050e4becf71bc26ebbaf79abff28caf966f46a4dbded1e6ec4c6c |