PREVIEW / stock_5min / 2009-01-06
file: by_date/stock_5min/2009/2009-01-06.parquet size: 4.7 MB rows: 324,830 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-06 05:40:00 | AAPL | Stock | 3.3925 | 3.3925 | 3.3925 | 3.3925 | 5600.0 |
| 2009-01-06 06:00:00 | AAPL | Stock | 3.4161 | 3.4161 | 3.4161 | 3.4161 | 19600.0 |
| 2009-01-06 07:00:00 | AAPL | Stock | 3.4357 | 3.4561 | 3.4357 | 3.4561 | 228032.0 |
| 2009-01-06 07:05:00 | AAPL | Stock | 3.4561 | 3.4643 | 3.4561 | 3.4643 | 226660.0 |
| 2009-01-06 07:15:00 | AAPL | Stock | 3.4357 | 3.4561 | 3.4321 | 3.4561 | 166488.0 |
| 2009-01-06 07:20:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4271 | 3.4286 | 296044.0 |
| 2009-01-06 07:25:00 | AAPL | Stock | 3.4389 | 3.4389 | 3.4214 | 3.425 | 99400.0 |
| 2009-01-06 07:30:00 | AAPL | Stock | 3.4268 | 3.4336 | 3.4232 | 3.4236 | 57120.0 |
| 2009-01-06 07:35:00 | AAPL | Stock | 3.4236 | 3.4339 | 3.4236 | 3.4321 | 257320.0 |
| 2009-01-06 07:40:00 | AAPL | Stock | 3.435 | 3.4357 | 3.435 | 3.4357 | 47600.0 |
| 2009-01-06 07:45:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4357 | 3.4357 | 5600.0 |
| 2009-01-06 07:50:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4354 | 3.4354 | 10976.0 |
| 2009-01-06 07:55:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4286 | 3.435 | 105560.0 |
| 2009-01-06 08:00:00 | AAPL | Stock | 3.4346 | 3.4354 | 3.4286 | 3.4321 | 913864.0 |
| 2009-01-06 08:05:00 | AAPL | Stock | 3.4321 | 3.4375 | 3.4318 | 3.4371 | 609000.0 |
| 2009-01-06 08:10:00 | AAPL | Stock | 3.4375 | 3.4393 | 3.4321 | 3.4393 | 391216.0 |
| 2009-01-06 08:15:00 | AAPL | Stock | 3.4393 | 3.44 | 3.4339 | 3.4357 | 265020.0 |
| 2009-01-06 08:20:00 | AAPL | Stock | 3.4371 | 3.4414 | 3.4318 | 3.4329 | 700532.0 |
| 2009-01-06 08:25:00 | AAPL | Stock | 3.4329 | 3.4329 | 3.4214 | 3.4286 | 980728.0 |
| 2009-01-06 08:30:00 | AAPL | Stock | 3.4271 | 3.4321 | 3.4232 | 3.4232 | 939092.0 |
| 2009-01-06 08:35:00 | AAPL | Stock | 3.4271 | 3.4314 | 3.415 | 3.4211 | 723968.0 |
| 2009-01-06 08:40:00 | AAPL | Stock | 3.42 | 3.4207 | 3.4143 | 3.4189 | 277060.0 |
| 2009-01-06 08:45:00 | AAPL | Stock | 3.4189 | 3.4196 | 3.4143 | 3.4179 | 445732.0 |
| 2009-01-06 08:50:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.4161 | 3.4189 | 277200.0 |
| 2009-01-06 08:55:00 | AAPL | Stock | 3.4193 | 3.4218 | 3.4161 | 3.4196 | 343252.0 |
| 2009-01-06 09:00:00 | AAPL | Stock | 3.42 | 3.4229 | 3.4179 | 3.4214 | 276024.0 |
| 2009-01-06 09:05:00 | AAPL | Stock | 3.4232 | 3.435 | 3.4214 | 3.4343 | 1093960.0 |
| 2009-01-06 09:10:00 | AAPL | Stock | 3.4343 | 3.4386 | 3.4286 | 3.4321 | 1004136.0 |
| 2009-01-06 09:15:00 | AAPL | Stock | 3.4343 | 3.4357 | 3.4293 | 3.4293 | 184660.0 |
| 2009-01-06 09:20:00 | AAPL | Stock | 3.43 | 3.4357 | 3.4286 | 3.4314 | 887208.0 |
| 2009-01-06 09:25:00 | AAPL | Stock | 3.43 | 3.4329 | 3.4239 | 3.4243 | 1003856.0 |
| 2009-01-06 09:30:00 | AAPL | Stock | 3.4239 | 3.4439 | 3.4071 | 3.4179 | 27178396.0 |
| 2009-01-06 09:35:00 | AAPL | Stock | 3.4171 | 3.4264 | 3.4029 | 3.4246 | 21049532.0 |
| 2009-01-06 09:40:00 | AAPL | Stock | 3.4246 | 3.4375 | 3.4154 | 3.4289 | 24470768.0 |
| 2009-01-06 09:45:00 | AAPL | Stock | 3.4286 | 3.4489 | 3.4225 | 3.4416 | 23167984.0 |
| 2009-01-06 09:50:00 | AAPL | Stock | 3.4418 | 3.4432 | 3.4307 | 3.4396 | 18495120.0 |
| 2009-01-06 09:55:00 | AAPL | Stock | 3.4404 | 3.4429 | 3.4268 | 3.4296 | 15186304.0 |
| 2009-01-06 10:00:00 | AAPL | Stock | 3.4293 | 3.4393 | 3.42 | 3.4304 | 20327468.0 |
| 2009-01-06 10:05:00 | AAPL | Stock | 3.4311 | 3.4346 | 3.4214 | 3.4329 | 12409320.0 |
| 2009-01-06 10:10:00 | AAPL | Stock | 3.4325 | 3.4621 | 3.4271 | 3.4611 | 27610968.0 |
| 2009-01-06 10:15:00 | AAPL | Stock | 3.4611 | 3.4654 | 3.4514 | 3.4546 | 27099128.0 |
| 2009-01-06 10:20:00 | AAPL | Stock | 3.4546 | 3.4704 | 3.4511 | 3.4607 | 17133088.0 |
| 2009-01-06 10:25:00 | AAPL | Stock | 3.4618 | 3.4686 | 3.4546 | 3.4604 | 19202176.0 |
| 2009-01-06 10:30:00 | AAPL | Stock | 3.4604 | 3.4611 | 3.4414 | 3.4443 | 19367152.0 |
| 2009-01-06 10:35:00 | AAPL | Stock | 3.4439 | 3.4511 | 3.4429 | 3.4496 | 10634736.0 |
| 2009-01-06 10:40:00 | AAPL | Stock | 3.45 | 3.4536 | 3.4386 | 3.4425 | 10880464.0 |
| 2009-01-06 10:45:00 | AAPL | Stock | 3.4425 | 3.4429 | 3.4282 | 3.4289 | 14199948.0 |
| 2009-01-06 10:50:00 | AAPL | Stock | 3.4286 | 3.4375 | 3.4257 | 3.4257 | 10443440.0 |
| 2009-01-06 10:55:00 | AAPL | Stock | 3.4261 | 3.4361 | 3.4214 | 3.4275 | 11263000.0 |
| 2009-01-06 11:00:00 | AAPL | Stock | 3.4282 | 3.4318 | 3.4164 | 3.4193 | 9911496.0 |
> showing 50 of 324,830 rows — these rows as CSV