PREVIEW / stock_5min / 2011-05-25
file: by_date/stock_5min/2011/2011-05-25.parquet size: 4.8 MB rows: 331,318 symbols: 3,536
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-25 04:05:00 | AAPL | Stock | 11.8164 | 11.8164 | 11.8164 | 11.8164 | 2800.0 |
| 2011-05-25 04:50:00 | AAPL | Stock | 11.8343 | 11.8368 | 11.8343 | 11.8368 | 5600.0 |
| 2011-05-25 05:15:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 5600.0 |
| 2011-05-25 05:25:00 | AAPL | Stock | 11.8632 | 11.8632 | 11.8632 | 11.8632 | 2800.0 |
| 2011-05-25 05:55:00 | AAPL | Stock | 11.8579 | 11.8579 | 11.8579 | 11.8579 | 2800.0 |
| 2011-05-25 06:00:00 | AAPL | Stock | 11.8579 | 11.8579 | 11.8579 | 11.8579 | 5600.0 |
| 2011-05-25 06:05:00 | AAPL | Stock | 11.8579 | 11.8579 | 11.8571 | 11.8571 | 5600.0 |
| 2011-05-25 06:35:00 | AAPL | Stock | 11.8818 | 11.8821 | 11.8818 | 11.8818 | 14000.0 |
| 2011-05-25 06:40:00 | AAPL | Stock | 11.8846 | 11.8857 | 11.8846 | 11.8857 | 33320.0 |
| 2011-05-25 06:45:00 | AAPL | Stock | 11.8714 | 11.8821 | 11.8689 | 11.8821 | 11200.0 |
| 2011-05-25 07:00:00 | AAPL | Stock | 11.8689 | 11.8689 | 11.8689 | 11.8689 | 2800.0 |
| 2011-05-25 07:05:00 | AAPL | Stock | 11.8575 | 11.875 | 11.8571 | 11.875 | 19600.0 |
| 2011-05-25 07:20:00 | AAPL | Stock | 11.8779 | 11.8779 | 11.8779 | 11.8779 | 2800.0 |
| 2011-05-25 07:30:00 | AAPL | Stock | 11.8775 | 11.8775 | 11.8771 | 11.8771 | 5600.0 |
| 2011-05-25 07:35:00 | AAPL | Stock | 11.8771 | 11.8775 | 11.8746 | 11.8771 | 20104.0 |
| 2011-05-25 07:40:00 | AAPL | Stock | 11.8646 | 11.8664 | 11.8646 | 11.8664 | 16800.0 |
| 2011-05-25 07:50:00 | AAPL | Stock | 11.8761 | 11.8821 | 11.8761 | 11.8818 | 39704.0 |
| 2011-05-25 07:55:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 2800.0 |
| 2011-05-25 08:00:00 | AAPL | Stock | 11.8754 | 11.8796 | 11.875 | 11.8786 | 42532.0 |
| 2011-05-25 08:05:00 | AAPL | Stock | 11.875 | 11.8754 | 11.8736 | 11.8736 | 9520.0 |
| 2011-05-25 08:10:00 | AAPL | Stock | 11.875 | 11.875 | 11.8668 | 11.8668 | 45360.0 |
| 2011-05-25 08:15:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8679 | 11.8679 | 14000.0 |
| 2011-05-25 08:20:00 | AAPL | Stock | 11.8661 | 11.8679 | 11.8661 | 11.8679 | 8400.0 |
| 2011-05-25 08:25:00 | AAPL | Stock | 11.8707 | 11.88 | 11.8707 | 11.8768 | 19600.0 |
| 2011-05-25 08:30:00 | AAPL | Stock | 11.875 | 11.875 | 11.8714 | 11.8714 | 8400.0 |
| 2011-05-25 08:35:00 | AAPL | Stock | 11.8754 | 11.8832 | 11.875 | 11.8832 | 19180.0 |
| 2011-05-25 08:40:00 | AAPL | Stock | 11.8836 | 11.885 | 11.8768 | 11.885 | 35000.0 |
| 2011-05-25 08:45:00 | AAPL | Stock | 11.8857 | 11.9036 | 11.8846 | 11.8961 | 418432.0 |
| 2011-05-25 08:50:00 | AAPL | Stock | 11.8964 | 11.8964 | 11.8879 | 11.8961 | 147140.0 |
| 2011-05-25 08:55:00 | AAPL | Stock | 11.8961 | 11.9014 | 11.8946 | 11.8982 | 93240.0 |
| 2011-05-25 09:00:00 | AAPL | Stock | 11.9011 | 11.9018 | 11.8929 | 11.8929 | 130872.0 |
| 2011-05-25 09:05:00 | AAPL | Stock | 11.8929 | 11.8964 | 11.8857 | 11.8964 | 324632.0 |
| 2011-05-25 09:10:00 | AAPL | Stock | 11.8911 | 11.8911 | 11.8839 | 11.8839 | 60172.0 |
| 2011-05-25 09:15:00 | AAPL | Stock | 11.8843 | 11.8982 | 11.8843 | 11.8932 | 324380.0 |
| 2011-05-25 09:20:00 | AAPL | Stock | 11.8946 | 11.9054 | 11.8929 | 11.9018 | 343000.0 |
| 2011-05-25 09:25:00 | AAPL | Stock | 11.9036 | 11.9118 | 11.9032 | 11.9104 | 490056.0 |
| 2011-05-25 09:30:00 | AAPL | Stock | 11.9107 | 11.9582 | 11.8875 | 11.9429 | 15439312.0 |
| 2011-05-25 09:35:00 | AAPL | Stock | 11.9421 | 11.9511 | 11.917 | 11.9471 | 8779652.0 |
| 2011-05-25 09:40:00 | AAPL | Stock | 11.9461 | 11.9589 | 11.9214 | 11.9293 | 6407940.0 |
| 2011-05-25 09:45:00 | AAPL | Stock | 11.9289 | 11.9446 | 11.9275 | 11.9446 | 4886336.0 |
| 2011-05-25 09:50:00 | AAPL | Stock | 11.9429 | 11.95 | 11.9229 | 11.9421 | 4893476.0 |
| 2011-05-25 09:55:00 | AAPL | Stock | 11.9396 | 11.9816 | 11.9382 | 11.9625 | 9095352.0 |
| 2011-05-25 10:00:00 | AAPL | Stock | 11.9643 | 11.9718 | 11.9486 | 11.9564 | 4851196.0 |
| 2011-05-25 10:05:00 | AAPL | Stock | 11.9571 | 11.9664 | 11.9407 | 11.9464 | 5012476.0 |
| 2011-05-25 10:10:00 | AAPL | Stock | 11.9454 | 11.9568 | 11.925 | 11.9518 | 6387108.0 |
| 2011-05-25 10:15:00 | AAPL | Stock | 11.9507 | 11.9557 | 11.9304 | 11.9314 | 2403436.0 |
| 2011-05-25 10:20:00 | AAPL | Stock | 11.9307 | 11.9546 | 11.9264 | 11.9546 | 4378836.0 |
| 2011-05-25 10:25:00 | AAPL | Stock | 11.9546 | 11.9746 | 11.9539 | 11.9736 | 5670784.0 |
| 2011-05-25 10:30:00 | AAPL | Stock | 11.9736 | 11.9993 | 11.9721 | 11.985 | 7041104.0 |
| 2011-05-25 10:35:00 | AAPL | Stock | 11.9862 | 12.0 | 11.9804 | 11.9842 | 5934068.0 |
> showing 50 of 331,318 rows — these rows as CSV