PREVIEW / stock_5min / 2005-10-24
file: by_date/stock_5min/2005/2005-10-24.parquet size: 2.8 MB rows: 204,424 symbols: 2,102
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-24 08:00:00 | AAPL | Stock | 1.9875 | 1.9893 | 1.9754 | 1.9754 | 136388.0 |
| 2005-10-24 08:05:00 | AAPL | Stock | 1.9786 | 1.9786 | 1.975 | 1.9786 | 14000.0 |
| 2005-10-24 08:10:00 | AAPL | Stock | 1.9786 | 1.9821 | 1.9786 | 1.9786 | 156800.0 |
| 2005-10-24 08:15:00 | AAPL | Stock | 1.9754 | 1.9754 | 1.9668 | 1.9696 | 107576.0 |
| 2005-10-24 08:20:00 | AAPL | Stock | 1.9679 | 1.975 | 1.9679 | 1.975 | 89460.0 |
| 2005-10-24 08:25:00 | AAPL | Stock | 1.975 | 1.9821 | 1.975 | 1.9821 | 100100.0 |
| 2005-10-24 08:30:00 | AAPL | Stock | 1.9821 | 1.9821 | 1.9804 | 1.9821 | 36400.0 |
| 2005-10-24 08:35:00 | AAPL | Stock | 1.9786 | 1.9786 | 1.9768 | 1.9786 | 19600.0 |
| 2005-10-24 08:40:00 | AAPL | Stock | 1.9786 | 1.9814 | 1.9786 | 1.98 | 86660.0 |
| 2005-10-24 08:45:00 | AAPL | Stock | 1.9786 | 1.9814 | 1.9786 | 1.9814 | 28000.0 |
| 2005-10-24 08:50:00 | AAPL | Stock | 1.9814 | 1.9839 | 1.9814 | 1.9821 | 177940.0 |
| 2005-10-24 08:55:00 | AAPL | Stock | 1.9825 | 1.9825 | 1.9825 | 1.9825 | 14000.0 |
| 2005-10-24 09:00:00 | AAPL | Stock | 1.9825 | 1.9846 | 1.9821 | 1.9846 | 131600.0 |
| 2005-10-24 09:05:00 | AAPL | Stock | 1.9854 | 1.9893 | 1.9854 | 1.9875 | 124040.0 |
| 2005-10-24 09:10:00 | AAPL | Stock | 1.9854 | 1.9854 | 1.9854 | 1.9854 | 11200.0 |
| 2005-10-24 09:15:00 | AAPL | Stock | 1.9864 | 1.9864 | 1.9857 | 1.9864 | 76188.0 |
| 2005-10-24 09:20:00 | AAPL | Stock | 1.9854 | 1.9854 | 1.985 | 1.985 | 22400.0 |
| 2005-10-24 09:25:00 | AAPL | Stock | 1.985 | 1.9907 | 1.9743 | 1.9743 | 1236592.0 |
| 2005-10-24 09:30:00 | AAPL | Stock | 1.9732 | 1.9893 | 1.9711 | 1.9782 | 22220940.0 |
| 2005-10-24 09:35:00 | AAPL | Stock | 1.9775 | 1.9786 | 1.9696 | 1.9707 | 11492768.0 |
| 2005-10-24 09:40:00 | AAPL | Stock | 1.9707 | 1.9811 | 1.9675 | 1.9782 | 15208060.0 |
| 2005-10-24 09:45:00 | AAPL | Stock | 1.9782 | 1.9821 | 1.9696 | 1.9764 | 9060492.0 |
| 2005-10-24 09:50:00 | AAPL | Stock | 1.9764 | 1.9886 | 1.9696 | 1.9861 | 16596496.0 |
| 2005-10-24 09:55:00 | AAPL | Stock | 1.9861 | 1.9982 | 1.9854 | 1.9939 | 16601872.0 |
| 2005-10-24 10:00:00 | AAPL | Stock | 1.9939 | 1.9993 | 1.9936 | 1.9943 | 13733440.0 |
| 2005-10-24 10:05:00 | AAPL | Stock | 1.9939 | 2.0107 | 1.9914 | 2.0093 | 19819128.0 |
| 2005-10-24 10:10:00 | AAPL | Stock | 2.0093 | 2.01 | 1.9982 | 2.0007 | 14435456.0 |
| 2005-10-24 10:15:00 | AAPL | Stock | 2.0007 | 2.0014 | 1.9918 | 1.9954 | 10830204.0 |
| 2005-10-24 10:20:00 | AAPL | Stock | 1.9964 | 1.9968 | 1.9929 | 1.9936 | 3814104.0 |
| 2005-10-24 10:25:00 | AAPL | Stock | 1.9932 | 1.9961 | 1.9929 | 1.9929 | 4643184.0 |
| 2005-10-24 10:30:00 | AAPL | Stock | 1.9929 | 2.0025 | 1.9918 | 2.0 | 13007708.0 |
| 2005-10-24 10:35:00 | AAPL | Stock | 2.0 | 2.0 | 1.9946 | 1.9968 | 6888224.0 |
| 2005-10-24 10:40:00 | AAPL | Stock | 1.9968 | 1.9971 | 1.9886 | 1.9907 | 10481660.0 |
| 2005-10-24 10:45:00 | AAPL | Stock | 1.9907 | 1.9939 | 1.9836 | 1.985 | 12917184.0 |
| 2005-10-24 10:50:00 | AAPL | Stock | 1.9843 | 1.9875 | 1.9789 | 1.9846 | 10856132.0 |
| 2005-10-24 10:55:00 | AAPL | Stock | 1.9857 | 1.9886 | 1.9846 | 1.9868 | 4218340.0 |
| 2005-10-24 11:00:00 | AAPL | Stock | 1.9875 | 1.995 | 1.985 | 1.9932 | 4882892.0 |
| 2005-10-24 11:05:00 | AAPL | Stock | 1.9929 | 1.995 | 1.9907 | 1.9936 | 5362812.0 |
| 2005-10-24 11:10:00 | AAPL | Stock | 1.9936 | 1.9957 | 1.99 | 1.9911 | 5199740.0 |
| 2005-10-24 11:15:00 | AAPL | Stock | 1.9918 | 1.9982 | 1.9918 | 1.996 | 5671092.0 |
| 2005-10-24 11:20:00 | AAPL | Stock | 1.9961 | 1.9971 | 1.9921 | 1.9954 | 4797296.0 |
| 2005-10-24 11:25:00 | AAPL | Stock | 1.9943 | 2.0021 | 1.9929 | 2.0007 | 6799912.0 |
| 2005-10-24 11:30:00 | AAPL | Stock | 2.0004 | 2.005 | 2.0 | 2.0007 | 11767140.0 |
| 2005-10-24 11:35:00 | AAPL | Stock | 2.0007 | 2.0064 | 2.0004 | 2.0064 | 8277500.0 |
| 2005-10-24 11:40:00 | AAPL | Stock | 2.0064 | 2.0114 | 2.0029 | 2.0075 | 14469756.0 |
| 2005-10-24 11:45:00 | AAPL | Stock | 2.0075 | 2.0107 | 2.0054 | 2.0107 | 8342824.0 |
| 2005-10-24 11:50:00 | AAPL | Stock | 2.0107 | 2.0207 | 2.0096 | 2.0129 | 18670428.0 |
| 2005-10-24 11:55:00 | AAPL | Stock | 2.0125 | 2.0139 | 2.0089 | 2.01 | 6085688.0 |
| 2005-10-24 12:00:00 | AAPL | Stock | 2.0096 | 2.0129 | 2.0096 | 2.0107 | 8332212.0 |
| 2005-10-24 12:05:00 | AAPL | Stock | 2.0111 | 2.0211 | 2.0111 | 2.0164 | 12329940.0 |
> showing 50 of 204,424 rows — these rows as CSV