PREVIEW / stock_1min / 2012-06-25
file: by_date/stock_1min/2012/2012-06-25.parquet size: 12.7 MB rows: 962,709 symbols: 2,844
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-06-25 04:00:00 | AAPL | Stock | 20.7893 | 20.7893 | 20.6607 | 20.6607 | 27580.0 |
| 2012-06-25 04:39:00 | AAPL | Stock | 20.6964 | 20.6964 | 20.6964 | 20.6964 | 2800.0 |
| 2012-06-25 05:18:00 | AAPL | Stock | 20.6611 | 20.6611 | 20.6611 | 20.6611 | 5600.0 |
| 2012-06-25 05:48:00 | AAPL | Stock | 20.6611 | 20.6611 | 20.6611 | 20.6611 | 7840.0 |
| 2012-06-25 07:00:00 | AAPL | Stock | 20.6729 | 20.6729 | 20.6729 | 20.6729 | 2800.0 |
| 2012-06-25 07:01:00 | AAPL | Stock | 20.6764 | 20.6764 | 20.6764 | 20.6764 | 2800.0 |
| 2012-06-25 07:05:00 | AAPL | Stock | 20.6786 | 20.6786 | 20.6786 | 20.6786 | 2800.0 |
| 2012-06-25 07:06:00 | AAPL | Stock | 20.6696 | 20.6696 | 20.6696 | 20.6696 | 8400.0 |
| 2012-06-25 07:16:00 | AAPL | Stock | 20.6696 | 20.6696 | 20.6696 | 20.6696 | 2800.0 |
| 2012-06-25 07:17:00 | AAPL | Stock | 20.6518 | 20.6539 | 20.6518 | 20.6539 | 8400.0 |
| 2012-06-25 07:24:00 | AAPL | Stock | 20.6607 | 20.6607 | 20.6607 | 20.6607 | 2800.0 |
| 2012-06-25 07:28:00 | AAPL | Stock | 20.6625 | 20.6625 | 20.6625 | 20.6625 | 2800.0 |
| 2012-06-25 07:29:00 | AAPL | Stock | 20.6607 | 20.6607 | 20.6607 | 20.6607 | 12600.0 |
| 2012-06-25 07:32:00 | AAPL | Stock | 20.6536 | 20.6536 | 20.6536 | 20.6536 | 2800.0 |
| 2012-06-25 07:36:00 | AAPL | Stock | 20.66 | 20.66 | 20.66 | 20.66 | 2800.0 |
| 2012-06-25 07:40:00 | AAPL | Stock | 20.6575 | 20.6579 | 20.6575 | 20.6579 | 5600.0 |
| 2012-06-25 07:53:00 | AAPL | Stock | 20.6686 | 20.6696 | 20.6686 | 20.6696 | 16800.0 |
| 2012-06-25 07:55:00 | AAPL | Stock | 20.6786 | 20.6786 | 20.6786 | 20.6786 | 2800.0 |
| 2012-06-25 07:56:00 | AAPL | Stock | 20.6754 | 20.6754 | 20.6754 | 20.6754 | 5600.0 |
| 2012-06-25 07:57:00 | AAPL | Stock | 20.6746 | 20.6768 | 20.6743 | 20.6768 | 11200.0 |
| 2012-06-25 08:00:00 | AAPL | Stock | 20.6764 | 20.6764 | 20.6568 | 20.6604 | 194740.0 |
| 2012-06-25 08:01:00 | AAPL | Stock | 20.6607 | 20.6607 | 20.6536 | 20.6536 | 14000.0 |
| 2012-06-25 08:02:00 | AAPL | Stock | 20.6579 | 20.6579 | 20.6579 | 20.6579 | 2800.0 |
| 2012-06-25 08:03:00 | AAPL | Stock | 20.6571 | 20.6571 | 20.6571 | 20.6571 | 2800.0 |
| 2012-06-25 08:04:00 | AAPL | Stock | 20.6621 | 20.6621 | 20.6507 | 20.6507 | 38920.0 |
| 2012-06-25 08:05:00 | AAPL | Stock | 20.6475 | 20.6475 | 20.6339 | 20.6361 | 131768.0 |
| 2012-06-25 08:06:00 | AAPL | Stock | 20.6393 | 20.6418 | 20.6286 | 20.6286 | 24976.0 |
| 2012-06-25 08:07:00 | AAPL | Stock | 20.6264 | 20.6332 | 20.6257 | 20.6332 | 14000.0 |
| 2012-06-25 08:08:00 | AAPL | Stock | 20.6268 | 20.6268 | 20.6171 | 20.6186 | 51380.0 |
| 2012-06-25 08:09:00 | AAPL | Stock | 20.625 | 20.6257 | 20.625 | 20.6257 | 11200.0 |
| 2012-06-25 08:10:00 | AAPL | Stock | 20.6321 | 20.6321 | 20.6268 | 20.6268 | 5600.0 |
| 2012-06-25 08:11:00 | AAPL | Stock | 20.6339 | 20.6468 | 20.6339 | 20.6421 | 39200.0 |
| 2012-06-25 08:12:00 | AAPL | Stock | 20.6357 | 20.6357 | 20.6254 | 20.6343 | 14000.0 |
| 2012-06-25 08:13:00 | AAPL | Stock | 20.6254 | 20.6254 | 20.6246 | 20.6246 | 25200.0 |
| 2012-06-25 08:14:00 | AAPL | Stock | 20.6218 | 20.6218 | 20.6211 | 20.6218 | 21000.0 |
| 2012-06-25 08:16:00 | AAPL | Stock | 20.6343 | 20.6343 | 20.6343 | 20.6343 | 2800.0 |
| 2012-06-25 08:17:00 | AAPL | Stock | 20.6343 | 20.6343 | 20.6286 | 20.6286 | 14000.0 |
| 2012-06-25 08:18:00 | AAPL | Stock | 20.6286 | 20.6286 | 20.6182 | 20.6254 | 31360.0 |
| 2012-06-25 08:21:00 | AAPL | Stock | 20.6318 | 20.6321 | 20.6271 | 20.6321 | 19600.0 |
| 2012-06-25 08:22:00 | AAPL | Stock | 20.6314 | 20.6314 | 20.6314 | 20.6314 | 2800.0 |
| 2012-06-25 08:23:00 | AAPL | Stock | 20.6321 | 20.65 | 20.6321 | 20.65 | 33600.0 |
| 2012-06-25 08:24:00 | AAPL | Stock | 20.6429 | 20.6429 | 20.6418 | 20.6429 | 11200.0 |
| 2012-06-25 08:25:00 | AAPL | Stock | 20.6361 | 20.6493 | 20.6357 | 20.6493 | 8400.0 |
| 2012-06-25 08:29:00 | AAPL | Stock | 20.6429 | 20.6429 | 20.6425 | 20.6425 | 33768.0 |
| 2012-06-25 08:30:00 | AAPL | Stock | 20.6429 | 20.6429 | 20.6429 | 20.6429 | 2800.0 |
| 2012-06-25 08:32:00 | AAPL | Stock | 20.6514 | 20.6514 | 20.6514 | 20.6514 | 3500.0 |
| 2012-06-25 08:33:00 | AAPL | Stock | 20.6436 | 20.6436 | 20.6429 | 20.6429 | 12600.0 |
| 2012-06-25 08:34:00 | AAPL | Stock | 20.6393 | 20.6393 | 20.6393 | 20.6393 | 2800.0 |
| 2012-06-25 08:35:00 | AAPL | Stock | 20.6407 | 20.6407 | 20.6407 | 20.6407 | 2800.0 |
| 2012-06-25 08:36:00 | AAPL | Stock | 20.6414 | 20.6429 | 20.6414 | 20.6429 | 8400.0 |
> showing 50 of 962,709 rows — these rows as CSV