PREVIEW / stock_5min / 2013-08-12
file: by_date/stock_5min/2013/2013-08-12.parquet size: 5.1 MB rows: 339,796 symbols: 3,521
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-08-12 04:35:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 2800.0 |
| 2013-08-12 04:40:00 | AAPL | Stock | 16.2743 | 16.2743 | 16.2743 | 16.2743 | 2800.0 |
| 2013-08-12 04:55:00 | AAPL | Stock | 16.2611 | 16.2611 | 16.2611 | 16.2611 | 2800.0 |
| 2013-08-12 05:00:00 | AAPL | Stock | 16.2625 | 16.2625 | 16.2625 | 16.2625 | 2800.0 |
| 2013-08-12 05:10:00 | AAPL | Stock | 16.2379 | 16.2379 | 16.2379 | 16.2379 | 42000.0 |
| 2013-08-12 05:35:00 | AAPL | Stock | 16.2689 | 16.2689 | 16.2589 | 16.2689 | 11200.0 |
| 2013-08-12 06:00:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-08-12 06:05:00 | AAPL | Stock | 16.2571 | 16.2571 | 16.25 | 16.25 | 14000.0 |
| 2013-08-12 06:10:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 8400.0 |
| 2013-08-12 06:30:00 | AAPL | Stock | 16.285 | 16.2854 | 16.285 | 16.2854 | 5600.0 |
| 2013-08-12 06:35:00 | AAPL | Stock | 16.3029 | 16.3029 | 16.3029 | 16.3029 | 2800.0 |
| 2013-08-12 06:50:00 | AAPL | Stock | 16.2943 | 16.3054 | 16.2939 | 16.3029 | 33600.0 |
| 2013-08-12 07:00:00 | AAPL | Stock | 16.3321 | 16.3375 | 16.2857 | 16.3214 | 43288.0 |
| 2013-08-12 07:05:00 | AAPL | Stock | 16.3125 | 16.3179 | 16.3125 | 16.3179 | 14000.0 |
| 2013-08-12 07:10:00 | AAPL | Stock | 16.3139 | 16.3139 | 16.3139 | 16.3139 | 2800.0 |
| 2013-08-12 07:15:00 | AAPL | Stock | 16.3043 | 16.3043 | 16.2879 | 16.2879 | 22400.0 |
| 2013-08-12 07:20:00 | AAPL | Stock | 16.3 | 16.3029 | 16.3 | 16.3029 | 11200.0 |
| 2013-08-12 07:25:00 | AAPL | Stock | 16.3036 | 16.3168 | 16.3036 | 16.3161 | 44380.0 |
| 2013-08-12 07:30:00 | AAPL | Stock | 16.3139 | 16.3393 | 16.3139 | 16.3254 | 173544.0 |
| 2013-08-12 07:35:00 | AAPL | Stock | 16.335 | 16.3679 | 16.335 | 16.3482 | 216076.0 |
| 2013-08-12 07:40:00 | AAPL | Stock | 16.3432 | 16.3432 | 16.3236 | 16.3271 | 22960.0 |
| 2013-08-12 07:45:00 | AAPL | Stock | 16.3271 | 16.3393 | 16.3271 | 16.3393 | 98000.0 |
| 2013-08-12 07:50:00 | AAPL | Stock | 16.335 | 16.335 | 16.3136 | 16.3136 | 39200.0 |
| 2013-08-12 07:55:00 | AAPL | Stock | 16.3143 | 16.3143 | 16.3018 | 16.3046 | 74900.0 |
| 2013-08-12 08:00:00 | AAPL | Stock | 16.3046 | 16.3471 | 16.2857 | 16.3214 | 681912.0 |
| 2013-08-12 08:05:00 | AAPL | Stock | 16.3289 | 16.34 | 16.3186 | 16.3304 | 116480.0 |
| 2013-08-12 08:10:00 | AAPL | Stock | 16.3275 | 16.3357 | 16.3214 | 16.3221 | 88732.0 |
| 2013-08-12 08:15:00 | AAPL | Stock | 16.3268 | 16.3411 | 16.3268 | 16.3411 | 285740.0 |
| 2013-08-12 08:20:00 | AAPL | Stock | 16.3407 | 16.3446 | 16.3354 | 16.3446 | 181664.0 |
| 2013-08-12 08:25:00 | AAPL | Stock | 16.3443 | 16.3536 | 16.3429 | 16.3489 | 389564.0 |
| 2013-08-12 08:30:00 | AAPL | Stock | 16.3507 | 16.3529 | 16.3379 | 16.3521 | 156800.0 |
| 2013-08-12 08:35:00 | AAPL | Stock | 16.3532 | 16.3629 | 16.3396 | 16.355 | 287476.0 |
| 2013-08-12 08:40:00 | AAPL | Stock | 16.3496 | 16.3496 | 16.3286 | 16.3375 | 134148.0 |
| 2013-08-12 08:45:00 | AAPL | Stock | 16.3421 | 16.3421 | 16.3321 | 16.3321 | 57260.0 |
| 2013-08-12 08:50:00 | AAPL | Stock | 16.3361 | 16.3411 | 16.3361 | 16.3393 | 30772.0 |
| 2013-08-12 08:55:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3257 | 16.3275 | 64708.0 |
| 2013-08-12 09:00:00 | AAPL | Stock | 16.3257 | 16.3304 | 16.3171 | 16.33 | 263732.0 |
| 2013-08-12 09:05:00 | AAPL | Stock | 16.33 | 16.3339 | 16.325 | 16.3336 | 169652.0 |
| 2013-08-12 09:10:00 | AAPL | Stock | 16.3357 | 16.3382 | 16.3271 | 16.3325 | 103992.0 |
| 2013-08-12 09:15:00 | AAPL | Stock | 16.3386 | 16.3393 | 16.3289 | 16.3371 | 169932.0 |
| 2013-08-12 09:20:00 | AAPL | Stock | 16.3393 | 16.34 | 16.325 | 16.3286 | 252784.0 |
| 2013-08-12 09:25:00 | AAPL | Stock | 16.3282 | 16.3286 | 16.2996 | 16.3104 | 472836.0 |
| 2013-08-12 09:30:00 | AAPL | Stock | 16.3046 | 16.3957 | 16.3046 | 16.3404 | 16840236.0 |
| 2013-08-12 09:35:00 | AAPL | Stock | 16.3404 | 16.4596 | 16.3379 | 16.4361 | 17285016.0 |
| 2013-08-12 09:40:00 | AAPL | Stock | 16.4393 | 16.4675 | 16.4173 | 16.4293 | 8804824.0 |
| 2013-08-12 09:45:00 | AAPL | Stock | 16.4286 | 16.481 | 16.4154 | 16.4561 | 8343608.0 |
| 2013-08-12 09:50:00 | AAPL | Stock | 16.4543 | 16.535 | 16.4543 | 16.51 | 9701076.0 |
| 2013-08-12 09:55:00 | AAPL | Stock | 16.5057 | 16.5118 | 16.4829 | 16.4907 | 5746076.0 |
| 2013-08-12 10:00:00 | AAPL | Stock | 16.4904 | 16.5029 | 16.4764 | 16.4954 | 5771612.0 |
| 2013-08-12 10:05:00 | AAPL | Stock | 16.4925 | 16.5461 | 16.4925 | 16.5286 | 12819240.0 |
> showing 50 of 339,796 rows — these rows as CSV