PREVIEW / stock_5min / 2011-11-29
file: by_date/stock_5min/2011/2011-11-29.parquet size: 4.7 MB rows: 319,617 symbols: 3,528
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-11-29 05:15:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 8400.0 |
| 2011-11-29 05:35:00 | AAPL | Stock | 13.5414 | 13.5414 | 13.5414 | 13.5414 | 4200.0 |
| 2011-11-29 05:40:00 | AAPL | Stock | 13.5414 | 13.5414 | 13.5414 | 13.5414 | 2800.0 |
| 2011-11-29 05:45:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 4200.0 |
| 2011-11-29 06:05:00 | AAPL | Stock | 13.5411 | 13.5411 | 13.5411 | 13.5411 | 2800.0 |
| 2011-11-29 06:10:00 | AAPL | Stock | 13.5411 | 13.5411 | 13.5411 | 13.5411 | 6300.0 |
| 2011-11-29 06:15:00 | AAPL | Stock | 13.5411 | 13.5411 | 13.5411 | 13.5411 | 5600.0 |
| 2011-11-29 06:25:00 | AAPL | Stock | 13.5411 | 13.5411 | 13.5411 | 13.5411 | 2800.0 |
| 2011-11-29 06:35:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 28000.0 |
| 2011-11-29 06:40:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 2800.0 |
| 2011-11-29 07:00:00 | AAPL | Stock | 13.4721 | 13.4725 | 13.4468 | 13.4679 | 53200.0 |
| 2011-11-29 07:05:00 | AAPL | Stock | 13.485 | 13.4904 | 13.4554 | 13.4664 | 28000.0 |
| 2011-11-29 07:10:00 | AAPL | Stock | 13.4646 | 13.4693 | 13.4489 | 13.4539 | 39340.0 |
| 2011-11-29 07:15:00 | AAPL | Stock | 13.45 | 13.45 | 13.45 | 13.45 | 2800.0 |
| 2011-11-29 07:20:00 | AAPL | Stock | 13.4482 | 13.4554 | 13.4375 | 13.4375 | 47600.0 |
| 2011-11-29 07:25:00 | AAPL | Stock | 13.4375 | 13.4375 | 13.4371 | 13.4375 | 14000.0 |
| 2011-11-29 07:30:00 | AAPL | Stock | 13.4321 | 13.4321 | 13.4071 | 13.4071 | 103600.0 |
| 2011-11-29 07:35:00 | AAPL | Stock | 13.4279 | 13.4279 | 13.4264 | 13.4268 | 8400.0 |
| 2011-11-29 07:40:00 | AAPL | Stock | 13.425 | 13.425 | 13.425 | 13.425 | 7700.0 |
| 2011-11-29 07:45:00 | AAPL | Stock | 13.4329 | 13.4329 | 13.4321 | 13.4329 | 27860.0 |
| 2011-11-29 07:50:00 | AAPL | Stock | 13.4329 | 13.4375 | 13.4286 | 13.4286 | 45416.0 |
| 2011-11-29 07:55:00 | AAPL | Stock | 13.4196 | 13.4196 | 13.4018 | 13.4018 | 43540.0 |
| 2011-11-29 08:00:00 | AAPL | Stock | 13.4107 | 13.4823 | 13.3961 | 13.4196 | 158340.0 |
| 2011-11-29 08:05:00 | AAPL | Stock | 13.4196 | 13.4429 | 13.4196 | 13.4332 | 112644.0 |
| 2011-11-29 08:10:00 | AAPL | Stock | 13.4446 | 13.4446 | 13.4339 | 13.4418 | 45304.0 |
| 2011-11-29 08:15:00 | AAPL | Stock | 13.4346 | 13.4464 | 13.4286 | 13.4336 | 297080.0 |
| 2011-11-29 08:20:00 | AAPL | Stock | 13.4404 | 13.4554 | 13.4375 | 13.4518 | 97776.0 |
| 2011-11-29 08:25:00 | AAPL | Stock | 13.4525 | 13.455 | 13.4464 | 13.4464 | 42000.0 |
| 2011-11-29 08:30:00 | AAPL | Stock | 13.4418 | 13.4418 | 13.4196 | 13.4196 | 95200.0 |
| 2011-11-29 08:35:00 | AAPL | Stock | 13.4214 | 13.4214 | 13.4125 | 13.4204 | 28476.0 |
| 2011-11-29 08:40:00 | AAPL | Stock | 13.4214 | 13.4325 | 13.4164 | 13.4321 | 228284.0 |
| 2011-11-29 08:45:00 | AAPL | Stock | 13.4321 | 13.4354 | 13.4289 | 13.4289 | 71036.0 |
| 2011-11-29 08:50:00 | AAPL | Stock | 13.4214 | 13.4218 | 13.4214 | 13.4218 | 21280.0 |
| 2011-11-29 08:55:00 | AAPL | Stock | 13.4214 | 13.4214 | 13.4214 | 13.4214 | 5600.0 |
| 2011-11-29 09:00:00 | AAPL | Stock | 13.4286 | 13.4286 | 13.4054 | 13.4054 | 146244.0 |
| 2011-11-29 09:05:00 | AAPL | Stock | 13.4054 | 13.4079 | 13.3968 | 13.4036 | 127372.0 |
| 2011-11-29 09:10:00 | AAPL | Stock | 13.4 | 13.4018 | 13.3968 | 13.3971 | 141568.0 |
| 2011-11-29 09:15:00 | AAPL | Stock | 13.4029 | 13.405 | 13.4029 | 13.4036 | 14000.0 |
| 2011-11-29 09:20:00 | AAPL | Stock | 13.4039 | 13.4139 | 13.4011 | 13.4071 | 324800.0 |
| 2011-11-29 09:25:00 | AAPL | Stock | 13.4168 | 13.4261 | 13.4011 | 13.4221 | 326088.0 |
| 2011-11-29 09:30:00 | AAPL | Stock | 13.4182 | 13.4229 | 13.3532 | 13.3718 | 12874764.0 |
| 2011-11-29 09:35:00 | AAPL | Stock | 13.3723 | 13.3907 | 13.3639 | 13.3854 | 6211072.0 |
| 2011-11-29 09:40:00 | AAPL | Stock | 13.3857 | 13.3996 | 13.3689 | 13.3918 | 6997844.0 |
| 2011-11-29 09:45:00 | AAPL | Stock | 13.3914 | 13.4279 | 13.3821 | 13.4257 | 5950196.0 |
| 2011-11-29 09:50:00 | AAPL | Stock | 13.4254 | 13.4829 | 13.4046 | 13.4807 | 9521316.0 |
| 2011-11-29 09:55:00 | AAPL | Stock | 13.4804 | 13.4804 | 13.4511 | 13.4661 | 6346676.0 |
| 2011-11-29 10:00:00 | AAPL | Stock | 13.4768 | 13.4989 | 13.4236 | 13.4496 | 12232472.0 |
| 2011-11-29 10:05:00 | AAPL | Stock | 13.4529 | 13.475 | 13.4457 | 13.4679 | 4772152.0 |
| 2011-11-29 10:10:00 | AAPL | Stock | 13.47 | 13.4871 | 13.4679 | 13.475 | 4428676.0 |
| 2011-11-29 10:15:00 | AAPL | Stock | 13.475 | 13.5296 | 13.4689 | 13.5182 | 8048572.0 |
> showing 50 of 319,617 rows — these rows as CSV