PREVIEW / stock_5min / 2010-07-15
file: by_date/stock_5min/2010/2010-07-15.parquet size: 4.5 MB rows: 312,793 symbols: 3,435
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-07-15 06:10:00 | AAPL | Stock | 8.9736 | 8.9736 | 8.9721 | 8.9721 | 14000.0 |
| 2010-07-15 06:25:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 5600.0 |
| 2010-07-15 06:45:00 | AAPL | Stock | 9.0075 | 9.0093 | 9.0075 | 9.0093 | 8400.0 |
| 2010-07-15 06:50:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 2800.0 |
| 2010-07-15 07:00:00 | AAPL | Stock | 9.0 | 9.0193 | 9.0 | 9.0193 | 14812.0 |
| 2010-07-15 07:05:00 | AAPL | Stock | 9.0246 | 9.0254 | 9.0179 | 9.0179 | 14000.0 |
| 2010-07-15 07:10:00 | AAPL | Stock | 9.0221 | 9.0268 | 9.0221 | 9.0264 | 20832.0 |
| 2010-07-15 07:15:00 | AAPL | Stock | 9.0143 | 9.0143 | 9.0004 | 9.0004 | 8400.0 |
| 2010-07-15 07:20:00 | AAPL | Stock | 9.0 | 9.0 | 8.9629 | 8.9629 | 61040.0 |
| 2010-07-15 07:25:00 | AAPL | Stock | 8.9604 | 8.9607 | 8.9521 | 8.9604 | 30800.0 |
| 2010-07-15 07:30:00 | AAPL | Stock | 8.9607 | 8.9607 | 8.9321 | 8.9321 | 127932.0 |
| 2010-07-15 07:35:00 | AAPL | Stock | 8.9325 | 8.9554 | 8.9304 | 8.9539 | 114940.0 |
| 2010-07-15 07:40:00 | AAPL | Stock | 8.9543 | 8.9721 | 8.9464 | 8.9464 | 224532.0 |
| 2010-07-15 07:45:00 | AAPL | Stock | 8.9461 | 8.95 | 8.9461 | 8.9464 | 164640.0 |
| 2010-07-15 07:50:00 | AAPL | Stock | 8.9468 | 8.95 | 8.9468 | 8.95 | 65800.0 |
| 2010-07-15 07:55:00 | AAPL | Stock | 8.9468 | 8.9696 | 8.9464 | 8.9643 | 337960.0 |
| 2010-07-15 08:00:00 | AAPL | Stock | 8.9679 | 8.9882 | 8.9571 | 8.9821 | 495096.0 |
| 2010-07-15 08:05:00 | AAPL | Stock | 8.9829 | 8.9911 | 8.9818 | 8.9818 | 104160.0 |
| 2010-07-15 08:10:00 | AAPL | Stock | 8.9829 | 8.9829 | 8.9696 | 8.9786 | 272888.0 |
| 2010-07-15 08:15:00 | AAPL | Stock | 8.9811 | 8.9811 | 8.9679 | 8.9786 | 253064.0 |
| 2010-07-15 08:20:00 | AAPL | Stock | 8.9786 | 8.9911 | 8.975 | 8.9911 | 483112.0 |
| 2010-07-15 08:25:00 | AAPL | Stock | 8.9911 | 8.9968 | 8.9861 | 8.9964 | 407092.0 |
| 2010-07-15 08:30:00 | AAPL | Stock | 8.9932 | 9.0079 | 8.9732 | 8.9821 | 879144.0 |
| 2010-07-15 08:35:00 | AAPL | Stock | 8.985 | 9.005 | 8.9839 | 8.9946 | 390040.0 |
| 2010-07-15 08:40:00 | AAPL | Stock | 8.995 | 9.0054 | 8.9911 | 8.9939 | 168980.0 |
| 2010-07-15 08:45:00 | AAPL | Stock | 8.9986 | 9.0 | 8.9861 | 8.9939 | 156800.0 |
| 2010-07-15 08:50:00 | AAPL | Stock | 8.9904 | 8.9946 | 8.9821 | 8.9864 | 180348.0 |
| 2010-07-15 08:55:00 | AAPL | Stock | 8.9864 | 8.9864 | 8.9757 | 8.9779 | 547008.0 |
| 2010-07-15 09:00:00 | AAPL | Stock | 8.9764 | 8.9907 | 8.975 | 8.9882 | 257936.0 |
| 2010-07-15 09:05:00 | AAPL | Stock | 8.9882 | 8.9957 | 8.9839 | 8.9893 | 197904.0 |
| 2010-07-15 09:10:00 | AAPL | Stock | 8.99 | 8.9911 | 8.9804 | 8.9821 | 376460.0 |
| 2010-07-15 09:15:00 | AAPL | Stock | 8.9843 | 8.9843 | 8.9825 | 8.9836 | 22512.0 |
| 2010-07-15 09:20:00 | AAPL | Stock | 8.9832 | 8.9857 | 8.875 | 8.9093 | 6747804.0 |
| 2010-07-15 09:25:00 | AAPL | Stock | 8.9111 | 8.9325 | 8.8393 | 8.865 | 7740152.0 |
| 2010-07-15 09:30:00 | AAPL | Stock | 8.8654 | 8.8925 | 8.8321 | 8.8593 | 48997620.0 |
| 2010-07-15 09:35:00 | AAPL | Stock | 8.8746 | 8.9193 | 8.85 | 8.9 | 30005360.0 |
| 2010-07-15 09:40:00 | AAPL | Stock | 8.8994 | 8.9154 | 8.8761 | 8.9089 | 24213168.0 |
| 2010-07-15 09:45:00 | AAPL | Stock | 8.9082 | 8.9271 | 8.87 | 8.9014 | 21061488.0 |
| 2010-07-15 09:50:00 | AAPL | Stock | 8.9014 | 8.9321 | 8.8861 | 8.9225 | 18452728.0 |
| 2010-07-15 09:55:00 | AAPL | Stock | 8.9229 | 8.9314 | 8.9071 | 8.9137 | 13547632.0 |
| 2010-07-15 10:00:00 | AAPL | Stock | 8.9137 | 8.9161 | 8.8821 | 8.8907 | 22003268.0 |
| 2010-07-15 10:05:00 | AAPL | Stock | 8.8918 | 8.9096 | 8.8886 | 8.9068 | 10866576.0 |
| 2010-07-15 10:10:00 | AAPL | Stock | 8.9061 | 8.925 | 8.8857 | 8.9018 | 14389704.0 |
| 2010-07-15 10:15:00 | AAPL | Stock | 8.9028 | 8.9093 | 8.8875 | 8.89 | 12623856.0 |
| 2010-07-15 10:20:00 | AAPL | Stock | 8.8896 | 8.8921 | 8.85 | 8.8525 | 20141492.0 |
| 2010-07-15 10:25:00 | AAPL | Stock | 8.8504 | 8.8864 | 8.8504 | 8.8804 | 9158016.0 |
| 2010-07-15 10:30:00 | AAPL | Stock | 8.88 | 8.88 | 8.8393 | 8.8521 | 15499680.0 |
| 2010-07-15 10:35:00 | AAPL | Stock | 8.8516 | 8.8675 | 8.8382 | 8.8646 | 16139060.0 |
| 2010-07-15 10:40:00 | AAPL | Stock | 8.8645 | 8.8679 | 8.8432 | 8.8521 | 9804116.0 |
| 2010-07-15 10:45:00 | AAPL | Stock | 8.8514 | 8.8718 | 8.8436 | 8.8668 | 9702084.0 |
> showing 50 of 312,793 rows — these rows as CSV