PREVIEW / stock_1min / 2007-10-29
file: by_date/stock_1min/2007/2007-10-29.parquet size: 12.0 MB rows: 972,325 symbols: 2,590
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-29 06:37:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5908.0 |
| 2007-10-29 06:50:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2007-10-29 07:01:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 2800.0 |
| 2007-10-29 07:04:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 5600.0 |
| 2007-10-29 07:05:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 2800.0 |
| 2007-10-29 07:06:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 2800.0 |
| 2007-10-29 07:08:00 | AAPL | Stock | 6.6561 | 6.6561 | 6.6561 | 6.6561 | 19600.0 |
| 2007-10-29 07:10:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 9184.0 |
| 2007-10-29 07:11:00 | AAPL | Stock | 6.66 | 6.6607 | 6.66 | 6.6607 | 28000.0 |
| 2007-10-29 07:16:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 14000.0 |
| 2007-10-29 07:19:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 28000.0 |
| 2007-10-29 07:21:00 | AAPL | Stock | 6.6511 | 6.6511 | 6.65 | 6.65 | 11200.0 |
| 2007-10-29 07:25:00 | AAPL | Stock | 6.6511 | 6.6511 | 6.6511 | 6.6511 | 8400.0 |
| 2007-10-29 07:29:00 | AAPL | Stock | 6.6425 | 6.6425 | 6.6114 | 6.6114 | 5600.0 |
| 2007-10-29 07:31:00 | AAPL | Stock | 6.6496 | 6.6496 | 6.6496 | 6.6496 | 3640.0 |
| 2007-10-29 07:32:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 5600.0 |
| 2007-10-29 07:33:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2007-10-29 07:37:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2007-10-29 07:46:00 | AAPL | Stock | 6.6493 | 6.6493 | 6.6493 | 6.6493 | 5600.0 |
| 2007-10-29 07:47:00 | AAPL | Stock | 6.6493 | 6.65 | 6.6493 | 6.65 | 19600.0 |
| 2007-10-29 07:48:00 | AAPL | Stock | 6.6504 | 6.6504 | 6.6504 | 6.6504 | 2800.0 |
| 2007-10-29 07:49:00 | AAPL | Stock | 6.6504 | 6.6504 | 6.6493 | 6.6493 | 18480.0 |
| 2007-10-29 07:52:00 | AAPL | Stock | 6.6436 | 6.6436 | 6.6436 | 6.6436 | 2800.0 |
| 2007-10-29 07:53:00 | AAPL | Stock | 6.6493 | 6.6518 | 6.6493 | 6.6493 | 53956.0 |
| 2007-10-29 07:54:00 | AAPL | Stock | 6.6486 | 6.6493 | 6.6486 | 6.6493 | 14000.0 |
| 2007-10-29 07:57:00 | AAPL | Stock | 6.6436 | 6.6436 | 6.6429 | 6.6429 | 14000.0 |
| 2007-10-29 07:59:00 | AAPL | Stock | 6.6429 | 6.6554 | 6.6429 | 6.6554 | 130340.0 |
| 2007-10-29 08:00:00 | AAPL | Stock | 6.6475 | 6.6518 | 6.6357 | 6.6421 | 144396.0 |
| 2007-10-29 08:01:00 | AAPL | Stock | 6.6375 | 6.6439 | 6.6357 | 6.6429 | 290108.0 |
| 2007-10-29 08:02:00 | AAPL | Stock | 6.6439 | 6.6446 | 6.6421 | 6.6421 | 89600.0 |
| 2007-10-29 08:03:00 | AAPL | Stock | 6.6382 | 6.6393 | 6.6343 | 6.6393 | 28532.0 |
| 2007-10-29 08:04:00 | AAPL | Stock | 6.635 | 6.6393 | 6.6321 | 6.6393 | 120092.0 |
| 2007-10-29 08:05:00 | AAPL | Stock | 6.6393 | 6.6411 | 6.6321 | 6.6343 | 111160.0 |
| 2007-10-29 08:06:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6321 | 6.6321 | 15400.0 |
| 2007-10-29 08:07:00 | AAPL | Stock | 6.6307 | 6.6307 | 6.6254 | 6.6254 | 21000.0 |
| 2007-10-29 08:08:00 | AAPL | Stock | 6.6286 | 6.6286 | 6.6254 | 6.6257 | 47600.0 |
| 2007-10-29 08:09:00 | AAPL | Stock | 6.625 | 6.625 | 6.6143 | 6.6182 | 174692.0 |
| 2007-10-29 08:10:00 | AAPL | Stock | 6.6246 | 6.6286 | 6.6196 | 6.6286 | 52668.0 |
| 2007-10-29 08:11:00 | AAPL | Stock | 6.6218 | 6.6286 | 6.6218 | 6.6286 | 90860.0 |
| 2007-10-29 08:12:00 | AAPL | Stock | 6.6286 | 6.63 | 6.6286 | 6.6286 | 20020.0 |
| 2007-10-29 08:13:00 | AAPL | Stock | 6.6286 | 6.6286 | 6.6286 | 6.6286 | 24780.0 |
| 2007-10-29 08:14:00 | AAPL | Stock | 6.625 | 6.625 | 6.625 | 6.625 | 5600.0 |
| 2007-10-29 08:15:00 | AAPL | Stock | 6.625 | 6.6286 | 6.625 | 6.6286 | 23800.0 |
| 2007-10-29 08:16:00 | AAPL | Stock | 6.6293 | 6.6321 | 6.625 | 6.6321 | 27972.0 |
| 2007-10-29 08:17:00 | AAPL | Stock | 6.6286 | 6.6286 | 6.6286 | 6.6286 | 2800.0 |
| 2007-10-29 08:18:00 | AAPL | Stock | 6.6286 | 6.6307 | 6.6286 | 6.6307 | 8400.0 |
| 2007-10-29 08:19:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6321 | 6.6321 | 7700.0 |
| 2007-10-29 08:20:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6314 | 6.6314 | 23576.0 |
| 2007-10-29 08:21:00 | AAPL | Stock | 6.625 | 6.625 | 6.6214 | 6.6218 | 87416.0 |
| 2007-10-29 08:22:00 | AAPL | Stock | 6.6214 | 6.625 | 6.6214 | 6.625 | 28000.0 |
> showing 50 of 972,325 rows — these rows as CSV