PREVIEW / stock_1min / 2006-06-13
file: by_date/stock_1min/2006/2006-06-13.parquet size: 9.4 MB rows: 758,247 symbols: 1,880
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-06-13 06:44:00 | AAPL | Stock | 2.0196 | 2.0196 | 2.0196 | 2.0196 | 2800.0 |
| 2006-06-13 07:32:00 | AAPL | Stock | 2.0221 | 2.0221 | 2.0221 | 2.0221 | 19012.0 |
| 2006-06-13 07:55:00 | AAPL | Stock | 2.0321 | 2.0339 | 2.0321 | 2.0339 | 151816.0 |
| 2006-06-13 07:56:00 | AAPL | Stock | 2.0357 | 2.0446 | 2.0357 | 2.0446 | 148400.0 |
| 2006-06-13 07:57:00 | AAPL | Stock | 2.0375 | 2.0446 | 2.0375 | 2.0446 | 119000.0 |
| 2006-06-13 07:58:00 | AAPL | Stock | 2.0446 | 2.0446 | 2.0411 | 2.0443 | 72800.0 |
| 2006-06-13 07:59:00 | AAPL | Stock | 2.0446 | 2.0446 | 2.0446 | 2.0446 | 119392.0 |
| 2006-06-13 08:00:00 | AAPL | Stock | 2.0414 | 2.0446 | 2.0411 | 2.0411 | 58800.0 |
| 2006-06-13 08:01:00 | AAPL | Stock | 2.0414 | 2.0457 | 2.0386 | 2.0386 | 636720.0 |
| 2006-06-13 08:02:00 | AAPL | Stock | 2.0418 | 2.0418 | 2.0332 | 2.0393 | 208600.0 |
| 2006-06-13 08:03:00 | AAPL | Stock | 2.0393 | 2.0393 | 2.0371 | 2.0389 | 25144.0 |
| 2006-06-13 08:04:00 | AAPL | Stock | 2.0393 | 2.0393 | 2.0361 | 2.0393 | 63000.0 |
| 2006-06-13 08:05:00 | AAPL | Stock | 2.0361 | 2.0361 | 2.0361 | 2.0361 | 14000.0 |
| 2006-06-13 08:06:00 | AAPL | Stock | 2.0325 | 2.0357 | 2.0321 | 2.0357 | 70588.0 |
| 2006-06-13 08:07:00 | AAPL | Stock | 2.0357 | 2.0357 | 2.0336 | 2.0336 | 64568.0 |
| 2006-06-13 08:08:00 | AAPL | Stock | 2.0311 | 2.0357 | 2.0311 | 2.0357 | 158592.0 |
| 2006-06-13 08:09:00 | AAPL | Stock | 2.0357 | 2.0357 | 2.0357 | 2.0357 | 42000.0 |
| 2006-06-13 08:10:00 | AAPL | Stock | 2.0332 | 2.0339 | 2.0332 | 2.0339 | 47600.0 |
| 2006-06-13 08:11:00 | AAPL | Stock | 2.0357 | 2.0371 | 2.0357 | 2.0371 | 185248.0 |
| 2006-06-13 08:12:00 | AAPL | Stock | 2.0371 | 2.0371 | 2.0357 | 2.0357 | 140000.0 |
| 2006-06-13 08:13:00 | AAPL | Stock | 2.0368 | 2.0368 | 2.0361 | 2.0368 | 67200.0 |
| 2006-06-13 08:14:00 | AAPL | Stock | 2.0368 | 2.0389 | 2.0357 | 2.0379 | 432600.0 |
| 2006-06-13 08:15:00 | AAPL | Stock | 2.0368 | 2.0382 | 2.0368 | 2.0382 | 57400.0 |
| 2006-06-13 08:16:00 | AAPL | Stock | 2.0389 | 2.0389 | 2.0371 | 2.0371 | 144788.0 |
| 2006-06-13 08:17:00 | AAPL | Stock | 2.0379 | 2.0421 | 2.0379 | 2.0404 | 214788.0 |
| 2006-06-13 08:18:00 | AAPL | Stock | 2.0411 | 2.0418 | 2.0411 | 2.0418 | 81088.0 |
| 2006-06-13 08:19:00 | AAPL | Stock | 2.0418 | 2.0418 | 2.0411 | 2.0411 | 26488.0 |
| 2006-06-13 08:20:00 | AAPL | Stock | 2.0411 | 2.0411 | 2.0379 | 2.0379 | 18200.0 |
| 2006-06-13 08:21:00 | AAPL | Stock | 2.0414 | 2.0414 | 2.0414 | 2.0414 | 12600.0 |
| 2006-06-13 08:22:00 | AAPL | Stock | 2.0407 | 2.0407 | 2.0407 | 2.0407 | 8400.0 |
| 2006-06-13 08:23:00 | AAPL | Stock | 2.0411 | 2.0418 | 2.0411 | 2.0411 | 47600.0 |
| 2006-06-13 08:24:00 | AAPL | Stock | 2.0411 | 2.0418 | 2.0411 | 2.0418 | 81956.0 |
| 2006-06-13 08:25:00 | AAPL | Stock | 2.0418 | 2.0418 | 2.0418 | 2.0418 | 26600.0 |
| 2006-06-13 08:26:00 | AAPL | Stock | 2.0418 | 2.0418 | 2.0418 | 2.0418 | 91000.0 |
| 2006-06-13 08:27:00 | AAPL | Stock | 2.0418 | 2.0429 | 2.0418 | 2.0429 | 51800.0 |
| 2006-06-13 08:28:00 | AAPL | Stock | 2.0446 | 2.0446 | 2.0446 | 2.0446 | 25200.0 |
| 2006-06-13 08:29:00 | AAPL | Stock | 2.0446 | 2.0446 | 2.0446 | 2.0446 | 8400.0 |
| 2006-06-13 08:30:00 | AAPL | Stock | 2.0446 | 2.0475 | 2.0432 | 2.0475 | 200088.0 |
| 2006-06-13 08:31:00 | AAPL | Stock | 2.0464 | 2.05 | 2.0457 | 2.05 | 239456.0 |
| 2006-06-13 08:32:00 | AAPL | Stock | 2.0493 | 2.0546 | 2.0493 | 2.0546 | 233884.0 |
| 2006-06-13 08:33:00 | AAPL | Stock | 2.055 | 2.06 | 2.0532 | 2.0546 | 340172.0 |
| 2006-06-13 08:34:00 | AAPL | Stock | 2.055 | 2.055 | 2.0518 | 2.0543 | 78400.0 |
| 2006-06-13 08:35:00 | AAPL | Stock | 2.0536 | 2.0557 | 2.0536 | 2.0554 | 128324.0 |
| 2006-06-13 08:36:00 | AAPL | Stock | 2.0571 | 2.0586 | 2.0557 | 2.0557 | 208992.0 |
| 2006-06-13 08:37:00 | AAPL | Stock | 2.0557 | 2.0604 | 2.0518 | 2.0536 | 279860.0 |
| 2006-06-13 08:38:00 | AAPL | Stock | 2.0536 | 2.0536 | 2.0504 | 2.0504 | 142800.0 |
| 2006-06-13 08:39:00 | AAPL | Stock | 2.0504 | 2.0532 | 2.0504 | 2.0532 | 66220.0 |
| 2006-06-13 08:40:00 | AAPL | Stock | 2.0521 | 2.0521 | 2.05 | 2.0504 | 79380.0 |
| 2006-06-13 08:41:00 | AAPL | Stock | 2.0507 | 2.0514 | 2.0496 | 2.0496 | 159432.0 |
| 2006-06-13 08:42:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0407 | 2.0482 | 142576.0 |
> showing 50 of 758,247 rows — these rows as CSV