PREVIEW / stock_5min / 2007-04-26
file: by_date/stock_5min/2007/2007-04-26.parquet size: 3.7 MB rows: 261,914 symbols: 2,614
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-04-26 04:15:00 | AAPL | Stock | 3.6075 | 3.6075 | 3.6075 | 3.6075 | 2800.0 |
| 2007-04-26 04:35:00 | AAPL | Stock | 3.6571 | 3.6571 | 3.6571 | 3.6571 | 61600.0 |
| 2007-04-26 05:35:00 | AAPL | Stock | 3.6361 | 3.6361 | 3.6361 | 3.6361 | 2800.0 |
| 2007-04-26 05:40:00 | AAPL | Stock | 3.6368 | 3.6368 | 3.6364 | 3.6364 | 8400.0 |
| 2007-04-26 05:55:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 13020.0 |
| 2007-04-26 06:10:00 | AAPL | Stock | 3.6286 | 3.6361 | 3.6286 | 3.6339 | 142800.0 |
| 2007-04-26 06:15:00 | AAPL | Stock | 3.6357 | 3.65 | 3.6354 | 3.65 | 72800.0 |
| 2007-04-26 06:20:00 | AAPL | Stock | 3.6357 | 3.64 | 3.6357 | 3.6364 | 84028.0 |
| 2007-04-26 06:25:00 | AAPL | Stock | 3.6364 | 3.6429 | 3.6364 | 3.6429 | 42000.0 |
| 2007-04-26 06:30:00 | AAPL | Stock | 3.6371 | 3.6393 | 3.6368 | 3.6393 | 28868.0 |
| 2007-04-26 06:35:00 | AAPL | Stock | 3.6393 | 3.6532 | 3.6393 | 3.6396 | 53200.0 |
| 2007-04-26 06:40:00 | AAPL | Stock | 3.6439 | 3.6439 | 3.6436 | 3.6436 | 14000.0 |
| 2007-04-26 06:45:00 | AAPL | Stock | 3.6482 | 3.6557 | 3.6464 | 3.6557 | 105000.0 |
| 2007-04-26 06:50:00 | AAPL | Stock | 3.6546 | 3.6546 | 3.6518 | 3.6518 | 28000.0 |
| 2007-04-26 06:55:00 | AAPL | Stock | 3.65 | 3.6518 | 3.6468 | 3.6475 | 114800.0 |
| 2007-04-26 07:00:00 | AAPL | Stock | 3.6507 | 3.6714 | 3.6507 | 3.6714 | 721084.0 |
| 2007-04-26 07:05:00 | AAPL | Stock | 3.6629 | 3.6714 | 3.6625 | 3.6646 | 313572.0 |
| 2007-04-26 07:10:00 | AAPL | Stock | 3.6679 | 3.7121 | 3.6679 | 3.7071 | 2155272.0 |
| 2007-04-26 07:15:00 | AAPL | Stock | 3.7054 | 3.7179 | 3.7054 | 3.7107 | 751240.0 |
| 2007-04-26 07:20:00 | AAPL | Stock | 3.7107 | 3.7125 | 3.7043 | 3.7071 | 1067276.0 |
| 2007-04-26 07:25:00 | AAPL | Stock | 3.7071 | 3.7071 | 3.6893 | 3.6921 | 504644.0 |
| 2007-04-26 07:30:00 | AAPL | Stock | 3.6929 | 3.7071 | 3.6911 | 3.7071 | 959840.0 |
| 2007-04-26 07:35:00 | AAPL | Stock | 3.7036 | 3.7321 | 3.7036 | 3.7182 | 2023560.0 |
| 2007-04-26 07:40:00 | AAPL | Stock | 3.7161 | 3.7161 | 3.7032 | 3.7136 | 263060.0 |
| 2007-04-26 07:45:00 | AAPL | Stock | 3.7089 | 3.7132 | 3.6979 | 3.6979 | 618212.0 |
| 2007-04-26 07:50:00 | AAPL | Stock | 3.6979 | 3.7071 | 3.6964 | 3.7071 | 417200.0 |
| 2007-04-26 07:55:00 | AAPL | Stock | 3.7089 | 3.7286 | 3.6579 | 3.6611 | 6463352.0 |
| 2007-04-26 08:00:00 | AAPL | Stock | 3.6725 | 3.6961 | 3.6432 | 3.6929 | 11089680.0 |
| 2007-04-26 08:05:00 | AAPL | Stock | 3.6921 | 3.6964 | 3.6636 | 3.6682 | 7935452.0 |
| 2007-04-26 08:10:00 | AAPL | Stock | 3.6714 | 3.6779 | 3.6525 | 3.6564 | 6180524.0 |
| 2007-04-26 08:15:00 | AAPL | Stock | 3.6536 | 3.6568 | 3.6268 | 3.645 | 7212576.0 |
| 2007-04-26 08:20:00 | AAPL | Stock | 3.6461 | 3.6675 | 3.6361 | 3.6607 | 3818136.0 |
| 2007-04-26 08:25:00 | AAPL | Stock | 3.6607 | 3.6857 | 3.6575 | 3.6804 | 5059376.0 |
| 2007-04-26 08:30:00 | AAPL | Stock | 3.6796 | 3.6921 | 3.6689 | 3.6711 | 5307876.0 |
| 2007-04-26 08:35:00 | AAPL | Stock | 3.6693 | 3.6864 | 3.6679 | 3.675 | 3280704.0 |
| 2007-04-26 08:40:00 | AAPL | Stock | 3.6775 | 3.6843 | 3.6693 | 3.6782 | 2155132.0 |
| 2007-04-26 08:45:00 | AAPL | Stock | 3.6761 | 3.6761 | 3.6611 | 3.6661 | 2810920.0 |
| 2007-04-26 08:50:00 | AAPL | Stock | 3.6646 | 3.6714 | 3.6571 | 3.6643 | 4329584.0 |
| 2007-04-26 08:55:00 | AAPL | Stock | 3.6636 | 3.6666 | 3.6582 | 3.6643 | 3409756.0 |
| 2007-04-26 09:00:00 | AAPL | Stock | 3.6661 | 3.6718 | 3.6607 | 3.6682 | 5665576.0 |
| 2007-04-26 09:05:00 | AAPL | Stock | 3.6679 | 3.6679 | 3.6518 | 3.6586 | 6928488.0 |
| 2007-04-26 09:10:00 | AAPL | Stock | 3.6579 | 3.6607 | 3.6429 | 3.6482 | 8086764.0 |
| 2007-04-26 09:15:00 | AAPL | Stock | 3.6479 | 3.6557 | 3.6471 | 3.6536 | 2688000.0 |
| 2007-04-26 09:20:00 | AAPL | Stock | 3.6536 | 3.6554 | 3.6489 | 3.655 | 4610704.0 |
| 2007-04-26 09:25:00 | AAPL | Stock | 3.6539 | 3.6571 | 3.6257 | 3.6286 | 13998040.0 |
| 2007-04-26 09:30:00 | AAPL | Stock | 3.6279 | 3.6507 | 3.6036 | 3.6182 | 123539052.0 |
| 2007-04-26 09:35:00 | AAPL | Stock | 3.6189 | 3.6607 | 3.5761 | 3.5889 | 74443712.0 |
| 2007-04-26 09:40:00 | AAPL | Stock | 3.5889 | 3.6279 | 3.5804 | 3.5861 | 53024832.0 |
| 2007-04-26 09:45:00 | AAPL | Stock | 3.5857 | 3.6429 | 3.5489 | 3.5707 | 81008312.0 |
| 2007-04-26 09:50:00 | AAPL | Stock | 3.5707 | 3.6179 | 3.5489 | 3.5654 | 52397520.0 |
> showing 50 of 261,914 rows — these rows as CSV