PREVIEW / stock_5min / 2013-05-06
file: by_date/stock_5min/2013/2013-05-06.parquet size: 4.9 MB rows: 328,586 symbols: 3,486
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-05-06 04:10:00 | AAPL | Stock | 16.1071 | 16.1071 | 16.1071 | 16.1071 | 2800.0 |
| 2013-05-06 04:20:00 | AAPL | Stock | 16.1261 | 16.1261 | 16.125 | 16.125 | 5600.0 |
| 2013-05-06 04:30:00 | AAPL | Stock | 16.1289 | 16.1289 | 16.1289 | 16.1289 | 2800.0 |
| 2013-05-06 04:35:00 | AAPL | Stock | 16.1386 | 16.1386 | 16.1225 | 16.1225 | 8400.0 |
| 2013-05-06 04:50:00 | AAPL | Stock | 16.1354 | 16.1354 | 16.1354 | 16.1354 | 2800.0 |
| 2013-05-06 05:10:00 | AAPL | Stock | 16.1375 | 16.1375 | 16.1375 | 16.1375 | 2800.0 |
| 2013-05-06 05:55:00 | AAPL | Stock | 16.105 | 16.105 | 16.105 | 16.105 | 2800.0 |
| 2013-05-06 06:15:00 | AAPL | Stock | 16.1071 | 16.1161 | 16.1071 | 16.1161 | 22064.0 |
| 2013-05-06 07:00:00 | AAPL | Stock | 16.1143 | 16.1143 | 16.1143 | 16.1143 | 2800.0 |
| 2013-05-06 07:05:00 | AAPL | Stock | 16.1161 | 16.1161 | 16.1161 | 16.1161 | 5600.0 |
| 2013-05-06 07:10:00 | AAPL | Stock | 16.1289 | 16.1646 | 16.1232 | 16.1607 | 53956.0 |
| 2013-05-06 07:15:00 | AAPL | Stock | 16.1525 | 16.1607 | 16.1354 | 16.1354 | 76496.0 |
| 2013-05-06 07:20:00 | AAPL | Stock | 16.1343 | 16.1343 | 16.1318 | 16.1318 | 7000.0 |
| 2013-05-06 07:25:00 | AAPL | Stock | 16.1429 | 16.1554 | 16.1418 | 16.1518 | 38500.0 |
| 2013-05-06 07:30:00 | AAPL | Stock | 16.1518 | 16.1536 | 16.1429 | 16.1429 | 22400.0 |
| 2013-05-06 07:35:00 | AAPL | Stock | 16.1396 | 16.1536 | 16.1357 | 16.1464 | 117880.0 |
| 2013-05-06 07:40:00 | AAPL | Stock | 16.1482 | 16.1482 | 16.1418 | 16.1429 | 50820.0 |
| 2013-05-06 07:45:00 | AAPL | Stock | 16.1432 | 16.1518 | 16.1429 | 16.1457 | 58800.0 |
| 2013-05-06 07:50:00 | AAPL | Stock | 16.1518 | 16.1696 | 16.1454 | 16.1607 | 53760.0 |
| 2013-05-06 07:55:00 | AAPL | Stock | 16.1746 | 16.21 | 16.1746 | 16.1964 | 136304.0 |
| 2013-05-06 08:00:00 | AAPL | Stock | 16.1914 | 16.2475 | 16.1246 | 16.2368 | 476364.0 |
| 2013-05-06 08:05:00 | AAPL | Stock | 16.2361 | 16.2446 | 16.2161 | 16.2161 | 330456.0 |
| 2013-05-06 08:10:00 | AAPL | Stock | 16.2182 | 16.2314 | 16.2032 | 16.2032 | 543620.0 |
| 2013-05-06 08:15:00 | AAPL | Stock | 16.2143 | 16.2182 | 16.2 | 16.2018 | 246932.0 |
| 2013-05-06 08:20:00 | AAPL | Stock | 16.2021 | 16.2286 | 16.1993 | 16.2275 | 269388.0 |
| 2013-05-06 08:25:00 | AAPL | Stock | 16.2246 | 16.2389 | 16.2179 | 16.2321 | 238168.0 |
| 2013-05-06 08:30:00 | AAPL | Stock | 16.2321 | 16.2732 | 16.2286 | 16.2625 | 683928.0 |
| 2013-05-06 08:35:00 | AAPL | Stock | 16.2696 | 16.305 | 16.2607 | 16.2821 | 614908.0 |
| 2013-05-06 08:40:00 | AAPL | Stock | 16.2804 | 16.3139 | 16.2804 | 16.2946 | 570388.0 |
| 2013-05-06 08:45:00 | AAPL | Stock | 16.3 | 16.3125 | 16.2964 | 16.3125 | 219772.0 |
| 2013-05-06 08:50:00 | AAPL | Stock | 16.3125 | 16.3382 | 16.3071 | 16.3375 | 660100.0 |
| 2013-05-06 08:55:00 | AAPL | Stock | 16.3357 | 16.345 | 16.3107 | 16.3164 | 424060.0 |
| 2013-05-06 09:00:00 | AAPL | Stock | 16.3104 | 16.3364 | 16.3046 | 16.3354 | 500640.0 |
| 2013-05-06 09:05:00 | AAPL | Stock | 16.3321 | 16.3321 | 16.3182 | 16.3254 | 501340.0 |
| 2013-05-06 09:10:00 | AAPL | Stock | 16.3241 | 16.335 | 16.3204 | 16.3232 | 515312.0 |
| 2013-05-06 09:15:00 | AAPL | Stock | 16.3207 | 16.3279 | 16.3179 | 16.3271 | 776580.0 |
| 2013-05-06 09:20:00 | AAPL | Stock | 16.3243 | 16.3268 | 16.3214 | 16.3236 | 271040.0 |
| 2013-05-06 09:25:00 | AAPL | Stock | 16.3214 | 16.3232 | 16.2843 | 16.2843 | 679392.0 |
| 2013-05-06 09:30:00 | AAPL | Stock | 16.2754 | 16.3671 | 16.2254 | 16.3668 | 32719400.0 |
| 2013-05-06 09:35:00 | AAPL | Stock | 16.3671 | 16.3857 | 16.3261 | 16.3689 | 17910116.0 |
| 2013-05-06 09:40:00 | AAPL | Stock | 16.3718 | 16.4179 | 16.3339 | 16.4179 | 16830632.0 |
| 2013-05-06 09:45:00 | AAPL | Stock | 16.4179 | 16.4243 | 16.3854 | 16.4103 | 13483792.0 |
| 2013-05-06 09:50:00 | AAPL | Stock | 16.4075 | 16.455 | 16.3929 | 16.4516 | 15702400.0 |
| 2013-05-06 09:55:00 | AAPL | Stock | 16.4517 | 16.4714 | 16.4361 | 16.4514 | 15093036.0 |
| 2013-05-06 10:00:00 | AAPL | Stock | 16.4518 | 16.4582 | 16.3986 | 16.4107 | 9891112.0 |
| 2013-05-06 10:05:00 | AAPL | Stock | 16.4102 | 16.4344 | 16.4029 | 16.4107 | 5513760.0 |
| 2013-05-06 10:10:00 | AAPL | Stock | 16.4082 | 16.4236 | 16.3896 | 16.3932 | 7481852.0 |
| 2013-05-06 10:15:00 | AAPL | Stock | 16.3946 | 16.4371 | 16.3896 | 16.4229 | 10607996.0 |
| 2013-05-06 10:20:00 | AAPL | Stock | 16.425 | 16.4321 | 16.4075 | 16.4257 | 7148484.0 |
| 2013-05-06 10:25:00 | AAPL | Stock | 16.4264 | 16.4521 | 16.3982 | 16.3989 | 7378700.0 |
> showing 50 of 328,586 rows — these rows as CSV