PREVIEW / stock_5min / 2008-01-24
file: by_date/stock_5min/2008/2008-01-24.parquet size: 4.6 MB rows: 328,839 symbols: 3,264
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-24 06:05:00 | AAPL | Stock | 5.0446 | 5.0446 | 5.0446 | 5.0446 | 70000.0 |
| 2008-01-24 06:10:00 | AAPL | Stock | 5.0464 | 5.0464 | 5.0464 | 5.0464 | 2800.0 |
| 2008-01-24 06:15:00 | AAPL | Stock | 5.0671 | 5.0671 | 5.0571 | 5.0571 | 22400.0 |
| 2008-01-24 06:20:00 | AAPL | Stock | 5.0596 | 5.0786 | 5.0593 | 5.0786 | 16800.0 |
| 2008-01-24 06:25:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 7560.0 |
| 2008-01-24 06:45:00 | AAPL | Stock | 5.0875 | 5.0875 | 5.0875 | 5.0875 | 5600.0 |
| 2008-01-24 06:50:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0686 | 5.0686 | 8400.0 |
| 2008-01-24 06:55:00 | AAPL | Stock | 5.0679 | 5.0714 | 5.0679 | 5.0714 | 17500.0 |
| 2008-01-24 07:00:00 | AAPL | Stock | 5.0714 | 5.0732 | 5.0604 | 5.0675 | 193200.0 |
| 2008-01-24 07:05:00 | AAPL | Stock | 5.0604 | 5.0604 | 5.0536 | 5.0539 | 204428.0 |
| 2008-01-24 07:10:00 | AAPL | Stock | 5.0596 | 5.0596 | 5.0525 | 5.0525 | 161868.0 |
| 2008-01-24 07:15:00 | AAPL | Stock | 5.0536 | 5.0568 | 5.0496 | 5.0496 | 61516.0 |
| 2008-01-24 07:20:00 | AAPL | Stock | 5.045 | 5.0464 | 5.0296 | 5.0357 | 252140.0 |
| 2008-01-24 07:25:00 | AAPL | Stock | 5.0293 | 5.0443 | 5.0293 | 5.0443 | 183820.0 |
| 2008-01-24 07:30:00 | AAPL | Stock | 5.0357 | 5.0375 | 5.0275 | 5.0275 | 80304.0 |
| 2008-01-24 07:35:00 | AAPL | Stock | 5.0286 | 5.0321 | 5.0268 | 5.0268 | 78400.0 |
| 2008-01-24 07:40:00 | AAPL | Stock | 5.03 | 5.0425 | 5.0268 | 5.0268 | 329952.0 |
| 2008-01-24 07:45:00 | AAPL | Stock | 5.0218 | 5.0286 | 5.0218 | 5.0271 | 55972.0 |
| 2008-01-24 07:50:00 | AAPL | Stock | 5.0289 | 5.0289 | 5.0275 | 5.0275 | 29904.0 |
| 2008-01-24 07:55:00 | AAPL | Stock | 5.0214 | 5.0214 | 5.0129 | 5.0129 | 53312.0 |
| 2008-01-24 08:00:00 | AAPL | Stock | 5.0161 | 5.0325 | 4.9929 | 5.0 | 1588860.0 |
| 2008-01-24 08:05:00 | AAPL | Stock | 5.0018 | 5.0179 | 5.0018 | 5.0143 | 346220.0 |
| 2008-01-24 08:10:00 | AAPL | Stock | 5.0125 | 5.0125 | 4.9957 | 4.9961 | 838152.0 |
| 2008-01-24 08:15:00 | AAPL | Stock | 4.9964 | 4.9964 | 4.9718 | 4.9821 | 445620.0 |
| 2008-01-24 08:20:00 | AAPL | Stock | 4.9889 | 4.9911 | 4.9714 | 4.9736 | 385868.0 |
| 2008-01-24 08:25:00 | AAPL | Stock | 4.9768 | 4.9814 | 4.9607 | 4.9639 | 734216.0 |
| 2008-01-24 08:30:00 | AAPL | Stock | 4.9643 | 5.0036 | 4.9643 | 4.9996 | 1603392.0 |
| 2008-01-24 08:35:00 | AAPL | Stock | 5.0 | 5.0061 | 4.9946 | 5.0029 | 834400.0 |
| 2008-01-24 08:40:00 | AAPL | Stock | 5.0025 | 5.0061 | 4.9857 | 5.0 | 928536.0 |
| 2008-01-24 08:45:00 | AAPL | Stock | 5.0 | 5.005 | 4.9893 | 4.9979 | 420672.0 |
| 2008-01-24 08:50:00 | AAPL | Stock | 4.9961 | 5.0018 | 4.9857 | 4.9911 | 501732.0 |
| 2008-01-24 08:55:00 | AAPL | Stock | 4.9939 | 4.9975 | 4.9714 | 4.9807 | 511756.0 |
| 2008-01-24 09:00:00 | AAPL | Stock | 4.9857 | 4.9979 | 4.9839 | 4.9954 | 598808.0 |
| 2008-01-24 09:05:00 | AAPL | Stock | 4.9975 | 4.9979 | 4.9893 | 4.9943 | 492688.0 |
| 2008-01-24 09:10:00 | AAPL | Stock | 4.9946 | 4.9964 | 4.975 | 4.9754 | 642572.0 |
| 2008-01-24 09:15:00 | AAPL | Stock | 4.98 | 4.9886 | 4.98 | 4.9857 | 702968.0 |
| 2008-01-24 09:20:00 | AAPL | Stock | 4.9854 | 4.9854 | 4.9607 | 4.9725 | 1436344.0 |
| 2008-01-24 09:25:00 | AAPL | Stock | 4.9689 | 5.0089 | 4.9568 | 4.9989 | 5283264.0 |
| 2008-01-24 09:30:00 | AAPL | Stock | 4.9993 | 5.0086 | 4.9321 | 4.9368 | 74390848.0 |
| 2008-01-24 09:35:00 | AAPL | Stock | 4.9364 | 4.9393 | 4.9064 | 4.9143 | 39016824.0 |
| 2008-01-24 09:40:00 | AAPL | Stock | 4.9143 | 4.9736 | 4.9125 | 4.9732 | 38356276.0 |
| 2008-01-24 09:45:00 | AAPL | Stock | 4.9732 | 4.9929 | 4.9639 | 4.9793 | 33950728.0 |
| 2008-01-24 09:50:00 | AAPL | Stock | 4.9796 | 5.0189 | 4.9643 | 5.0168 | 45371032.0 |
| 2008-01-24 09:55:00 | AAPL | Stock | 5.0175 | 5.025 | 4.9936 | 5.0 | 42600404.0 |
| 2008-01-24 10:00:00 | AAPL | Stock | 5.0 | 5.0211 | 4.9893 | 5.0029 | 38486140.0 |
| 2008-01-24 10:05:00 | AAPL | Stock | 5.0071 | 5.0121 | 4.9386 | 4.9593 | 43245104.0 |
| 2008-01-24 10:10:00 | AAPL | Stock | 4.9589 | 4.9857 | 4.935 | 4.9414 | 38043152.0 |
| 2008-01-24 10:15:00 | AAPL | Stock | 4.9418 | 4.9422 | 4.8575 | 4.8657 | 55665372.0 |
| 2008-01-24 10:20:00 | AAPL | Stock | 4.865 | 4.8893 | 4.825 | 4.8739 | 50363488.0 |
| 2008-01-24 10:25:00 | AAPL | Stock | 4.8743 | 4.9064 | 4.8727 | 4.9014 | 26326384.0 |
> showing 50 of 328,839 rows — these rows as CSV