PREVIEW / stock_5min / 2006-10-12
file: by_date/stock_5min/2006/2006-10-12.parquet size: 3.1 MB rows: 230,858 symbols: 2,389
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-10-12 07:35:00 | AAPL | Stock | 2.6204 | 2.6204 | 2.6204 | 2.6204 | 5600.0 |
| 2006-10-12 07:45:00 | AAPL | Stock | 2.6204 | 2.6204 | 2.6204 | 2.6204 | 5600.0 |
| 2006-10-12 07:50:00 | AAPL | Stock | 2.6204 | 2.6204 | 2.6204 | 2.6204 | 22400.0 |
| 2006-10-12 08:00:00 | AAPL | Stock | 2.6196 | 2.6218 | 2.6164 | 2.6218 | 89040.0 |
| 2006-10-12 08:05:00 | AAPL | Stock | 2.6218 | 2.6261 | 2.6218 | 2.625 | 79800.0 |
| 2006-10-12 08:10:00 | AAPL | Stock | 2.6246 | 2.6246 | 2.6221 | 2.6221 | 14840.0 |
| 2006-10-12 08:15:00 | AAPL | Stock | 2.6221 | 2.6221 | 2.6221 | 2.6221 | 19600.0 |
| 2006-10-12 08:20:00 | AAPL | Stock | 2.6246 | 2.6286 | 2.6246 | 2.6286 | 47600.0 |
| 2006-10-12 08:25:00 | AAPL | Stock | 2.6268 | 2.6304 | 2.6268 | 2.6304 | 61320.0 |
| 2006-10-12 08:30:00 | AAPL | Stock | 2.6304 | 2.6304 | 2.6246 | 2.6246 | 67200.0 |
| 2006-10-12 08:35:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 2800.0 |
| 2006-10-12 08:40:00 | AAPL | Stock | 2.6236 | 2.6286 | 2.6225 | 2.6268 | 211400.0 |
| 2006-10-12 08:45:00 | AAPL | Stock | 2.6268 | 2.6339 | 2.6264 | 2.6339 | 135520.0 |
| 2006-10-12 08:50:00 | AAPL | Stock | 2.6321 | 2.6354 | 2.6321 | 2.635 | 394800.0 |
| 2006-10-12 08:55:00 | AAPL | Stock | 2.6336 | 2.635 | 2.6336 | 2.635 | 58800.0 |
| 2006-10-12 09:00:00 | AAPL | Stock | 2.6339 | 2.6343 | 2.6311 | 2.6321 | 116984.0 |
| 2006-10-12 09:05:00 | AAPL | Stock | 2.6311 | 2.6321 | 2.6311 | 2.6321 | 39200.0 |
| 2006-10-12 09:10:00 | AAPL | Stock | 2.6321 | 2.6329 | 2.6321 | 2.6321 | 159600.0 |
| 2006-10-12 09:15:00 | AAPL | Stock | 2.6307 | 2.6321 | 2.6286 | 2.6293 | 605080.0 |
| 2006-10-12 09:20:00 | AAPL | Stock | 2.6314 | 2.6314 | 2.6289 | 2.6314 | 131600.0 |
| 2006-10-12 09:25:00 | AAPL | Stock | 2.6279 | 2.6321 | 2.6279 | 2.6318 | 336028.0 |
| 2006-10-12 09:30:00 | AAPL | Stock | 2.6289 | 2.6504 | 2.6286 | 2.6446 | 19757304.0 |
| 2006-10-12 09:35:00 | AAPL | Stock | 2.6446 | 2.6507 | 2.6436 | 2.6461 | 13706476.0 |
| 2006-10-12 09:40:00 | AAPL | Stock | 2.6464 | 2.65 | 2.6436 | 2.6457 | 13426364.0 |
| 2006-10-12 09:45:00 | AAPL | Stock | 2.6457 | 2.6493 | 2.6425 | 2.6457 | 9225580.0 |
| 2006-10-12 09:50:00 | AAPL | Stock | 2.6461 | 2.6532 | 2.6457 | 2.6496 | 15232728.0 |
| 2006-10-12 09:55:00 | AAPL | Stock | 2.65 | 2.67 | 2.6496 | 2.6661 | 32717384.0 |
| 2006-10-12 10:00:00 | AAPL | Stock | 2.6668 | 2.6782 | 2.6643 | 2.6771 | 20564488.0 |
| 2006-10-12 10:05:00 | AAPL | Stock | 2.6779 | 2.6779 | 2.6682 | 2.6689 | 17211292.0 |
| 2006-10-12 10:10:00 | AAPL | Stock | 2.6686 | 2.6807 | 2.665 | 2.6793 | 19870060.0 |
| 2006-10-12 10:15:00 | AAPL | Stock | 2.6793 | 2.6793 | 2.6707 | 2.6757 | 11447240.0 |
| 2006-10-12 10:20:00 | AAPL | Stock | 2.6757 | 2.6775 | 2.6664 | 2.6668 | 9397304.0 |
| 2006-10-12 10:25:00 | AAPL | Stock | 2.6675 | 2.6693 | 2.6621 | 2.6679 | 7696612.0 |
| 2006-10-12 10:30:00 | AAPL | Stock | 2.6682 | 2.6689 | 2.6571 | 2.6643 | 14135436.0 |
| 2006-10-12 10:35:00 | AAPL | Stock | 2.6643 | 2.6671 | 2.6611 | 2.6629 | 6779108.0 |
| 2006-10-12 10:40:00 | AAPL | Stock | 2.6636 | 2.6671 | 2.6618 | 2.6657 | 6219948.0 |
| 2006-10-12 10:45:00 | AAPL | Stock | 2.665 | 2.6661 | 2.6582 | 2.6643 | 7308224.0 |
| 2006-10-12 10:50:00 | AAPL | Stock | 2.6639 | 2.6696 | 2.6639 | 2.6679 | 8537228.0 |
| 2006-10-12 10:55:00 | AAPL | Stock | 2.6679 | 2.6679 | 2.6554 | 2.6582 | 9285416.0 |
| 2006-10-12 11:00:00 | AAPL | Stock | 2.6582 | 2.6604 | 2.6536 | 2.6586 | 6968752.0 |
| 2006-10-12 11:05:00 | AAPL | Stock | 2.6586 | 2.6632 | 2.6571 | 2.6604 | 7588196.0 |
| 2006-10-12 11:10:00 | AAPL | Stock | 2.6606 | 2.6636 | 2.6596 | 2.66 | 4944240.0 |
| 2006-10-12 11:15:00 | AAPL | Stock | 2.66 | 2.6639 | 2.6575 | 2.6636 | 7183148.0 |
| 2006-10-12 11:20:00 | AAPL | Stock | 2.6636 | 2.6643 | 2.6589 | 2.6614 | 3324748.0 |
| 2006-10-12 11:25:00 | AAPL | Stock | 2.6614 | 2.6661 | 2.6614 | 2.6643 | 5941656.0 |
| 2006-10-12 11:30:00 | AAPL | Stock | 2.6646 | 2.6679 | 2.6646 | 2.6654 | 3436776.0 |
| 2006-10-12 11:35:00 | AAPL | Stock | 2.665 | 2.6664 | 2.6632 | 2.6636 | 3497312.0 |
| 2006-10-12 11:40:00 | AAPL | Stock | 2.6632 | 2.6636 | 2.6575 | 2.6582 | 4372788.0 |
| 2006-10-12 11:45:00 | AAPL | Stock | 2.6582 | 2.6621 | 2.6557 | 2.6621 | 3076528.0 |
| 2006-10-12 11:50:00 | AAPL | Stock | 2.6621 | 2.6636 | 2.6611 | 2.6631 | 2092020.0 |
> showing 50 of 230,858 rows — these rows as CSV