PREVIEW / stock_1min / 2012-08-14
file: by_date/stock_1min/2012/2012-08-14.parquet size: 12.1 MB rows: 903,668 symbols: 2,817
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-14 04:00:00 | AAPL | Stock | 22.6225 | 22.6225 | 22.6107 | 22.6107 | 9800.0 |
| 2012-08-14 04:06:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5893 | 22.5893 | 2800.0 |
| 2012-08-14 04:13:00 | AAPL | Stock | 22.5932 | 22.5932 | 22.5929 | 22.5929 | 5600.0 |
| 2012-08-14 04:22:00 | AAPL | Stock | 22.6211 | 22.6211 | 22.6211 | 22.6211 | 5180.0 |
| 2012-08-14 04:26:00 | AAPL | Stock | 22.6375 | 22.6375 | 22.6375 | 22.6375 | 4200.0 |
| 2012-08-14 04:27:00 | AAPL | Stock | 22.6375 | 22.6375 | 22.6375 | 22.6375 | 2800.0 |
| 2012-08-14 04:32:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 2800.0 |
| 2012-08-14 04:40:00 | AAPL | Stock | 22.625 | 22.625 | 22.625 | 22.625 | 2800.0 |
| 2012-08-14 04:45:00 | AAPL | Stock | 22.6079 | 22.6079 | 22.6079 | 22.6079 | 2800.0 |
| 2012-08-14 04:52:00 | AAPL | Stock | 22.6521 | 22.6521 | 22.6521 | 22.6521 | 2800.0 |
| 2012-08-14 04:56:00 | AAPL | Stock | 22.6464 | 22.6464 | 22.6464 | 22.6464 | 8400.0 |
| 2012-08-14 04:58:00 | AAPL | Stock | 22.6521 | 22.6521 | 22.6521 | 22.6521 | 2800.0 |
| 2012-08-14 04:59:00 | AAPL | Stock | 22.6464 | 22.6464 | 22.6464 | 22.6464 | 2800.0 |
| 2012-08-14 05:03:00 | AAPL | Stock | 22.6093 | 22.6093 | 22.6089 | 22.6089 | 5600.0 |
| 2012-08-14 05:05:00 | AAPL | Stock | 22.6482 | 22.6482 | 22.6482 | 22.6482 | 5600.0 |
| 2012-08-14 05:13:00 | AAPL | Stock | 22.6429 | 22.6429 | 22.6429 | 22.6429 | 8400.0 |
| 2012-08-14 05:31:00 | AAPL | Stock | 22.6429 | 22.6429 | 22.6429 | 22.6429 | 2800.0 |
| 2012-08-14 05:34:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6357 | 22.6357 | 19600.0 |
| 2012-08-14 05:38:00 | AAPL | Stock | 22.6339 | 22.6339 | 22.6339 | 22.6339 | 2800.0 |
| 2012-08-14 05:46:00 | AAPL | Stock | 22.6339 | 22.6339 | 22.6339 | 22.6339 | 2800.0 |
| 2012-08-14 05:53:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 5600.0 |
| 2012-08-14 05:54:00 | AAPL | Stock | 22.61 | 22.6357 | 22.61 | 22.6357 | 16660.0 |
| 2012-08-14 05:55:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6357 | 22.6357 | 14000.0 |
| 2012-08-14 05:56:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6357 | 22.6357 | 2800.0 |
| 2012-08-14 05:57:00 | AAPL | Stock | 22.6354 | 22.6354 | 22.6354 | 22.6354 | 2800.0 |
| 2012-08-14 06:02:00 | AAPL | Stock | 22.6261 | 22.6261 | 22.6261 | 22.6261 | 2800.0 |
| 2012-08-14 06:08:00 | AAPL | Stock | 22.6354 | 22.6354 | 22.6354 | 22.6354 | 2800.0 |
| 2012-08-14 06:09:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6357 | 22.6357 | 8400.0 |
| 2012-08-14 06:14:00 | AAPL | Stock | 22.6493 | 22.6496 | 22.6493 | 22.6496 | 5600.0 |
| 2012-08-14 06:25:00 | AAPL | Stock | 22.6361 | 22.6361 | 22.6357 | 22.6357 | 20440.0 |
| 2012-08-14 06:37:00 | AAPL | Stock | 22.6493 | 22.6493 | 22.6493 | 22.6493 | 2800.0 |
| 2012-08-14 06:51:00 | AAPL | Stock | 22.6496 | 22.6496 | 22.6496 | 22.6496 | 2800.0 |
| 2012-08-14 06:57:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6339 | 22.6339 | 30800.0 |
| 2012-08-14 07:00:00 | AAPL | Stock | 22.6389 | 22.6425 | 22.6389 | 22.6425 | 34132.0 |
| 2012-08-14 07:01:00 | AAPL | Stock | 22.6393 | 22.6393 | 22.6339 | 22.6389 | 28168.0 |
| 2012-08-14 07:03:00 | AAPL | Stock | 22.6293 | 22.635 | 22.62 | 22.6346 | 25200.0 |
| 2012-08-14 07:04:00 | AAPL | Stock | 22.6261 | 22.6261 | 22.6261 | 22.6261 | 2800.0 |
| 2012-08-14 07:05:00 | AAPL | Stock | 22.6182 | 22.6182 | 22.6182 | 22.6182 | 2800.0 |
| 2012-08-14 07:06:00 | AAPL | Stock | 22.6182 | 22.6239 | 22.6161 | 22.6161 | 8400.0 |
| 2012-08-14 07:07:00 | AAPL | Stock | 22.6161 | 22.6161 | 22.6161 | 22.6161 | 16800.0 |
| 2012-08-14 07:08:00 | AAPL | Stock | 22.6143 | 22.6143 | 22.6143 | 22.6143 | 4172.0 |
| 2012-08-14 07:10:00 | AAPL | Stock | 22.6121 | 22.6121 | 22.6036 | 22.6036 | 15820.0 |
| 2012-08-14 07:11:00 | AAPL | Stock | 22.6036 | 22.6246 | 22.6036 | 22.6246 | 26320.0 |
| 2012-08-14 07:13:00 | AAPL | Stock | 22.6139 | 22.6139 | 22.6139 | 22.6139 | 2800.0 |
| 2012-08-14 07:16:00 | AAPL | Stock | 22.6107 | 22.6143 | 22.6107 | 22.6143 | 5600.0 |
| 2012-08-14 07:18:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 13272.0 |
| 2012-08-14 07:26:00 | AAPL | Stock | 22.5982 | 22.5989 | 22.5982 | 22.5982 | 8400.0 |
| 2012-08-14 07:31:00 | AAPL | Stock | 22.605 | 22.6064 | 22.605 | 22.6064 | 11228.0 |
| 2012-08-14 07:32:00 | AAPL | Stock | 22.5968 | 22.6064 | 22.5968 | 22.6064 | 8400.0 |
| 2012-08-14 07:36:00 | AAPL | Stock | 22.6036 | 22.6143 | 22.6036 | 22.6096 | 56672.0 |
> showing 50 of 903,668 rows — these rows as CSV