PREVIEW / stock_5min / 2010-02-11
file: by_date/stock_5min/2010/2010-02-11.parquet size: 4.6 MB rows: 318,138 symbols: 3,414
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-11 06:15:00 | AAPL | Stock | 6.9682 | 6.9821 | 6.9643 | 6.9821 | 44324.0 |
| 2010-02-11 07:10:00 | AAPL | Stock | 7.0011 | 7.0011 | 7.0011 | 7.0011 | 5600.0 |
| 2010-02-11 07:15:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9864 | 6.9864 | 56000.0 |
| 2010-02-11 07:20:00 | AAPL | Stock | 6.9886 | 6.9886 | 6.9886 | 6.9886 | 2800.0 |
| 2010-02-11 07:30:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.9911 | 6.9911 | 5600.0 |
| 2010-02-11 07:35:00 | AAPL | Stock | 6.9996 | 7.0014 | 6.9996 | 7.0 | 25200.0 |
| 2010-02-11 07:40:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 41132.0 |
| 2010-02-11 07:50:00 | AAPL | Stock | 6.9979 | 6.9979 | 6.9979 | 6.9979 | 2800.0 |
| 2010-02-11 08:00:00 | AAPL | Stock | 6.9893 | 6.9954 | 6.9889 | 6.9889 | 112000.0 |
| 2010-02-11 08:05:00 | AAPL | Stock | 6.9861 | 6.9911 | 6.9818 | 6.9911 | 163380.0 |
| 2010-02-11 08:10:00 | AAPL | Stock | 6.9829 | 6.9871 | 6.9793 | 6.9798 | 54600.0 |
| 2010-02-11 08:15:00 | AAPL | Stock | 6.9796 | 6.9862 | 6.975 | 6.9854 | 61600.0 |
| 2010-02-11 08:20:00 | AAPL | Stock | 6.98 | 6.9825 | 6.9786 | 6.9821 | 117012.0 |
| 2010-02-11 08:25:00 | AAPL | Stock | 6.9825 | 6.9854 | 6.9821 | 6.9832 | 168280.0 |
| 2010-02-11 08:30:00 | AAPL | Stock | 6.9889 | 6.9961 | 6.9857 | 6.9879 | 319256.0 |
| 2010-02-11 08:35:00 | AAPL | Stock | 6.9896 | 6.9896 | 6.9811 | 6.9821 | 134960.0 |
| 2010-02-11 08:40:00 | AAPL | Stock | 6.9821 | 6.9875 | 6.9821 | 6.9875 | 58800.0 |
| 2010-02-11 08:45:00 | AAPL | Stock | 6.9857 | 6.9871 | 6.9839 | 6.9839 | 75320.0 |
| 2010-02-11 08:50:00 | AAPL | Stock | 6.9839 | 6.9854 | 6.9804 | 6.9821 | 69300.0 |
| 2010-02-11 08:55:00 | AAPL | Stock | 6.9829 | 6.9829 | 6.9782 | 6.9782 | 467068.0 |
| 2010-02-11 09:00:00 | AAPL | Stock | 6.9782 | 6.9818 | 6.9689 | 6.9786 | 714028.0 |
| 2010-02-11 09:05:00 | AAPL | Stock | 6.9796 | 6.9832 | 6.9711 | 6.9732 | 361480.0 |
| 2010-02-11 09:10:00 | AAPL | Stock | 6.9732 | 6.9743 | 6.9686 | 6.9732 | 219884.0 |
| 2010-02-11 09:15:00 | AAPL | Stock | 6.9739 | 6.9782 | 6.9696 | 6.9782 | 70280.0 |
| 2010-02-11 09:20:00 | AAPL | Stock | 6.9754 | 6.9768 | 6.9721 | 6.9736 | 108052.0 |
| 2010-02-11 09:25:00 | AAPL | Stock | 6.9761 | 6.9786 | 6.96 | 6.9671 | 523152.0 |
| 2010-02-11 09:30:00 | AAPL | Stock | 6.9607 | 6.9768 | 6.9489 | 6.9711 | 10799600.0 |
| 2010-02-11 09:35:00 | AAPL | Stock | 6.9718 | 6.9871 | 6.9575 | 6.9746 | 10418268.0 |
| 2010-02-11 09:40:00 | AAPL | Stock | 6.9736 | 6.9779 | 6.9529 | 6.9614 | 8294720.0 |
| 2010-02-11 09:45:00 | AAPL | Stock | 6.9607 | 6.9675 | 6.9486 | 6.9607 | 9288860.0 |
| 2010-02-11 09:50:00 | AAPL | Stock | 6.9607 | 6.9625 | 6.9439 | 6.9456 | 8364580.0 |
| 2010-02-11 09:55:00 | AAPL | Stock | 6.9457 | 6.968 | 6.9429 | 6.9582 | 8675072.0 |
| 2010-02-11 10:00:00 | AAPL | Stock | 6.9586 | 6.9587 | 6.9307 | 6.9421 | 11117988.0 |
| 2010-02-11 10:05:00 | AAPL | Stock | 6.9418 | 6.9714 | 6.94 | 6.9607 | 9022580.0 |
| 2010-02-11 10:10:00 | AAPL | Stock | 6.9621 | 6.9821 | 6.9607 | 6.9614 | 8826776.0 |
| 2010-02-11 10:15:00 | AAPL | Stock | 6.9643 | 6.9736 | 6.9579 | 6.9656 | 4071284.0 |
| 2010-02-11 10:20:00 | AAPL | Stock | 6.9665 | 6.9732 | 6.9571 | 6.9664 | 5098016.0 |
| 2010-02-11 10:25:00 | AAPL | Stock | 6.9647 | 6.975 | 6.9643 | 6.9707 | 4032840.0 |
| 2010-02-11 10:30:00 | AAPL | Stock | 6.9711 | 6.9732 | 6.9546 | 6.9604 | 4666116.0 |
| 2010-02-11 10:35:00 | AAPL | Stock | 6.9604 | 6.9714 | 6.9536 | 6.9671 | 4232088.0 |
| 2010-02-11 10:40:00 | AAPL | Stock | 6.9673 | 6.97 | 6.9579 | 6.9646 | 3856440.0 |
| 2010-02-11 10:45:00 | AAPL | Stock | 6.9646 | 6.9732 | 6.9589 | 6.97 | 5869668.0 |
| 2010-02-11 10:50:00 | AAPL | Stock | 6.9693 | 6.9711 | 6.9554 | 6.9636 | 5831644.0 |
| 2010-02-11 10:55:00 | AAPL | Stock | 6.9633 | 6.9679 | 6.9554 | 6.9604 | 3515652.0 |
| 2010-02-11 11:00:00 | AAPL | Stock | 6.9593 | 6.9732 | 6.9593 | 6.9626 | 4877320.0 |
| 2010-02-11 11:05:00 | AAPL | Stock | 6.9675 | 6.9768 | 6.9589 | 6.9679 | 6097616.0 |
| 2010-02-11 11:10:00 | AAPL | Stock | 6.968 | 6.9943 | 6.9679 | 6.9907 | 10265304.0 |
| 2010-02-11 11:15:00 | AAPL | Stock | 6.9907 | 7.0086 | 6.9893 | 7.0021 | 10252564.0 |
| 2010-02-11 11:20:00 | AAPL | Stock | 7.0029 | 7.0418 | 7.0011 | 7.0339 | 16148636.0 |
| 2010-02-11 11:25:00 | AAPL | Stock | 7.035 | 7.0532 | 7.0339 | 7.0518 | 11106284.0 |
> showing 50 of 318,138 rows — these rows as CSV