本股票数据库主要包括中国A股上市的102个行业的14,295股票的基本信息以及交易信息，同时也包含了与其相关的11,193家控股公司及其35,962名高管的具体信息。
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.
| 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) |
Data Samples
Database APIs
Tables & Columns
| 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%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
