PREVIEW / stock_5min / 2012-06-21
file: by_date/stock_5min/2012/2012-06-21.parquet size: 5.0 MB rows: 334,394 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-21 04:00:00 | AAPL | Stock | 20.8571 | 20.8571 | 20.8571 | 20.8571 | 28000.0 |
| 2012-06-21 04:25:00 | AAPL | Stock | 20.8393 | 20.8393 | 20.8393 | 20.8393 | 2800.0 |
| 2012-06-21 07:10:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8925 | 20.8929 | 19068.0 |
| 2012-06-21 07:15:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 6552.0 |
| 2012-06-21 07:35:00 | AAPL | Stock | 20.9196 | 20.9264 | 20.9196 | 20.9264 | 5600.0 |
| 2012-06-21 07:40:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.9111 | 20.9111 | 5600.0 |
| 2012-06-21 07:45:00 | AAPL | Stock | 20.9286 | 20.9375 | 20.9286 | 20.9311 | 33600.0 |
| 2012-06-21 07:50:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9125 | 20.9125 | 14000.0 |
| 2012-06-21 08:00:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.9032 | 20.9064 | 57344.0 |
| 2012-06-21 08:05:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 2800.0 |
| 2012-06-21 08:10:00 | AAPL | Stock | 20.9089 | 20.9268 | 20.9064 | 20.92 | 89712.0 |
| 2012-06-21 08:15:00 | AAPL | Stock | 20.9196 | 20.9196 | 20.9161 | 20.9161 | 11200.0 |
| 2012-06-21 08:20:00 | AAPL | Stock | 20.9161 | 20.9161 | 20.9018 | 20.9064 | 19600.0 |
| 2012-06-21 08:25:00 | AAPL | Stock | 20.9018 | 20.9018 | 20.8932 | 20.8932 | 50400.0 |
| 2012-06-21 08:30:00 | AAPL | Stock | 20.8968 | 20.9082 | 20.8857 | 20.8982 | 56000.0 |
| 2012-06-21 08:35:00 | AAPL | Stock | 20.9118 | 20.9221 | 20.9039 | 20.9039 | 19600.0 |
| 2012-06-21 08:40:00 | AAPL | Stock | 20.9207 | 20.9211 | 20.9143 | 20.9143 | 14000.0 |
| 2012-06-21 08:50:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.8929 | 20.8929 | 86156.0 |
| 2012-06-21 09:00:00 | AAPL | Stock | 20.8929 | 20.8964 | 20.8911 | 20.8911 | 36400.0 |
| 2012-06-21 09:05:00 | AAPL | Stock | 20.8875 | 20.8893 | 20.8736 | 20.8893 | 67200.0 |
| 2012-06-21 09:10:00 | AAPL | Stock | 20.8921 | 20.8971 | 20.8839 | 20.8971 | 31248.0 |
| 2012-06-21 09:15:00 | AAPL | Stock | 20.8925 | 20.9029 | 20.8925 | 20.9029 | 38500.0 |
| 2012-06-21 09:20:00 | AAPL | Stock | 20.8996 | 20.9104 | 20.8936 | 20.9104 | 112000.0 |
| 2012-06-21 09:25:00 | AAPL | Stock | 20.9107 | 20.9361 | 20.905 | 20.915 | 346360.0 |
| 2012-06-21 09:30:00 | AAPL | Stock | 20.9086 | 20.9925 | 20.8771 | 20.9718 | 9410856.0 |
| 2012-06-21 09:35:00 | AAPL | Stock | 20.9714 | 20.9875 | 20.9121 | 20.9371 | 5395656.0 |
| 2012-06-21 09:40:00 | AAPL | Stock | 20.9357 | 20.9586 | 20.9254 | 20.9586 | 3867360.0 |
| 2012-06-21 09:45:00 | AAPL | Stock | 20.9596 | 20.9618 | 20.9168 | 20.92 | 4171216.0 |
| 2012-06-21 09:50:00 | AAPL | Stock | 20.9182 | 20.9739 | 20.9161 | 20.9321 | 5292392.0 |
| 2012-06-21 09:55:00 | AAPL | Stock | 20.9324 | 20.9357 | 20.92 | 20.9273 | 4059496.0 |
| 2012-06-21 10:00:00 | AAPL | Stock | 20.9293 | 20.9425 | 20.8643 | 20.8793 | 8239560.0 |
| 2012-06-21 10:05:00 | AAPL | Stock | 20.8746 | 20.9125 | 20.8689 | 20.8996 | 4790688.0 |
| 2012-06-21 10:10:00 | AAPL | Stock | 20.8921 | 20.9396 | 20.8761 | 20.9329 | 3914988.0 |
| 2012-06-21 10:15:00 | AAPL | Stock | 20.9299 | 20.9536 | 20.9247 | 20.9375 | 3345636.0 |
| 2012-06-21 10:20:00 | AAPL | Stock | 20.9386 | 20.945 | 20.9168 | 20.9246 | 2763852.0 |
| 2012-06-21 10:25:00 | AAPL | Stock | 20.9246 | 20.9293 | 20.8979 | 20.925 | 3057880.0 |
| 2012-06-21 10:30:00 | AAPL | Stock | 20.9221 | 20.9243 | 20.9086 | 20.9239 | 1678292.0 |
| 2012-06-21 10:35:00 | AAPL | Stock | 20.9239 | 20.9464 | 20.9236 | 20.9386 | 3499692.0 |
| 2012-06-21 10:40:00 | AAPL | Stock | 20.9411 | 20.955 | 20.9286 | 20.9525 | 3366132.0 |
| 2012-06-21 10:45:00 | AAPL | Stock | 20.955 | 20.9793 | 20.9524 | 20.9607 | 5606496.0 |
| 2012-06-21 10:50:00 | AAPL | Stock | 20.9625 | 21.0079 | 20.9579 | 21.0007 | 6607692.0 |
| 2012-06-21 10:55:00 | AAPL | Stock | 21.0036 | 21.0054 | 20.9779 | 20.9943 | 3880940.0 |
| 2012-06-21 11:00:00 | AAPL | Stock | 20.9932 | 20.9996 | 20.9529 | 20.9529 | 4703412.0 |
| 2012-06-21 11:05:00 | AAPL | Stock | 20.9532 | 20.9661 | 20.9207 | 20.9218 | 4901484.0 |
| 2012-06-21 11:10:00 | AAPL | Stock | 20.9239 | 20.938 | 20.9011 | 20.9107 | 5245240.0 |
| 2012-06-21 11:15:00 | AAPL | Stock | 20.9107 | 20.9439 | 20.9054 | 20.9393 | 3285632.0 |
| 2012-06-21 11:20:00 | AAPL | Stock | 20.9393 | 20.9393 | 20.9161 | 20.9161 | 1823108.0 |
| 2012-06-21 11:25:00 | AAPL | Stock | 20.9161 | 20.9193 | 20.9 | 20.9065 | 3199028.0 |
| 2012-06-21 11:30:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.8821 | 20.8876 | 3718120.0 |
| 2012-06-21 11:35:00 | AAPL | Stock | 20.8914 | 20.9049 | 20.8729 | 20.8957 | 3979612.0 |
> showing 50 of 334,394 rows — these rows as CSV