PREVIEW / stock_5min / 2014-05-19
file: by_date/stock_5min/2014/2014-05-19.parquet size: 5.3 MB rows: 353,643 symbols: 3,552
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-19 04:00:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 8400.0 |
| 2014-05-19 04:05:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.2536 | 21.2536 | 103600.0 |
| 2014-05-19 04:30:00 | AAPL | Stock | 21.2579 | 21.2579 | 21.2579 | 21.2579 | 2800.0 |
| 2014-05-19 04:40:00 | AAPL | Stock | 21.2679 | 21.2679 | 21.2679 | 21.2679 | 2800.0 |
| 2014-05-19 04:50:00 | AAPL | Stock | 21.2514 | 21.2514 | 21.25 | 21.25 | 5600.0 |
| 2014-05-19 05:10:00 | AAPL | Stock | 21.2539 | 21.2539 | 21.2539 | 21.2539 | 2800.0 |
| 2014-05-19 05:30:00 | AAPL | Stock | 21.2579 | 21.2579 | 21.2571 | 21.2571 | 11200.0 |
| 2014-05-19 05:40:00 | AAPL | Stock | 21.2593 | 21.2593 | 21.2593 | 21.2593 | 2800.0 |
| 2014-05-19 05:50:00 | AAPL | Stock | 21.2604 | 21.2604 | 21.2489 | 21.2489 | 25200.0 |
| 2014-05-19 05:55:00 | AAPL | Stock | 21.265 | 21.2657 | 21.265 | 21.2657 | 5600.0 |
| 2014-05-19 06:00:00 | AAPL | Stock | 21.2657 | 21.2657 | 21.2657 | 21.2657 | 10304.0 |
| 2014-05-19 06:05:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.2589 | 21.2589 | 5600.0 |
| 2014-05-19 06:30:00 | AAPL | Stock | 21.2857 | 21.2925 | 21.2857 | 21.2925 | 8400.0 |
| 2014-05-19 06:45:00 | AAPL | Stock | 21.2971 | 21.3 | 21.2886 | 21.2886 | 32396.0 |
| 2014-05-19 06:50:00 | AAPL | Stock | 21.2886 | 21.2886 | 21.2864 | 21.2864 | 22400.0 |
| 2014-05-19 07:00:00 | AAPL | Stock | 21.2864 | 21.2889 | 21.2821 | 21.2889 | 52864.0 |
| 2014-05-19 07:05:00 | AAPL | Stock | 21.2889 | 21.2943 | 21.2889 | 21.2929 | 38640.0 |
| 2014-05-19 07:10:00 | AAPL | Stock | 21.2964 | 21.3036 | 21.2964 | 21.3036 | 22400.0 |
| 2014-05-19 07:15:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.3036 | 21.3036 | 8400.0 |
| 2014-05-19 07:25:00 | AAPL | Stock | 21.3036 | 21.3125 | 21.3036 | 21.3036 | 31976.0 |
| 2014-05-19 07:30:00 | AAPL | Stock | 21.3036 | 21.3143 | 21.3036 | 21.3143 | 48300.0 |
| 2014-05-19 07:40:00 | AAPL | Stock | 21.3136 | 21.3464 | 21.3136 | 21.3268 | 76300.0 |
| 2014-05-19 07:45:00 | AAPL | Stock | 21.3286 | 21.3304 | 21.3268 | 21.3304 | 27720.0 |
| 2014-05-19 07:50:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3196 | 21.3196 | 8400.0 |
| 2014-05-19 07:55:00 | AAPL | Stock | 21.3168 | 21.3214 | 21.3168 | 21.3214 | 39032.0 |
| 2014-05-19 08:00:00 | AAPL | Stock | 21.3293 | 21.3293 | 21.2889 | 21.3179 | 153216.0 |
| 2014-05-19 08:05:00 | AAPL | Stock | 21.3179 | 21.3207 | 21.3161 | 21.3207 | 35000.0 |
| 2014-05-19 08:10:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3161 | 21.3179 | 57680.0 |
| 2014-05-19 08:15:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 29820.0 |
| 2014-05-19 08:20:00 | AAPL | Stock | 21.3232 | 21.3279 | 21.3232 | 21.3279 | 62776.0 |
| 2014-05-19 08:25:00 | AAPL | Stock | 21.3296 | 21.3304 | 21.325 | 21.3268 | 57680.0 |
| 2014-05-19 08:30:00 | AAPL | Stock | 21.3286 | 21.3318 | 21.3268 | 21.3318 | 75908.0 |
| 2014-05-19 08:35:00 | AAPL | Stock | 21.3321 | 21.3382 | 21.3321 | 21.3339 | 96908.0 |
| 2014-05-19 08:40:00 | AAPL | Stock | 21.3318 | 21.3382 | 21.3293 | 21.3321 | 70000.0 |
| 2014-05-19 08:45:00 | AAPL | Stock | 21.3304 | 21.3304 | 21.3107 | 21.3107 | 78176.0 |
| 2014-05-19 08:50:00 | AAPL | Stock | 21.3146 | 21.3275 | 21.3089 | 21.3164 | 67564.0 |
| 2014-05-19 08:55:00 | AAPL | Stock | 21.3114 | 21.3279 | 21.3107 | 21.3257 | 89124.0 |
| 2014-05-19 09:00:00 | AAPL | Stock | 21.3264 | 21.335 | 21.3264 | 21.3321 | 69748.0 |
| 2014-05-19 09:05:00 | AAPL | Stock | 21.3321 | 21.3339 | 21.3318 | 21.3325 | 53200.0 |
| 2014-05-19 09:10:00 | AAPL | Stock | 21.3314 | 21.3464 | 21.3304 | 21.3429 | 179060.0 |
| 2014-05-19 09:15:00 | AAPL | Stock | 21.3439 | 21.35 | 21.3332 | 21.3407 | 202048.0 |
| 2014-05-19 09:20:00 | AAPL | Stock | 21.3421 | 21.3589 | 21.3396 | 21.3571 | 241500.0 |
| 2014-05-19 09:25:00 | AAPL | Stock | 21.3571 | 21.3661 | 21.3329 | 21.3411 | 587860.0 |
| 2014-05-19 09:30:00 | AAPL | Stock | 21.3518 | 21.4714 | 21.3332 | 21.4571 | 21280028.0 |
| 2014-05-19 09:35:00 | AAPL | Stock | 21.4514 | 21.5443 | 21.4505 | 21.5355 | 14660240.0 |
| 2014-05-19 09:40:00 | AAPL | Stock | 21.5361 | 21.63 | 21.5336 | 21.6221 | 17899420.0 |
| 2014-05-19 09:45:00 | AAPL | Stock | 21.6243 | 21.6282 | 21.5589 | 21.5768 | 10306940.0 |
| 2014-05-19 09:50:00 | AAPL | Stock | 21.5807 | 21.5914 | 21.5468 | 21.5843 | 6553428.0 |
| 2014-05-19 09:55:00 | AAPL | Stock | 21.5825 | 21.5911 | 21.5368 | 21.5704 | 5269264.0 |
| 2014-05-19 10:00:00 | AAPL | Stock | 21.5704 | 21.5946 | 21.5554 | 21.5754 | 5242132.0 |
> showing 50 of 353,643 rows — these rows as CSV