PREVIEW / stock_5min / 2011-10-12
file: by_date/stock_5min/2011/2011-10-12.parquet size: 4.8 MB rows: 328,206 symbols: 3,515
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-12 04:15:00 | AAPL | Stock | 14.375 | 14.375 | 14.3571 | 14.3571 | 24836.0 |
| 2011-10-12 04:20:00 | AAPL | Stock | 14.3857 | 14.4196 | 14.3857 | 14.4196 | 23156.0 |
| 2011-10-12 04:25:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-10-12 04:30:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-10-12 04:35:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 4200.0 |
| 2011-10-12 04:40:00 | AAPL | Stock | 14.4107 | 14.4157 | 14.4089 | 14.4089 | 26684.0 |
| 2011-10-12 04:45:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 5600.0 |
| 2011-10-12 04:50:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 2800.0 |
| 2011-10-12 05:05:00 | AAPL | Stock | 14.4139 | 14.4157 | 14.4036 | 14.4157 | 16800.0 |
| 2011-10-12 05:10:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 22400.0 |
| 2011-10-12 05:15:00 | AAPL | Stock | 14.4461 | 14.4464 | 14.4282 | 14.4282 | 11200.0 |
| 2011-10-12 05:20:00 | AAPL | Stock | 14.4146 | 14.4146 | 14.4146 | 14.4146 | 2800.0 |
| 2011-10-12 05:25:00 | AAPL | Stock | 14.4461 | 14.4464 | 14.4461 | 14.4464 | 34580.0 |
| 2011-10-12 05:30:00 | AAPL | Stock | 14.4196 | 14.4196 | 14.4196 | 14.4196 | 8400.0 |
| 2011-10-12 05:40:00 | AAPL | Stock | 14.4461 | 14.4482 | 14.4461 | 14.4482 | 28000.0 |
| 2011-10-12 05:45:00 | AAPL | Stock | 14.45 | 14.45 | 14.45 | 14.45 | 4480.0 |
| 2011-10-12 05:50:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 2800.0 |
| 2011-10-12 06:00:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4464 | 14.4464 | 5600.0 |
| 2011-10-12 06:10:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 2800.0 |
| 2011-10-12 06:15:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 4200.0 |
| 2011-10-12 06:20:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4429 | 14.4464 | 16772.0 |
| 2011-10-12 06:25:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2011-10-12 06:30:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 2800.0 |
| 2011-10-12 06:35:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2011-10-12 07:00:00 | AAPL | Stock | 14.4143 | 14.4143 | 14.3929 | 14.4 | 111020.0 |
| 2011-10-12 07:05:00 | AAPL | Stock | 14.3961 | 14.4107 | 14.3929 | 14.4107 | 71400.0 |
| 2011-10-12 07:10:00 | AAPL | Stock | 14.4232 | 14.4239 | 14.4214 | 14.4214 | 35980.0 |
| 2011-10-12 07:15:00 | AAPL | Stock | 14.4143 | 14.4264 | 14.4107 | 14.4236 | 57680.0 |
| 2011-10-12 07:20:00 | AAPL | Stock | 14.4271 | 14.4464 | 14.4186 | 14.4236 | 173376.0 |
| 2011-10-12 07:25:00 | AAPL | Stock | 14.4243 | 14.4425 | 14.4232 | 14.4354 | 117376.0 |
| 2011-10-12 07:30:00 | AAPL | Stock | 14.4354 | 14.4357 | 14.4286 | 14.4357 | 108640.0 |
| 2011-10-12 07:35:00 | AAPL | Stock | 14.4293 | 14.4475 | 14.4293 | 14.4357 | 92540.0 |
| 2011-10-12 07:40:00 | AAPL | Stock | 14.4343 | 14.4343 | 14.4218 | 14.4229 | 89600.0 |
| 2011-10-12 07:45:00 | AAPL | Stock | 14.4236 | 14.4268 | 14.415 | 14.4189 | 39200.0 |
| 2011-10-12 07:50:00 | AAPL | Stock | 14.4204 | 14.4204 | 14.4121 | 14.4175 | 28000.0 |
| 2011-10-12 07:55:00 | AAPL | Stock | 14.4 | 14.4146 | 14.3996 | 14.4036 | 131740.0 |
| 2011-10-12 08:00:00 | AAPL | Stock | 14.4036 | 14.4271 | 14.3929 | 14.41 | 727860.0 |
| 2011-10-12 08:05:00 | AAPL | Stock | 14.4107 | 14.4214 | 14.4 | 14.4143 | 270984.0 |
| 2011-10-12 08:10:00 | AAPL | Stock | 14.4161 | 14.4286 | 14.4114 | 14.4286 | 341404.0 |
| 2011-10-12 08:15:00 | AAPL | Stock | 14.4261 | 14.4571 | 14.425 | 14.4514 | 521192.0 |
| 2011-10-12 08:20:00 | AAPL | Stock | 14.4471 | 14.4518 | 14.4421 | 14.4464 | 215068.0 |
| 2011-10-12 08:25:00 | AAPL | Stock | 14.4464 | 14.4643 | 14.4464 | 14.4475 | 530852.0 |
| 2011-10-12 08:30:00 | AAPL | Stock | 14.4532 | 14.4643 | 14.4432 | 14.4596 | 339024.0 |
| 2011-10-12 08:35:00 | AAPL | Stock | 14.4625 | 14.4643 | 14.4482 | 14.4579 | 554540.0 |
| 2011-10-12 08:40:00 | AAPL | Stock | 14.4571 | 14.49 | 14.4571 | 14.4821 | 429184.0 |
| 2011-10-12 08:45:00 | AAPL | Stock | 14.4804 | 14.5286 | 14.4804 | 14.5286 | 719292.0 |
| 2011-10-12 08:50:00 | AAPL | Stock | 14.5286 | 14.5432 | 14.5121 | 14.5286 | 955220.0 |
| 2011-10-12 08:55:00 | AAPL | Stock | 14.5221 | 14.5429 | 14.5214 | 14.5364 | 758268.0 |
| 2011-10-12 09:00:00 | AAPL | Stock | 14.5407 | 14.5639 | 14.5293 | 14.5554 | 1401400.0 |
| 2011-10-12 09:05:00 | AAPL | Stock | 14.5536 | 14.5668 | 14.5454 | 14.5504 | 813008.0 |
> showing 50 of 328,206 rows — these rows as CSV