PREVIEW / stock_5min / 2009-09-03
file: by_date/stock_5min/2009/2009-09-03.parquet size: 4.5 MB rows: 312,258 symbols: 3,358
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-03 07:10:00 | AAPL | Stock | 5.9464 | 5.9654 | 5.9464 | 5.9654 | 15400.0 |
| 2009-09-03 07:15:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 2800.0 |
| 2009-09-03 07:20:00 | AAPL | Stock | 5.9796 | 5.9796 | 5.9796 | 5.9796 | 5600.0 |
| 2009-09-03 07:25:00 | AAPL | Stock | 5.9782 | 5.9796 | 5.9782 | 5.9793 | 28028.0 |
| 2009-09-03 07:35:00 | AAPL | Stock | 5.975 | 5.9796 | 5.975 | 5.9796 | 38780.0 |
| 2009-09-03 07:40:00 | AAPL | Stock | 5.9796 | 5.9825 | 5.9789 | 5.9789 | 53200.0 |
| 2009-09-03 07:45:00 | AAPL | Stock | 5.9793 | 5.9793 | 5.9682 | 5.9682 | 86828.0 |
| 2009-09-03 07:50:00 | AAPL | Stock | 5.9796 | 5.9796 | 5.9796 | 5.9796 | 28000.0 |
| 2009-09-03 07:55:00 | AAPL | Stock | 5.9714 | 5.9714 | 5.9693 | 5.9711 | 34188.0 |
| 2009-09-03 08:00:00 | AAPL | Stock | 5.9664 | 5.975 | 5.965 | 5.975 | 234640.0 |
| 2009-09-03 08:05:00 | AAPL | Stock | 5.975 | 5.9818 | 5.9732 | 5.9746 | 246148.0 |
| 2009-09-03 08:10:00 | AAPL | Stock | 5.9743 | 5.975 | 5.9679 | 5.9679 | 58716.0 |
| 2009-09-03 08:15:00 | AAPL | Stock | 5.965 | 5.9696 | 5.965 | 5.965 | 8400.0 |
| 2009-09-03 08:20:00 | AAPL | Stock | 5.9664 | 5.9707 | 5.965 | 5.9707 | 48944.0 |
| 2009-09-03 08:25:00 | AAPL | Stock | 5.9704 | 5.9704 | 5.9675 | 5.97 | 61600.0 |
| 2009-09-03 08:30:00 | AAPL | Stock | 5.9675 | 5.9686 | 5.9554 | 5.9554 | 283360.0 |
| 2009-09-03 08:35:00 | AAPL | Stock | 5.9536 | 5.9632 | 5.9529 | 5.9554 | 30800.0 |
| 2009-09-03 08:40:00 | AAPL | Stock | 5.9539 | 5.9571 | 5.9504 | 5.955 | 138040.0 |
| 2009-09-03 08:45:00 | AAPL | Stock | 5.9568 | 5.96 | 5.9568 | 5.96 | 62776.0 |
| 2009-09-03 08:50:00 | AAPL | Stock | 5.9593 | 5.9607 | 5.9582 | 5.9607 | 30632.0 |
| 2009-09-03 08:55:00 | AAPL | Stock | 5.9575 | 5.9614 | 5.9571 | 5.9614 | 81872.0 |
| 2009-09-03 09:00:00 | AAPL | Stock | 5.9571 | 5.9571 | 5.955 | 5.955 | 70084.0 |
| 2009-09-03 09:05:00 | AAPL | Stock | 5.9586 | 5.9668 | 5.9554 | 5.9646 | 129920.0 |
| 2009-09-03 09:10:00 | AAPL | Stock | 5.9664 | 5.9732 | 5.9654 | 5.9732 | 210728.0 |
| 2009-09-03 09:15:00 | AAPL | Stock | 5.9714 | 5.9718 | 5.9668 | 5.9714 | 91392.0 |
| 2009-09-03 09:20:00 | AAPL | Stock | 5.9714 | 5.9714 | 5.9571 | 5.9668 | 125104.0 |
| 2009-09-03 09:25:00 | AAPL | Stock | 5.9646 | 5.9646 | 5.9418 | 5.9504 | 652344.0 |
| 2009-09-03 09:30:00 | AAPL | Stock | 5.9443 | 5.9564 | 5.9289 | 5.9337 | 13249040.0 |
| 2009-09-03 09:35:00 | AAPL | Stock | 5.9332 | 5.9407 | 5.9221 | 5.9321 | 9403212.0 |
| 2009-09-03 09:40:00 | AAPL | Stock | 5.9318 | 5.9346 | 5.9129 | 5.9171 | 10230388.0 |
| 2009-09-03 09:45:00 | AAPL | Stock | 5.9175 | 5.9393 | 5.9121 | 5.9293 | 7542164.0 |
| 2009-09-03 09:50:00 | AAPL | Stock | 5.9293 | 5.9436 | 5.9291 | 5.9388 | 6404608.0 |
| 2009-09-03 09:55:00 | AAPL | Stock | 5.9404 | 5.9446 | 5.9125 | 5.9175 | 9012220.0 |
| 2009-09-03 10:00:00 | AAPL | Stock | 5.9161 | 5.9271 | 5.9029 | 5.9143 | 10496696.0 |
| 2009-09-03 10:05:00 | AAPL | Stock | 5.9157 | 5.9157 | 5.8971 | 5.9139 | 8891288.0 |
| 2009-09-03 10:10:00 | AAPL | Stock | 5.9139 | 5.9232 | 5.9096 | 5.9131 | 4973976.0 |
| 2009-09-03 10:15:00 | AAPL | Stock | 5.9136 | 5.9179 | 5.9004 | 5.9054 | 4655196.0 |
| 2009-09-03 10:20:00 | AAPL | Stock | 5.9054 | 5.9104 | 5.8929 | 5.9029 | 5771416.0 |
| 2009-09-03 10:25:00 | AAPL | Stock | 5.9039 | 5.92 | 5.8996 | 5.9161 | 3924424.0 |
| 2009-09-03 10:30:00 | AAPL | Stock | 5.9157 | 5.9225 | 5.9066 | 5.9221 | 5010796.0 |
| 2009-09-03 10:35:00 | AAPL | Stock | 5.9221 | 5.9264 | 5.9182 | 5.9225 | 3147928.0 |
| 2009-09-03 10:40:00 | AAPL | Stock | 5.9232 | 5.93 | 5.9204 | 5.9271 | 3400684.0 |
| 2009-09-03 10:45:00 | AAPL | Stock | 5.9264 | 5.9271 | 5.9143 | 5.9196 | 3679816.0 |
| 2009-09-03 10:50:00 | AAPL | Stock | 5.9196 | 5.9321 | 5.9193 | 5.9289 | 3217648.0 |
| 2009-09-03 10:55:00 | AAPL | Stock | 5.9296 | 5.9304 | 5.9261 | 5.9302 | 2255708.0 |
| 2009-09-03 11:00:00 | AAPL | Stock | 5.9293 | 5.945 | 5.9293 | 5.94 | 4992876.0 |
| 2009-09-03 11:05:00 | AAPL | Stock | 5.9407 | 5.955 | 5.9396 | 5.9532 | 5075476.0 |
| 2009-09-03 11:10:00 | AAPL | Stock | 5.9536 | 5.955 | 5.9414 | 5.9414 | 3691632.0 |
| 2009-09-03 11:15:00 | AAPL | Stock | 5.9425 | 5.9425 | 5.9375 | 5.9375 | 2136568.0 |
| 2009-09-03 11:20:00 | AAPL | Stock | 5.9379 | 5.9461 | 5.9357 | 5.9432 | 2430120.0 |
> showing 50 of 312,258 rows — these rows as CSV