PREVIEW / stock_5min / 2007-07-16
file: by_date/stock_5min/2007/2007-07-16.parquet size: 4.1 MB rows: 297,177 symbols: 3,070
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-07-16 09:30:00 | AAPL | Stock | 4.9425 | 4.9786 | 4.9289 | 4.975 | 41165908.0 |
| 2007-07-16 09:35:00 | AAPL | Stock | 4.9746 | 4.9761 | 4.9643 | 4.9704 | 30801288.0 |
| 2007-07-16 09:40:00 | AAPL | Stock | 4.97 | 4.9964 | 4.9679 | 4.9952 | 37930704.0 |
| 2007-07-16 09:45:00 | AAPL | Stock | 4.995 | 4.9993 | 4.9654 | 4.9729 | 39955412.0 |
| 2007-07-16 09:50:00 | AAPL | Stock | 4.9729 | 4.9789 | 4.9611 | 4.9614 | 26917296.0 |
| 2007-07-16 09:55:00 | AAPL | Stock | 4.9621 | 4.9711 | 4.94 | 4.9493 | 32345656.0 |
| 2007-07-16 10:00:00 | AAPL | Stock | 4.9514 | 4.9639 | 4.9432 | 4.955 | 27238064.0 |
| 2007-07-16 10:05:00 | AAPL | Stock | 4.9554 | 4.9586 | 4.9414 | 4.9504 | 22642088.0 |
| 2007-07-16 10:10:00 | AAPL | Stock | 4.9504 | 4.9511 | 4.9382 | 4.9464 | 26834752.0 |
| 2007-07-16 10:15:00 | AAPL | Stock | 4.9464 | 4.9496 | 4.9368 | 4.9496 | 19802160.0 |
| 2007-07-16 10:20:00 | AAPL | Stock | 4.9491 | 4.9554 | 4.9414 | 4.9464 | 18050536.0 |
| 2007-07-16 10:25:00 | AAPL | Stock | 4.9464 | 4.9564 | 4.9411 | 4.955 | 12410216.0 |
| 2007-07-16 10:30:00 | AAPL | Stock | 4.955 | 4.9686 | 4.955 | 4.9611 | 16985052.0 |
| 2007-07-16 10:35:00 | AAPL | Stock | 4.9614 | 4.9654 | 4.9504 | 4.9514 | 12144860.0 |
| 2007-07-16 10:40:00 | AAPL | Stock | 4.9511 | 4.9582 | 4.9436 | 4.9561 | 10864000.0 |
| 2007-07-16 10:45:00 | AAPL | Stock | 4.9561 | 4.9739 | 4.9525 | 4.9732 | 15510096.0 |
| 2007-07-16 10:50:00 | AAPL | Stock | 4.9736 | 4.9882 | 4.9617 | 4.9793 | 22264592.0 |
| 2007-07-16 10:55:00 | AAPL | Stock | 4.9793 | 4.9818 | 4.9725 | 4.9729 | 10517752.0 |
| 2007-07-16 11:00:00 | AAPL | Stock | 4.9734 | 4.9775 | 4.9657 | 4.9761 | 8806420.0 |
| 2007-07-16 11:05:00 | AAPL | Stock | 4.9761 | 4.9804 | 4.9729 | 4.9804 | 6481216.0 |
| 2007-07-16 11:10:00 | AAPL | Stock | 4.9804 | 4.9811 | 4.9743 | 4.9779 | 5048736.0 |
| 2007-07-16 11:15:00 | AAPL | Stock | 4.9779 | 4.9857 | 4.9768 | 4.9857 | 8871744.0 |
| 2007-07-16 11:20:00 | AAPL | Stock | 4.9857 | 4.9882 | 4.98 | 4.9806 | 9016140.0 |
| 2007-07-16 11:25:00 | AAPL | Stock | 4.9807 | 4.9879 | 4.9796 | 4.9821 | 9149224.0 |
| 2007-07-16 11:30:00 | AAPL | Stock | 4.9825 | 4.9843 | 4.9754 | 4.9771 | 6609064.0 |
| 2007-07-16 11:35:00 | AAPL | Stock | 4.9775 | 4.9775 | 4.9729 | 4.9744 | 6989024.0 |
| 2007-07-16 11:40:00 | AAPL | Stock | 4.9743 | 4.9754 | 4.9643 | 4.9707 | 12090400.0 |
| 2007-07-16 11:45:00 | AAPL | Stock | 4.9707 | 4.9782 | 4.9704 | 4.9754 | 7745724.0 |
| 2007-07-16 11:50:00 | AAPL | Stock | 4.9754 | 4.9771 | 4.9721 | 4.9757 | 4680116.0 |
| 2007-07-16 11:55:00 | AAPL | Stock | 4.9761 | 4.9789 | 4.975 | 4.9754 | 3445736.0 |
| 2007-07-16 12:00:00 | AAPL | Stock | 4.9757 | 4.9768 | 4.9736 | 4.9739 | 3509240.0 |
| 2007-07-16 12:05:00 | AAPL | Stock | 4.9741 | 4.9789 | 4.9739 | 4.9774 | 2893072.0 |
| 2007-07-16 12:10:00 | AAPL | Stock | 4.9775 | 4.9779 | 4.9718 | 4.9722 | 3521252.0 |
| 2007-07-16 12:15:00 | AAPL | Stock | 4.9721 | 4.9732 | 4.9639 | 4.9664 | 9104396.0 |
| 2007-07-16 12:20:00 | AAPL | Stock | 4.9664 | 4.9682 | 4.9611 | 4.9614 | 8164212.0 |
| 2007-07-16 12:25:00 | AAPL | Stock | 4.9611 | 4.9629 | 4.9561 | 4.9611 | 11293380.0 |
| 2007-07-16 12:30:00 | AAPL | Stock | 4.9611 | 4.9711 | 4.9611 | 4.9682 | 6541248.0 |
| 2007-07-16 12:35:00 | AAPL | Stock | 4.9689 | 4.9707 | 4.9639 | 4.9661 | 4200616.0 |
| 2007-07-16 12:40:00 | AAPL | Stock | 4.9664 | 4.9679 | 4.9639 | 4.9668 | 3690148.0 |
| 2007-07-16 12:45:00 | AAPL | Stock | 4.9668 | 4.9711 | 4.9668 | 4.9696 | 2826908.0 |
| 2007-07-16 12:50:00 | AAPL | Stock | 4.97 | 4.9707 | 4.965 | 4.965 | 2816968.0 |
| 2007-07-16 12:55:00 | AAPL | Stock | 4.965 | 4.9664 | 4.9636 | 4.9654 | 3807860.0 |
| 2007-07-16 13:00:00 | AAPL | Stock | 4.9654 | 4.9725 | 4.9654 | 4.97 | 3327548.0 |
| 2007-07-16 13:05:00 | AAPL | Stock | 4.9696 | 4.9704 | 4.9582 | 4.9589 | 6728344.0 |
| 2007-07-16 13:10:00 | AAPL | Stock | 4.9589 | 4.9639 | 4.9554 | 4.9554 | 6679512.0 |
| 2007-07-16 13:15:00 | AAPL | Stock | 4.9554 | 4.9575 | 4.9443 | 4.9489 | 12586532.0 |
| 2007-07-16 13:20:00 | AAPL | Stock | 4.9482 | 4.9554 | 4.9461 | 4.9554 | 5575808.0 |
| 2007-07-16 13:25:00 | AAPL | Stock | 4.955 | 4.9554 | 4.9464 | 4.9479 | 8711948.0 |
| 2007-07-16 13:30:00 | AAPL | Stock | 4.9479 | 4.9493 | 4.9379 | 4.9414 | 19873280.0 |
| 2007-07-16 13:35:00 | AAPL | Stock | 4.9414 | 4.9418 | 4.9214 | 4.9336 | 21764736.0 |
> showing 50 of 297,177 rows — these rows as CSV