PREVIEW / stock_5min / 2007-08-31
file: by_date/stock_5min/2007/2007-08-31.parquet size: 3.9 MB rows: 290,700 symbols: 3,117
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-08-31 09:30:00 | AAPL | Stock | 4.9821 | 4.9875 | 4.9518 | 4.9518 | 45270372.0 |
| 2007-08-31 09:35:00 | AAPL | Stock | 4.9523 | 4.9754 | 4.9443 | 4.9671 | 32876816.0 |
| 2007-08-31 09:40:00 | AAPL | Stock | 4.9661 | 4.9729 | 4.9539 | 4.9676 | 23821028.0 |
| 2007-08-31 09:45:00 | AAPL | Stock | 4.9679 | 4.9689 | 4.9482 | 4.9579 | 20485304.0 |
| 2007-08-31 09:50:00 | AAPL | Stock | 4.9575 | 4.9636 | 4.9511 | 4.9521 | 15981364.0 |
| 2007-08-31 09:55:00 | AAPL | Stock | 4.9518 | 4.9625 | 4.9432 | 4.9579 | 18592392.0 |
| 2007-08-31 10:00:00 | AAPL | Stock | 4.9582 | 4.9696 | 4.9271 | 4.9275 | 35282940.0 |
| 2007-08-31 10:05:00 | AAPL | Stock | 4.9282 | 4.9496 | 4.9236 | 4.9382 | 28269892.0 |
| 2007-08-31 10:10:00 | AAPL | Stock | 4.9379 | 4.9432 | 4.9179 | 4.9193 | 23574040.0 |
| 2007-08-31 10:15:00 | AAPL | Stock | 4.9186 | 4.9396 | 4.9161 | 4.9354 | 17871700.0 |
| 2007-08-31 10:20:00 | AAPL | Stock | 4.9361 | 4.9454 | 4.9293 | 4.9344 | 13309996.0 |
| 2007-08-31 10:25:00 | AAPL | Stock | 4.9344 | 4.9389 | 4.9268 | 4.9343 | 12211472.0 |
| 2007-08-31 10:30:00 | AAPL | Stock | 4.9341 | 4.945 | 4.9289 | 4.9439 | 14577864.0 |
| 2007-08-31 10:35:00 | AAPL | Stock | 4.9442 | 4.9518 | 4.9414 | 4.945 | 14865228.0 |
| 2007-08-31 10:40:00 | AAPL | Stock | 4.945 | 4.95 | 4.9331 | 4.9332 | 12494272.0 |
| 2007-08-31 10:45:00 | AAPL | Stock | 4.9343 | 4.9375 | 4.93 | 4.9344 | 8627696.0 |
| 2007-08-31 10:50:00 | AAPL | Stock | 4.9336 | 4.9389 | 4.9264 | 4.9382 | 8663340.0 |
| 2007-08-31 10:55:00 | AAPL | Stock | 4.9382 | 4.9386 | 4.9289 | 4.93 | 5966100.0 |
| 2007-08-31 11:00:00 | AAPL | Stock | 4.9289 | 4.9375 | 4.9268 | 4.9286 | 9573200.0 |
| 2007-08-31 11:05:00 | AAPL | Stock | 4.9286 | 4.9307 | 4.9079 | 4.9107 | 17072748.0 |
| 2007-08-31 11:10:00 | AAPL | Stock | 4.9104 | 4.9239 | 4.9079 | 4.9229 | 13605564.0 |
| 2007-08-31 11:15:00 | AAPL | Stock | 4.9225 | 4.9279 | 4.9114 | 4.9182 | 10645208.0 |
| 2007-08-31 11:20:00 | AAPL | Stock | 4.9186 | 4.9211 | 4.9075 | 4.9125 | 11034212.0 |
| 2007-08-31 11:25:00 | AAPL | Stock | 4.9125 | 4.9218 | 4.91 | 4.9214 | 9213932.0 |
| 2007-08-31 11:30:00 | AAPL | Stock | 4.9212 | 4.9375 | 4.9196 | 4.9346 | 13709220.0 |
| 2007-08-31 11:35:00 | AAPL | Stock | 4.935 | 4.9418 | 4.9293 | 4.9418 | 9911300.0 |
| 2007-08-31 11:40:00 | AAPL | Stock | 4.9418 | 4.9432 | 4.9364 | 4.9393 | 8962968.0 |
| 2007-08-31 11:45:00 | AAPL | Stock | 4.9393 | 4.9404 | 4.9329 | 4.9397 | 7521080.0 |
| 2007-08-31 11:50:00 | AAPL | Stock | 4.9396 | 4.9461 | 4.9361 | 4.9379 | 9262456.0 |
| 2007-08-31 11:55:00 | AAPL | Stock | 4.9386 | 4.9457 | 4.9379 | 4.9407 | 6266960.0 |
| 2007-08-31 12:00:00 | AAPL | Stock | 4.9407 | 4.9429 | 4.9361 | 4.9364 | 3727836.0 |
| 2007-08-31 12:05:00 | AAPL | Stock | 4.9371 | 4.9371 | 4.9214 | 4.9236 | 9110276.0 |
| 2007-08-31 12:10:00 | AAPL | Stock | 4.9236 | 4.9279 | 4.9193 | 4.925 | 10761380.0 |
| 2007-08-31 12:15:00 | AAPL | Stock | 4.9247 | 4.9268 | 4.9161 | 4.9268 | 7307832.0 |
| 2007-08-31 12:20:00 | AAPL | Stock | 4.9268 | 4.9404 | 4.9261 | 4.9346 | 8747732.0 |
| 2007-08-31 12:25:00 | AAPL | Stock | 4.9343 | 4.9375 | 4.93 | 4.93 | 3289636.0 |
| 2007-08-31 12:30:00 | AAPL | Stock | 4.93 | 4.9429 | 4.9293 | 4.9389 | 8307012.0 |
| 2007-08-31 12:35:00 | AAPL | Stock | 4.94 | 4.9418 | 4.9321 | 4.9375 | 5251120.0 |
| 2007-08-31 12:40:00 | AAPL | Stock | 4.9371 | 4.9386 | 4.9293 | 4.9343 | 5132624.0 |
| 2007-08-31 12:45:00 | AAPL | Stock | 4.9339 | 4.935 | 4.9286 | 4.9325 | 4625600.0 |
| 2007-08-31 12:50:00 | AAPL | Stock | 4.9325 | 4.9325 | 4.9232 | 4.9246 | 5266016.0 |
| 2007-08-31 12:55:00 | AAPL | Stock | 4.9243 | 4.9332 | 4.9236 | 4.9304 | 4224304.0 |
| 2007-08-31 13:00:00 | AAPL | Stock | 4.9304 | 4.9343 | 4.9246 | 4.9261 | 3988628.0 |
| 2007-08-31 13:05:00 | AAPL | Stock | 4.9261 | 4.9286 | 4.9232 | 4.9261 | 4500888.0 |
| 2007-08-31 13:10:00 | AAPL | Stock | 4.9271 | 4.9311 | 4.9243 | 4.9289 | 3723748.0 |
| 2007-08-31 13:15:00 | AAPL | Stock | 4.9289 | 4.9319 | 4.9264 | 4.9268 | 4102560.0 |
| 2007-08-31 13:20:00 | AAPL | Stock | 4.9264 | 4.9286 | 4.9236 | 4.9236 | 2592520.0 |
| 2007-08-31 13:25:00 | AAPL | Stock | 4.9236 | 4.9314 | 4.9232 | 4.9304 | 3606260.0 |
| 2007-08-31 13:30:00 | AAPL | Stock | 4.9307 | 4.9318 | 4.9214 | 4.9221 | 4744768.0 |
| 2007-08-31 13:35:00 | AAPL | Stock | 4.9229 | 4.9296 | 4.9223 | 4.9257 | 3482024.0 |
> showing 50 of 290,700 rows — these rows as CSV