PREVIEW / stock_5min / 2008-04-22
file: by_date/stock_5min/2008/2008-04-22.parquet size: 4.4 MB rows: 313,193 symbols: 3,279
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-04-22 05:00:00 | AAPL | Stock | 5.9857 | 5.9857 | 5.9857 | 5.9857 | 2800.0 |
| 2008-04-22 05:40:00 | AAPL | Stock | 5.9789 | 5.9789 | 5.9789 | 5.9789 | 2800.0 |
| 2008-04-22 05:45:00 | AAPL | Stock | 5.9936 | 5.9936 | 5.9936 | 5.9936 | 2800.0 |
| 2008-04-22 05:50:00 | AAPL | Stock | 6.0129 | 6.0129 | 6.0129 | 6.0129 | 2800.0 |
| 2008-04-22 06:00:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0125 | 6.0125 | 2800.0 |
| 2008-04-22 06:05:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 5600.0 |
| 2008-04-22 06:35:00 | AAPL | Stock | 6.0071 | 6.0071 | 6.0071 | 6.0071 | 26124.0 |
| 2008-04-22 06:45:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 5600.0 |
| 2008-04-22 06:50:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 5600.0 |
| 2008-04-22 06:55:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 27384.0 |
| 2008-04-22 07:00:00 | AAPL | Stock | 5.9993 | 6.0007 | 5.9993 | 6.0004 | 28476.0 |
| 2008-04-22 07:05:00 | AAPL | Stock | 6.0004 | 6.0004 | 6.0004 | 6.0004 | 3584.0 |
| 2008-04-22 07:10:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 12600.0 |
| 2008-04-22 07:15:00 | AAPL | Stock | 5.9932 | 5.9964 | 5.9929 | 5.9964 | 108360.0 |
| 2008-04-22 07:20:00 | AAPL | Stock | 5.9918 | 5.9918 | 5.9918 | 5.9918 | 4900.0 |
| 2008-04-22 07:30:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 42000.0 |
| 2008-04-22 07:35:00 | AAPL | Stock | 5.9921 | 5.9964 | 5.9918 | 5.9964 | 39340.0 |
| 2008-04-22 07:40:00 | AAPL | Stock | 6.0036 | 6.0036 | 5.9996 | 5.9996 | 38360.0 |
| 2008-04-22 07:50:00 | AAPL | Stock | 5.9996 | 5.9996 | 5.9996 | 5.9996 | 2800.0 |
| 2008-04-22 07:55:00 | AAPL | Stock | 5.9911 | 5.9911 | 5.9893 | 5.9893 | 25200.0 |
| 2008-04-22 08:00:00 | AAPL | Stock | 5.9893 | 5.9979 | 5.9861 | 5.9886 | 231140.0 |
| 2008-04-22 08:05:00 | AAPL | Stock | 5.9889 | 5.9979 | 5.9875 | 5.9964 | 176484.0 |
| 2008-04-22 08:10:00 | AAPL | Stock | 5.9979 | 6.01 | 5.9979 | 6.0089 | 494620.0 |
| 2008-04-22 08:15:00 | AAPL | Stock | 6.01 | 6.0129 | 5.9771 | 5.9871 | 1329244.0 |
| 2008-04-22 08:20:00 | AAPL | Stock | 5.985 | 5.9907 | 5.9732 | 5.9836 | 1051988.0 |
| 2008-04-22 08:25:00 | AAPL | Stock | 5.9839 | 5.9996 | 5.9839 | 5.9946 | 732508.0 |
| 2008-04-22 08:30:00 | AAPL | Stock | 5.9946 | 5.9946 | 5.9761 | 5.9796 | 642012.0 |
| 2008-04-22 08:35:00 | AAPL | Stock | 5.9789 | 5.9861 | 5.9711 | 5.9786 | 460348.0 |
| 2008-04-22 08:40:00 | AAPL | Stock | 5.9761 | 5.9793 | 5.9468 | 5.9571 | 1731688.0 |
| 2008-04-22 08:45:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9546 | 5.9636 | 552608.0 |
| 2008-04-22 08:50:00 | AAPL | Stock | 5.9636 | 5.9654 | 5.9589 | 5.9589 | 490364.0 |
| 2008-04-22 08:55:00 | AAPL | Stock | 5.9571 | 5.9693 | 5.9554 | 5.9671 | 603960.0 |
| 2008-04-22 09:00:00 | AAPL | Stock | 5.9671 | 5.9732 | 5.9661 | 5.9696 | 694232.0 |
| 2008-04-22 09:05:00 | AAPL | Stock | 5.9707 | 5.9821 | 5.9661 | 5.9696 | 672056.0 |
| 2008-04-22 09:10:00 | AAPL | Stock | 5.9714 | 5.9746 | 5.9639 | 5.965 | 336280.0 |
| 2008-04-22 09:15:00 | AAPL | Stock | 5.9654 | 5.9686 | 5.9571 | 5.9607 | 543396.0 |
| 2008-04-22 09:20:00 | AAPL | Stock | 5.9625 | 5.9679 | 5.9571 | 5.9643 | 331576.0 |
| 2008-04-22 09:25:00 | AAPL | Stock | 5.9625 | 5.9821 | 5.9625 | 5.9789 | 1855672.0 |
| 2008-04-22 09:30:00 | AAPL | Stock | 5.9789 | 6.0 | 5.9661 | 5.9743 | 33031656.0 |
| 2008-04-22 09:35:00 | AAPL | Stock | 5.9743 | 5.9821 | 5.9089 | 5.915 | 38303692.0 |
| 2008-04-22 09:40:00 | AAPL | Stock | 5.9133 | 5.9261 | 5.9 | 5.9243 | 30114224.0 |
| 2008-04-22 09:45:00 | AAPL | Stock | 5.9243 | 5.9346 | 5.895 | 5.8975 | 25053196.0 |
| 2008-04-22 09:50:00 | AAPL | Stock | 5.8975 | 5.9154 | 5.8868 | 5.8896 | 28004452.0 |
| 2008-04-22 09:55:00 | AAPL | Stock | 5.8896 | 5.9079 | 5.8875 | 5.9062 | 17545808.0 |
| 2008-04-22 10:00:00 | AAPL | Stock | 5.9046 | 5.9082 | 5.8504 | 5.8596 | 38833844.0 |
| 2008-04-22 10:05:00 | AAPL | Stock | 5.8596 | 5.87 | 5.8507 | 5.8607 | 27064716.0 |
| 2008-04-22 10:10:00 | AAPL | Stock | 5.8632 | 5.8779 | 5.8511 | 5.8661 | 22448328.0 |
| 2008-04-22 10:15:00 | AAPL | Stock | 5.8668 | 5.8786 | 5.8579 | 5.8625 | 19105744.0 |
| 2008-04-22 10:20:00 | AAPL | Stock | 5.8625 | 5.865 | 5.8482 | 5.8539 | 21451556.0 |
| 2008-04-22 10:25:00 | AAPL | Stock | 5.853 | 5.8536 | 5.83 | 5.83 | 29527932.0 |
> showing 50 of 313,193 rows — these rows as CSV