PREVIEW / stock_5min / 2010-09-02
file: by_date/stock_5min/2010/2010-09-02.parquet size: 4.6 MB rows: 318,365 symbols: 3,455
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-09-02 04:20:00 | AAPL | Stock | 8.9729 | 8.9729 | 8.9729 | 8.9729 | 5600.0 |
| 2010-09-02 07:05:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 2800.0 |
| 2010-09-02 07:10:00 | AAPL | Stock | 8.9418 | 8.9729 | 8.9418 | 8.9554 | 33600.0 |
| 2010-09-02 07:20:00 | AAPL | Stock | 8.9775 | 8.9875 | 8.9775 | 8.9875 | 70000.0 |
| 2010-09-02 07:25:00 | AAPL | Stock | 8.9786 | 8.9786 | 8.9786 | 8.9786 | 4900.0 |
| 2010-09-02 07:30:00 | AAPL | Stock | 8.9868 | 8.9871 | 8.9464 | 8.9507 | 92400.0 |
| 2010-09-02 07:35:00 | AAPL | Stock | 8.9629 | 8.9686 | 8.9507 | 8.9507 | 16800.0 |
| 2010-09-02 07:40:00 | AAPL | Stock | 8.9507 | 8.9589 | 8.95 | 8.9589 | 14000.0 |
| 2010-09-02 07:55:00 | AAPL | Stock | 8.9554 | 8.9554 | 8.9554 | 8.9554 | 2800.0 |
| 2010-09-02 08:00:00 | AAPL | Stock | 8.9504 | 8.9696 | 8.9504 | 8.9611 | 242200.0 |
| 2010-09-02 08:05:00 | AAPL | Stock | 8.9568 | 8.9636 | 8.9568 | 8.9632 | 65800.0 |
| 2010-09-02 08:10:00 | AAPL | Stock | 8.9564 | 8.9614 | 8.9468 | 8.9564 | 189924.0 |
| 2010-09-02 08:15:00 | AAPL | Stock | 8.95 | 8.9518 | 8.9468 | 8.9504 | 73080.0 |
| 2010-09-02 08:20:00 | AAPL | Stock | 8.9493 | 8.9557 | 8.9479 | 8.9518 | 187264.0 |
| 2010-09-02 08:25:00 | AAPL | Stock | 8.9536 | 8.9607 | 8.9507 | 8.9568 | 174440.0 |
| 2010-09-02 08:30:00 | AAPL | Stock | 8.9554 | 8.9964 | 8.9554 | 8.9921 | 995400.0 |
| 2010-09-02 08:35:00 | AAPL | Stock | 8.9929 | 9.0104 | 8.9864 | 9.0086 | 1166676.0 |
| 2010-09-02 08:40:00 | AAPL | Stock | 9.0089 | 9.0246 | 9.0082 | 9.0196 | 1004416.0 |
| 2010-09-02 08:45:00 | AAPL | Stock | 9.0118 | 9.0229 | 9.0079 | 9.0093 | 665616.0 |
| 2010-09-02 08:50:00 | AAPL | Stock | 9.0104 | 9.0186 | 9.0086 | 9.0136 | 424284.0 |
| 2010-09-02 08:55:00 | AAPL | Stock | 9.0139 | 9.0168 | 9.0071 | 9.0071 | 210252.0 |
| 2010-09-02 09:00:00 | AAPL | Stock | 9.0054 | 9.0054 | 8.9861 | 8.9929 | 901432.0 |
| 2010-09-02 09:05:00 | AAPL | Stock | 8.9929 | 8.9993 | 8.9889 | 8.9943 | 239596.0 |
| 2010-09-02 09:10:00 | AAPL | Stock | 8.9925 | 8.9964 | 8.9914 | 8.9921 | 85400.0 |
| 2010-09-02 09:15:00 | AAPL | Stock | 8.9946 | 8.9964 | 8.9882 | 8.9946 | 311948.0 |
| 2010-09-02 09:20:00 | AAPL | Stock | 8.9929 | 8.9954 | 8.9882 | 8.9882 | 156604.0 |
| 2010-09-02 09:25:00 | AAPL | Stock | 8.9886 | 8.9889 | 8.9761 | 8.9761 | 318640.0 |
| 2010-09-02 09:30:00 | AAPL | Stock | 8.9754 | 8.9786 | 8.9521 | 8.9636 | 17197852.0 |
| 2010-09-02 09:35:00 | AAPL | Stock | 8.9636 | 8.9664 | 8.9286 | 8.9371 | 12800060.0 |
| 2010-09-02 09:40:00 | AAPL | Stock | 8.9361 | 8.9371 | 8.9054 | 8.9132 | 15101996.0 |
| 2010-09-02 09:45:00 | AAPL | Stock | 8.9129 | 8.9382 | 8.9089 | 8.9364 | 11369316.0 |
| 2010-09-02 09:50:00 | AAPL | Stock | 8.9364 | 8.9496 | 8.9236 | 8.9257 | 10778096.0 |
| 2010-09-02 09:55:00 | AAPL | Stock | 8.9254 | 8.9321 | 8.9193 | 8.9279 | 6246296.0 |
| 2010-09-02 10:00:00 | AAPL | Stock | 8.9286 | 8.9546 | 8.8804 | 8.8896 | 21212072.0 |
| 2010-09-02 10:05:00 | AAPL | Stock | 8.8907 | 8.905 | 8.8836 | 8.8839 | 12977048.0 |
| 2010-09-02 10:10:00 | AAPL | Stock | 8.8861 | 8.9036 | 8.8775 | 8.8957 | 8567272.0 |
| 2010-09-02 10:15:00 | AAPL | Stock | 8.8946 | 8.9029 | 8.8775 | 8.8807 | 7369740.0 |
| 2010-09-02 10:20:00 | AAPL | Stock | 8.8807 | 8.9086 | 8.8775 | 8.9029 | 7461132.0 |
| 2010-09-02 10:25:00 | AAPL | Stock | 8.9029 | 8.9207 | 8.9021 | 8.9175 | 6759284.0 |
| 2010-09-02 10:30:00 | AAPL | Stock | 8.9182 | 8.9204 | 8.9054 | 8.9121 | 5555592.0 |
| 2010-09-02 10:35:00 | AAPL | Stock | 8.9129 | 8.9246 | 8.9096 | 8.9236 | 3605168.0 |
| 2010-09-02 10:40:00 | AAPL | Stock | 8.9236 | 8.9432 | 8.9232 | 8.9296 | 7289072.0 |
| 2010-09-02 10:45:00 | AAPL | Stock | 8.9293 | 8.9368 | 8.925 | 8.9357 | 3714760.0 |
| 2010-09-02 10:50:00 | AAPL | Stock | 8.935 | 8.9543 | 8.9336 | 8.94 | 6263012.0 |
| 2010-09-02 10:55:00 | AAPL | Stock | 8.9404 | 8.9471 | 8.9311 | 8.9393 | 4524940.0 |
| 2010-09-02 11:00:00 | AAPL | Stock | 8.9386 | 8.9471 | 8.9379 | 8.945 | 3914848.0 |
| 2010-09-02 11:05:00 | AAPL | Stock | 8.9448 | 8.945 | 8.9304 | 8.9311 | 3974152.0 |
| 2010-09-02 11:10:00 | AAPL | Stock | 8.9311 | 8.9336 | 8.9221 | 8.9222 | 4097660.0 |
| 2010-09-02 11:15:00 | AAPL | Stock | 8.9221 | 8.9321 | 8.9196 | 8.9318 | 3212048.0 |
| 2010-09-02 11:20:00 | AAPL | Stock | 8.9304 | 8.9321 | 8.9221 | 8.9264 | 2665740.0 |
> showing 50 of 318,365 rows — these rows as CSV