PREVIEW / stock_1min / 2014-01-02
file: by_date/stock_1min/2014/2014-01-02.parquet size: 14.6 MB rows: 1,062,183 symbols: 2,847
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2014-01-02 04:00:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 5264.0 |
| 2014-01-02 04:08:00 | AAPL | Stock | 19.8632 | 19.8632 | 19.8632 | 19.8632 | 5600.0 |
| 2014-01-02 04:09:00 | AAPL | Stock | 19.8596 | 19.8596 | 19.8596 | 19.8596 | 2800.0 |
| 2014-01-02 04:11:00 | AAPL | Stock | 19.8471 | 19.8471 | 19.8471 | 19.8471 | 5600.0 |
| 2014-01-02 04:12:00 | AAPL | Stock | 19.8471 | 19.8571 | 19.8471 | 19.8571 | 19236.0 |
| 2014-01-02 04:13:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 11200.0 |
| 2014-01-02 04:14:00 | AAPL | Stock | 19.8571 | 19.8579 | 19.8571 | 19.8579 | 59080.0 |
| 2014-01-02 04:15:00 | AAPL | Stock | 19.8611 | 19.8611 | 19.8607 | 19.8607 | 8400.0 |
| 2014-01-02 04:27:00 | AAPL | Stock | 19.8614 | 19.8679 | 19.8568 | 19.8568 | 15092.0 |
| 2014-01-02 04:29:00 | AAPL | Stock | 19.8586 | 19.8586 | 19.8586 | 19.8586 | 2800.0 |
| 2014-01-02 04:39:00 | AAPL | Stock | 19.8571 | 19.8575 | 19.8571 | 19.8575 | 8400.0 |
| 2014-01-02 04:42:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5600.0 |
| 2014-01-02 04:47:00 | AAPL | Stock | 19.8521 | 19.8521 | 19.8521 | 19.8521 | 2800.0 |
| 2014-01-02 05:01:00 | AAPL | Stock | 19.8318 | 19.8318 | 19.8318 | 19.8318 | 2800.0 |
| 2014-01-02 05:12:00 | AAPL | Stock | 19.8107 | 19.8107 | 19.8107 | 19.8107 | 2800.0 |
| 2014-01-02 05:20:00 | AAPL | Stock | 19.8039 | 19.8039 | 19.8039 | 19.8039 | 2800.0 |
| 2014-01-02 05:35:00 | AAPL | Stock | 19.8018 | 19.8036 | 19.8018 | 19.8036 | 8400.0 |
| 2014-01-02 05:38:00 | AAPL | Stock | 19.8018 | 19.8018 | 19.8018 | 19.8018 | 2800.0 |
| 2014-01-02 05:46:00 | AAPL | Stock | 19.8118 | 19.8118 | 19.8118 | 19.8118 | 2800.0 |
| 2014-01-02 06:06:00 | AAPL | Stock | 19.8607 | 19.8607 | 19.8607 | 19.8607 | 11284.0 |
| 2014-01-02 06:10:00 | AAPL | Stock | 19.8543 | 19.8543 | 19.8543 | 19.8543 | 2800.0 |
| 2014-01-02 06:14:00 | AAPL | Stock | 19.8643 | 19.8643 | 19.8571 | 19.8571 | 10556.0 |
| 2014-01-02 06:18:00 | AAPL | Stock | 19.8364 | 19.8364 | 19.8354 | 19.8354 | 5600.0 |
| 2014-01-02 06:19:00 | AAPL | Stock | 19.825 | 19.825 | 19.8214 | 19.8214 | 12544.0 |
| 2014-01-02 06:24:00 | AAPL | Stock | 19.8282 | 19.8282 | 19.8214 | 19.8214 | 5600.0 |
| 2014-01-02 06:25:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 11200.0 |
| 2014-01-02 06:31:00 | AAPL | Stock | 19.8396 | 19.8396 | 19.8396 | 19.8396 | 2800.0 |
| 2014-01-02 06:45:00 | AAPL | Stock | 19.845 | 19.845 | 19.845 | 19.845 | 5600.0 |
| 2014-01-02 07:01:00 | AAPL | Stock | 19.8214 | 19.8457 | 19.8214 | 19.8457 | 13720.0 |
| 2014-01-02 07:02:00 | AAPL | Stock | 19.8429 | 19.8429 | 19.8429 | 19.8429 | 2800.0 |
| 2014-01-02 07:04:00 | AAPL | Stock | 19.8568 | 19.8568 | 19.8561 | 19.8568 | 14000.0 |
| 2014-01-02 07:05:00 | AAPL | Stock | 19.8571 | 19.8575 | 19.8571 | 19.8575 | 25200.0 |
| 2014-01-02 07:06:00 | AAPL | Stock | 19.8596 | 19.87 | 19.8571 | 19.87 | 37128.0 |
| 2014-01-02 07:07:00 | AAPL | Stock | 19.8518 | 19.8518 | 19.8518 | 19.8518 | 12600.0 |
| 2014-01-02 07:10:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5880.0 |
| 2014-01-02 07:11:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 2800.0 |
| 2014-01-02 07:12:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 2800.0 |
| 2014-01-02 07:14:00 | AAPL | Stock | 19.8714 | 19.8729 | 19.8714 | 19.8729 | 5600.0 |
| 2014-01-02 07:15:00 | AAPL | Stock | 19.8871 | 19.8871 | 19.8871 | 19.8871 | 2800.0 |
| 2014-01-02 07:20:00 | AAPL | Stock | 19.8821 | 19.9286 | 19.8821 | 19.8857 | 45668.0 |
| 2014-01-02 07:21:00 | AAPL | Stock | 19.8821 | 19.8825 | 19.8821 | 19.8825 | 8400.0 |
| 2014-01-02 07:22:00 | AAPL | Stock | 19.8821 | 19.8821 | 19.875 | 19.875 | 27860.0 |
| 2014-01-02 07:23:00 | AAPL | Stock | 19.8818 | 19.8818 | 19.8818 | 19.8818 | 2800.0 |
| 2014-01-02 07:24:00 | AAPL | Stock | 19.875 | 19.875 | 19.875 | 19.875 | 5600.0 |
| 2014-01-02 07:28:00 | AAPL | Stock | 19.8596 | 19.8679 | 19.8582 | 19.8582 | 28000.0 |
| 2014-01-02 07:29:00 | AAPL | Stock | 19.8596 | 19.8596 | 19.8536 | 19.8536 | 8400.0 |
| 2014-01-02 07:30:00 | AAPL | Stock | 19.8496 | 19.8504 | 19.8496 | 19.8504 | 8400.0 |
| 2014-01-02 07:31:00 | AAPL | Stock | 19.85 | 19.8571 | 19.8482 | 19.8571 | 19656.0 |
| 2014-01-02 07:32:00 | AAPL | Stock | 19.8571 | 19.8643 | 19.8571 | 19.8643 | 9240.0 |
| 2014-01-02 07:33:00 | AAPL | Stock | 19.8696 | 19.875 | 19.8696 | 19.875 | 5600.0 |
> showing 50 of 1,062,183 rows — these rows as CSV