PREVIEW / stock_1min / 2013-09-17
file: by_date/stock_1min/2013/2013-09-17.parquet size: 13.4 MB rows: 983,504 symbols: 2,867
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-09-17 04:00:00 | AAPL | Stock | 15.8857 | 15.9739 | 15.8714 | 15.8714 | 39200.0 |
| 2013-09-17 04:01:00 | AAPL | Stock | 15.8821 | 15.8821 | 15.8821 | 15.8821 | 13020.0 |
| 2013-09-17 04:06:00 | AAPL | Stock | 15.9221 | 15.9346 | 15.9221 | 15.9346 | 27944.0 |
| 2013-09-17 04:08:00 | AAPL | Stock | 15.9071 | 15.9071 | 15.9071 | 15.9071 | 2800.0 |
| 2013-09-17 04:09:00 | AAPL | Stock | 15.9054 | 15.9336 | 15.9054 | 15.9336 | 21448.0 |
| 2013-09-17 04:13:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.9286 | 15.9286 | 8400.0 |
| 2013-09-17 04:23:00 | AAPL | Stock | 15.9461 | 15.9461 | 15.9461 | 15.9461 | 11200.0 |
| 2013-09-17 04:45:00 | AAPL | Stock | 15.9443 | 15.9443 | 15.9443 | 15.9443 | 2800.0 |
| 2013-09-17 04:48:00 | AAPL | Stock | 15.9339 | 15.9339 | 15.9329 | 15.9329 | 10920.0 |
| 2013-09-17 04:54:00 | AAPL | Stock | 15.9529 | 15.9529 | 15.9529 | 15.9529 | 5600.0 |
| 2013-09-17 04:56:00 | AAPL | Stock | 15.9543 | 15.9543 | 15.9543 | 15.9543 | 2800.0 |
| 2013-09-17 04:59:00 | AAPL | Stock | 15.9679 | 15.9679 | 15.9679 | 15.9679 | 2800.0 |
| 2013-09-17 05:00:00 | AAPL | Stock | 15.9679 | 15.97 | 15.9679 | 15.97 | 5600.0 |
| 2013-09-17 05:01:00 | AAPL | Stock | 15.9564 | 15.9564 | 15.9564 | 15.9564 | 2800.0 |
| 2013-09-17 05:06:00 | AAPL | Stock | 15.9818 | 15.9818 | 15.9818 | 15.9818 | 2800.0 |
| 2013-09-17 05:07:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 2800.0 |
| 2013-09-17 05:10:00 | AAPL | Stock | 15.9718 | 15.9718 | 15.9643 | 15.9643 | 15680.0 |
| 2013-09-17 05:25:00 | AAPL | Stock | 15.9582 | 15.9589 | 15.9582 | 15.9589 | 5600.0 |
| 2013-09-17 05:27:00 | AAPL | Stock | 15.9589 | 15.9589 | 15.9589 | 15.9589 | 2800.0 |
| 2013-09-17 05:40:00 | AAPL | Stock | 15.95 | 15.95 | 15.95 | 15.95 | 2800.0 |
| 2013-09-17 05:55:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.9429 | 15.9429 | 2800.0 |
| 2013-09-17 05:58:00 | AAPL | Stock | 15.9432 | 15.9432 | 15.9432 | 15.9432 | 2800.0 |
| 2013-09-17 06:01:00 | AAPL | Stock | 15.9375 | 15.9375 | 15.9375 | 15.9375 | 2800.0 |
| 2013-09-17 06:20:00 | AAPL | Stock | 15.9368 | 15.9368 | 15.9368 | 15.9368 | 5600.0 |
| 2013-09-17 06:22:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.9429 | 15.9429 | 2800.0 |
| 2013-09-17 06:39:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9282 | 15.9282 | 5600.0 |
| 2013-09-17 06:52:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9214 | 15.9214 | 2800.0 |
| 2013-09-17 06:53:00 | AAPL | Stock | 15.9218 | 15.9218 | 15.9214 | 15.9214 | 5600.0 |
| 2013-09-17 06:55:00 | AAPL | Stock | 15.9068 | 15.9143 | 15.9068 | 15.9143 | 10640.0 |
| 2013-09-17 07:02:00 | AAPL | Stock | 15.9089 | 15.9089 | 15.9089 | 15.9089 | 4564.0 |
| 2013-09-17 07:03:00 | AAPL | Stock | 15.9211 | 15.9289 | 15.9211 | 15.9286 | 28700.0 |
| 2013-09-17 07:04:00 | AAPL | Stock | 15.9164 | 15.9164 | 15.9164 | 15.9164 | 2800.0 |
| 2013-09-17 07:06:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 5600.0 |
| 2013-09-17 07:07:00 | AAPL | Stock | 15.9221 | 15.9221 | 15.9221 | 15.9221 | 2800.0 |
| 2013-09-17 07:08:00 | AAPL | Stock | 15.9275 | 15.9275 | 15.9204 | 15.9204 | 10388.0 |
| 2013-09-17 07:09:00 | AAPL | Stock | 15.9232 | 15.9232 | 15.9204 | 15.9204 | 16380.0 |
| 2013-09-17 07:10:00 | AAPL | Stock | 15.9232 | 15.9286 | 15.9232 | 15.9286 | 70000.0 |
| 2013-09-17 07:11:00 | AAPL | Stock | 15.9375 | 15.9429 | 15.9293 | 15.9429 | 33600.0 |
| 2013-09-17 07:12:00 | AAPL | Stock | 15.9468 | 15.9468 | 15.9468 | 15.9468 | 5600.0 |
| 2013-09-17 07:13:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9461 | 15.9461 | 11200.0 |
| 2013-09-17 07:14:00 | AAPL | Stock | 15.9339 | 15.9339 | 15.9339 | 15.9339 | 9996.0 |
| 2013-09-17 07:15:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9393 | 15.9393 | 5600.0 |
| 2013-09-17 07:16:00 | AAPL | Stock | 15.9389 | 15.9393 | 15.9389 | 15.9393 | 8400.0 |
| 2013-09-17 07:17:00 | AAPL | Stock | 15.9332 | 15.9332 | 15.9332 | 15.9332 | 2800.0 |
| 2013-09-17 07:22:00 | AAPL | Stock | 15.9368 | 15.9375 | 15.9368 | 15.9375 | 14000.0 |
| 2013-09-17 07:23:00 | AAPL | Stock | 15.9439 | 15.9439 | 15.9439 | 15.9439 | 5600.0 |
| 2013-09-17 07:24:00 | AAPL | Stock | 15.94 | 15.9443 | 15.94 | 15.9414 | 21000.0 |
| 2013-09-17 07:25:00 | AAPL | Stock | 15.9529 | 15.9554 | 15.9529 | 15.9554 | 21000.0 |
| 2013-09-17 07:27:00 | AAPL | Stock | 15.9636 | 15.9639 | 15.9636 | 15.9639 | 5600.0 |
| 2013-09-17 07:28:00 | AAPL | Stock | 15.9646 | 15.9646 | 15.9643 | 15.9643 | 8400.0 |
> showing 50 of 983,504 rows — these rows as CSV