PREVIEW / stock_5min / 2007-05-29
file: by_date/stock_5min/2007/2007-05-29.parquet size: 3.9 MB rows: 290,839 symbols: 3,021
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-05-29 09:30:00 | AAPL | Stock | 4.0875 | 4.1021 | 4.0786 | 4.0986 | 22136296.0 |
| 2007-05-29 09:35:00 | AAPL | Stock | 4.0982 | 4.0996 | 4.0757 | 4.0839 | 17880744.0 |
| 2007-05-29 09:40:00 | AAPL | Stock | 4.0836 | 4.0836 | 4.0607 | 4.0643 | 19322212.0 |
| 2007-05-29 09:45:00 | AAPL | Stock | 4.0639 | 4.085 | 4.0589 | 4.0821 | 12680080.0 |
| 2007-05-29 09:50:00 | AAPL | Stock | 4.0818 | 4.0818 | 4.065 | 4.0668 | 12508776.0 |
| 2007-05-29 09:55:00 | AAPL | Stock | 4.0668 | 4.0757 | 4.0561 | 4.063 | 13134576.0 |
| 2007-05-29 10:00:00 | AAPL | Stock | 4.065 | 4.0711 | 4.0579 | 4.0646 | 13707764.0 |
| 2007-05-29 10:05:00 | AAPL | Stock | 4.0639 | 4.0779 | 4.0639 | 4.0764 | 14331604.0 |
| 2007-05-29 10:10:00 | AAPL | Stock | 4.0768 | 4.0768 | 4.0704 | 4.0743 | 8535464.0 |
| 2007-05-29 10:15:00 | AAPL | Stock | 4.0746 | 4.0746 | 4.0593 | 4.065 | 9050860.0 |
| 2007-05-29 10:20:00 | AAPL | Stock | 4.065 | 4.0654 | 4.0489 | 4.0582 | 15261988.0 |
| 2007-05-29 10:25:00 | AAPL | Stock | 4.0575 | 4.0654 | 4.055 | 4.0582 | 6295604.0 |
| 2007-05-29 10:30:00 | AAPL | Stock | 4.0586 | 4.0629 | 4.0536 | 4.0611 | 5328316.0 |
| 2007-05-29 10:35:00 | AAPL | Stock | 4.0604 | 4.0625 | 4.0568 | 4.0592 | 5495588.0 |
| 2007-05-29 10:40:00 | AAPL | Stock | 4.0593 | 4.0711 | 4.0589 | 4.0643 | 8021664.0 |
| 2007-05-29 10:45:00 | AAPL | Stock | 4.0636 | 4.0732 | 4.0636 | 4.0661 | 8587684.0 |
| 2007-05-29 10:50:00 | AAPL | Stock | 4.0661 | 4.0711 | 4.0625 | 4.0661 | 4496324.0 |
| 2007-05-29 10:55:00 | AAPL | Stock | 4.0661 | 4.0679 | 4.0611 | 4.0618 | 5242048.0 |
| 2007-05-29 11:00:00 | AAPL | Stock | 4.0611 | 4.0618 | 4.0475 | 4.0507 | 11329472.0 |
| 2007-05-29 11:05:00 | AAPL | Stock | 4.0507 | 4.0525 | 4.0407 | 4.0479 | 12037424.0 |
| 2007-05-29 11:10:00 | AAPL | Stock | 4.0468 | 4.0518 | 4.0439 | 4.0478 | 6358828.0 |
| 2007-05-29 11:15:00 | AAPL | Stock | 4.0475 | 4.05 | 4.0439 | 4.0471 | 5340440.0 |
| 2007-05-29 11:20:00 | AAPL | Stock | 4.0471 | 4.0521 | 4.0464 | 4.0514 | 4486748.0 |
| 2007-05-29 11:25:00 | AAPL | Stock | 4.0511 | 4.0554 | 4.0482 | 4.0493 | 5345704.0 |
| 2007-05-29 11:30:00 | AAPL | Stock | 4.0493 | 4.0582 | 4.0486 | 4.0557 | 6974716.0 |
| 2007-05-29 11:35:00 | AAPL | Stock | 4.0554 | 4.0575 | 4.0521 | 4.0575 | 6154624.0 |
| 2007-05-29 11:40:00 | AAPL | Stock | 4.0568 | 4.0639 | 4.0568 | 4.0575 | 6995184.0 |
| 2007-05-29 11:45:00 | AAPL | Stock | 4.0575 | 4.0589 | 4.0536 | 4.0546 | 4648056.0 |
| 2007-05-29 11:50:00 | AAPL | Stock | 4.055 | 4.0586 | 4.0536 | 4.0546 | 2617972.0 |
| 2007-05-29 11:55:00 | AAPL | Stock | 4.0539 | 4.055 | 4.0461 | 4.0464 | 5905872.0 |
| 2007-05-29 12:00:00 | AAPL | Stock | 4.0464 | 4.0492 | 4.0429 | 4.0461 | 6904016.0 |
| 2007-05-29 12:05:00 | AAPL | Stock | 4.0454 | 4.05 | 4.045 | 4.0471 | 3123176.0 |
| 2007-05-29 12:10:00 | AAPL | Stock | 4.0468 | 4.0489 | 4.0375 | 4.0382 | 6534976.0 |
| 2007-05-29 12:15:00 | AAPL | Stock | 4.0382 | 4.0389 | 4.0314 | 4.0357 | 9641436.0 |
| 2007-05-29 12:20:00 | AAPL | Stock | 4.0361 | 4.0375 | 4.0311 | 4.0332 | 3825332.0 |
| 2007-05-29 12:25:00 | AAPL | Stock | 4.0331 | 4.0393 | 4.0293 | 4.0301 | 5402292.0 |
| 2007-05-29 12:30:00 | AAPL | Stock | 4.0304 | 4.0321 | 4.0268 | 4.0271 | 7351400.0 |
| 2007-05-29 12:35:00 | AAPL | Stock | 4.0271 | 4.0354 | 4.0268 | 4.0336 | 5276936.0 |
| 2007-05-29 12:40:00 | AAPL | Stock | 4.0339 | 4.0368 | 4.0289 | 4.0339 | 6216476.0 |
| 2007-05-29 12:45:00 | AAPL | Stock | 4.0339 | 4.0446 | 4.0332 | 4.0364 | 6089300.0 |
| 2007-05-29 12:50:00 | AAPL | Stock | 4.0361 | 4.0407 | 4.0361 | 4.0379 | 2854264.0 |
| 2007-05-29 12:55:00 | AAPL | Stock | 4.0379 | 4.0411 | 4.0339 | 4.0404 | 3368204.0 |
| 2007-05-29 13:00:00 | AAPL | Stock | 4.0397 | 4.0411 | 4.0375 | 4.0386 | 2857764.0 |
| 2007-05-29 13:05:00 | AAPL | Stock | 4.0382 | 4.0464 | 4.0375 | 4.0457 | 3279640.0 |
| 2007-05-29 13:10:00 | AAPL | Stock | 4.0457 | 4.0496 | 4.0443 | 4.0464 | 5827444.0 |
| 2007-05-29 13:15:00 | AAPL | Stock | 4.0461 | 4.0471 | 4.0404 | 4.0432 | 4241132.0 |
| 2007-05-29 13:20:00 | AAPL | Stock | 4.0429 | 4.0439 | 4.0279 | 4.0307 | 8987860.0 |
| 2007-05-29 13:25:00 | AAPL | Stock | 4.0307 | 4.0382 | 4.0298 | 4.0364 | 5157012.0 |
| 2007-05-29 13:30:00 | AAPL | Stock | 4.0357 | 4.0364 | 4.0314 | 4.0314 | 3476480.0 |
| 2007-05-29 13:35:00 | AAPL | Stock | 4.0319 | 4.035 | 4.0246 | 4.0261 | 5509196.0 |
> showing 50 of 290,839 rows — these rows as CSV