PREVIEW / stock_5min / 2010-08-17
file: by_date/stock_5min/2010/2010-08-17.parquet size: 4.7 MB rows: 324,797 symbols: 3,472
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-08-17 05:10:00 | AAPL | Stock | 8.9261 | 8.9261 | 8.9261 | 8.9261 | 2884.0 |
| 2010-08-17 05:45:00 | AAPL | Stock | 8.9261 | 8.9261 | 8.9261 | 8.9261 | 2800.0 |
| 2010-08-17 07:10:00 | AAPL | Stock | 8.8964 | 8.8964 | 8.8964 | 8.8964 | 2968.0 |
| 2010-08-17 07:20:00 | AAPL | Stock | 8.8929 | 8.9111 | 8.8929 | 8.9111 | 5600.0 |
| 2010-08-17 07:45:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9007 | 8.9025 | 15400.0 |
| 2010-08-17 07:50:00 | AAPL | Stock | 8.9025 | 8.9086 | 8.9025 | 8.9086 | 21000.0 |
| 2010-08-17 07:55:00 | AAPL | Stock | 8.9132 | 8.9132 | 8.9132 | 8.9132 | 2800.0 |
| 2010-08-17 08:00:00 | AAPL | Stock | 8.9039 | 8.9039 | 8.8911 | 8.8929 | 96236.0 |
| 2010-08-17 08:05:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.8946 | 8.9018 | 116900.0 |
| 2010-08-17 08:10:00 | AAPL | Stock | 8.9018 | 8.9061 | 8.9018 | 8.9018 | 114884.0 |
| 2010-08-17 08:15:00 | AAPL | Stock | 8.9036 | 8.9064 | 8.8993 | 8.9 | 73108.0 |
| 2010-08-17 08:20:00 | AAPL | Stock | 8.9018 | 8.9107 | 8.9018 | 8.9043 | 125860.0 |
| 2010-08-17 08:25:00 | AAPL | Stock | 8.9079 | 8.9132 | 8.9079 | 8.9107 | 147560.0 |
| 2010-08-17 08:30:00 | AAPL | Stock | 8.9107 | 8.9346 | 8.9036 | 8.9318 | 552048.0 |
| 2010-08-17 08:35:00 | AAPL | Stock | 8.9339 | 8.9357 | 8.9296 | 8.9339 | 217840.0 |
| 2010-08-17 08:40:00 | AAPL | Stock | 8.9329 | 8.9389 | 8.9329 | 8.9389 | 118496.0 |
| 2010-08-17 08:45:00 | AAPL | Stock | 8.9389 | 8.9407 | 8.935 | 8.9357 | 237440.0 |
| 2010-08-17 08:50:00 | AAPL | Stock | 8.935 | 8.9375 | 8.9307 | 8.9314 | 83720.0 |
| 2010-08-17 08:55:00 | AAPL | Stock | 8.9321 | 8.9371 | 8.9275 | 8.9311 | 301084.0 |
| 2010-08-17 09:00:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.9271 | 8.9271 | 41048.0 |
| 2010-08-17 09:05:00 | AAPL | Stock | 8.9232 | 8.9286 | 8.9225 | 8.925 | 157164.0 |
| 2010-08-17 09:10:00 | AAPL | Stock | 8.925 | 8.925 | 8.9214 | 8.925 | 136444.0 |
| 2010-08-17 09:15:00 | AAPL | Stock | 8.925 | 8.925 | 8.9214 | 8.9214 | 167160.0 |
| 2010-08-17 09:20:00 | AAPL | Stock | 8.9204 | 8.9286 | 8.9175 | 8.9286 | 292600.0 |
| 2010-08-17 09:25:00 | AAPL | Stock | 8.9282 | 8.9393 | 8.9268 | 8.9375 | 103740.0 |
| 2010-08-17 09:30:00 | AAPL | Stock | 8.9314 | 8.9414 | 8.9 | 8.9339 | 11422264.0 |
| 2010-08-17 09:35:00 | AAPL | Stock | 8.9339 | 8.95 | 8.9196 | 8.9464 | 8456616.0 |
| 2010-08-17 09:40:00 | AAPL | Stock | 8.9489 | 8.9539 | 8.9196 | 8.9225 | 8792364.0 |
| 2010-08-17 09:45:00 | AAPL | Stock | 8.9236 | 8.9358 | 8.92 | 8.9282 | 6809404.0 |
| 2010-08-17 09:50:00 | AAPL | Stock | 8.9268 | 8.9643 | 8.9268 | 8.9586 | 14554876.0 |
| 2010-08-17 09:55:00 | AAPL | Stock | 8.9614 | 8.9739 | 8.9571 | 8.9691 | 11442284.0 |
| 2010-08-17 10:00:00 | AAPL | Stock | 8.9689 | 8.9946 | 8.9686 | 8.9907 | 13691412.0 |
| 2010-08-17 10:05:00 | AAPL | Stock | 8.9907 | 8.9975 | 8.9775 | 8.9821 | 9441544.0 |
| 2010-08-17 10:10:00 | AAPL | Stock | 8.9804 | 8.9882 | 8.9771 | 8.9811 | 5578608.0 |
| 2010-08-17 10:15:00 | AAPL | Stock | 8.9821 | 8.9839 | 8.9504 | 8.9532 | 9612652.0 |
| 2010-08-17 10:20:00 | AAPL | Stock | 8.9539 | 8.9718 | 8.9471 | 8.9704 | 7664580.0 |
| 2010-08-17 10:25:00 | AAPL | Stock | 8.9693 | 8.9732 | 8.9646 | 8.9678 | 4735108.0 |
| 2010-08-17 10:30:00 | AAPL | Stock | 8.9686 | 8.9732 | 8.9597 | 8.9714 | 3683932.0 |
| 2010-08-17 10:35:00 | AAPL | Stock | 8.9721 | 8.9796 | 8.9625 | 8.9707 | 4615772.0 |
| 2010-08-17 10:40:00 | AAPL | Stock | 8.9707 | 8.9757 | 8.9671 | 8.97 | 2439472.0 |
| 2010-08-17 10:45:00 | AAPL | Stock | 8.9686 | 8.9821 | 8.9629 | 8.9786 | 4546668.0 |
| 2010-08-17 10:50:00 | AAPL | Stock | 8.9789 | 8.9893 | 8.9768 | 8.9889 | 5814648.0 |
| 2010-08-17 10:55:00 | AAPL | Stock | 8.9891 | 8.9993 | 8.9854 | 8.9946 | 8809780.0 |
| 2010-08-17 11:00:00 | AAPL | Stock | 8.9943 | 9.0025 | 8.9921 | 8.9982 | 6842864.0 |
| 2010-08-17 11:05:00 | AAPL | Stock | 8.9982 | 9.0082 | 8.9971 | 9.005 | 5916624.0 |
| 2010-08-17 11:10:00 | AAPL | Stock | 9.0046 | 9.0179 | 9.0039 | 9.0179 | 6886124.0 |
| 2010-08-17 11:15:00 | AAPL | Stock | 9.0171 | 9.0204 | 9.0114 | 9.0146 | 5422340.0 |
| 2010-08-17 11:20:00 | AAPL | Stock | 9.015 | 9.0196 | 9.0118 | 9.0143 | 3143392.0 |
| 2010-08-17 11:25:00 | AAPL | Stock | 9.0143 | 9.0164 | 9.0096 | 9.0157 | 4051376.0 |
| 2010-08-17 11:30:00 | AAPL | Stock | 9.0157 | 9.0304 | 9.0143 | 9.0249 | 6569416.0 |
> showing 50 of 324,797 rows — these rows as CSV