US Stock Market End of Day dataset
Atreyuroc



Support
Academic Torrents!

Disable your
ad-blocker!

endofday.tar.gz250.71MB
Type: Dataset
Tags: Stock Market High Low Close Open Volume Ticker Date

Bibtex:
@article{,
title= {US Stock Market End of Day dataset},
keywords= {Stock Market High Low Close Open Volume Ticker Date},
journal= {},
author= {Atreyuroc},
year= {},
url= {},
license= {},
abstract= {4974 Stock Symbols End of day data. Includes close open high low volume and date. Data was collected from Google finance public data. 

```
+----------+------------+
| Table    | Size in MB |
+----------+------------+
| surf_eod |    1109.00 |
+----------+------------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(DISTINCT(`ticker`)) FROM surf_eod;
+---------------------------+
| COUNT(DISTINCT(`ticker`)) |
+---------------------------+
|                      4974 |
+---------------------------+
1 row in set (6.31 sec)

mysql> describe surf_eod;
+--------+-------------+------+-----+-------------------+-----------------------------+
| Field  | Type        | Null | Key | Default           | Extra                       |
+--------+-------------+------+-----+-------------------+-----------------------------+
| ticker | varchar(10) | YES  | MUL | NULL              |                             |
| date   | date        | YES  |     | NULL              |                             |
| close  | varchar(20) | YES  |     | NULL              |                             |
| high   | varchar(20) | YES  |     | NULL              |                             |
| low    | varchar(20) | YES  |     | NULL              |                             |
| open   | varchar(20) | YES  |     | NULL              |                             |
| volume | varchar(20) | YES  |     | NULL              |                             |
| time   | timestamp   | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+--------+-------------+------+-----+-------------------+-----------------------------+
8 rows in set (0.04 sec)

mysql> SELECT COUNT(*) FROM surf_eod;
+----------+
| COUNT(*) |
+----------+
| 17726722 |
+----------+
1 row in set (25.18 sec)
```},
superseded= {},
terms= {}
}