PREVIEW / stock_5min / 2011-01-07
file: by_date/stock_5min/2011/2011-01-07.parquet size: 4.9 MB rows: 328,028 symbols: 3,516
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-01-07 04:15:00 | AAPL | Stock | 11.9468 | 11.9611 | 11.9468 | 11.9611 | 11200.0 |
| 2011-01-07 04:45:00 | AAPL | Stock | 11.9189 | 11.9189 | 11.9189 | 11.9189 | 2800.0 |
| 2011-01-07 05:10:00 | AAPL | Stock | 11.9489 | 11.9489 | 11.9489 | 11.9489 | 2800.0 |
| 2011-01-07 06:30:00 | AAPL | Stock | 11.9543 | 11.9543 | 11.9543 | 11.9543 | 2800.0 |
| 2011-01-07 07:00:00 | AAPL | Stock | 11.9393 | 11.9464 | 11.9393 | 11.9393 | 16800.0 |
| 2011-01-07 07:15:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9393 | 11.9393 | 8400.0 |
| 2011-01-07 07:20:00 | AAPL | Stock | 11.9393 | 11.9714 | 11.9393 | 11.9643 | 150080.0 |
| 2011-01-07 07:25:00 | AAPL | Stock | 11.9596 | 11.9596 | 11.9464 | 11.9464 | 26712.0 |
| 2011-01-07 07:30:00 | AAPL | Stock | 11.9543 | 11.9543 | 11.9393 | 11.9464 | 20888.0 |
| 2011-01-07 07:35:00 | AAPL | Stock | 11.9479 | 11.9479 | 11.9286 | 11.9286 | 41160.0 |
| 2011-01-07 07:40:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9393 | 11.9393 | 5600.0 |
| 2011-01-07 07:45:00 | AAPL | Stock | 11.9289 | 11.9393 | 11.9289 | 11.9393 | 16800.0 |
| 2011-01-07 08:00:00 | AAPL | Stock | 11.9382 | 11.9382 | 11.9179 | 11.925 | 149324.0 |
| 2011-01-07 08:05:00 | AAPL | Stock | 11.925 | 11.9257 | 11.9214 | 11.9239 | 72884.0 |
| 2011-01-07 08:10:00 | AAPL | Stock | 11.9236 | 11.9286 | 11.9236 | 11.9279 | 31220.0 |
| 2011-01-07 08:15:00 | AAPL | Stock | 11.9275 | 11.9293 | 11.9232 | 11.9232 | 133000.0 |
| 2011-01-07 08:20:00 | AAPL | Stock | 11.9275 | 11.9286 | 11.9271 | 11.9286 | 48020.0 |
| 2011-01-07 08:25:00 | AAPL | Stock | 11.9246 | 11.9304 | 11.9225 | 11.9257 | 108696.0 |
| 2011-01-07 08:30:00 | AAPL | Stock | 11.9214 | 11.9321 | 11.8693 | 11.9079 | 898072.0 |
| 2011-01-07 08:35:00 | AAPL | Stock | 11.9104 | 11.9139 | 11.8946 | 11.9071 | 220360.0 |
| 2011-01-07 08:40:00 | AAPL | Stock | 11.9086 | 11.9086 | 11.8846 | 11.9018 | 372400.0 |
| 2011-01-07 08:45:00 | AAPL | Stock | 11.9029 | 11.9029 | 11.8946 | 11.9018 | 86856.0 |
| 2011-01-07 08:50:00 | AAPL | Stock | 11.9018 | 11.9125 | 11.9004 | 11.9125 | 33432.0 |
| 2011-01-07 08:55:00 | AAPL | Stock | 11.9107 | 11.9179 | 11.9107 | 11.9143 | 63728.0 |
| 2011-01-07 09:00:00 | AAPL | Stock | 11.9179 | 11.9257 | 11.9179 | 11.9257 | 187376.0 |
| 2011-01-07 09:05:00 | AAPL | Stock | 11.925 | 11.9279 | 11.9196 | 11.9279 | 149184.0 |
| 2011-01-07 09:10:00 | AAPL | Stock | 11.925 | 11.9286 | 11.9232 | 11.9286 | 136976.0 |
| 2011-01-07 09:15:00 | AAPL | Stock | 11.9286 | 11.9361 | 11.9257 | 11.9286 | 95704.0 |
| 2011-01-07 09:20:00 | AAPL | Stock | 11.9282 | 11.9321 | 11.9282 | 11.9321 | 28000.0 |
| 2011-01-07 09:25:00 | AAPL | Stock | 11.9286 | 11.9329 | 11.9207 | 11.9318 | 451220.0 |
| 2011-01-07 09:30:00 | AAPL | Stock | 11.9318 | 11.9418 | 11.9179 | 11.9243 | 6907600.0 |
| 2011-01-07 09:35:00 | AAPL | Stock | 11.9254 | 11.9357 | 11.8829 | 11.8982 | 9139648.0 |
| 2011-01-07 09:40:00 | AAPL | Stock | 11.8961 | 11.9039 | 11.8725 | 11.8868 | 8026872.0 |
| 2011-01-07 09:45:00 | AAPL | Stock | 11.8864 | 11.9018 | 11.8796 | 11.8846 | 6101172.0 |
| 2011-01-07 09:50:00 | AAPL | Stock | 11.8854 | 11.9029 | 11.8811 | 11.8968 | 4884936.0 |
| 2011-01-07 09:55:00 | AAPL | Stock | 11.8968 | 11.9193 | 11.8957 | 11.9014 | 3855768.0 |
| 2011-01-07 10:00:00 | AAPL | Stock | 11.9014 | 11.9275 | 11.8986 | 11.9221 | 3962252.0 |
| 2011-01-07 10:05:00 | AAPL | Stock | 11.9216 | 11.9364 | 11.9104 | 11.9257 | 3705716.0 |
| 2011-01-07 10:10:00 | AAPL | Stock | 11.9257 | 11.939 | 11.9121 | 11.9379 | 6060040.0 |
| 2011-01-07 10:15:00 | AAPL | Stock | 11.9386 | 11.9404 | 11.9293 | 11.935 | 3002776.0 |
| 2011-01-07 10:20:00 | AAPL | Stock | 11.9354 | 11.9518 | 11.9311 | 11.9518 | 8770048.0 |
| 2011-01-07 10:25:00 | AAPL | Stock | 11.9518 | 11.9675 | 11.945 | 11.9661 | 6941620.0 |
| 2011-01-07 10:30:00 | AAPL | Stock | 11.9657 | 11.9861 | 11.9621 | 11.9829 | 9772364.0 |
| 2011-01-07 10:35:00 | AAPL | Stock | 11.9823 | 11.985 | 11.9643 | 11.9661 | 6905948.0 |
| 2011-01-07 10:40:00 | AAPL | Stock | 11.9671 | 11.9675 | 11.9486 | 11.9543 | 4755352.0 |
| 2011-01-07 10:45:00 | AAPL | Stock | 11.9525 | 11.9564 | 11.9389 | 11.955 | 4437020.0 |
| 2011-01-07 10:50:00 | AAPL | Stock | 11.9549 | 11.955 | 11.9357 | 11.9457 | 5693912.0 |
| 2011-01-07 10:55:00 | AAPL | Stock | 11.9437 | 11.9521 | 11.9393 | 11.9461 | 2634660.0 |
| 2011-01-07 11:00:00 | AAPL | Stock | 11.9457 | 11.9518 | 11.9364 | 11.945 | 2694272.0 |
| 2011-01-07 11:05:00 | AAPL | Stock | 11.9436 | 11.9446 | 11.925 | 11.9283 | 3122980.0 |
> showing 50 of 328,028 rows — these rows as CSV