PREVIEW / stock_1min / 2013-11-25
file: by_date/stock_1min/2013/2013-11-25.parquet size: 14.0 MB rows: 1,027,831 symbols: 2,875
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-11-25 04:07:00 | AAPL | Stock | 18.6068 | 18.6068 | 18.6068 | 18.6068 | 2800.0 |
| 2013-11-25 04:16:00 | AAPL | Stock | 18.6054 | 18.6068 | 18.6054 | 18.6068 | 11200.0 |
| 2013-11-25 04:37:00 | AAPL | Stock | 18.6061 | 18.6061 | 18.6061 | 18.6061 | 2800.0 |
| 2013-11-25 05:09:00 | AAPL | Stock | 18.6218 | 18.6218 | 18.6218 | 18.6218 | 2940.0 |
| 2013-11-25 05:55:00 | AAPL | Stock | 18.6218 | 18.6218 | 18.6218 | 18.6218 | 2800.0 |
| 2013-11-25 06:14:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6036 | 18.6036 | 14000.0 |
| 2013-11-25 06:16:00 | AAPL | Stock | 18.5779 | 18.5779 | 18.5779 | 18.5779 | 8400.0 |
| 2013-11-25 06:17:00 | AAPL | Stock | 18.575 | 18.575 | 18.575 | 18.575 | 2800.0 |
| 2013-11-25 06:19:00 | AAPL | Stock | 18.5721 | 18.5721 | 18.5721 | 18.5721 | 2800.0 |
| 2013-11-25 06:51:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 14000.0 |
| 2013-11-25 06:52:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 2800.0 |
| 2013-11-25 07:02:00 | AAPL | Stock | 18.625 | 18.625 | 18.6071 | 18.6071 | 36400.0 |
| 2013-11-25 07:04:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 14000.0 |
| 2013-11-25 07:08:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 19600.0 |
| 2013-11-25 07:12:00 | AAPL | Stock | 18.63 | 18.6429 | 18.63 | 18.6429 | 8400.0 |
| 2013-11-25 07:14:00 | AAPL | Stock | 18.65 | 18.6521 | 18.65 | 18.6521 | 16800.0 |
| 2013-11-25 07:15:00 | AAPL | Stock | 18.6521 | 18.6529 | 18.6521 | 18.6529 | 5600.0 |
| 2013-11-25 07:20:00 | AAPL | Stock | 18.6375 | 18.6375 | 18.6375 | 18.6375 | 14000.0 |
| 2013-11-25 07:32:00 | AAPL | Stock | 18.6475 | 18.6493 | 18.6475 | 18.6493 | 29960.0 |
| 2013-11-25 07:40:00 | AAPL | Stock | 18.6529 | 18.6529 | 18.6514 | 18.6514 | 23800.0 |
| 2013-11-25 07:41:00 | AAPL | Stock | 18.66 | 18.6661 | 18.66 | 18.6661 | 49000.0 |
| 2013-11-25 07:42:00 | AAPL | Stock | 18.6654 | 18.6696 | 18.6654 | 18.6679 | 44800.0 |
| 2013-11-25 07:44:00 | AAPL | Stock | 18.6679 | 18.6746 | 18.6679 | 18.6746 | 39032.0 |
| 2013-11-25 07:45:00 | AAPL | Stock | 18.6736 | 18.6746 | 18.6736 | 18.6746 | 5600.0 |
| 2013-11-25 07:46:00 | AAPL | Stock | 18.6746 | 18.6782 | 18.6746 | 18.6764 | 43708.0 |
| 2013-11-25 07:47:00 | AAPL | Stock | 18.6782 | 18.6782 | 18.6746 | 18.6779 | 26236.0 |
| 2013-11-25 07:48:00 | AAPL | Stock | 18.6746 | 18.6746 | 18.6696 | 18.6696 | 23660.0 |
| 2013-11-25 07:49:00 | AAPL | Stock | 18.6575 | 18.6689 | 18.6543 | 18.6689 | 16800.0 |
| 2013-11-25 07:50:00 | AAPL | Stock | 18.6546 | 18.6546 | 18.6525 | 18.6525 | 9800.0 |
| 2013-11-25 07:53:00 | AAPL | Stock | 18.6554 | 18.6621 | 18.6554 | 18.6621 | 19600.0 |
| 2013-11-25 07:59:00 | AAPL | Stock | 18.6621 | 18.6621 | 18.6621 | 18.6621 | 2800.0 |
| 2013-11-25 08:00:00 | AAPL | Stock | 18.6568 | 18.6568 | 18.6071 | 18.6518 | 81648.0 |
| 2013-11-25 08:01:00 | AAPL | Stock | 18.6546 | 18.66 | 18.6546 | 18.6561 | 33600.0 |
| 2013-11-25 08:03:00 | AAPL | Stock | 18.6429 | 18.6571 | 18.6429 | 18.6571 | 5600.0 |
| 2013-11-25 08:04:00 | AAPL | Stock | 18.6571 | 18.6571 | 18.6571 | 18.6571 | 2800.0 |
| 2013-11-25 08:06:00 | AAPL | Stock | 18.6446 | 18.6446 | 18.6432 | 18.6432 | 5600.0 |
| 2013-11-25 08:08:00 | AAPL | Stock | 18.6436 | 18.6436 | 18.6432 | 18.6432 | 5600.0 |
| 2013-11-25 08:09:00 | AAPL | Stock | 18.6396 | 18.6396 | 18.625 | 18.625 | 25620.0 |
| 2013-11-25 08:10:00 | AAPL | Stock | 18.6386 | 18.6411 | 18.6386 | 18.6411 | 8400.0 |
| 2013-11-25 08:11:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6339 | 18.6339 | 13440.0 |
| 2013-11-25 08:14:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.625 | 18.625 | 40180.0 |
| 2013-11-25 08:15:00 | AAPL | Stock | 18.6254 | 18.6257 | 18.6229 | 18.625 | 22400.0 |
| 2013-11-25 08:18:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6214 | 18.6214 | 2800.0 |
| 2013-11-25 08:19:00 | AAPL | Stock | 18.6221 | 18.6221 | 18.6096 | 18.6143 | 44520.0 |
| 2013-11-25 08:20:00 | AAPL | Stock | 18.6132 | 18.6132 | 18.6125 | 18.6125 | 22400.0 |
| 2013-11-25 08:21:00 | AAPL | Stock | 18.6143 | 18.6171 | 18.6082 | 18.6168 | 95200.0 |
| 2013-11-25 08:23:00 | AAPL | Stock | 18.6161 | 18.6214 | 18.6161 | 18.6214 | 11200.0 |
| 2013-11-25 08:24:00 | AAPL | Stock | 18.6214 | 18.6232 | 18.6214 | 18.6232 | 61600.0 |
| 2013-11-25 08:26:00 | AAPL | Stock | 18.6314 | 18.6329 | 18.6314 | 18.6329 | 8400.0 |
| 2013-11-25 08:27:00 | AAPL | Stock | 18.6229 | 18.6229 | 18.6229 | 18.6229 | 2800.0 |
> showing 50 of 1,027,831 rows — these rows as CSV