PREVIEW / stock_5min / 2011-04-13
file: by_date/stock_5min/2011/2011-04-13.parquet size: 4.9 MB rows: 331,256 symbols: 3,528
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-04-13 04:50:00 | AAPL | Stock | 11.9236 | 11.9236 | 11.9236 | 11.9236 | 2800.0 |
| 2011-04-13 05:05:00 | AAPL | Stock | 11.9236 | 11.95 | 11.9236 | 11.95 | 14000.0 |
| 2011-04-13 05:10:00 | AAPL | Stock | 11.9418 | 11.9418 | 11.9418 | 11.9418 | 2800.0 |
| 2011-04-13 05:35:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 2800.0 |
| 2011-04-13 06:10:00 | AAPL | Stock | 11.9682 | 11.9682 | 11.9661 | 11.9661 | 5600.0 |
| 2011-04-13 06:15:00 | AAPL | Stock | 11.9714 | 11.9729 | 11.9714 | 11.9729 | 8400.0 |
| 2011-04-13 06:30:00 | AAPL | Stock | 11.9764 | 11.9764 | 11.9764 | 11.9764 | 2800.0 |
| 2011-04-13 07:00:00 | AAPL | Stock | 11.9696 | 11.9746 | 11.9571 | 11.9571 | 42000.0 |
| 2011-04-13 07:05:00 | AAPL | Stock | 11.9571 | 11.9571 | 11.9479 | 11.9571 | 33152.0 |
| 2011-04-13 07:10:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9639 | 11.9639 | 11200.0 |
| 2011-04-13 07:15:00 | AAPL | Stock | 11.9632 | 11.9636 | 11.9582 | 11.9589 | 30800.0 |
| 2011-04-13 07:20:00 | AAPL | Stock | 11.9607 | 11.9714 | 11.9607 | 11.9714 | 171192.0 |
| 2011-04-13 07:25:00 | AAPL | Stock | 11.9714 | 11.9775 | 11.9682 | 11.9696 | 120820.0 |
| 2011-04-13 07:30:00 | AAPL | Stock | 11.9711 | 11.985 | 11.9614 | 11.985 | 139272.0 |
| 2011-04-13 07:35:00 | AAPL | Stock | 11.9832 | 11.9839 | 11.9775 | 11.9775 | 114660.0 |
| 2011-04-13 07:40:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9775 | 11.9786 | 108080.0 |
| 2011-04-13 07:45:00 | AAPL | Stock | 11.9786 | 11.9804 | 11.9779 | 11.9779 | 40600.0 |
| 2011-04-13 07:50:00 | AAPL | Stock | 11.9775 | 11.9811 | 11.9775 | 11.9775 | 36624.0 |
| 2011-04-13 07:55:00 | AAPL | Stock | 11.9786 | 11.9854 | 11.9775 | 11.9854 | 62300.0 |
| 2011-04-13 08:00:00 | AAPL | Stock | 11.9807 | 11.9807 | 11.9643 | 11.975 | 185920.0 |
| 2011-04-13 08:05:00 | AAPL | Stock | 11.9743 | 11.9743 | 11.9675 | 11.9682 | 119896.0 |
| 2011-04-13 08:10:00 | AAPL | Stock | 11.9682 | 11.9732 | 11.9646 | 11.9732 | 74816.0 |
| 2011-04-13 08:15:00 | AAPL | Stock | 11.975 | 11.975 | 11.9643 | 11.9696 | 183428.0 |
| 2011-04-13 08:20:00 | AAPL | Stock | 11.97 | 11.9875 | 11.9657 | 11.9854 | 334516.0 |
| 2011-04-13 08:25:00 | AAPL | Stock | 11.9786 | 11.9839 | 11.9786 | 11.9821 | 54628.0 |
| 2011-04-13 08:30:00 | AAPL | Stock | 11.9821 | 11.9875 | 11.9821 | 11.9857 | 92204.0 |
| 2011-04-13 08:35:00 | AAPL | Stock | 11.9875 | 11.9893 | 11.9757 | 11.9821 | 243908.0 |
| 2011-04-13 08:40:00 | AAPL | Stock | 11.9846 | 11.9875 | 11.975 | 11.9821 | 256648.0 |
| 2011-04-13 08:45:00 | AAPL | Stock | 11.9811 | 11.9843 | 11.9768 | 11.9789 | 133896.0 |
| 2011-04-13 08:50:00 | AAPL | Stock | 11.9775 | 11.9779 | 11.9693 | 11.9718 | 86492.0 |
| 2011-04-13 08:55:00 | AAPL | Stock | 11.9725 | 11.9771 | 11.9646 | 11.9657 | 114912.0 |
| 2011-04-13 09:00:00 | AAPL | Stock | 11.9725 | 11.9725 | 11.9639 | 11.9639 | 102536.0 |
| 2011-04-13 09:05:00 | AAPL | Stock | 11.9643 | 11.9682 | 11.9621 | 11.9682 | 142576.0 |
| 2011-04-13 09:10:00 | AAPL | Stock | 11.9661 | 11.9721 | 11.9643 | 11.9696 | 121464.0 |
| 2011-04-13 09:15:00 | AAPL | Stock | 11.9643 | 11.9714 | 11.9582 | 11.9679 | 328496.0 |
| 2011-04-13 09:20:00 | AAPL | Stock | 11.9693 | 11.9693 | 11.8702 | 11.9564 | 348908.0 |
| 2011-04-13 09:25:00 | AAPL | Stock | 11.9586 | 11.9718 | 11.9475 | 11.9664 | 616504.0 |
| 2011-04-13 09:30:00 | AAPL | Stock | 11.9664 | 11.9664 | 11.9204 | 11.9225 | 14119700.0 |
| 2011-04-13 09:35:00 | AAPL | Stock | 11.9243 | 11.9364 | 11.9071 | 11.9093 | 10134460.0 |
| 2011-04-13 09:40:00 | AAPL | Stock | 11.9086 | 11.9257 | 11.8954 | 11.9064 | 9446836.0 |
| 2011-04-13 09:45:00 | AAPL | Stock | 11.9062 | 11.9093 | 11.8839 | 11.9031 | 6424012.0 |
| 2011-04-13 09:50:00 | AAPL | Stock | 11.9029 | 11.9214 | 11.8995 | 11.9161 | 6175848.0 |
| 2011-04-13 09:55:00 | AAPL | Stock | 11.9154 | 11.9162 | 11.8979 | 11.8979 | 5551896.0 |
| 2011-04-13 10:00:00 | AAPL | Stock | 11.8989 | 11.9089 | 11.8882 | 11.8996 | 6041700.0 |
| 2011-04-13 10:05:00 | AAPL | Stock | 11.8985 | 11.9061 | 11.8786 | 11.8857 | 5766404.0 |
| 2011-04-13 10:10:00 | AAPL | Stock | 11.8843 | 11.9018 | 11.8757 | 11.8796 | 6175960.0 |
| 2011-04-13 10:15:00 | AAPL | Stock | 11.8768 | 11.9114 | 11.8757 | 11.9086 | 6195868.0 |
| 2011-04-13 10:20:00 | AAPL | Stock | 11.91 | 11.9154 | 11.8971 | 11.9118 | 3785152.0 |
| 2011-04-13 10:25:00 | AAPL | Stock | 11.9129 | 11.9221 | 11.9046 | 11.9132 | 3561124.0 |
| 2011-04-13 10:30:00 | AAPL | Stock | 11.9139 | 11.9286 | 11.9096 | 11.9164 | 4141956.0 |
> showing 50 of 331,256 rows — these rows as CSV