Home Data By Language 中文 / Chinese 金融股市

4,050美股上市股票及42,195名控股高管信息数据库 USA 4,050 Stocks Data: No., Company Address & 42,195 Boards: Name, Position

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)
Last Commit	2023-06-19 18:12:05 (+ 169 d)

本股票数据库主要为来自美股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.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_lyz/stock_information_of_USA_3/ (By Table)

Tables + Columns
Media Files
Updates
Download

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%
category_x_stock	4,664	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.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	16.28M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	16.28M (+ 896K)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	15.41M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	15.41M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	15.41M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	15.41M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	15.41M (+ 0B)	5 (+ 0)	51 (+ 0)	54,227 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10	15.41M	5	51	54,227	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

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.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.