PREVIEW / stock_5min / 2009-12-16
file: by_date/stock_5min/2009/2009-12-16.parquet size: 4.8 MB rows: 325,532 symbols: 3,438
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-16 07:00:00 | AAPL | Stock | 6.9714 | 6.9714 | 6.9714 | 6.9714 | 2800.0 |
| 2009-12-16 07:05:00 | AAPL | Stock | 6.9654 | 6.9821 | 6.9654 | 6.9821 | 11060.0 |
| 2009-12-16 07:10:00 | AAPL | Stock | 6.9811 | 6.9811 | 6.9811 | 6.9811 | 4200.0 |
| 2009-12-16 07:20:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9889 | 6.9889 | 2800.0 |
| 2009-12-16 07:30:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9793 | 6.9793 | 19600.0 |
| 2009-12-16 07:35:00 | AAPL | Stock | 6.9786 | 6.9829 | 6.9786 | 6.9829 | 21840.0 |
| 2009-12-16 07:45:00 | AAPL | Stock | 6.9829 | 6.985 | 6.9821 | 6.985 | 30800.0 |
| 2009-12-16 07:50:00 | AAPL | Stock | 6.9882 | 6.9889 | 6.9868 | 6.9868 | 47572.0 |
| 2009-12-16 07:55:00 | AAPL | Stock | 6.9882 | 6.9882 | 6.9882 | 6.9882 | 19600.0 |
| 2009-12-16 08:00:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9661 | 6.9661 | 266924.0 |
| 2009-12-16 08:05:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9607 | 6.9639 | 77168.0 |
| 2009-12-16 08:10:00 | AAPL | Stock | 6.9636 | 6.9643 | 6.9518 | 6.9589 | 130060.0 |
| 2009-12-16 08:15:00 | AAPL | Stock | 6.9571 | 6.9636 | 6.9571 | 6.9589 | 35868.0 |
| 2009-12-16 08:20:00 | AAPL | Stock | 6.9596 | 6.9818 | 6.9596 | 6.9718 | 164612.0 |
| 2009-12-16 08:25:00 | AAPL | Stock | 6.9689 | 6.9732 | 6.9689 | 6.9732 | 40292.0 |
| 2009-12-16 08:30:00 | AAPL | Stock | 6.9732 | 6.975 | 6.9643 | 6.9643 | 96600.0 |
| 2009-12-16 08:35:00 | AAPL | Stock | 6.9686 | 6.9732 | 6.9643 | 6.9643 | 139104.0 |
| 2009-12-16 08:40:00 | AAPL | Stock | 6.9643 | 6.9686 | 6.9375 | 6.9686 | 46116.0 |
| 2009-12-16 08:45:00 | AAPL | Stock | 6.9675 | 6.9675 | 6.9625 | 6.9625 | 59752.0 |
| 2009-12-16 08:50:00 | AAPL | Stock | 6.9643 | 6.9668 | 6.9643 | 6.9643 | 52920.0 |
| 2009-12-16 08:55:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9611 | 6.9611 | 26600.0 |
| 2009-12-16 09:00:00 | AAPL | Stock | 6.9625 | 6.9643 | 6.9625 | 6.9625 | 42028.0 |
| 2009-12-16 09:05:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9625 | 6.9643 | 126336.0 |
| 2009-12-16 09:10:00 | AAPL | Stock | 6.9643 | 6.9714 | 6.9643 | 6.9714 | 79184.0 |
| 2009-12-16 09:15:00 | AAPL | Stock | 6.9714 | 6.9729 | 6.9664 | 6.9664 | 158312.0 |
| 2009-12-16 09:20:00 | AAPL | Stock | 6.9682 | 6.9743 | 6.9682 | 6.9696 | 34160.0 |
| 2009-12-16 09:25:00 | AAPL | Stock | 6.9696 | 6.9721 | 6.9643 | 6.9671 | 219856.0 |
| 2009-12-16 09:30:00 | AAPL | Stock | 6.9679 | 6.985 | 6.9643 | 6.9725 | 12741008.0 |
| 2009-12-16 09:35:00 | AAPL | Stock | 6.9725 | 6.975 | 6.9554 | 6.9743 | 11459420.0 |
| 2009-12-16 09:40:00 | AAPL | Stock | 6.9736 | 6.985 | 6.9686 | 6.9782 | 9489872.0 |
| 2009-12-16 09:45:00 | AAPL | Stock | 6.9793 | 7.0054 | 6.9761 | 6.9961 | 12470612.0 |
| 2009-12-16 09:50:00 | AAPL | Stock | 6.9968 | 7.0054 | 6.9871 | 6.99 | 8322384.0 |
| 2009-12-16 09:55:00 | AAPL | Stock | 6.99 | 6.9982 | 6.9896 | 6.9982 | 5037340.0 |
| 2009-12-16 10:00:00 | AAPL | Stock | 6.9982 | 7.0046 | 6.9886 | 6.9936 | 6454392.0 |
| 2009-12-16 10:05:00 | AAPL | Stock | 6.9936 | 7.0018 | 6.9896 | 6.9979 | 6315456.0 |
| 2009-12-16 10:10:00 | AAPL | Stock | 6.9989 | 7.0179 | 6.9986 | 7.011 | 10987060.0 |
| 2009-12-16 10:15:00 | AAPL | Stock | 7.01 | 7.0111 | 6.9929 | 7.0011 | 5649504.0 |
| 2009-12-16 10:20:00 | AAPL | Stock | 7.0011 | 7.0046 | 6.9882 | 6.9993 | 5583256.0 |
| 2009-12-16 10:25:00 | AAPL | Stock | 6.9994 | 6.9994 | 6.9879 | 6.9982 | 3969000.0 |
| 2009-12-16 10:30:00 | AAPL | Stock | 6.9982 | 7.0054 | 6.9929 | 7.0029 | 4486776.0 |
| 2009-12-16 10:35:00 | AAPL | Stock | 7.0029 | 7.0111 | 6.9964 | 6.9989 | 3855460.0 |
| 2009-12-16 10:40:00 | AAPL | Stock | 6.9989 | 7.003 | 6.9946 | 6.9957 | 2888592.0 |
| 2009-12-16 10:45:00 | AAPL | Stock | 6.996 | 6.9979 | 6.9943 | 6.9949 | 1737484.0 |
| 2009-12-16 10:50:00 | AAPL | Stock | 6.995 | 6.9979 | 6.9857 | 6.9889 | 3649884.0 |
| 2009-12-16 10:55:00 | AAPL | Stock | 6.9896 | 6.995 | 6.9861 | 6.9889 | 2304372.0 |
| 2009-12-16 11:00:00 | AAPL | Stock | 6.9884 | 6.9904 | 6.9807 | 6.9843 | 4026820.0 |
| 2009-12-16 11:05:00 | AAPL | Stock | 6.9846 | 6.9911 | 6.9832 | 6.9893 | 2283092.0 |
| 2009-12-16 11:10:00 | AAPL | Stock | 6.9893 | 6.9936 | 6.9893 | 6.9902 | 3462760.0 |
| 2009-12-16 11:15:00 | AAPL | Stock | 6.9896 | 6.9904 | 6.9879 | 6.9889 | 1708812.0 |
| 2009-12-16 11:20:00 | AAPL | Stock | 6.9889 | 6.9982 | 6.9882 | 6.9977 | 3782296.0 |
> showing 50 of 325,532 rows — these rows as CSV