PREVIEW / stock_5min / 2011-12-02
file: by_date/stock_5min/2011/2011-12-02.parquet size: 4.8 MB rows: 323,972 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-12-02 04:00:00 | AAPL | Stock | 13.9321 | 13.945 | 13.8768 | 13.8768 | 31360.0 |
| 2011-12-02 04:50:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 16800.0 |
| 2011-12-02 04:55:00 | AAPL | Stock | 14.0193 | 14.0193 | 14.0193 | 14.0193 | 5460.0 |
| 2011-12-02 05:00:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-02 05:10:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 2800.0 |
| 2011-12-02 05:15:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-02 05:25:00 | AAPL | Stock | 14.0107 | 14.0107 | 14.0107 | 14.0107 | 8400.0 |
| 2011-12-02 05:35:00 | AAPL | Stock | 14.0107 | 14.0107 | 14.0107 | 14.0107 | 19600.0 |
| 2011-12-02 05:45:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 5600.0 |
| 2011-12-02 06:25:00 | AAPL | Stock | 13.9929 | 13.9929 | 13.9929 | 13.9929 | 2800.0 |
| 2011-12-02 06:30:00 | AAPL | Stock | 13.9821 | 14.0 | 13.9807 | 14.0 | 21560.0 |
| 2011-12-02 06:35:00 | AAPL | Stock | 13.9743 | 13.9743 | 13.9714 | 13.9714 | 11200.0 |
| 2011-12-02 06:40:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 8400.0 |
| 2011-12-02 06:50:00 | AAPL | Stock | 13.9482 | 13.95 | 13.9482 | 13.95 | 8400.0 |
| 2011-12-02 06:55:00 | AAPL | Stock | 13.9607 | 13.9607 | 13.9607 | 13.9607 | 4200.0 |
| 2011-12-02 07:00:00 | AAPL | Stock | 13.9468 | 13.9671 | 13.9464 | 13.9643 | 80220.0 |
| 2011-12-02 07:05:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9557 | 13.9636 | 80864.0 |
| 2011-12-02 07:10:00 | AAPL | Stock | 13.9571 | 13.9679 | 13.9571 | 13.9643 | 44520.0 |
| 2011-12-02 07:15:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9411 | 13.9411 | 39200.0 |
| 2011-12-02 07:20:00 | AAPL | Stock | 13.9636 | 13.9714 | 13.9636 | 13.9714 | 17500.0 |
| 2011-12-02 07:25:00 | AAPL | Stock | 13.9804 | 13.9911 | 13.9804 | 13.9804 | 72800.0 |
| 2011-12-02 07:30:00 | AAPL | Stock | 13.9725 | 13.9821 | 13.9714 | 13.9821 | 25200.0 |
| 2011-12-02 07:35:00 | AAPL | Stock | 13.9821 | 13.9918 | 13.9754 | 13.9829 | 82180.0 |
| 2011-12-02 07:40:00 | AAPL | Stock | 13.9821 | 13.9957 | 13.9782 | 13.9946 | 54600.0 |
| 2011-12-02 07:45:00 | AAPL | Stock | 13.9911 | 13.9911 | 13.9857 | 13.9857 | 33600.0 |
| 2011-12-02 07:50:00 | AAPL | Stock | 13.9893 | 13.9893 | 13.9643 | 13.975 | 136976.0 |
| 2011-12-02 07:55:00 | AAPL | Stock | 13.9732 | 13.9789 | 13.9643 | 13.975 | 152600.0 |
| 2011-12-02 08:00:00 | AAPL | Stock | 13.9643 | 13.9782 | 13.9468 | 13.95 | 439572.0 |
| 2011-12-02 08:05:00 | AAPL | Stock | 13.9536 | 13.9643 | 13.9443 | 13.9504 | 105560.0 |
| 2011-12-02 08:10:00 | AAPL | Stock | 13.9504 | 13.9589 | 13.9504 | 13.9568 | 196196.0 |
| 2011-12-02 08:15:00 | AAPL | Stock | 13.9596 | 13.9643 | 13.9543 | 13.9621 | 136080.0 |
| 2011-12-02 08:20:00 | AAPL | Stock | 13.9625 | 13.9643 | 13.9571 | 13.9639 | 138488.0 |
| 2011-12-02 08:25:00 | AAPL | Stock | 13.9589 | 13.9671 | 13.9536 | 13.9643 | 485604.0 |
| 2011-12-02 08:30:00 | AAPL | Stock | 13.9579 | 13.9907 | 13.9454 | 13.9729 | 1136996.0 |
| 2011-12-02 08:35:00 | AAPL | Stock | 13.9604 | 13.9664 | 13.9539 | 13.9571 | 406784.0 |
| 2011-12-02 08:40:00 | AAPL | Stock | 13.9564 | 13.9589 | 13.9418 | 13.9429 | 1042188.0 |
| 2011-12-02 08:45:00 | AAPL | Stock | 13.9421 | 13.9507 | 13.9386 | 13.9446 | 921648.0 |
| 2011-12-02 08:50:00 | AAPL | Stock | 13.9482 | 13.9568 | 13.9429 | 13.9482 | 698180.0 |
| 2011-12-02 08:55:00 | AAPL | Stock | 13.9475 | 13.9489 | 13.9289 | 13.9304 | 632072.0 |
| 2011-12-02 09:00:00 | AAPL | Stock | 13.9293 | 13.9379 | 13.9232 | 13.935 | 1190924.0 |
| 2011-12-02 09:05:00 | AAPL | Stock | 13.9354 | 13.9421 | 13.9075 | 13.9111 | 482216.0 |
| 2011-12-02 09:10:00 | AAPL | Stock | 13.9146 | 13.9286 | 13.9114 | 13.9214 | 248220.0 |
| 2011-12-02 09:15:00 | AAPL | Stock | 13.9196 | 13.9211 | 13.9107 | 13.9139 | 408324.0 |
| 2011-12-02 09:20:00 | AAPL | Stock | 13.9139 | 13.915 | 13.9064 | 13.9075 | 182000.0 |
| 2011-12-02 09:25:00 | AAPL | Stock | 13.9071 | 13.9339 | 13.9036 | 13.9236 | 1107764.0 |
| 2011-12-02 09:30:00 | AAPL | Stock | 13.9286 | 13.9518 | 13.8779 | 13.8982 | 14699244.0 |
| 2011-12-02 09:35:00 | AAPL | Stock | 13.8996 | 13.9443 | 13.8957 | 13.9282 | 10290784.0 |
| 2011-12-02 09:40:00 | AAPL | Stock | 13.9279 | 13.9385 | 13.9025 | 13.905 | 8233512.0 |
| 2011-12-02 09:45:00 | AAPL | Stock | 13.9084 | 13.9411 | 13.8929 | 13.922 | 9207436.0 |
| 2011-12-02 09:50:00 | AAPL | Stock | 13.9214 | 13.9432 | 13.9082 | 13.94 | 6942936.0 |
> showing 50 of 323,972 rows — these rows as CSV