PREVIEW / stock_5min / 2008-06-27
file: by_date/stock_5min/2008/2008-06-27.parquet size: 5.0 MB rows: 353,059 symbols: 3,335
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-27 04:30:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 2800.0 |
| 2008-06-27 05:00:00 | AAPL | Stock | 6.0089 | 6.0089 | 6.0089 | 6.0089 | 2800.0 |
| 2008-06-27 05:15:00 | AAPL | Stock | 5.9839 | 5.9839 | 5.9839 | 5.9839 | 2800.0 |
| 2008-06-27 05:40:00 | AAPL | Stock | 5.9896 | 5.9911 | 5.9896 | 5.9911 | 5600.0 |
| 2008-06-27 05:50:00 | AAPL | Stock | 5.9943 | 5.9943 | 5.9943 | 5.9943 | 2800.0 |
| 2008-06-27 07:05:00 | AAPL | Stock | 5.9646 | 5.9646 | 5.9646 | 5.9646 | 2800.0 |
| 2008-06-27 07:15:00 | AAPL | Stock | 5.9639 | 5.9804 | 5.9639 | 5.9804 | 21980.0 |
| 2008-06-27 07:35:00 | AAPL | Stock | 5.965 | 5.965 | 5.9543 | 5.9543 | 64400.0 |
| 2008-06-27 07:40:00 | AAPL | Stock | 5.9525 | 5.9525 | 5.9357 | 5.9382 | 39200.0 |
| 2008-06-27 07:45:00 | AAPL | Stock | 5.9471 | 5.9471 | 5.9471 | 5.9471 | 16800.0 |
| 2008-06-27 07:50:00 | AAPL | Stock | 5.9568 | 5.9639 | 5.9568 | 5.9639 | 101948.0 |
| 2008-06-27 07:55:00 | AAPL | Stock | 5.9575 | 5.9575 | 5.9568 | 5.9568 | 14000.0 |
| 2008-06-27 08:00:00 | AAPL | Stock | 5.9643 | 5.9775 | 5.9393 | 5.9475 | 384608.0 |
| 2008-06-27 08:05:00 | AAPL | Stock | 5.9568 | 5.9607 | 5.9475 | 5.9504 | 97160.0 |
| 2008-06-27 08:10:00 | AAPL | Stock | 5.9511 | 5.9511 | 5.9329 | 5.9329 | 331100.0 |
| 2008-06-27 08:15:00 | AAPL | Stock | 5.9375 | 5.9421 | 5.9136 | 5.9261 | 363300.0 |
| 2008-06-27 08:20:00 | AAPL | Stock | 5.9214 | 5.9268 | 5.9071 | 5.9154 | 598612.0 |
| 2008-06-27 08:25:00 | AAPL | Stock | 5.9071 | 5.915 | 5.8957 | 5.9107 | 419804.0 |
| 2008-06-27 08:30:00 | AAPL | Stock | 5.9107 | 5.9464 | 5.9107 | 5.9107 | 1443932.0 |
| 2008-06-27 08:35:00 | AAPL | Stock | 5.9214 | 5.9275 | 5.9182 | 5.9182 | 144200.0 |
| 2008-06-27 08:40:00 | AAPL | Stock | 5.9154 | 5.9461 | 5.9036 | 5.9332 | 756364.0 |
| 2008-06-27 08:45:00 | AAPL | Stock | 5.9332 | 5.9393 | 5.9257 | 5.9375 | 299068.0 |
| 2008-06-27 08:50:00 | AAPL | Stock | 5.9357 | 5.9468 | 5.9354 | 5.9386 | 281960.0 |
| 2008-06-27 08:55:00 | AAPL | Stock | 5.9389 | 5.955 | 5.9375 | 5.9518 | 510076.0 |
| 2008-06-27 09:00:00 | AAPL | Stock | 5.9514 | 5.9643 | 5.9421 | 5.9625 | 604184.0 |
| 2008-06-27 09:05:00 | AAPL | Stock | 5.9614 | 5.9732 | 5.9554 | 5.9625 | 1088220.0 |
| 2008-06-27 09:10:00 | AAPL | Stock | 5.9604 | 5.9643 | 5.9525 | 5.9568 | 269780.0 |
| 2008-06-27 09:15:00 | AAPL | Stock | 5.9568 | 5.9568 | 5.95 | 5.9536 | 537208.0 |
| 2008-06-27 09:20:00 | AAPL | Stock | 5.9539 | 5.9607 | 5.9536 | 5.9596 | 486080.0 |
| 2008-06-27 09:25:00 | AAPL | Stock | 5.9575 | 5.9629 | 5.9475 | 5.9482 | 1653260.0 |
| 2008-06-27 09:30:00 | AAPL | Stock | 5.9468 | 6.0093 | 5.9318 | 5.9771 | 32012428.0 |
| 2008-06-27 09:35:00 | AAPL | Stock | 5.9793 | 5.9793 | 5.9246 | 5.9382 | 27878256.0 |
| 2008-06-27 09:40:00 | AAPL | Stock | 5.9371 | 5.9504 | 5.9107 | 5.9146 | 24385648.0 |
| 2008-06-27 09:45:00 | AAPL | Stock | 5.9107 | 5.9532 | 5.9068 | 5.9293 | 21499184.0 |
| 2008-06-27 09:50:00 | AAPL | Stock | 5.9271 | 5.9821 | 5.9232 | 5.9596 | 18513656.0 |
| 2008-06-27 09:55:00 | AAPL | Stock | 5.9596 | 6.0179 | 5.9479 | 6.0168 | 19681536.0 |
| 2008-06-27 10:00:00 | AAPL | Stock | 6.0171 | 6.0625 | 6.0029 | 6.0339 | 29086652.0 |
| 2008-06-27 10:05:00 | AAPL | Stock | 6.0339 | 6.0504 | 6.0118 | 6.0265 | 16466548.0 |
| 2008-06-27 10:10:00 | AAPL | Stock | 6.0296 | 6.0296 | 6.0075 | 6.0164 | 11066916.0 |
| 2008-06-27 10:15:00 | AAPL | Stock | 6.0166 | 6.0243 | 5.9696 | 5.9836 | 15313228.0 |
| 2008-06-27 10:20:00 | AAPL | Stock | 5.9829 | 6.0164 | 5.9814 | 6.0076 | 10553032.0 |
| 2008-06-27 10:25:00 | AAPL | Stock | 6.0096 | 6.0325 | 6.0064 | 6.0129 | 10543260.0 |
| 2008-06-27 10:30:00 | AAPL | Stock | 6.0146 | 6.0532 | 6.0104 | 6.039 | 12593140.0 |
| 2008-06-27 10:35:00 | AAPL | Stock | 6.0393 | 6.0539 | 6.0307 | 6.0532 | 11482296.0 |
| 2008-06-27 10:40:00 | AAPL | Stock | 6.0529 | 6.0536 | 6.0107 | 6.0204 | 14485660.0 |
| 2008-06-27 10:45:00 | AAPL | Stock | 6.0193 | 6.025 | 5.995 | 6.0 | 11217136.0 |
| 2008-06-27 10:50:00 | AAPL | Stock | 6.0 | 6.0139 | 5.9968 | 6.0021 | 7694232.0 |
| 2008-06-27 10:55:00 | AAPL | Stock | 6.0021 | 6.0089 | 5.9886 | 6.0061 | 9103948.0 |
| 2008-06-27 11:00:00 | AAPL | Stock | 6.0067 | 6.0075 | 5.9775 | 5.9979 | 10512264.0 |
| 2008-06-27 11:05:00 | AAPL | Stock | 5.9973 | 6.0018 | 5.9911 | 5.9967 | 7411040.0 |
> showing 50 of 353,059 rows — these rows as CSV