说明
jqdatapy为聚宽数据http接口的python封装,为官方jqdatasdk的轻量替代。
其目的在于减少依赖,解决版本冲突,在zvt中用于数据的本地化,
特性
- 原始封装,方法名和字段跟官方文档一致
- 自动化保留token,按需请求
- 只依赖requests和pandas(可用最新版)
安装
pip install jqdatapy
pip show jqdatapy
更新到最新版本
pip install --upgrade jqdatapy
使用
初始化环境,会自动本地化token
In [1]: from jqdatapy import *
In [2]: init_env(username='聚宽注册手机',password='密码')
api使用
In [5]: print(get_bars(code='000338.XSHE'))
...: print(get_all_securities())
...: print(get_trade_days())
...: print(get_trade_days())
...: print(get_fundamentals(count=10))
...: print(get_mtss())
...: print(run_query(count=10, parse_dates=None))
date open close high low volume money paused high_limit low_limit avg pre_close
0 2020-09-14 14.24 14.35 14.43 14.22 24556166 3.514904e+08 0 15.59 12.75 14.31 14.17
1 2020-09-15 14.35 14.90 14.95 14.31 56693203 8.360576e+08 0 15.79 12.92 14.75 14.35
2 2020-09-16 14.83 15.02 15.34 14.75 49258551 7.402552e+08 0 16.39 13.41 15.03 14.90
3 2020-09-17 15.19 16.18 16.30 15.19 130136055 2.063710e+09 0 16.52 13.52 15.86 15.02
4 2020-09-18 16.35 16.59 16.65 16.23 112580041 1.854240e+09 0 17.80 14.56 16.47 16.18
5 2020-09-21 16.60 16.00 16.62 15.84 69804961 1.123414e+09 0 18.25 14.93 16.09 16.59
6 2020-09-22 15.85 15.62 16.04 15.54 50336697 7.942570e+08 0 17.60 14.40 15.78 16.00
7 2020-09-23 15.69 15.48 15.75 15.34 46083422 7.135471e+08 0 17.18 14.06 15.48 15.62
8 2020-09-24 15.34 15.08 15.37 15.04 37973611 5.750271e+08 0 17.03 13.93 15.14 15.48
9 2020-09-25 15.20 14.92 15.20 14.91 18540881 2.786308e+08 0 16.59 13.57 15.03 15.08
code display_name name start_date end_date type
0 000001.XSHE 平安银行 PAYX 1991-04-03 2200-01-01 stock
1 000002.XSHE 万科A WKA 1991-01-29 2200-01-01 stock
2 000004.XSHE 国农科技 GNKJ 1990-12-01 2200-01-01 stock
3 000005.XSHE 世纪星源 SJXY 1990-12-10 2200-01-01 stock
4 000006.XSHE 深振业A SZYA 1992-04-27 2200-01-01 stock
... ... ... ... ... ... ...
4126 688596.XSHG 正帆科技 ZFKJ 2020-08-20 2200-01-01 stock
4127 688598.XSHG 金博股份 JBGF 2020-05-18 2200-01-01 stock
4128 688599.XSHG 天合光能 THGN 2020-06-10 2200-01-01 stock
4129 688600.XSHG 皖仪科技 WYKJ 2020-07-03 2200-01-01 stock
4130 688981.XSHG 中芯国际 ZXGJ 2020-07-16 2200-01-01 stock
[4131 rows x 6 columns]
0
0 2004-11-08
1 2004-11-09
2 2004-11-10
3 2004-11-11
4 2004-11-12
... ...
3861 2020-09-21
3862 2020-09-22
3863 2020-09-23
3864 2020-09-24
3865 2020-09-25
[3866 rows x 1 columns]
0
0 2004-11-08
1 2004-11-09
2 2004-11-10
3 2004-11-11
4 2004-11-12
... ...
3861 2020-09-21
3862 2020-09-22
3863 2020-09-23
3864 2020-09-24
3865 2020-09-25
[3866 rows x 1 columns]
id code day pubDate statDate periodStart ... retained_profit foreign_currency_report_conv_diff equities_parent_company_owners minority_interests total_owner_equities total_sheet_owner_equities
0 28053040.0 000001.XSHE 2020-09-16 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
1 28053042.0 000001.XSHE 2020-09-17 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
2 28053044.0 000001.XSHE 2020-09-18 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
3 28053044.0 000001.XSHE 2020-09-19 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
4 28053044.0 000001.XSHE 2020-09-20 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
5 28053046.0 000001.XSHE 2020-09-21 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
6 28053048.0 000001.XSHE 2020-09-22 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
7 28053048.0 000001.XSHE 2020-09-23 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
8 28053048.0 000001.XSHE 2020-09-24 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
9 28053050.0 000001.XSHE 2020-09-25 2020-08-28 2020-06-30 2020-08-28 ... 1.219440e+11 NaN 3.513970e+11 NaN 3.513970e+11 4.178622e+12
[10 rows x 89 columns]
date sec_code fin_value fin_buy_value fin_refund_value sec_value sec_sell_value sec_refund_value fin_sec_value
0 2010-03-31 000001.XSHE 4730 4730 0 2100 2100 0 53450
1 2010-04-01 000001.XSHE 4730 0 0 0 0 2100 4730
2 2010-04-02 000001.XSHE 4712 2347 2365 0 0 0 4712
3 2010-04-06 000001.XSHE 4712 0 0 0 0 0 4712
4 2010-04-07 000001.XSHE 4712 0 0 0 0 0 4712
... ... ... ... ... ... ... ... ... ...
2548 2020-09-18 000001.XSHE 3919556191 238189827 270275976 67512142 120200 234200 5004476313
2549 2020-09-21 000001.XSHE 3849371241 108081360 178266310 66813349 429500 1128293 4909030957
2550 2020-09-22 000001.XSHE 3855420696 106478290 100428835 70238849 3559400 133900 4949039576
2551 2020-09-23 000001.XSHE 3744883578 71282484 181819602 71950394 1788079 76534 4869468236
2552 2020-09-24 000001.XSHE 3771133403 113139423 86889598 72439450 1561856 1072800 4866417887
[2553 rows x 9 columns]
id exchange_code exchange_name date total_market_cap circulating_market_cap volume money deal_number pe_average turnover_ratio
0 1 322002 上海A股 2005-01-04 25228.240618 6941.067590 80648.3466 43.888276 42.2473 23.817 0.6368
1 2 322003 上海B股 2005-01-04 298.830614 298.830614 1019.3588 0.311245 0.4442 20.065 0.1018
2 3 322001 上海市场 2005-01-04 25527.071233 7239.898204 81667.7054 44.199521 42.6915 23.768 0.5976
3 4 322006 中小企业板 2005-01-04 409.450000 118.850000 800.0000 1.190000 1.4600 31.030 NaN
4 5 322004 深圳市场 2005-01-04 10859.540000 4279.140000 NaN 24.740000 NaN 24.220 0.5300
5 6 322002 上海A股 2005-01-05 25408.493484 7022.186703 85238.5339 48.680153 52.7249 23.978 0.6731
6 7 322003 上海B股 2005-01-05 306.795402 306.795402 1597.9846 0.500740 0.6206 20.629 0.1595
7 8 322001 上海市场 2005-01-05 25715.288885 7328.982104 86836.5185 49.180893 53.3455 23.934 0.6354
8 9 322006 中小企业板 2005-01-05 415.900000 120.760000 1000.0000 1.370000 1.6800 31.520 NaN
9 10 322004 深圳市场 2005-01-05 11021.380000 4347.240000 NaN 30.500000 NaN 24.570 0.6700
联系
微信 foolcage
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
jqdatapy-0.1.8.tar.gz
(13.0 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file jqdatapy-0.1.8.tar.gz.
File metadata
- Download URL: jqdatapy-0.1.8.tar.gz
- Upload date:
- Size: 13.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.0 CPython/3.9.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b9cd6d26bead718ad5aa9bbc7cf8858271eb6d7cad6549988e2d1265cd2a576c
|
|
| MD5 |
2bbdec777919411b66c5ad6cddddefd6
|
|
| BLAKE2b-256 |
1465e03202c6c69b1cc0419685f35f6401cd1981eeda11f8ae25d9db1477c255
|
File details
Details for the file jqdatapy-0.1.8-py3-none-any.whl.
File metadata
- Download URL: jqdatapy-0.1.8-py3-none-any.whl
- Upload date:
- Size: 9.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.0 CPython/3.9.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
66cd5c087e139546e214dddbe4e65f2ce1cd8f9417912304c9350e97dedc81a0
|
|
| MD5 |
557ec08d7851a1295b020a1975131989
|
|
| BLAKE2b-256 |
e149e263252f4852295f100cc6ae39e23cbbe9189513804a2ac06ca577ed9b47
|