PREVIEW / stock_5min / 2006-09-15
file: by_date/stock_5min/2006/2006-09-15.parquet size: 3.2 MB rows: 229,590 symbols: 2,342
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-15 08:00:00 | AAPL | Stock | 2.6489 | 2.655 | 2.6489 | 2.655 | 86800.0 |
| 2006-09-15 08:05:00 | AAPL | Stock | 2.655 | 2.655 | 2.6507 | 2.6507 | 36260.0 |
| 2006-09-15 08:10:00 | AAPL | Stock | 2.6518 | 2.655 | 2.6518 | 2.6546 | 39340.0 |
| 2006-09-15 08:15:00 | AAPL | Stock | 2.6539 | 2.6539 | 2.6536 | 2.6536 | 56000.0 |
| 2006-09-15 08:20:00 | AAPL | Stock | 2.6554 | 2.6554 | 2.6554 | 2.6554 | 4620.0 |
| 2006-09-15 08:25:00 | AAPL | Stock | 2.655 | 2.655 | 2.6507 | 2.6511 | 28560.0 |
| 2006-09-15 08:30:00 | AAPL | Stock | 2.6514 | 2.6618 | 2.6514 | 2.6607 | 1510740.0 |
| 2006-09-15 08:35:00 | AAPL | Stock | 2.6611 | 2.6614 | 2.6579 | 2.6607 | 253260.0 |
| 2006-09-15 08:40:00 | AAPL | Stock | 2.6607 | 2.6625 | 2.6589 | 2.6625 | 348040.0 |
| 2006-09-15 08:45:00 | AAPL | Stock | 2.6636 | 2.6654 | 2.6625 | 2.6643 | 629244.0 |
| 2006-09-15 08:50:00 | AAPL | Stock | 2.6636 | 2.665 | 2.6614 | 2.6621 | 429100.0 |
| 2006-09-15 08:55:00 | AAPL | Stock | 2.6625 | 2.6639 | 2.6625 | 2.6639 | 59612.0 |
| 2006-09-15 09:00:00 | AAPL | Stock | 2.6639 | 2.6643 | 2.6607 | 2.6607 | 249200.0 |
| 2006-09-15 09:05:00 | AAPL | Stock | 2.6607 | 2.6646 | 2.6607 | 2.6646 | 304612.0 |
| 2006-09-15 09:10:00 | AAPL | Stock | 2.6646 | 2.665 | 2.6625 | 2.6643 | 629300.0 |
| 2006-09-15 09:15:00 | AAPL | Stock | 2.6643 | 2.665 | 2.6643 | 2.6643 | 96600.0 |
| 2006-09-15 09:20:00 | AAPL | Stock | 2.6643 | 2.6661 | 2.6643 | 2.6661 | 175252.0 |
| 2006-09-15 09:25:00 | AAPL | Stock | 2.6643 | 2.6786 | 2.6639 | 2.665 | 6792576.0 |
| 2006-09-15 09:30:00 | AAPL | Stock | 2.6643 | 2.6779 | 2.6614 | 2.6725 | 170670472.0 |
| 2006-09-15 09:35:00 | AAPL | Stock | 2.6721 | 2.6729 | 2.6586 | 2.6643 | 20323072.0 |
| 2006-09-15 09:40:00 | AAPL | Stock | 2.6639 | 2.665 | 2.655 | 2.6554 | 19793732.0 |
| 2006-09-15 09:45:00 | AAPL | Stock | 2.6554 | 2.6714 | 2.6496 | 2.6561 | 19065788.0 |
| 2006-09-15 09:50:00 | AAPL | Stock | 2.6557 | 2.6668 | 2.6525 | 2.6657 | 22224608.0 |
| 2006-09-15 09:55:00 | AAPL | Stock | 2.6661 | 2.6696 | 2.6593 | 2.6657 | 19007856.0 |
| 2006-09-15 10:00:00 | AAPL | Stock | 2.6657 | 2.67 | 2.6557 | 2.6643 | 9925104.0 |
| 2006-09-15 10:05:00 | AAPL | Stock | 2.6646 | 2.6682 | 2.6607 | 2.6646 | 12630996.0 |
| 2006-09-15 10:10:00 | AAPL | Stock | 2.6646 | 2.6679 | 2.6614 | 2.6654 | 10750684.0 |
| 2006-09-15 10:15:00 | AAPL | Stock | 2.6661 | 2.6679 | 2.6611 | 2.6614 | 13317052.0 |
| 2006-09-15 10:20:00 | AAPL | Stock | 2.6614 | 2.6725 | 2.6557 | 2.6575 | 13242936.0 |
| 2006-09-15 10:25:00 | AAPL | Stock | 2.6575 | 2.67 | 2.6536 | 2.6582 | 15364244.0 |
| 2006-09-15 10:30:00 | AAPL | Stock | 2.6579 | 2.67 | 2.6529 | 2.6543 | 12640040.0 |
| 2006-09-15 10:35:00 | AAPL | Stock | 2.6543 | 2.6564 | 2.6511 | 2.6511 | 10588704.0 |
| 2006-09-15 10:40:00 | AAPL | Stock | 2.6511 | 2.6586 | 2.6511 | 2.6557 | 8323336.0 |
| 2006-09-15 10:45:00 | AAPL | Stock | 2.6557 | 2.6557 | 2.6457 | 2.6461 | 8869812.0 |
| 2006-09-15 10:50:00 | AAPL | Stock | 2.6461 | 2.6461 | 2.6318 | 2.6339 | 31285072.0 |
| 2006-09-15 10:55:00 | AAPL | Stock | 2.6343 | 2.6382 | 2.6293 | 2.6368 | 16192652.0 |
| 2006-09-15 11:00:00 | AAPL | Stock | 2.6368 | 2.6436 | 2.6354 | 2.6436 | 12779396.0 |
| 2006-09-15 11:05:00 | AAPL | Stock | 2.6432 | 2.6443 | 2.635 | 2.6382 | 12804932.0 |
| 2006-09-15 11:10:00 | AAPL | Stock | 2.6379 | 2.6404 | 2.6314 | 2.6314 | 9918244.0 |
| 2006-09-15 11:15:00 | AAPL | Stock | 2.632 | 2.6343 | 2.6271 | 2.6275 | 16605120.0 |
| 2006-09-15 11:20:00 | AAPL | Stock | 2.6275 | 2.6339 | 2.6175 | 2.6307 | 27630988.0 |
| 2006-09-15 11:25:00 | AAPL | Stock | 2.6311 | 2.6372 | 2.63 | 2.635 | 10386320.0 |
| 2006-09-15 11:30:00 | AAPL | Stock | 2.6346 | 2.6354 | 2.6311 | 2.6343 | 6904128.0 |
| 2006-09-15 11:35:00 | AAPL | Stock | 2.6343 | 2.6382 | 2.6325 | 2.6371 | 6602568.0 |
| 2006-09-15 11:40:00 | AAPL | Stock | 2.6371 | 2.6418 | 2.6357 | 2.6407 | 7317996.0 |
| 2006-09-15 11:45:00 | AAPL | Stock | 2.6404 | 2.6429 | 2.64 | 2.6414 | 5708892.0 |
| 2006-09-15 11:50:00 | AAPL | Stock | 2.6414 | 2.6418 | 2.6343 | 2.6404 | 7408688.0 |
| 2006-09-15 11:55:00 | AAPL | Stock | 2.64 | 2.6496 | 2.64 | 2.645 | 11953088.0 |
| 2006-09-15 12:00:00 | AAPL | Stock | 2.645 | 2.6457 | 2.6375 | 2.6414 | 9571688.0 |
| 2006-09-15 12:05:00 | AAPL | Stock | 2.6418 | 2.6461 | 2.6379 | 2.6429 | 6532092.0 |
> showing 50 of 229,590 rows — these rows as CSV