PREVIEW / stock_5min / 2010-06-09
file: by_date/stock_5min/2010/2010-06-09.parquet size: 4.7 MB rows: 325,180 symbols: 3,454
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-06-09 04:15:00 | AAPL | Stock | 9.0036 | 9.0036 | 8.9321 | 8.9321 | 14000.0 |
| 2010-06-09 04:20:00 | AAPL | Stock | 8.9196 | 8.9196 | 8.9196 | 8.9196 | 11200.0 |
| 2010-06-09 04:35:00 | AAPL | Stock | 8.8807 | 8.9107 | 8.8807 | 8.9107 | 20020.0 |
| 2010-06-09 05:20:00 | AAPL | Stock | 8.9404 | 8.9404 | 8.9404 | 8.9404 | 7000.0 |
| 2010-06-09 05:25:00 | AAPL | Stock | 8.9321 | 8.9321 | 8.9321 | 8.9321 | 2800.0 |
| 2010-06-09 05:30:00 | AAPL | Stock | 8.9321 | 8.9321 | 8.9196 | 8.9196 | 6832.0 |
| 2010-06-09 05:45:00 | AAPL | Stock | 8.9304 | 8.9304 | 8.9304 | 8.9304 | 5600.0 |
| 2010-06-09 06:15:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 2800.0 |
| 2010-06-09 06:30:00 | AAPL | Stock | 8.9429 | 8.9429 | 8.9429 | 8.9429 | 2800.0 |
| 2010-06-09 07:00:00 | AAPL | Stock | 8.9461 | 8.9461 | 8.9461 | 8.9461 | 2800.0 |
| 2010-06-09 07:05:00 | AAPL | Stock | 8.9357 | 8.9357 | 8.9357 | 8.9357 | 2800.0 |
| 2010-06-09 07:10:00 | AAPL | Stock | 8.9332 | 8.9332 | 8.9332 | 8.9332 | 2800.0 |
| 2010-06-09 07:30:00 | AAPL | Stock | 8.9514 | 8.9589 | 8.9514 | 8.9589 | 11200.0 |
| 2010-06-09 07:35:00 | AAPL | Stock | 8.9643 | 8.9686 | 8.9643 | 8.9686 | 33740.0 |
| 2010-06-09 07:45:00 | AAPL | Stock | 8.9814 | 8.9818 | 8.9814 | 8.9818 | 19600.0 |
| 2010-06-09 07:50:00 | AAPL | Stock | 8.9889 | 8.9943 | 8.97 | 8.9786 | 70000.0 |
| 2010-06-09 07:55:00 | AAPL | Stock | 8.9939 | 9.0111 | 8.9889 | 9.0111 | 138040.0 |
| 2010-06-09 08:00:00 | AAPL | Stock | 9.0 | 9.0075 | 8.9721 | 8.9893 | 538160.0 |
| 2010-06-09 08:05:00 | AAPL | Stock | 8.9882 | 8.9954 | 8.9821 | 8.9912 | 324940.0 |
| 2010-06-09 08:10:00 | AAPL | Stock | 8.9893 | 8.9896 | 8.9714 | 8.9714 | 172060.0 |
| 2010-06-09 08:15:00 | AAPL | Stock | 8.9704 | 8.9779 | 8.9693 | 8.9768 | 392896.0 |
| 2010-06-09 08:20:00 | AAPL | Stock | 8.9754 | 8.9768 | 8.9571 | 8.9589 | 238952.0 |
| 2010-06-09 08:25:00 | AAPL | Stock | 8.9586 | 8.9643 | 8.9504 | 8.9611 | 283276.0 |
| 2010-06-09 08:30:00 | AAPL | Stock | 8.9618 | 8.9739 | 8.9571 | 8.9714 | 268688.0 |
| 2010-06-09 08:35:00 | AAPL | Stock | 8.9689 | 8.9814 | 8.9661 | 8.975 | 241640.0 |
| 2010-06-09 08:40:00 | AAPL | Stock | 8.9743 | 8.9768 | 8.9643 | 8.9668 | 168560.0 |
| 2010-06-09 08:45:00 | AAPL | Stock | 8.9646 | 8.9704 | 8.9621 | 8.9661 | 68600.0 |
| 2010-06-09 08:50:00 | AAPL | Stock | 8.9714 | 8.9782 | 8.9682 | 8.9736 | 232288.0 |
| 2010-06-09 08:55:00 | AAPL | Stock | 8.9777 | 8.9821 | 8.9743 | 8.9814 | 238392.0 |
| 2010-06-09 09:00:00 | AAPL | Stock | 8.9811 | 8.9811 | 8.9661 | 8.9796 | 343952.0 |
| 2010-06-09 09:05:00 | AAPL | Stock | 8.9796 | 8.9821 | 8.9761 | 8.9768 | 206500.0 |
| 2010-06-09 09:10:00 | AAPL | Stock | 8.9764 | 8.9857 | 8.9761 | 8.9821 | 350000.0 |
| 2010-06-09 09:15:00 | AAPL | Stock | 8.9854 | 8.9875 | 8.9743 | 8.975 | 114828.0 |
| 2010-06-09 09:20:00 | AAPL | Stock | 8.9725 | 8.9804 | 8.9714 | 8.9786 | 165480.0 |
| 2010-06-09 09:25:00 | AAPL | Stock | 8.985 | 8.9893 | 8.9786 | 8.98 | 693000.0 |
| 2010-06-09 09:30:00 | AAPL | Stock | 8.9807 | 8.9964 | 8.9529 | 8.995 | 28234500.0 |
| 2010-06-09 09:35:00 | AAPL | Stock | 8.995 | 8.9964 | 8.9118 | 8.9257 | 19063464.0 |
| 2010-06-09 09:40:00 | AAPL | Stock | 8.9246 | 8.9568 | 8.9161 | 8.9171 | 13047244.0 |
| 2010-06-09 09:45:00 | AAPL | Stock | 8.9171 | 8.9232 | 8.8832 | 8.8929 | 18088952.0 |
| 2010-06-09 09:50:00 | AAPL | Stock | 8.8935 | 8.9182 | 8.8861 | 8.8939 | 14071484.0 |
| 2010-06-09 09:55:00 | AAPL | Stock | 8.8932 | 8.9107 | 8.875 | 8.8943 | 15172360.0 |
| 2010-06-09 10:00:00 | AAPL | Stock | 8.8943 | 8.9071 | 8.8468 | 8.8624 | 17993388.0 |
| 2010-06-09 10:05:00 | AAPL | Stock | 8.8625 | 8.8664 | 8.8089 | 8.8221 | 21313908.0 |
| 2010-06-09 10:10:00 | AAPL | Stock | 8.8239 | 8.8386 | 8.8107 | 8.8214 | 15327928.0 |
| 2010-06-09 10:15:00 | AAPL | Stock | 8.8232 | 8.8411 | 8.8 | 8.8068 | 15187228.0 |
| 2010-06-09 10:20:00 | AAPL | Stock | 8.8086 | 8.8464 | 8.8075 | 8.8361 | 11508420.0 |
| 2010-06-09 10:25:00 | AAPL | Stock | 8.8346 | 8.8546 | 8.8343 | 8.8421 | 7709464.0 |
| 2010-06-09 10:30:00 | AAPL | Stock | 8.8421 | 8.8521 | 8.8161 | 8.8306 | 8049328.0 |
| 2010-06-09 10:35:00 | AAPL | Stock | 8.8304 | 8.8389 | 8.8071 | 8.8096 | 9024316.0 |
| 2010-06-09 10:40:00 | AAPL | Stock | 8.8093 | 8.8334 | 8.8018 | 8.8321 | 11341932.0 |
> showing 50 of 325,180 rows — these rows as CSV