PREVIEW / stock_1min / 2006-09-19
file: by_date/stock_1min/2006/2006-09-19.parquet size: 8.6 MB rows: 704,338 symbols: 1,934
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-19 07:02:00 | AAPL | Stock | 2.6261 | 2.6261 | 2.625 | 2.625 | 11200.0 |
| 2006-09-19 07:55:00 | AAPL | Stock | 2.6282 | 2.6282 | 2.6282 | 2.6282 | 2800.0 |
| 2006-09-19 08:00:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6393 | 2.6393 | 5600.0 |
| 2006-09-19 08:01:00 | AAPL | Stock | 2.6254 | 2.6254 | 2.6254 | 2.6254 | 5600.0 |
| 2006-09-19 08:06:00 | AAPL | Stock | 2.6289 | 2.6289 | 2.6289 | 2.6289 | 2800.0 |
| 2006-09-19 08:07:00 | AAPL | Stock | 2.6289 | 2.6289 | 2.6286 | 2.6289 | 42000.0 |
| 2006-09-19 08:13:00 | AAPL | Stock | 2.6304 | 2.6321 | 2.6304 | 2.6321 | 5600.0 |
| 2006-09-19 08:14:00 | AAPL | Stock | 2.6289 | 2.6289 | 2.6286 | 2.6286 | 25200.0 |
| 2006-09-19 08:15:00 | AAPL | Stock | 2.6314 | 2.6314 | 2.6314 | 2.6314 | 8400.0 |
| 2006-09-19 08:18:00 | AAPL | Stock | 2.6314 | 2.6314 | 2.6314 | 2.6314 | 5600.0 |
| 2006-09-19 08:19:00 | AAPL | Stock | 2.6321 | 2.6325 | 2.6321 | 2.6325 | 19600.0 |
| 2006-09-19 08:21:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 8400.0 |
| 2006-09-19 08:24:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 14000.0 |
| 2006-09-19 08:27:00 | AAPL | Stock | 2.6339 | 2.6375 | 2.6339 | 2.6375 | 19600.0 |
| 2006-09-19 08:28:00 | AAPL | Stock | 2.6357 | 2.6364 | 2.6357 | 2.6364 | 11200.0 |
| 2006-09-19 08:29:00 | AAPL | Stock | 2.6375 | 2.6393 | 2.6375 | 2.6393 | 5600.0 |
| 2006-09-19 08:30:00 | AAPL | Stock | 2.6411 | 2.6464 | 2.6411 | 2.6429 | 141708.0 |
| 2006-09-19 08:31:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6429 | 2.6429 | 23800.0 |
| 2006-09-19 08:32:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6393 | 2.6393 | 84000.0 |
| 2006-09-19 08:33:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6418 | 2.6429 | 44800.0 |
| 2006-09-19 08:34:00 | AAPL | Stock | 2.6429 | 2.6457 | 2.6411 | 2.6457 | 78400.0 |
| 2006-09-19 08:35:00 | AAPL | Stock | 2.6457 | 2.6457 | 2.6429 | 2.6446 | 18200.0 |
| 2006-09-19 08:36:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6411 | 2.6429 | 16800.0 |
| 2006-09-19 08:38:00 | AAPL | Stock | 2.6414 | 2.6414 | 2.6411 | 2.6411 | 64652.0 |
| 2006-09-19 08:39:00 | AAPL | Stock | 2.64 | 2.64 | 2.6396 | 2.6396 | 31668.0 |
| 2006-09-19 08:44:00 | AAPL | Stock | 2.6396 | 2.6396 | 2.6375 | 2.6375 | 90720.0 |
| 2006-09-19 08:45:00 | AAPL | Stock | 2.6368 | 2.6375 | 2.635 | 2.635 | 100800.0 |
| 2006-09-19 08:46:00 | AAPL | Stock | 2.6371 | 2.6375 | 2.6371 | 2.6375 | 30800.0 |
| 2006-09-19 08:47:00 | AAPL | Stock | 2.6375 | 2.6375 | 2.6339 | 2.6339 | 96628.0 |
| 2006-09-19 08:48:00 | AAPL | Stock | 2.635 | 2.6357 | 2.635 | 2.6357 | 5600.0 |
| 2006-09-19 08:49:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 45892.0 |
| 2006-09-19 08:50:00 | AAPL | Stock | 2.6339 | 2.6357 | 2.6339 | 2.6357 | 57372.0 |
| 2006-09-19 08:51:00 | AAPL | Stock | 2.6414 | 2.6414 | 2.6414 | 2.6414 | 25200.0 |
| 2006-09-19 08:55:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6393 | 2.6393 | 28000.0 |
| 2006-09-19 09:00:00 | AAPL | Stock | 2.6418 | 2.6418 | 2.6418 | 2.6418 | 2800.0 |
| 2006-09-19 09:01:00 | AAPL | Stock | 2.6421 | 2.6429 | 2.6421 | 2.6429 | 37772.0 |
| 2006-09-19 09:02:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6421 | 2.6421 | 19600.0 |
| 2006-09-19 09:03:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6429 | 2.6429 | 22428.0 |
| 2006-09-19 09:04:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6429 | 2.6429 | 61600.0 |
| 2006-09-19 09:05:00 | AAPL | Stock | 2.6432 | 2.65 | 2.6432 | 2.65 | 145600.0 |
| 2006-09-19 09:06:00 | AAPL | Stock | 2.65 | 2.65 | 2.6439 | 2.6439 | 36400.0 |
| 2006-09-19 09:07:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6464 | 2.6464 | 2800.0 |
| 2006-09-19 09:08:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6464 | 2.6464 | 2800.0 |
| 2006-09-19 09:10:00 | AAPL | Stock | 2.6457 | 2.6457 | 2.6446 | 2.6454 | 43400.0 |
| 2006-09-19 09:12:00 | AAPL | Stock | 2.6457 | 2.6464 | 2.6457 | 2.6464 | 100520.0 |
| 2006-09-19 09:13:00 | AAPL | Stock | 2.6464 | 2.6471 | 2.6464 | 2.6468 | 42000.0 |
| 2006-09-19 09:14:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6464 | 2.6464 | 14000.0 |
| 2006-09-19 09:16:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6457 | 2.6457 | 15400.0 |
| 2006-09-19 09:17:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6443 | 2.6443 | 23100.0 |
| 2006-09-19 09:18:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6443 | 2.6443 | 13300.0 |
> showing 50 of 704,338 rows — these rows as CSV