PREVIEW / stock_5min / 2011-08-04
file: by_date/stock_5min/2011/2011-08-04.parquet size: 5.5 MB rows: 360,962 symbols: 3,567
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-08-04 04:05:00 | AAPL | Stock | 13.9964 | 13.9964 | 13.9964 | 13.9964 | 2800.0 |
| 2011-08-04 04:20:00 | AAPL | Stock | 14.0039 | 14.0039 | 14.0039 | 14.0039 | 2800.0 |
| 2011-08-04 04:25:00 | AAPL | Stock | 14.0089 | 14.0089 | 14.0089 | 14.0089 | 5600.0 |
| 2011-08-04 04:30:00 | AAPL | Stock | 14.0211 | 14.0211 | 14.0204 | 14.0204 | 5600.0 |
| 2011-08-04 04:40:00 | AAPL | Stock | 14.0207 | 14.0207 | 14.0207 | 14.0207 | 5600.0 |
| 2011-08-04 05:25:00 | AAPL | Stock | 13.9789 | 13.9789 | 13.9789 | 13.9789 | 2800.0 |
| 2011-08-04 06:00:00 | AAPL | Stock | 13.9761 | 13.9761 | 13.9639 | 13.9639 | 25200.0 |
| 2011-08-04 06:15:00 | AAPL | Stock | 13.9532 | 13.9536 | 13.9357 | 13.9357 | 25200.0 |
| 2011-08-04 06:20:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-04 06:25:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 14000.0 |
| 2011-08-04 06:30:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 11200.0 |
| 2011-08-04 06:40:00 | AAPL | Stock | 13.9221 | 13.9221 | 13.9221 | 13.9221 | 2800.0 |
| 2011-08-04 06:55:00 | AAPL | Stock | 13.9375 | 13.9375 | 13.9375 | 13.9375 | 2800.0 |
| 2011-08-04 07:00:00 | AAPL | Stock | 13.9375 | 13.9429 | 13.925 | 13.9268 | 239680.0 |
| 2011-08-04 07:05:00 | AAPL | Stock | 13.9264 | 13.9268 | 13.925 | 13.9268 | 44800.0 |
| 2011-08-04 07:10:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9268 | 13.9268 | 6300.0 |
| 2011-08-04 07:15:00 | AAPL | Stock | 13.9214 | 13.9264 | 13.9214 | 13.9264 | 8400.0 |
| 2011-08-04 07:20:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.9232 | 13.9232 | 31948.0 |
| 2011-08-04 07:25:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9257 | 13.9257 | 32200.0 |
| 2011-08-04 07:30:00 | AAPL | Stock | 13.9286 | 13.9396 | 13.9286 | 13.9396 | 11200.0 |
| 2011-08-04 07:35:00 | AAPL | Stock | 13.9461 | 13.9514 | 13.9461 | 13.9514 | 8400.0 |
| 2011-08-04 07:40:00 | AAPL | Stock | 13.9482 | 13.9579 | 13.9464 | 13.9464 | 14000.0 |
| 2011-08-04 07:50:00 | AAPL | Stock | 13.9357 | 13.9357 | 13.9339 | 13.9339 | 13216.0 |
| 2011-08-04 07:55:00 | AAPL | Stock | 13.9339 | 13.9521 | 13.9339 | 13.9432 | 8400.0 |
| 2011-08-04 08:00:00 | AAPL | Stock | 13.9543 | 13.9571 | 13.9196 | 13.9375 | 217084.0 |
| 2011-08-04 08:05:00 | AAPL | Stock | 13.9393 | 13.9393 | 13.8929 | 13.8929 | 322112.0 |
| 2011-08-04 08:10:00 | AAPL | Stock | 13.8982 | 13.9004 | 13.8821 | 13.8839 | 159852.0 |
| 2011-08-04 08:15:00 | AAPL | Stock | 13.8832 | 13.8929 | 13.8786 | 13.8821 | 199892.0 |
| 2011-08-04 08:20:00 | AAPL | Stock | 13.8793 | 13.8886 | 13.875 | 13.8843 | 95508.0 |
| 2011-08-04 08:25:00 | AAPL | Stock | 13.8843 | 13.8929 | 13.8804 | 13.8925 | 244300.0 |
| 2011-08-04 08:30:00 | AAPL | Stock | 13.8925 | 13.9368 | 13.8925 | 13.9243 | 1047032.0 |
| 2011-08-04 08:35:00 | AAPL | Stock | 13.9207 | 13.9286 | 13.8807 | 13.8929 | 345352.0 |
| 2011-08-04 08:40:00 | AAPL | Stock | 13.8868 | 13.8921 | 13.8671 | 13.8732 | 408128.0 |
| 2011-08-04 08:45:00 | AAPL | Stock | 13.8714 | 13.8979 | 13.8536 | 13.8979 | 509208.0 |
| 2011-08-04 08:50:00 | AAPL | Stock | 13.8918 | 13.9107 | 13.8768 | 13.8814 | 171500.0 |
| 2011-08-04 08:55:00 | AAPL | Stock | 13.8807 | 13.9054 | 13.8804 | 13.9054 | 72800.0 |
| 2011-08-04 09:00:00 | AAPL | Stock | 13.9057 | 13.9321 | 13.9018 | 13.9275 | 608328.0 |
| 2011-08-04 09:05:00 | AAPL | Stock | 13.9289 | 13.9404 | 13.925 | 13.9321 | 770168.0 |
| 2011-08-04 09:10:00 | AAPL | Stock | 13.9293 | 13.9354 | 13.9146 | 13.9229 | 256760.0 |
| 2011-08-04 09:15:00 | AAPL | Stock | 13.9232 | 13.9318 | 13.9107 | 13.9107 | 126000.0 |
| 2011-08-04 09:20:00 | AAPL | Stock | 13.9125 | 13.9125 | 13.8929 | 13.8993 | 208852.0 |
| 2011-08-04 09:25:00 | AAPL | Stock | 13.9036 | 13.9214 | 13.8825 | 13.9136 | 257600.0 |
| 2011-08-04 09:30:00 | AAPL | Stock | 13.9136 | 13.9757 | 13.875 | 13.9157 | 16783816.0 |
| 2011-08-04 09:35:00 | AAPL | Stock | 13.9161 | 13.9557 | 13.9018 | 13.9107 | 9855832.0 |
| 2011-08-04 09:40:00 | AAPL | Stock | 13.9107 | 13.9529 | 13.8929 | 13.8943 | 12873560.0 |
| 2011-08-04 09:45:00 | AAPL | Stock | 13.8946 | 13.9329 | 13.8571 | 13.8656 | 16038064.0 |
| 2011-08-04 09:50:00 | AAPL | Stock | 13.8654 | 13.8764 | 13.8214 | 13.8386 | 20258028.0 |
| 2011-08-04 09:55:00 | AAPL | Stock | 13.8386 | 13.8907 | 13.8371 | 13.8771 | 11384576.0 |
| 2011-08-04 10:00:00 | AAPL | Stock | 13.8743 | 13.905 | 13.8682 | 13.8682 | 11036872.0 |
| 2011-08-04 10:05:00 | AAPL | Stock | 13.8679 | 13.9018 | 13.8643 | 13.8756 | 8742552.0 |
> showing 50 of 360,962 rows — these rows as CSV