PREVIEW / stock_5min / 2006-07-05
file: by_date/stock_5min/2006/2006-07-05.parquet size: 3.1 MB rows: 231,738 symbols: 2,311
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-07-05 06:25:00 | AAPL | Stock | 2.0518 | 2.0696 | 2.0429 | 2.0696 | 12600.0 |
| 2006-07-05 08:00:00 | AAPL | Stock | 2.0664 | 2.0664 | 2.0646 | 2.0646 | 21560.0 |
| 2006-07-05 08:05:00 | AAPL | Stock | 2.0636 | 2.0636 | 2.0575 | 2.0579 | 19600.0 |
| 2006-07-05 08:10:00 | AAPL | Stock | 2.0575 | 2.0579 | 2.0546 | 2.0579 | 288176.0 |
| 2006-07-05 08:15:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0575 | 2.0575 | 18200.0 |
| 2006-07-05 08:20:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0554 | 2.0554 | 8400.0 |
| 2006-07-05 08:25:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0536 | 2.0536 | 118188.0 |
| 2006-07-05 08:30:00 | AAPL | Stock | 2.0554 | 2.0575 | 2.0536 | 2.0554 | 126000.0 |
| 2006-07-05 08:35:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0536 | 2.0554 | 39788.0 |
| 2006-07-05 08:45:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0554 | 2.0554 | 27748.0 |
| 2006-07-05 08:50:00 | AAPL | Stock | 2.0557 | 2.0557 | 2.055 | 2.055 | 22400.0 |
| 2006-07-05 08:55:00 | AAPL | Stock | 2.0546 | 2.0546 | 2.05 | 2.05 | 112588.0 |
| 2006-07-05 09:00:00 | AAPL | Stock | 2.05 | 2.05 | 2.0464 | 2.0464 | 181328.0 |
| 2006-07-05 09:05:00 | AAPL | Stock | 2.0482 | 2.05 | 2.0464 | 2.0482 | 105532.0 |
| 2006-07-05 09:10:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0464 | 2.0464 | 80416.0 |
| 2006-07-05 09:15:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 306348.0 |
| 2006-07-05 09:20:00 | AAPL | Stock | 2.0468 | 2.0468 | 2.0407 | 2.0414 | 464352.0 |
| 2006-07-05 09:25:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0386 | 2.0425 | 1052996.0 |
| 2006-07-05 09:30:00 | AAPL | Stock | 2.0411 | 2.0425 | 2.0321 | 2.0386 | 20950440.0 |
| 2006-07-05 09:35:00 | AAPL | Stock | 2.0382 | 2.0514 | 2.0361 | 2.05 | 9726780.0 |
| 2006-07-05 09:40:00 | AAPL | Stock | 2.05 | 2.0546 | 2.0468 | 2.05 | 12392240.0 |
| 2006-07-05 09:45:00 | AAPL | Stock | 2.05 | 2.0571 | 2.0489 | 2.0521 | 9494604.0 |
| 2006-07-05 09:50:00 | AAPL | Stock | 2.0521 | 2.0521 | 2.0418 | 2.0432 | 9435888.0 |
| 2006-07-05 09:55:00 | AAPL | Stock | 2.0429 | 2.0486 | 2.0386 | 2.0478 | 10531108.0 |
| 2006-07-05 10:00:00 | AAPL | Stock | 2.0479 | 2.05 | 2.0425 | 2.0432 | 8629432.0 |
| 2006-07-05 10:05:00 | AAPL | Stock | 2.0432 | 2.0446 | 2.0368 | 2.0446 | 9888004.0 |
| 2006-07-05 10:10:00 | AAPL | Stock | 2.0436 | 2.05 | 2.0418 | 2.0468 | 7884912.0 |
| 2006-07-05 10:15:00 | AAPL | Stock | 2.0471 | 2.0485 | 2.0432 | 2.0468 | 3973704.0 |
| 2006-07-05 10:20:00 | AAPL | Stock | 2.0464 | 2.0468 | 2.0439 | 2.0443 | 3221008.0 |
| 2006-07-05 10:25:00 | AAPL | Stock | 2.0443 | 2.0443 | 2.0371 | 2.0407 | 9189768.0 |
| 2006-07-05 10:30:00 | AAPL | Stock | 2.0404 | 2.0432 | 2.0393 | 2.04 | 3331524.0 |
| 2006-07-05 10:35:00 | AAPL | Stock | 2.0404 | 2.0421 | 2.0371 | 2.0379 | 3986948.0 |
| 2006-07-05 10:40:00 | AAPL | Stock | 2.0375 | 2.0393 | 2.0361 | 2.0368 | 9027900.0 |
| 2006-07-05 10:45:00 | AAPL | Stock | 2.0368 | 2.0375 | 2.0329 | 2.0368 | 9419872.0 |
| 2006-07-05 10:50:00 | AAPL | Stock | 2.0368 | 2.0389 | 2.0346 | 2.0368 | 4327064.0 |
| 2006-07-05 10:55:00 | AAPL | Stock | 2.0368 | 2.0368 | 2.03 | 2.0307 | 13853336.0 |
| 2006-07-05 11:00:00 | AAPL | Stock | 2.0304 | 2.0339 | 2.0286 | 2.0314 | 9289616.0 |
| 2006-07-05 11:05:00 | AAPL | Stock | 2.0314 | 2.0354 | 2.0289 | 2.0354 | 7144928.0 |
| 2006-07-05 11:10:00 | AAPL | Stock | 2.0354 | 2.0357 | 2.0311 | 2.0314 | 5666584.0 |
| 2006-07-05 11:15:00 | AAPL | Stock | 2.0315 | 2.0329 | 2.0289 | 2.03 | 6282640.0 |
| 2006-07-05 11:20:00 | AAPL | Stock | 2.0304 | 2.0314 | 2.0264 | 2.0275 | 6333936.0 |
| 2006-07-05 11:25:00 | AAPL | Stock | 2.0271 | 2.0318 | 2.0271 | 2.0307 | 6288968.0 |
| 2006-07-05 11:30:00 | AAPL | Stock | 2.0307 | 2.0314 | 2.0293 | 2.0304 | 4946396.0 |
| 2006-07-05 11:35:00 | AAPL | Stock | 2.0311 | 2.0321 | 2.0304 | 2.0314 | 5132036.0 |
| 2006-07-05 11:40:00 | AAPL | Stock | 2.0318 | 2.0329 | 2.0289 | 2.0289 | 4855004.0 |
| 2006-07-05 11:45:00 | AAPL | Stock | 2.0293 | 2.0321 | 2.0271 | 2.0289 | 5627888.0 |
| 2006-07-05 11:50:00 | AAPL | Stock | 2.0286 | 2.0314 | 2.0282 | 2.0307 | 2871204.0 |
| 2006-07-05 11:55:00 | AAPL | Stock | 2.0307 | 2.0311 | 2.0296 | 2.0296 | 2687524.0 |
| 2006-07-05 12:00:00 | AAPL | Stock | 2.0296 | 2.03 | 2.0254 | 2.0257 | 4397456.0 |
| 2006-07-05 12:05:00 | AAPL | Stock | 2.0257 | 2.0257 | 2.0236 | 2.0254 | 4443404.0 |
> showing 50 of 231,738 rows — these rows as CSV