PREVIEW / stock_5min / 2006-12-22
file: by_date/stock_5min/2006/2006-12-22.parquet size: 3.1 MB rows: 231,513 symbols: 2,461
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-22 04:15:00 | AAPL | Stock | 2.9675 | 2.9675 | 2.9643 | 2.9643 | 19600.0 |
| 2006-12-22 07:00:00 | AAPL | Stock | 2.9614 | 2.9693 | 2.9614 | 2.9693 | 56000.0 |
| 2006-12-22 07:10:00 | AAPL | Stock | 2.9693 | 2.9693 | 2.9693 | 2.9693 | 19600.0 |
| 2006-12-22 07:30:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 56000.0 |
| 2006-12-22 07:50:00 | AAPL | Stock | 2.9707 | 2.9711 | 2.9707 | 2.9711 | 26600.0 |
| 2006-12-22 08:00:00 | AAPL | Stock | 2.9711 | 2.9711 | 2.9643 | 2.9682 | 104580.0 |
| 2006-12-22 08:05:00 | AAPL | Stock | 2.9643 | 2.9675 | 2.9643 | 2.9675 | 133560.0 |
| 2006-12-22 08:10:00 | AAPL | Stock | 2.9671 | 2.9675 | 2.9664 | 2.9675 | 23520.0 |
| 2006-12-22 08:15:00 | AAPL | Stock | 2.9686 | 2.9696 | 2.9686 | 2.9696 | 129500.0 |
| 2006-12-22 08:20:00 | AAPL | Stock | 2.9707 | 2.9786 | 2.9707 | 2.9771 | 283780.0 |
| 2006-12-22 08:25:00 | AAPL | Stock | 2.9771 | 2.9779 | 2.9714 | 2.9732 | 342440.0 |
| 2006-12-22 08:30:00 | AAPL | Stock | 2.9732 | 2.9768 | 2.9714 | 2.975 | 133700.0 |
| 2006-12-22 08:35:00 | AAPL | Stock | 2.9732 | 2.9768 | 2.9721 | 2.975 | 320264.0 |
| 2006-12-22 08:40:00 | AAPL | Stock | 2.975 | 2.9889 | 2.975 | 2.9882 | 637560.0 |
| 2006-12-22 08:45:00 | AAPL | Stock | 2.9861 | 2.9875 | 2.9861 | 2.9871 | 126980.0 |
| 2006-12-22 08:50:00 | AAPL | Stock | 2.9871 | 2.9886 | 2.9868 | 2.9868 | 63560.0 |
| 2006-12-22 08:55:00 | AAPL | Stock | 2.9875 | 2.9882 | 2.9839 | 2.9839 | 440580.0 |
| 2006-12-22 09:00:00 | AAPL | Stock | 2.9839 | 2.9839 | 2.9786 | 2.9786 | 128184.0 |
| 2006-12-22 09:05:00 | AAPL | Stock | 2.9811 | 2.9818 | 2.9786 | 2.9818 | 161000.0 |
| 2006-12-22 09:10:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9804 | 2.9804 | 58800.0 |
| 2006-12-22 09:15:00 | AAPL | Stock | 2.9789 | 2.9814 | 2.9786 | 2.9786 | 42756.0 |
| 2006-12-22 09:20:00 | AAPL | Stock | 2.9804 | 2.9804 | 2.9804 | 2.9804 | 27384.0 |
| 2006-12-22 09:25:00 | AAPL | Stock | 2.9786 | 2.98 | 2.975 | 2.98 | 137144.0 |
| 2006-12-22 09:30:00 | AAPL | Stock | 2.9807 | 2.9864 | 2.9707 | 2.9714 | 14931140.0 |
| 2006-12-22 09:35:00 | AAPL | Stock | 2.9725 | 2.9729 | 2.9486 | 2.9539 | 14716408.0 |
| 2006-12-22 09:40:00 | AAPL | Stock | 2.9539 | 2.9571 | 2.9143 | 2.9332 | 29238384.0 |
| 2006-12-22 09:45:00 | AAPL | Stock | 2.9336 | 2.9493 | 2.9286 | 2.9493 | 15523060.0 |
| 2006-12-22 09:50:00 | AAPL | Stock | 2.9493 | 2.9732 | 2.9482 | 2.9646 | 20024536.0 |
| 2006-12-22 09:55:00 | AAPL | Stock | 2.965 | 2.9711 | 2.9593 | 2.9636 | 13836648.0 |
| 2006-12-22 10:00:00 | AAPL | Stock | 2.9639 | 2.9714 | 2.9579 | 2.96 | 13801704.0 |
| 2006-12-22 10:05:00 | AAPL | Stock | 2.9597 | 2.9925 | 2.9593 | 2.9921 | 22617532.0 |
| 2006-12-22 10:10:00 | AAPL | Stock | 2.9914 | 2.9979 | 2.9811 | 2.9904 | 21182952.0 |
| 2006-12-22 10:15:00 | AAPL | Stock | 2.99 | 2.99 | 2.9832 | 2.9868 | 10803408.0 |
| 2006-12-22 10:20:00 | AAPL | Stock | 2.9864 | 2.9982 | 2.9839 | 2.9964 | 13365492.0 |
| 2006-12-22 10:25:00 | AAPL | Stock | 2.9968 | 3.0014 | 2.9911 | 3.0 | 18511528.0 |
| 2006-12-22 10:30:00 | AAPL | Stock | 2.9996 | 3.0004 | 2.9929 | 2.9971 | 11050480.0 |
| 2006-12-22 10:35:00 | AAPL | Stock | 2.9971 | 2.9979 | 2.9857 | 2.9882 | 12749632.0 |
| 2006-12-22 10:40:00 | AAPL | Stock | 2.9886 | 2.9889 | 2.98 | 2.98 | 10394804.0 |
| 2006-12-22 10:45:00 | AAPL | Stock | 2.9804 | 2.985 | 2.9775 | 2.9836 | 7804608.0 |
| 2006-12-22 10:50:00 | AAPL | Stock | 2.9839 | 2.9875 | 2.9786 | 2.9811 | 13034420.0 |
| 2006-12-22 10:55:00 | AAPL | Stock | 2.9811 | 2.9839 | 2.9732 | 2.9771 | 7228760.0 |
| 2006-12-22 11:00:00 | AAPL | Stock | 2.9774 | 2.9821 | 2.9771 | 2.9807 | 4940796.0 |
| 2006-12-22 11:05:00 | AAPL | Stock | 2.9807 | 2.9839 | 2.9804 | 2.9814 | 5232584.0 |
| 2006-12-22 11:10:00 | AAPL | Stock | 2.9814 | 2.9814 | 2.9689 | 2.971 | 8830108.0 |
| 2006-12-22 11:15:00 | AAPL | Stock | 2.9711 | 2.9771 | 2.97 | 2.974 | 5310284.0 |
| 2006-12-22 11:20:00 | AAPL | Stock | 2.974 | 2.9768 | 2.9518 | 2.9739 | 5481364.0 |
| 2006-12-22 11:25:00 | AAPL | Stock | 2.9743 | 2.9754 | 2.9682 | 2.9704 | 5464088.0 |
| 2006-12-22 11:30:00 | AAPL | Stock | 2.97 | 2.9743 | 2.9686 | 2.9743 | 5077156.0 |
| 2006-12-22 11:35:00 | AAPL | Stock | 2.9743 | 2.9839 | 2.9718 | 2.9807 | 9864344.0 |
| 2006-12-22 11:40:00 | AAPL | Stock | 2.9807 | 2.9857 | 2.9789 | 2.9821 | 5934572.0 |
> showing 50 of 231,513 rows — these rows as CSV