PREVIEW / stock_5min / 2013-10-29
file: by_date/stock_5min/2013/2013-10-29.parquet size: 5.2 MB rows: 341,859 symbols: 3,546
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-29 04:00:00 | AAPL | Stock | 19.0575 | 19.0575 | 18.7143 | 18.8111 | 73920.0 |
| 2013-10-29 04:05:00 | AAPL | Stock | 18.8021 | 18.8157 | 18.8021 | 18.8157 | 16800.0 |
| 2013-10-29 04:10:00 | AAPL | Stock | 18.815 | 18.8393 | 18.7914 | 18.8393 | 39200.0 |
| 2013-10-29 04:15:00 | AAPL | Stock | 18.8093 | 18.8093 | 18.8093 | 18.8093 | 10640.0 |
| 2013-10-29 04:20:00 | AAPL | Stock | 18.8218 | 18.8429 | 18.8218 | 18.8429 | 33600.0 |
| 2013-10-29 04:25:00 | AAPL | Stock | 18.8514 | 18.8825 | 18.8514 | 18.8736 | 40880.0 |
| 2013-10-29 04:30:00 | AAPL | Stock | 18.8775 | 18.8775 | 18.8768 | 18.8775 | 11200.0 |
| 2013-10-29 04:35:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-10-29 04:40:00 | AAPL | Stock | 18.8729 | 18.9054 | 18.8729 | 18.9054 | 46200.0 |
| 2013-10-29 04:45:00 | AAPL | Stock | 18.9093 | 18.9179 | 18.9093 | 18.9161 | 19600.0 |
| 2013-10-29 04:50:00 | AAPL | Stock | 18.9161 | 18.9161 | 18.9071 | 18.9071 | 5600.0 |
| 2013-10-29 04:55:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2013-10-29 05:00:00 | AAPL | Stock | 18.9032 | 18.9068 | 18.9032 | 18.9068 | 11200.0 |
| 2013-10-29 05:05:00 | AAPL | Stock | 18.8754 | 18.8754 | 18.875 | 18.875 | 11172.0 |
| 2013-10-29 05:15:00 | AAPL | Stock | 18.8571 | 18.8839 | 18.8571 | 18.8839 | 11200.0 |
| 2013-10-29 05:20:00 | AAPL | Stock | 18.875 | 18.9089 | 18.875 | 18.9089 | 20160.0 |
| 2013-10-29 05:25:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 2800.0 |
| 2013-10-29 05:30:00 | AAPL | Stock | 18.9039 | 18.9039 | 18.9039 | 18.9039 | 2800.0 |
| 2013-10-29 05:35:00 | AAPL | Stock | 18.9143 | 18.9286 | 18.9118 | 18.9286 | 91560.0 |
| 2013-10-29 05:40:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9 | 18.9282 | 45052.0 |
| 2013-10-29 05:45:00 | AAPL | Stock | 18.9007 | 18.9286 | 18.9007 | 18.9286 | 11200.0 |
| 2013-10-29 05:50:00 | AAPL | Stock | 18.9364 | 18.9621 | 18.9364 | 18.9621 | 16800.0 |
| 2013-10-29 06:00:00 | AAPL | Stock | 18.9089 | 18.9268 | 18.9057 | 18.9268 | 28000.0 |
| 2013-10-29 06:05:00 | AAPL | Stock | 18.9429 | 18.9461 | 18.9429 | 18.9429 | 11844.0 |
| 2013-10-29 06:10:00 | AAPL | Stock | 18.96 | 18.9857 | 18.96 | 18.9857 | 41300.0 |
| 2013-10-29 06:20:00 | AAPL | Stock | 18.9714 | 18.9893 | 18.9643 | 18.9893 | 18480.0 |
| 2013-10-29 06:25:00 | AAPL | Stock | 18.9982 | 19.0304 | 18.9939 | 19.0304 | 73220.0 |
| 2013-10-29 06:30:00 | AAPL | Stock | 19.0357 | 19.0407 | 18.9821 | 18.9821 | 54600.0 |
| 2013-10-29 06:35:00 | AAPL | Stock | 18.9754 | 18.9754 | 18.9714 | 18.9714 | 5600.0 |
| 2013-10-29 06:40:00 | AAPL | Stock | 18.9964 | 19.0143 | 18.9964 | 19.0036 | 50400.0 |
| 2013-10-29 06:50:00 | AAPL | Stock | 19.0271 | 19.0271 | 19.0271 | 19.0271 | 2800.0 |
| 2013-10-29 06:55:00 | AAPL | Stock | 19.0286 | 19.0286 | 19.0 | 19.0004 | 53564.0 |
| 2013-10-29 07:00:00 | AAPL | Stock | 19.0029 | 19.0136 | 18.9625 | 18.9761 | 180180.0 |
| 2013-10-29 07:05:00 | AAPL | Stock | 18.9693 | 18.9821 | 18.9107 | 18.9164 | 334852.0 |
| 2013-10-29 07:10:00 | AAPL | Stock | 18.9261 | 18.995 | 18.9261 | 18.9643 | 569996.0 |
| 2013-10-29 07:15:00 | AAPL | Stock | 18.9643 | 18.9732 | 18.9196 | 18.9218 | 326340.0 |
| 2013-10-29 07:20:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.8993 | 18.8993 | 242032.0 |
| 2013-10-29 07:25:00 | AAPL | Stock | 18.9025 | 18.9286 | 18.9025 | 18.9246 | 158984.0 |
| 2013-10-29 07:30:00 | AAPL | Stock | 18.9143 | 18.9286 | 18.875 | 18.8921 | 676732.0 |
| 2013-10-29 07:35:00 | AAPL | Stock | 18.8754 | 18.9821 | 18.8571 | 18.9821 | 509012.0 |
| 2013-10-29 07:40:00 | AAPL | Stock | 18.9943 | 19.0871 | 18.9807 | 19.0718 | 1121148.0 |
| 2013-10-29 07:45:00 | AAPL | Stock | 19.0711 | 19.1071 | 19.0393 | 19.0893 | 1065568.0 |
| 2013-10-29 07:50:00 | AAPL | Stock | 19.0882 | 19.1332 | 19.0714 | 19.08 | 850836.0 |
| 2013-10-29 07:55:00 | AAPL | Stock | 19.0857 | 19.15 | 19.0729 | 19.15 | 738108.0 |
| 2013-10-29 08:00:00 | AAPL | Stock | 19.1386 | 19.15 | 18.7857 | 19.0275 | 2638552.0 |
| 2013-10-29 08:05:00 | AAPL | Stock | 19.0536 | 19.0714 | 19.0179 | 19.0246 | 917980.0 |
| 2013-10-29 08:10:00 | AAPL | Stock | 19.0243 | 19.0446 | 18.9936 | 19.0318 | 788004.0 |
| 2013-10-29 08:15:00 | AAPL | Stock | 19.0357 | 19.0675 | 19.0318 | 19.0486 | 394268.0 |
| 2013-10-29 08:20:00 | AAPL | Stock | 19.0364 | 19.0489 | 19.0275 | 19.0304 | 221228.0 |
| 2013-10-29 08:25:00 | AAPL | Stock | 19.0314 | 19.0414 | 18.9879 | 19.0139 | 611996.0 |
> showing 50 of 341,859 rows — these rows as CSV