本股票数据库主要为来自美股21个类别，4,050支股票的基本信息和交易信息，以及与其相关的42,195名控股高管的基本信息。
In this stocks data, there are 4,050 US stocks by 21 categories and 42,195 boards information. Each stock has stock number, description, company website, company address, etc. and there are name, position, stock, resume and business in each. It also includes 3,297 day transactions with detailed information. It has 5 tables in America stocks database.
| Name | n3_lyz_xueqiu.com_hq_mg |
|---|---|
| Data | 16.28M (+ 0B) |
| Tables | 5 (+ 0) |
| Columns | 51 (+ 0) |
| Table Rows | 54,227 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| board | 42,195 | name |
100%
|
| stock_id |
100%
|
||
| position |
100%
|
||
| resume |
0%
|
||
| category | 21 | title |
100%
|
| category_x_stock | 4,664 | category_id |
100%
|
| stock_id |
100%
|
||
| day_transaction | 3,297 | today_open |
100%
|
| last_close |
100%
|
||
| stock_id |
100%
|
||
| high |
100%
|
||
| low |
100%
|
||
| high52week |
100%
|
||
| low52week |
100%
|
||
| volume |
100%
|
||
| amplitude |
100%
|
||
| turnover_rate |
100%
|
||
| market_capital |
100%
|
||
| eps |
100%
|
||
| pe_lyr |
100%
|
||
| moving_avg_50_day |
100%
|
||
| moving_avg_200_day |
100%
|
||
| total_shares |
100%
|
||
| inst_own |
100%
|
||
| net_assets |
100%
|
||
| bonus_stock |
99.88%
|
||
| mrq |
99.85%
|
||
| number_of_empty_heads |
99.85%
|
||
| stock | 4,050 | stock_number |
100%
|
| stock |
100%
|
||
| description |
25.26%
|
||
| description_1 |
4.42%
|
||
| company_websit_1 |
27.11%
|
||
| company_websit |
4.42%
|
||
| company_address |
0.1%
|
||
| business |
0.1%
|
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.
