PREVIEW / stock_5min / 2006-01-18
file: by_date/stock_5min/2006/2006-01-18.parquet size: 3.0 MB rows: 216,696 symbols: 2,166
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-01-18 06:20:00 | AAPL | Stock | 2.9321 | 2.9429 | 2.9321 | 2.9429 | 22400.0 |
| 2006-01-18 06:45:00 | AAPL | Stock | 2.9411 | 2.9411 | 2.9411 | 2.9411 | 2800.0 |
| 2006-01-18 06:50:00 | AAPL | Stock | 2.9393 | 2.9393 | 2.9393 | 2.9393 | 5600.0 |
| 2006-01-18 06:55:00 | AAPL | Stock | 2.9411 | 2.9429 | 2.9411 | 2.9429 | 8400.0 |
| 2006-01-18 07:00:00 | AAPL | Stock | 2.9446 | 2.9446 | 2.9446 | 2.9446 | 18200.0 |
| 2006-01-18 07:05:00 | AAPL | Stock | 2.9446 | 2.9446 | 2.9446 | 2.9446 | 2800.0 |
| 2006-01-18 07:10:00 | AAPL | Stock | 2.9464 | 2.9464 | 2.9464 | 2.9464 | 8400.0 |
| 2006-01-18 07:15:00 | AAPL | Stock | 2.9429 | 2.9429 | 2.9425 | 2.9429 | 77000.0 |
| 2006-01-18 07:20:00 | AAPL | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 8400.0 |
| 2006-01-18 07:25:00 | AAPL | Stock | 2.9536 | 2.9586 | 2.9536 | 2.9571 | 72800.0 |
| 2006-01-18 07:30:00 | AAPL | Stock | 2.9586 | 2.9586 | 2.9586 | 2.9586 | 56000.0 |
| 2006-01-18 07:35:00 | AAPL | Stock | 2.9571 | 2.9571 | 2.9571 | 2.9571 | 28000.0 |
| 2006-01-18 07:40:00 | AAPL | Stock | 2.9571 | 2.9571 | 2.9571 | 2.9571 | 50400.0 |
| 2006-01-18 07:45:00 | AAPL | Stock | 2.9589 | 2.9607 | 2.9536 | 2.9571 | 92400.0 |
| 2006-01-18 07:50:00 | AAPL | Stock | 2.9536 | 2.9536 | 2.9536 | 2.9536 | 2800.0 |
| 2006-01-18 07:55:00 | AAPL | Stock | 2.9579 | 2.9579 | 2.9536 | 2.9557 | 11396.0 |
| 2006-01-18 08:00:00 | AAPL | Stock | 2.9589 | 2.9714 | 2.9511 | 2.9679 | 1392356.0 |
| 2006-01-18 08:05:00 | AAPL | Stock | 2.9671 | 2.9671 | 2.9582 | 2.9604 | 1384124.0 |
| 2006-01-18 08:10:00 | AAPL | Stock | 2.96 | 2.9604 | 2.9464 | 2.9496 | 1773324.0 |
| 2006-01-18 08:15:00 | AAPL | Stock | 2.9482 | 2.95 | 2.9446 | 2.9464 | 1031352.0 |
| 2006-01-18 08:20:00 | AAPL | Stock | 2.9461 | 2.9571 | 2.9461 | 2.9571 | 645988.0 |
| 2006-01-18 08:25:00 | AAPL | Stock | 2.9589 | 2.9625 | 2.9532 | 2.9554 | 644868.0 |
| 2006-01-18 08:30:00 | AAPL | Stock | 2.9557 | 2.9632 | 2.9557 | 2.9589 | 954716.0 |
| 2006-01-18 08:35:00 | AAPL | Stock | 2.9586 | 2.9596 | 2.95 | 2.95 | 547932.0 |
| 2006-01-18 08:40:00 | AAPL | Stock | 2.9496 | 2.9536 | 2.9446 | 2.9532 | 1081780.0 |
| 2006-01-18 08:45:00 | AAPL | Stock | 2.9539 | 2.9589 | 2.9539 | 2.9571 | 1712760.0 |
| 2006-01-18 08:50:00 | AAPL | Stock | 2.9579 | 2.9625 | 2.9575 | 2.9621 | 487900.0 |
| 2006-01-18 08:55:00 | AAPL | Stock | 2.9625 | 2.9721 | 2.9607 | 2.9707 | 1016876.0 |
| 2006-01-18 09:00:00 | AAPL | Stock | 2.9704 | 2.9711 | 2.9654 | 2.9689 | 838460.0 |
| 2006-01-18 09:05:00 | AAPL | Stock | 2.9686 | 2.9696 | 2.9636 | 2.9661 | 621628.0 |
| 2006-01-18 09:10:00 | AAPL | Stock | 2.9671 | 2.9711 | 2.9643 | 2.9675 | 942480.0 |
| 2006-01-18 09:15:00 | AAPL | Stock | 2.9664 | 2.9689 | 2.9614 | 2.9657 | 1259328.0 |
| 2006-01-18 09:20:00 | AAPL | Stock | 2.9668 | 2.9689 | 2.9646 | 2.9689 | 364672.0 |
| 2006-01-18 09:25:00 | AAPL | Stock | 2.9686 | 2.9761 | 2.9654 | 2.9654 | 3226244.0 |
| 2006-01-18 09:30:00 | AAPL | Stock | 2.9671 | 2.9771 | 2.9286 | 2.9314 | 50819524.0 |
| 2006-01-18 09:35:00 | AAPL | Stock | 2.9314 | 2.9704 | 2.9232 | 2.9407 | 42104692.0 |
| 2006-01-18 09:40:00 | AAPL | Stock | 2.9407 | 2.9725 | 2.9355 | 2.9657 | 34881112.0 |
| 2006-01-18 09:45:00 | AAPL | Stock | 2.9657 | 2.9789 | 2.9641 | 2.9779 | 23132816.0 |
| 2006-01-18 09:50:00 | AAPL | Stock | 2.9779 | 2.9882 | 2.9732 | 2.9754 | 20969172.0 |
| 2006-01-18 09:55:00 | AAPL | Stock | 2.9754 | 2.9854 | 2.9679 | 2.9725 | 17215128.0 |
| 2006-01-18 10:00:00 | AAPL | Stock | 2.9721 | 2.9807 | 2.965 | 2.9807 | 12307596.0 |
| 2006-01-18 10:05:00 | AAPL | Stock | 2.9807 | 2.9911 | 2.9754 | 2.9821 | 27948564.0 |
| 2006-01-18 10:10:00 | AAPL | Stock | 2.9821 | 2.985 | 2.9714 | 2.9786 | 14561540.0 |
| 2006-01-18 10:15:00 | AAPL | Stock | 2.9786 | 2.9896 | 2.9761 | 2.9875 | 11731188.0 |
| 2006-01-18 10:20:00 | AAPL | Stock | 2.9875 | 3.0018 | 2.9829 | 2.9993 | 28400820.0 |
| 2006-01-18 10:25:00 | AAPL | Stock | 2.9986 | 3.0011 | 2.9893 | 2.9946 | 10858428.0 |
| 2006-01-18 10:30:00 | AAPL | Stock | 2.9946 | 3.0 | 2.9861 | 2.9904 | 9911132.0 |
| 2006-01-18 10:35:00 | AAPL | Stock | 2.9899 | 2.9939 | 2.9861 | 2.9896 | 7433944.0 |
| 2006-01-18 10:40:00 | AAPL | Stock | 2.9911 | 2.9932 | 2.9839 | 2.9921 | 8829884.0 |
| 2006-01-18 10:45:00 | AAPL | Stock | 2.9918 | 3.0 | 2.9914 | 2.9954 | 10292604.0 |
> showing 50 of 216,696 rows — these rows as CSV