PREVIEW / stock_5min / 2011-12-07
file: by_date/stock_5min/2011/2011-12-07.parquet size: 4.7 MB rows: 315,997 symbols: 3,515
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-12-07 04:50:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 2800.0 |
| 2011-12-07 05:00:00 | AAPL | Stock | 14.0361 | 14.0361 | 14.0357 | 14.0357 | 7000.0 |
| 2011-12-07 05:15:00 | AAPL | Stock | 14.0393 | 14.0393 | 14.0357 | 14.0357 | 30800.0 |
| 2011-12-07 05:55:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 30800.0 |
| 2011-12-07 07:00:00 | AAPL | Stock | 14.0 | 14.0 | 13.9821 | 13.9821 | 30800.0 |
| 2011-12-07 07:05:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9811 | 13.9811 | 26320.0 |
| 2011-12-07 07:10:00 | AAPL | Stock | 13.9796 | 13.9911 | 13.9796 | 13.9911 | 31080.0 |
| 2011-12-07 07:20:00 | AAPL | Stock | 13.9911 | 13.9911 | 13.9911 | 13.9911 | 5600.0 |
| 2011-12-07 07:30:00 | AAPL | Stock | 13.9914 | 13.9914 | 13.9864 | 13.9864 | 18172.0 |
| 2011-12-07 07:35:00 | AAPL | Stock | 13.9875 | 13.9875 | 13.9857 | 13.9857 | 19600.0 |
| 2011-12-07 07:45:00 | AAPL | Stock | 13.9796 | 13.9796 | 13.9625 | 13.9704 | 57680.0 |
| 2011-12-07 07:50:00 | AAPL | Stock | 13.9814 | 13.9857 | 13.9679 | 13.9679 | 16800.0 |
| 2011-12-07 07:55:00 | AAPL | Stock | 13.9664 | 13.985 | 13.9661 | 13.9796 | 34384.0 |
| 2011-12-07 08:00:00 | AAPL | Stock | 13.9714 | 13.9939 | 13.9714 | 13.9929 | 204988.0 |
| 2011-12-07 08:05:00 | AAPL | Stock | 13.9854 | 13.9854 | 13.9707 | 13.9707 | 165200.0 |
| 2011-12-07 08:10:00 | AAPL | Stock | 13.975 | 13.9754 | 13.9679 | 13.9725 | 172760.0 |
| 2011-12-07 08:15:00 | AAPL | Stock | 13.9725 | 13.9725 | 13.9643 | 13.9643 | 47600.0 |
| 2011-12-07 08:20:00 | AAPL | Stock | 13.9625 | 13.9625 | 13.9429 | 13.9529 | 215628.0 |
| 2011-12-07 08:25:00 | AAPL | Stock | 13.95 | 13.95 | 13.9254 | 13.9282 | 386512.0 |
| 2011-12-07 08:30:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9179 | 13.9179 | 451304.0 |
| 2011-12-07 08:35:00 | AAPL | Stock | 13.9196 | 13.9536 | 13.9179 | 13.9214 | 699748.0 |
| 2011-12-07 08:40:00 | AAPL | Stock | 13.9182 | 13.9314 | 13.9107 | 13.9254 | 210420.0 |
| 2011-12-07 08:45:00 | AAPL | Stock | 13.92 | 13.9275 | 13.9036 | 13.9193 | 326340.0 |
| 2011-12-07 08:50:00 | AAPL | Stock | 13.9214 | 13.9275 | 13.9196 | 13.9214 | 113260.0 |
| 2011-12-07 08:55:00 | AAPL | Stock | 13.9214 | 13.9246 | 13.9214 | 13.9225 | 29400.0 |
| 2011-12-07 09:00:00 | AAPL | Stock | 13.9168 | 13.9289 | 13.915 | 13.9221 | 212604.0 |
| 2011-12-07 09:05:00 | AAPL | Stock | 13.9271 | 13.9271 | 13.9168 | 13.9232 | 43960.0 |
| 2011-12-07 09:10:00 | AAPL | Stock | 13.9246 | 13.9339 | 13.9246 | 13.9339 | 23800.0 |
| 2011-12-07 09:15:00 | AAPL | Stock | 13.9339 | 13.9339 | 13.9236 | 13.9236 | 103600.0 |
| 2011-12-07 09:20:00 | AAPL | Stock | 13.9204 | 13.9268 | 13.9196 | 13.9232 | 25200.0 |
| 2011-12-07 09:25:00 | AAPL | Stock | 13.9254 | 13.9296 | 13.9018 | 13.9296 | 755188.0 |
| 2011-12-07 09:30:00 | AAPL | Stock | 13.9254 | 13.9554 | 13.8632 | 13.8736 | 12403636.0 |
| 2011-12-07 09:35:00 | AAPL | Stock | 13.8707 | 13.9025 | 13.8529 | 13.8724 | 10238928.0 |
| 2011-12-07 09:40:00 | AAPL | Stock | 13.875 | 13.8821 | 13.8254 | 13.8367 | 10342472.0 |
| 2011-12-07 09:45:00 | AAPL | Stock | 13.8361 | 13.8514 | 13.8186 | 13.8432 | 8525468.0 |
| 2011-12-07 09:50:00 | AAPL | Stock | 13.8454 | 13.855 | 13.83 | 13.845 | 6832448.0 |
| 2011-12-07 09:55:00 | AAPL | Stock | 13.8454 | 13.8507 | 13.8214 | 13.8429 | 6932240.0 |
| 2011-12-07 10:00:00 | AAPL | Stock | 13.8429 | 13.8679 | 13.8396 | 13.8632 | 6062616.0 |
| 2011-12-07 10:05:00 | AAPL | Stock | 13.8632 | 13.8696 | 13.8404 | 13.8429 | 3808616.0 |
| 2011-12-07 10:10:00 | AAPL | Stock | 13.8454 | 13.8696 | 13.8425 | 13.8596 | 2917600.0 |
| 2011-12-07 10:15:00 | AAPL | Stock | 13.8596 | 13.8632 | 13.8359 | 13.8493 | 2501632.0 |
| 2011-12-07 10:20:00 | AAPL | Stock | 13.8514 | 13.8654 | 13.8354 | 13.8355 | 4963420.0 |
| 2011-12-07 10:25:00 | AAPL | Stock | 13.8354 | 13.8464 | 13.8193 | 13.8314 | 5025804.0 |
| 2011-12-07 10:30:00 | AAPL | Stock | 13.8292 | 13.8446 | 13.8204 | 13.8421 | 3734696.0 |
| 2011-12-07 10:35:00 | AAPL | Stock | 13.8425 | 13.8429 | 13.8129 | 13.8375 | 5360628.0 |
| 2011-12-07 10:40:00 | AAPL | Stock | 13.8355 | 13.8446 | 13.8293 | 13.84 | 3105088.0 |
| 2011-12-07 10:45:00 | AAPL | Stock | 13.8424 | 13.8643 | 13.8332 | 13.8632 | 5283824.0 |
| 2011-12-07 10:50:00 | AAPL | Stock | 13.8632 | 13.8636 | 13.8475 | 13.8571 | 3296412.0 |
| 2011-12-07 10:55:00 | AAPL | Stock | 13.8554 | 13.8704 | 13.8393 | 13.8704 | 3184132.0 |
| 2011-12-07 11:00:00 | AAPL | Stock | 13.8704 | 13.8714 | 13.8518 | 13.8525 | 2633652.0 |
> showing 50 of 315,997 rows — these rows as CSV