PREVIEW / stock_5min / 2007-12-24
file: by_date/stock_5min/2007/2007-12-24.parquet size: 2.6 MB rows: 180,574 symbols: 3,205
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-12-24 04:25:00 | AAPL | Stock | 6.8757 | 6.8757 | 6.8757 | 6.8757 | 26600.0 |
| 2007-12-24 07:05:00 | AAPL | Stock | 6.8757 | 6.9107 | 6.8757 | 6.9107 | 11200.0 |
| 2007-12-24 07:10:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 9800.0 |
| 2007-12-24 07:15:00 | AAPL | Stock | 6.9107 | 6.9464 | 6.9107 | 6.9464 | 148400.0 |
| 2007-12-24 07:40:00 | AAPL | Stock | 6.9464 | 6.9464 | 6.9464 | 6.9464 | 39200.0 |
| 2007-12-24 07:45:00 | AAPL | Stock | 6.9339 | 6.9371 | 6.9339 | 6.9371 | 5600.0 |
| 2007-12-24 07:50:00 | AAPL | Stock | 6.9464 | 6.9464 | 6.9389 | 6.9389 | 27608.0 |
| 2007-12-24 07:55:00 | AAPL | Stock | 6.9429 | 6.9429 | 6.9429 | 6.9429 | 11200.0 |
| 2007-12-24 08:00:00 | AAPL | Stock | 6.9429 | 6.9532 | 6.9286 | 6.9464 | 731864.0 |
| 2007-12-24 08:05:00 | AAPL | Stock | 6.945 | 6.9593 | 6.945 | 6.9536 | 799008.0 |
| 2007-12-24 08:10:00 | AAPL | Stock | 6.9536 | 6.9564 | 6.9514 | 6.9536 | 104524.0 |
| 2007-12-24 08:15:00 | AAPL | Stock | 6.9543 | 6.9546 | 6.9464 | 6.9489 | 291816.0 |
| 2007-12-24 08:20:00 | AAPL | Stock | 6.9489 | 6.9589 | 6.9489 | 6.9536 | 145964.0 |
| 2007-12-24 08:25:00 | AAPL | Stock | 6.9536 | 6.9564 | 6.9536 | 6.9557 | 139720.0 |
| 2007-12-24 08:30:00 | AAPL | Stock | 6.9525 | 6.9554 | 6.9464 | 6.9536 | 113400.0 |
| 2007-12-24 08:35:00 | AAPL | Stock | 6.9536 | 6.9604 | 6.9518 | 6.9596 | 324016.0 |
| 2007-12-24 08:40:00 | AAPL | Stock | 6.9571 | 6.9596 | 6.9561 | 6.9586 | 286832.0 |
| 2007-12-24 08:45:00 | AAPL | Stock | 6.9586 | 6.9639 | 6.9554 | 6.9639 | 864052.0 |
| 2007-12-24 08:50:00 | AAPL | Stock | 6.9596 | 6.9825 | 6.9596 | 6.9782 | 1060276.0 |
| 2007-12-24 08:55:00 | AAPL | Stock | 6.9786 | 6.9857 | 6.9714 | 6.9786 | 1216040.0 |
| 2007-12-24 09:00:00 | AAPL | Stock | 6.9786 | 6.9818 | 6.9768 | 6.9789 | 910896.0 |
| 2007-12-24 09:05:00 | AAPL | Stock | 6.9793 | 6.9807 | 6.975 | 6.9782 | 524300.0 |
| 2007-12-24 09:10:00 | AAPL | Stock | 6.9782 | 6.9818 | 6.9254 | 6.9818 | 10813740.0 |
| 2007-12-24 09:15:00 | AAPL | Stock | 6.9807 | 6.9818 | 6.9696 | 6.9704 | 611436.0 |
| 2007-12-24 09:20:00 | AAPL | Stock | 6.9714 | 6.9761 | 6.9714 | 6.9732 | 212184.0 |
| 2007-12-24 09:25:00 | AAPL | Stock | 6.9732 | 6.9775 | 6.9646 | 6.9646 | 522564.0 |
| 2007-12-24 09:30:00 | AAPL | Stock | 6.9654 | 6.9986 | 6.9568 | 6.9646 | 23893996.0 |
| 2007-12-24 09:35:00 | AAPL | Stock | 6.964 | 6.9779 | 6.9607 | 6.9671 | 14848484.0 |
| 2007-12-24 09:40:00 | AAPL | Stock | 6.9661 | 6.9743 | 6.9604 | 6.9689 | 11857692.0 |
| 2007-12-24 09:45:00 | AAPL | Stock | 6.9682 | 7.0054 | 6.9675 | 7.0018 | 21346080.0 |
| 2007-12-24 09:50:00 | AAPL | Stock | 7.0011 | 7.0029 | 6.9893 | 6.9956 | 11009684.0 |
| 2007-12-24 09:55:00 | AAPL | Stock | 6.9964 | 7.0039 | 6.9893 | 7.0039 | 8885548.0 |
| 2007-12-24 10:00:00 | AAPL | Stock | 7.0025 | 7.0396 | 7.0025 | 7.0386 | 23050860.0 |
| 2007-12-24 10:05:00 | AAPL | Stock | 7.0386 | 7.0557 | 7.0289 | 7.0557 | 17811584.0 |
| 2007-12-24 10:10:00 | AAPL | Stock | 7.0543 | 7.0568 | 7.0336 | 7.0436 | 13486928.0 |
| 2007-12-24 10:15:00 | AAPL | Stock | 7.0436 | 7.0489 | 7.0364 | 7.0407 | 7292432.0 |
| 2007-12-24 10:20:00 | AAPL | Stock | 7.04 | 7.05 | 7.0382 | 7.05 | 8028132.0 |
| 2007-12-24 10:25:00 | AAPL | Stock | 7.05 | 7.0536 | 7.0421 | 7.0429 | 8422204.0 |
| 2007-12-24 10:30:00 | AAPL | Stock | 7.0425 | 7.05 | 7.0357 | 7.0421 | 8695064.0 |
| 2007-12-24 10:35:00 | AAPL | Stock | 7.0425 | 7.0564 | 7.0371 | 7.0461 | 8815800.0 |
| 2007-12-24 10:40:00 | AAPL | Stock | 7.045 | 7.0525 | 7.0411 | 7.0464 | 4844252.0 |
| 2007-12-24 10:45:00 | AAPL | Stock | 7.0468 | 7.0471 | 7.0379 | 7.0386 | 5878012.0 |
| 2007-12-24 10:50:00 | AAPL | Stock | 7.0386 | 7.0496 | 7.0357 | 7.0357 | 8315048.0 |
| 2007-12-24 10:55:00 | AAPL | Stock | 7.0357 | 7.0579 | 7.0357 | 7.0564 | 11147948.0 |
| 2007-12-24 11:00:00 | AAPL | Stock | 7.0564 | 7.0711 | 7.0518 | 7.0711 | 11899160.0 |
| 2007-12-24 11:05:00 | AAPL | Stock | 7.0707 | 7.0839 | 7.0643 | 7.0821 | 14049924.0 |
| 2007-12-24 11:10:00 | AAPL | Stock | 7.0825 | 7.0836 | 7.0671 | 7.0721 | 11271624.0 |
| 2007-12-24 11:15:00 | AAPL | Stock | 7.0718 | 7.0786 | 7.0675 | 7.0693 | 7126476.0 |
| 2007-12-24 11:20:00 | AAPL | Stock | 7.0691 | 7.0771 | 7.0687 | 7.0711 | 6267912.0 |
| 2007-12-24 11:25:00 | AAPL | Stock | 7.0714 | 7.0746 | 7.0636 | 7.0707 | 6748952.0 |
> showing 50 of 180,574 rows — these rows as CSV