PREVIEW / stock_1min / 2007-10-11
file: by_date/stock_1min/2007/2007-10-11.parquet size: 12.3 MB rows: 979,606 symbols: 2,574
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-11 06:24:00 | AAPL | Stock | 6.0007 | 6.0007 | 6.0007 | 6.0007 | 22400.0 |
| 2007-10-11 06:34:00 | AAPL | Stock | 6.0021 | 6.0021 | 6.0021 | 6.0021 | 2800.0 |
| 2007-10-11 07:00:00 | AAPL | Stock | 6.0282 | 6.0368 | 6.0282 | 6.0368 | 5600.0 |
| 2007-10-11 07:01:00 | AAPL | Stock | 6.0368 | 6.0536 | 6.0368 | 6.0525 | 75600.0 |
| 2007-10-11 07:02:00 | AAPL | Stock | 6.0525 | 6.0536 | 6.0521 | 6.0521 | 56000.0 |
| 2007-10-11 07:03:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 8400.0 |
| 2007-10-11 07:05:00 | AAPL | Stock | 6.05 | 6.0639 | 6.05 | 6.055 | 46256.0 |
| 2007-10-11 07:06:00 | AAPL | Stock | 6.0657 | 6.0714 | 6.0657 | 6.0714 | 44800.0 |
| 2007-10-11 07:07:00 | AAPL | Stock | 6.0721 | 6.0721 | 6.0714 | 6.0714 | 5600.0 |
| 2007-10-11 07:08:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0682 | 6.0682 | 22400.0 |
| 2007-10-11 07:10:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0714 | 6.0714 | 7000.0 |
| 2007-10-11 07:12:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0714 | 6.0714 | 28000.0 |
| 2007-10-11 07:13:00 | AAPL | Stock | 6.0679 | 6.0679 | 6.0632 | 6.0632 | 33600.0 |
| 2007-10-11 07:22:00 | AAPL | Stock | 6.0543 | 6.0543 | 6.0536 | 6.0536 | 28000.0 |
| 2007-10-11 07:24:00 | AAPL | Stock | 6.0539 | 6.0539 | 6.0539 | 6.0539 | 28000.0 |
| 2007-10-11 07:32:00 | AAPL | Stock | 6.0625 | 6.0625 | 6.0621 | 6.0621 | 8400.0 |
| 2007-10-11 07:33:00 | AAPL | Stock | 6.0625 | 6.0625 | 6.0625 | 6.0625 | 5600.0 |
| 2007-10-11 07:35:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0446 | 6.0446 | 13300.0 |
| 2007-10-11 07:39:00 | AAPL | Stock | 6.0393 | 6.0393 | 6.0393 | 6.0393 | 5600.0 |
| 2007-10-11 07:42:00 | AAPL | Stock | 6.0425 | 6.0446 | 6.0425 | 6.0446 | 145600.0 |
| 2007-10-11 07:43:00 | AAPL | Stock | 6.0425 | 6.0425 | 6.0425 | 6.0425 | 56000.0 |
| 2007-10-11 07:44:00 | AAPL | Stock | 6.0421 | 6.0425 | 6.0411 | 6.0411 | 47600.0 |
| 2007-10-11 07:45:00 | AAPL | Stock | 6.0396 | 6.0396 | 6.0396 | 6.0396 | 14000.0 |
| 2007-10-11 07:47:00 | AAPL | Stock | 6.0411 | 6.0411 | 6.0411 | 6.0411 | 22400.0 |
| 2007-10-11 07:48:00 | AAPL | Stock | 6.0411 | 6.0421 | 6.0411 | 6.0421 | 72800.0 |
| 2007-10-11 07:49:00 | AAPL | Stock | 6.0418 | 6.0418 | 6.0418 | 6.0418 | 36400.0 |
| 2007-10-11 07:50:00 | AAPL | Stock | 6.0361 | 6.0361 | 6.0361 | 6.0361 | 2800.0 |
| 2007-10-11 07:51:00 | AAPL | Stock | 6.0357 | 6.0418 | 6.0357 | 6.0418 | 99120.0 |
| 2007-10-11 07:52:00 | AAPL | Stock | 6.0418 | 6.0418 | 6.0418 | 6.0418 | 70000.0 |
| 2007-10-11 07:53:00 | AAPL | Stock | 6.0414 | 6.0414 | 6.0357 | 6.0357 | 128800.0 |
| 2007-10-11 07:54:00 | AAPL | Stock | 6.0368 | 6.0407 | 6.0368 | 6.0375 | 156800.0 |
| 2007-10-11 07:55:00 | AAPL | Stock | 6.0361 | 6.0361 | 6.0357 | 6.0357 | 33600.0 |
| 2007-10-11 07:56:00 | AAPL | Stock | 6.0393 | 6.0393 | 6.0357 | 6.0357 | 42000.0 |
| 2007-10-11 07:58:00 | AAPL | Stock | 6.0357 | 6.0375 | 6.0329 | 6.0375 | 44800.0 |
| 2007-10-11 07:59:00 | AAPL | Stock | 6.0361 | 6.0361 | 6.0357 | 6.0357 | 61600.0 |
| 2007-10-11 08:00:00 | AAPL | Stock | 6.0357 | 6.0386 | 6.0257 | 6.0357 | 642152.0 |
| 2007-10-11 08:01:00 | AAPL | Stock | 6.0364 | 6.0375 | 6.0357 | 6.0364 | 273364.0 |
| 2007-10-11 08:02:00 | AAPL | Stock | 6.0364 | 6.0375 | 6.0357 | 6.0357 | 285656.0 |
| 2007-10-11 08:03:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0321 | 6.035 | 208628.0 |
| 2007-10-11 08:04:00 | AAPL | Stock | 6.0354 | 6.0411 | 6.0354 | 6.0411 | 207704.0 |
| 2007-10-11 08:05:00 | AAPL | Stock | 6.0379 | 6.0411 | 6.0379 | 6.0393 | 109900.0 |
| 2007-10-11 08:06:00 | AAPL | Stock | 6.0375 | 6.0411 | 6.0354 | 6.0389 | 347900.0 |
| 2007-10-11 08:07:00 | AAPL | Stock | 6.0375 | 6.0375 | 6.0375 | 6.0375 | 8400.0 |
| 2007-10-11 08:08:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 88900.0 |
| 2007-10-11 08:09:00 | AAPL | Stock | 6.0357 | 6.0446 | 6.0357 | 6.0396 | 281344.0 |
| 2007-10-11 08:10:00 | AAPL | Stock | 6.0386 | 6.0418 | 6.0382 | 6.0393 | 92372.0 |
| 2007-10-11 08:11:00 | AAPL | Stock | 6.0411 | 6.0443 | 6.0393 | 6.0443 | 144200.0 |
| 2007-10-11 08:12:00 | AAPL | Stock | 6.0443 | 6.0482 | 6.04 | 6.0446 | 352800.0 |
| 2007-10-11 08:13:00 | AAPL | Stock | 6.0475 | 6.0475 | 6.0436 | 6.0446 | 235200.0 |
| 2007-10-11 08:14:00 | AAPL | Stock | 6.0464 | 6.0468 | 6.0411 | 6.0464 | 277620.0 |
> showing 50 of 979,606 rows — these rows as CSV