Name | n3_lyz_xueqiu.com_hq_hs |
---|---|
Data | 171.03M (+ 0B) |
Tables | 13 (+ 0) |
Columns | 163 (+ 0) |
Table Rows | 304,443 (+ 0) |
Media | 0B (+ 0B) |
Files | 0 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
本股票数据库主要包括中国A股上市的102个行业的14,295股票的基本信息以及交易信息,同时也包含了与其相关的11,193家控股公司及其35,962名高管的具体信息。/p>
This is a stocks database of 14,295 records with 8,067 stock companies by 102 industries in China. Each stock has stock number, description, company website, company address and business. It contains company name, English name, founddate, business range, stock id, type, register capital wan, authorize capital, chairman, manager, legal person, secretary, secretary telephone, secretary fax, etc. in table stock company information. There are 35,962 supervisors with name, resume, stock id, board, data, information, salary and shares in each and 35,962 high leaders with name, resume, stock id, board, data, information, salary and shares in each. Besides, there are 15,523 day transactions and 71,965 board records.
The whole China stocks database consists of 13 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
board | 71,965 | name |
100%
|
resume |
100%
|
||
stock_id |
100%
|
||
board |
100%
|
||
data |
100%
|
||
information |
99.03%
|
||
salary |
100%
|
||
shares |
100%
|
||
category | 2 | title |
100%
|
category_2 | 89 | title |
100%
|
category_id |
100%
|
||
category_2_x_stock | 18,542 | category_2_id |
100%
|
stock_id |
100%
|
||
day_transaction | 15,523 | today_open |
100%
|
last_close |
100%
|
||
rise_stop |
100%
|
||
fall_stop |
100%
|
||
stock_id |
100%
|
||
high |
100%
|
||
low |
100%
|
||
turnover_rate |
100%
|
||
amplitude |
100%
|
||
float_shares |
100%
|
||
high_52_weeks |
100%
|
||
low_52_weeks |
100%
|
||
eps |
100%
|
||
net_assets |
100%
|
||
market_capital |
100%
|
||
volume |
100%
|
||
amount |
100%
|
||
pe_ttm |
100%
|
||
pe_lyr |
100%
|
||
pb |
100%
|
||
float_market_capital |
100%
|
||
high_leader | 35,962 | name |
100%
|
resume |
100%
|
||
stock_id |
100%
|
||
board |
100%
|
||
data |
100%
|
||
information |
98.08%
|
||
salary |
100%
|
||
shares |
100%
|
||
industry | 102 | industry |
100%
|
share_company | 8,067 | share_and_holding_company |
100%
|
stock_id |
100%
|
||
consolidated_statement_company |
100%
|
||
share_company_detail | 80,852 | company |
100%
|
type |
100%
|
||
proportion_of_share |
100%
|
||
investment |
100%
|
||
net_profit |
100%
|
||
stock_id |
100%
|
||
consolidated_statement |
100%
|
||
stock | 14,295 | stock_number |
100%
|
stock |
100%
|
||
description |
97.8%
|
||
company_websit |
96.4%
|
||
company_address |
59.8%
|
||
business |
24.81%
|
||
stock_company_info | 11,193 | company_name |
100%
|
eng_name |
96.46%
|
||
founddate |
100%
|
||
business_range |
99.87%
|
||
stock_id |
100%
|
||
type |
95.83%
|
||
register_capital_wan |
100%
|
||
authorize_capital |
100%
|
||
chairman |
99.85%
|
||
manager |
99.64%
|
||
legal_person |
99.99%
|
||
secretary |
99.79%
|
||
secretary_telephone |
99.28%
|
||
secretary_fax |
98.65%
|
||
representative_of_shares |
5.76%
|
||
shares_representative_telephone |
5.27%
|
||
shares_representative_fax |
5.21%
|
||
shares_representative_email |
4.99%
|
||
authorize_representative |
0.02%
|
||
counsel |
99.71%
|
||
accounting_firm |
99.47%
|
||
register_address |
100%
|
||
office_address |
100%
|
||
office_zip_code |
100%
|
||
company_telephone |
98.71%
|
||
company_fax |
99.23%
|
||
company_email |
94.51%
|
||
company_websit |
96.17%
|
||
service_telephone |
0.82%
|
||
service_fax |
0.01%
|
||
main_business |
99.91%
|
||
section_one |
100%
|
||
section_two |
75.48%
|
||
stock_company_info_x_industry | 11,889 | stock_company_info_id |
100%
|
industry_id |
100%
|
||
supervisor | 35,962 | name |
100%
|
resume |
100%
|
||
stock_id |
100%
|
||
board |
100%
|
||
data |
100%
|
||
information |
98.08%
|
||
salary |
100%
|
||
shares |
100%
|
No media sets.
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2023-01-01 (+ 95 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2022-09-27 (+ 271 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-12-30 (+ 115 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-09-05 (+ 150 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-04-08 (+ 68 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-01-29 (+ 120 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-10-01 (+ 38 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-08-23 (+ 141 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-04-04 (+ 196 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-09-21 (+ 197 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-03-07 (+ 43 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-01-23 (+ 44 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-12-09 (+ 29 d) | 171.03M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-11-09 (+ 27 d) | 171.03M (+ 28.48M) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-10-13 (+ 29 d) | 142.55M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-09-13 (+ 34 d) | 142.55M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-08-09 (+ 27 d) | 142.55M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-07-12 (+ 31 d) | 142.55M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 (+ 31 d) | 142.55M (+ 0B) | 13 (+ 0) | 163 (+ 0) | 304,443 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-05-10 | 142.55M | 13 | 163 | 304,443 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.