NYSE: New-York Stock Exchange.

Home » NYSE: New-York Stock Exchange.

Statistic:

Number of shares ~ 2708
Data size ~ 1,3 Gb.
Number of attributes in PostgreSQL database ~ 11 million.
PostgreSQL table size ~ 1,1 Gb.
Updating every working day from 06:00 am to 06:30 am.

Download quotes:

You can download any data from our >>> Gdrive <<<
Please read readme.txt for description.

Scripts for PostgreSQL:

List of all shares in the tables. (nyse_ticker_list.csv).

CREATE table nyse_ticker_list(
	,ticker   VARCHAR(5) NOT NULL
	,name     VARCHAR(100));

Scripts for PostgreSQL:

Schema of the original table. (nyse_data.csv)
The same scheme is used for the table. (nyse_data_new.csv)

CREATE TABLE nyse_data(
	Date      DATE  NOT NULL
	,Symbols   VARCHAR(10) NOT NULL
	,Adj_Close NUMERIC(21, 15) NOT NULL
	,Close     NUMERIC(21, 15) NOT NULL
	,High      NUMERIC(21, 15) NOT NULL
	,Low       NUMERIC(21, 15) NOT NULL
	,Open      NUMERIC(21, 15) NOT NULL
	,Volume    NUMERIC(13, 2) NOT NULL);

Leave a Reply

Your email address will not be published. Required fields are marked *