PREVIEW / stock_5min / 2013-03-08
file: by_date/stock_5min/2013/2013-03-08.parquet size: 5.0 MB rows: 335,738 symbols: 3,494
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-03-08 04:00:00 | AAPL | Stock | 15.3964 | 15.3964 | 15.3921 | 15.3921 | 25200.0 |
| 2013-03-08 04:40:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 5600.0 |
| 2013-03-08 05:00:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-03-08 05:15:00 | AAPL | Stock | 15.415 | 15.415 | 15.415 | 15.415 | 2800.0 |
| 2013-03-08 05:25:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 5600.0 |
| 2013-03-08 05:55:00 | AAPL | Stock | 15.3964 | 15.4196 | 15.3964 | 15.4196 | 5600.0 |
| 2013-03-08 06:00:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-03-08 06:20:00 | AAPL | Stock | 15.4189 | 15.4196 | 15.4189 | 15.4196 | 10500.0 |
| 2013-03-08 06:30:00 | AAPL | Stock | 15.4189 | 15.4196 | 15.4189 | 15.4196 | 12908.0 |
| 2013-03-08 06:35:00 | AAPL | Stock | 15.4161 | 15.4161 | 15.4161 | 15.4161 | 15400.0 |
| 2013-03-08 06:45:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 5600.0 |
| 2013-03-08 06:50:00 | AAPL | Stock | 15.4071 | 15.4071 | 15.4068 | 15.4068 | 18200.0 |
| 2013-03-08 07:00:00 | AAPL | Stock | 15.4089 | 15.4286 | 15.4089 | 15.4286 | 85932.0 |
| 2013-03-08 07:05:00 | AAPL | Stock | 15.4325 | 15.4339 | 15.4325 | 15.4325 | 66304.0 |
| 2013-03-08 07:10:00 | AAPL | Stock | 15.4286 | 15.4464 | 15.4286 | 15.4464 | 85400.0 |
| 2013-03-08 07:15:00 | AAPL | Stock | 15.4525 | 15.4593 | 15.4318 | 15.4318 | 116900.0 |
| 2013-03-08 07:20:00 | AAPL | Stock | 15.4332 | 15.4404 | 15.4293 | 15.4404 | 16240.0 |
| 2013-03-08 07:25:00 | AAPL | Stock | 15.4393 | 15.4439 | 15.4179 | 15.4179 | 37856.0 |
| 2013-03-08 07:30:00 | AAPL | Stock | 15.4214 | 15.4286 | 15.4214 | 15.4286 | 27496.0 |
| 2013-03-08 07:35:00 | AAPL | Stock | 15.4321 | 15.4321 | 15.4275 | 15.4304 | 25200.0 |
| 2013-03-08 07:40:00 | AAPL | Stock | 15.4232 | 15.4232 | 15.4232 | 15.4232 | 14000.0 |
| 2013-03-08 07:45:00 | AAPL | Stock | 15.4182 | 15.4182 | 15.4107 | 15.4107 | 20076.0 |
| 2013-03-08 07:50:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.365 | 15.365 | 213808.0 |
| 2013-03-08 07:55:00 | AAPL | Stock | 15.375 | 15.375 | 15.3393 | 15.35 | 195160.0 |
| 2013-03-08 08:00:00 | AAPL | Stock | 15.3621 | 15.4429 | 15.3179 | 15.3214 | 362796.0 |
| 2013-03-08 08:05:00 | AAPL | Stock | 15.3214 | 15.3346 | 15.3186 | 15.3321 | 234556.0 |
| 2013-03-08 08:10:00 | AAPL | Stock | 15.3436 | 15.3436 | 15.3268 | 15.3357 | 206808.0 |
| 2013-03-08 08:15:00 | AAPL | Stock | 15.3354 | 15.3429 | 15.3036 | 15.3036 | 270760.0 |
| 2013-03-08 08:20:00 | AAPL | Stock | 15.3 | 15.3214 | 15.2996 | 15.3214 | 169092.0 |
| 2013-03-08 08:25:00 | AAPL | Stock | 15.3136 | 15.3321 | 15.2964 | 15.3143 | 238644.0 |
| 2013-03-08 08:30:00 | AAPL | Stock | 15.3143 | 15.3893 | 15.2964 | 15.3271 | 1067752.0 |
| 2013-03-08 08:35:00 | AAPL | Stock | 15.3289 | 15.3607 | 15.3214 | 15.3393 | 616028.0 |
| 2013-03-08 08:40:00 | AAPL | Stock | 15.3393 | 15.3393 | 15.3214 | 15.3343 | 207872.0 |
| 2013-03-08 08:45:00 | AAPL | Stock | 15.3343 | 15.3343 | 15.2968 | 15.2968 | 413028.0 |
| 2013-03-08 08:50:00 | AAPL | Stock | 15.3011 | 15.3139 | 15.2911 | 15.2964 | 506324.0 |
| 2013-03-08 08:55:00 | AAPL | Stock | 15.2914 | 15.3121 | 15.2904 | 15.3121 | 123788.0 |
| 2013-03-08 09:00:00 | AAPL | Stock | 15.3121 | 15.3475 | 15.3121 | 15.3475 | 332220.0 |
| 2013-03-08 09:05:00 | AAPL | Stock | 15.3446 | 15.3461 | 15.3307 | 15.3414 | 189756.0 |
| 2013-03-08 09:10:00 | AAPL | Stock | 15.3414 | 15.3421 | 15.3304 | 15.3393 | 141792.0 |
| 2013-03-08 09:15:00 | AAPL | Stock | 15.3393 | 15.3421 | 15.3154 | 15.3214 | 222432.0 |
| 2013-03-08 09:20:00 | AAPL | Stock | 15.3221 | 15.3221 | 15.3 | 15.305 | 263424.0 |
| 2013-03-08 09:25:00 | AAPL | Stock | 15.3082 | 15.355 | 15.305 | 15.3518 | 953736.0 |
| 2013-03-08 09:30:00 | AAPL | Stock | 15.3504 | 15.3929 | 15.3075 | 15.3194 | 18544848.0 |
| 2013-03-08 09:35:00 | AAPL | Stock | 15.3204 | 15.4768 | 15.3187 | 15.4679 | 25641448.0 |
| 2013-03-08 09:40:00 | AAPL | Stock | 15.4646 | 15.5246 | 15.4468 | 15.5182 | 17811332.0 |
| 2013-03-08 09:45:00 | AAPL | Stock | 15.5242 | 15.5389 | 15.4621 | 15.4775 | 18821768.0 |
| 2013-03-08 09:50:00 | AAPL | Stock | 15.4804 | 15.5511 | 15.4643 | 15.5098 | 14090244.0 |
| 2013-03-08 09:55:00 | AAPL | Stock | 15.5118 | 15.5307 | 15.49 | 15.51 | 8176028.0 |
| 2013-03-08 10:00:00 | AAPL | Stock | 15.5143 | 15.5143 | 15.4464 | 15.4652 | 10587360.0 |
| 2013-03-08 10:05:00 | AAPL | Stock | 15.4708 | 15.4708 | 15.4243 | 15.4536 | 8984500.0 |
> showing 50 of 335,738 rows — these rows as CSV