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