PREVIEW / stock_5min / 2013-02-05
file: by_date/stock_5min/2013/2013-02-05.parquet size: 4.9 MB rows: 328,708 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-05 04:30:00 | AAPL | Stock | 15.8357 | 15.8468 | 15.8357 | 15.8375 | 34692.0 |
| 2013-02-05 04:40:00 | AAPL | Stock | 15.8443 | 15.8536 | 15.8443 | 15.8536 | 14028.0 |
| 2013-02-05 05:15:00 | AAPL | Stock | 15.8696 | 15.8696 | 15.8696 | 15.8696 | 2800.0 |
| 2013-02-05 05:25:00 | AAPL | Stock | 15.8304 | 15.8304 | 15.8304 | 15.8304 | 4760.0 |
| 2013-02-05 05:45:00 | AAPL | Stock | 15.8464 | 15.8743 | 15.8464 | 15.8743 | 24276.0 |
| 2013-02-05 06:00:00 | AAPL | Stock | 15.875 | 15.875 | 15.875 | 15.875 | 11200.0 |
| 2013-02-05 06:05:00 | AAPL | Stock | 15.8643 | 15.8643 | 15.8643 | 15.8643 | 14000.0 |
| 2013-02-05 06:20:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8571 | 15.8571 | 28000.0 |
| 2013-02-05 06:25:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8571 | 15.8571 | 2800.0 |
| 2013-02-05 06:35:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8571 | 15.8571 | 44800.0 |
| 2013-02-05 06:50:00 | AAPL | Stock | 15.84 | 15.84 | 15.84 | 15.84 | 2800.0 |
| 2013-02-05 06:55:00 | AAPL | Stock | 15.8236 | 15.8393 | 15.8236 | 15.8304 | 22540.0 |
| 2013-02-05 07:00:00 | AAPL | Stock | 15.8389 | 15.875 | 15.8389 | 15.875 | 67872.0 |
| 2013-02-05 07:05:00 | AAPL | Stock | 15.875 | 15.8886 | 15.875 | 15.8886 | 40684.0 |
| 2013-02-05 07:10:00 | AAPL | Stock | 15.8918 | 15.8996 | 15.8918 | 15.8929 | 97412.0 |
| 2013-02-05 07:15:00 | AAPL | Stock | 15.8993 | 15.9193 | 15.8993 | 15.9164 | 128044.0 |
| 2013-02-05 07:20:00 | AAPL | Stock | 15.9232 | 15.9336 | 15.9207 | 15.9279 | 204512.0 |
| 2013-02-05 07:25:00 | AAPL | Stock | 15.9268 | 15.9464 | 15.925 | 15.9464 | 74368.0 |
| 2013-02-05 07:30:00 | AAPL | Stock | 15.925 | 15.9393 | 15.925 | 15.9329 | 29960.0 |
| 2013-02-05 07:35:00 | AAPL | Stock | 15.9271 | 15.9375 | 15.9271 | 15.9286 | 60900.0 |
| 2013-02-05 07:40:00 | AAPL | Stock | 15.9129 | 15.9129 | 15.8929 | 15.9018 | 115640.0 |
| 2013-02-05 07:45:00 | AAPL | Stock | 15.9007 | 15.9018 | 15.9004 | 15.9018 | 11200.0 |
| 2013-02-05 07:50:00 | AAPL | Stock | 15.9082 | 15.9179 | 15.9079 | 15.9079 | 75572.0 |
| 2013-02-05 07:55:00 | AAPL | Stock | 15.9246 | 15.9246 | 15.9025 | 15.9025 | 18200.0 |
| 2013-02-05 08:00:00 | AAPL | Stock | 15.8939 | 15.9411 | 15.8607 | 15.8868 | 367780.0 |
| 2013-02-05 08:05:00 | AAPL | Stock | 15.8914 | 15.9014 | 15.8811 | 15.8811 | 138880.0 |
| 2013-02-05 08:10:00 | AAPL | Stock | 15.8761 | 15.8929 | 15.8689 | 15.8886 | 185808.0 |
| 2013-02-05 08:15:00 | AAPL | Stock | 15.875 | 15.8886 | 15.8614 | 15.8886 | 128520.0 |
| 2013-02-05 08:20:00 | AAPL | Stock | 15.8886 | 15.8929 | 15.8768 | 15.8775 | 73808.0 |
| 2013-02-05 08:25:00 | AAPL | Stock | 15.8786 | 15.8789 | 15.8489 | 15.8489 | 285264.0 |
| 2013-02-05 08:30:00 | AAPL | Stock | 15.8521 | 15.8693 | 15.8411 | 15.8589 | 290556.0 |
| 2013-02-05 08:35:00 | AAPL | Stock | 15.8604 | 15.8689 | 15.8586 | 15.8586 | 200928.0 |
| 2013-02-05 08:40:00 | AAPL | Stock | 15.8589 | 15.885 | 15.8589 | 15.8821 | 242088.0 |
| 2013-02-05 08:45:00 | AAPL | Stock | 15.8814 | 15.8821 | 15.8771 | 15.8786 | 60620.0 |
| 2013-02-05 08:50:00 | AAPL | Stock | 15.8789 | 15.9075 | 15.8729 | 15.9068 | 434644.0 |
| 2013-02-05 08:55:00 | AAPL | Stock | 15.905 | 15.9171 | 15.9025 | 15.9154 | 211764.0 |
| 2013-02-05 09:00:00 | AAPL | Stock | 15.9171 | 15.925 | 15.9154 | 15.9221 | 307440.0 |
| 2013-02-05 09:05:00 | AAPL | Stock | 15.9218 | 15.9282 | 15.9121 | 15.9121 | 184800.0 |
| 2013-02-05 09:10:00 | AAPL | Stock | 15.9139 | 15.9175 | 15.9125 | 15.9129 | 95060.0 |
| 2013-02-05 09:15:00 | AAPL | Stock | 15.9136 | 15.9196 | 15.9046 | 15.9114 | 193200.0 |
| 2013-02-05 09:20:00 | AAPL | Stock | 15.9046 | 15.9079 | 15.8929 | 15.8957 | 120708.0 |
| 2013-02-05 09:25:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8579 | 15.8625 | 475944.0 |
| 2013-02-05 09:30:00 | AAPL | Stock | 15.8625 | 15.9464 | 15.7936 | 15.9304 | 23444316.0 |
| 2013-02-05 09:35:00 | AAPL | Stock | 15.9321 | 15.9325 | 15.8679 | 15.9244 | 10724364.0 |
| 2013-02-05 09:40:00 | AAPL | Stock | 15.9286 | 15.9721 | 15.8946 | 15.9425 | 10906728.0 |
| 2013-02-05 09:45:00 | AAPL | Stock | 15.9382 | 15.9464 | 15.8929 | 15.9254 | 6130432.0 |
| 2013-02-05 09:50:00 | AAPL | Stock | 15.9254 | 15.9407 | 15.8468 | 15.8968 | 10478328.0 |
| 2013-02-05 09:55:00 | AAPL | Stock | 15.8982 | 15.9086 | 15.84 | 15.8546 | 6990704.0 |
| 2013-02-05 10:00:00 | AAPL | Stock | 15.8539 | 15.8661 | 15.8086 | 15.82 | 9188676.0 |
| 2013-02-05 10:05:00 | AAPL | Stock | 15.8207 | 15.8675 | 15.815 | 15.8532 | 5310088.0 |
> showing 50 of 328,708 rows — these rows as CSV