PREVIEW / stock_5min / 2006-08-17
file: by_date/stock_5min/2006/2006-08-17.parquet size: 3.1 MB rows: 225,573 symbols: 2,346
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-17 07:30:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4339 | 2.4339 | 14000.0 |
| 2006-08-17 07:35:00 | AAPL | Stock | 2.4339 | 2.4357 | 2.4339 | 2.4339 | 39200.0 |
| 2006-08-17 07:55:00 | AAPL | Stock | 2.4339 | 2.4357 | 2.4339 | 2.4357 | 5600.0 |
| 2006-08-17 08:00:00 | AAPL | Stock | 2.4321 | 2.4389 | 2.4321 | 2.4389 | 351232.0 |
| 2006-08-17 08:05:00 | AAPL | Stock | 2.4343 | 2.4396 | 2.4339 | 2.4357 | 145460.0 |
| 2006-08-17 08:10:00 | AAPL | Stock | 2.4339 | 2.4357 | 2.4339 | 2.435 | 60200.0 |
| 2006-08-17 08:15:00 | AAPL | Stock | 2.435 | 2.4375 | 2.4339 | 2.4364 | 147000.0 |
| 2006-08-17 08:20:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4339 | 2.4357 | 61600.0 |
| 2006-08-17 08:25:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4339 | 2.4339 | 161000.0 |
| 2006-08-17 08:30:00 | AAPL | Stock | 2.4339 | 2.4339 | 2.4321 | 2.4336 | 164080.0 |
| 2006-08-17 08:35:00 | AAPL | Stock | 2.4357 | 2.4375 | 2.4357 | 2.4375 | 116200.0 |
| 2006-08-17 08:40:00 | AAPL | Stock | 2.4375 | 2.4375 | 2.4357 | 2.4357 | 50400.0 |
| 2006-08-17 08:45:00 | AAPL | Stock | 2.4343 | 2.4343 | 2.4318 | 2.4321 | 77560.0 |
| 2006-08-17 08:50:00 | AAPL | Stock | 2.4325 | 2.4325 | 2.4307 | 2.4311 | 74900.0 |
| 2006-08-17 08:55:00 | AAPL | Stock | 2.4311 | 2.4321 | 2.4311 | 2.4311 | 136920.0 |
| 2006-08-17 09:00:00 | AAPL | Stock | 2.4321 | 2.4329 | 2.4311 | 2.4311 | 141960.0 |
| 2006-08-17 09:05:00 | AAPL | Stock | 2.4311 | 2.4321 | 2.4304 | 2.4321 | 597072.0 |
| 2006-08-17 09:10:00 | AAPL | Stock | 2.4321 | 2.4329 | 2.4279 | 2.4286 | 351568.0 |
| 2006-08-17 09:15:00 | AAPL | Stock | 2.4286 | 2.4296 | 2.425 | 2.4296 | 89040.0 |
| 2006-08-17 09:20:00 | AAPL | Stock | 2.425 | 2.425 | 2.4218 | 2.4218 | 53200.0 |
| 2006-08-17 09:25:00 | AAPL | Stock | 2.4257 | 2.4296 | 2.4221 | 2.4286 | 364420.0 |
| 2006-08-17 09:30:00 | AAPL | Stock | 2.4286 | 2.43 | 2.4132 | 2.4168 | 15264648.0 |
| 2006-08-17 09:35:00 | AAPL | Stock | 2.4168 | 2.4411 | 2.4164 | 2.4379 | 20353340.0 |
| 2006-08-17 09:40:00 | AAPL | Stock | 2.4382 | 2.4429 | 2.4339 | 2.4418 | 16779476.0 |
| 2006-08-17 09:45:00 | AAPL | Stock | 2.4418 | 2.4464 | 2.4371 | 2.4454 | 15382584.0 |
| 2006-08-17 09:50:00 | AAPL | Stock | 2.445 | 2.4454 | 2.4379 | 2.4396 | 9818032.0 |
| 2006-08-17 09:55:00 | AAPL | Stock | 2.4393 | 2.4411 | 2.435 | 2.4411 | 8745492.0 |
| 2006-08-17 10:00:00 | AAPL | Stock | 2.4411 | 2.4518 | 2.4375 | 2.4518 | 15196664.0 |
| 2006-08-17 10:05:00 | AAPL | Stock | 2.4518 | 2.4521 | 2.4454 | 2.4504 | 9314592.0 |
| 2006-08-17 10:10:00 | AAPL | Stock | 2.4504 | 2.4507 | 2.4429 | 2.4479 | 8451016.0 |
| 2006-08-17 10:15:00 | AAPL | Stock | 2.4478 | 2.4478 | 2.4368 | 2.4439 | 11825492.0 |
| 2006-08-17 10:20:00 | AAPL | Stock | 2.4446 | 2.4454 | 2.4364 | 2.4371 | 7794192.0 |
| 2006-08-17 10:25:00 | AAPL | Stock | 2.4371 | 2.44 | 2.4318 | 2.4339 | 10073728.0 |
| 2006-08-17 10:30:00 | AAPL | Stock | 2.4339 | 2.4375 | 2.4264 | 2.4354 | 11641448.0 |
| 2006-08-17 10:35:00 | AAPL | Stock | 2.4354 | 2.4364 | 2.4318 | 2.4325 | 5529356.0 |
| 2006-08-17 10:40:00 | AAPL | Stock | 2.4329 | 2.4357 | 2.43 | 2.4357 | 6959148.0 |
| 2006-08-17 10:45:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.43 | 2.4307 | 3224900.0 |
| 2006-08-17 10:50:00 | AAPL | Stock | 2.4307 | 2.4375 | 2.4307 | 2.4361 | 5611872.0 |
| 2006-08-17 10:55:00 | AAPL | Stock | 2.4364 | 2.4457 | 2.4364 | 2.4425 | 7860328.0 |
| 2006-08-17 11:00:00 | AAPL | Stock | 2.4429 | 2.4429 | 2.4379 | 2.4396 | 4072684.0 |
| 2006-08-17 11:05:00 | AAPL | Stock | 2.4396 | 2.4411 | 2.4389 | 2.4396 | 3224788.0 |
| 2006-08-17 11:10:00 | AAPL | Stock | 2.4396 | 2.4432 | 2.4393 | 2.4425 | 4532108.0 |
| 2006-08-17 11:15:00 | AAPL | Stock | 2.4425 | 2.4446 | 2.435 | 2.4386 | 6286000.0 |
| 2006-08-17 11:20:00 | AAPL | Stock | 2.4386 | 2.44 | 2.4364 | 2.4364 | 4166540.0 |
| 2006-08-17 11:25:00 | AAPL | Stock | 2.4368 | 2.4421 | 2.4364 | 2.4389 | 3488100.0 |
| 2006-08-17 11:30:00 | AAPL | Stock | 2.4392 | 2.4446 | 2.4389 | 2.4425 | 5946556.0 |
| 2006-08-17 11:35:00 | AAPL | Stock | 2.4429 | 2.4429 | 2.4379 | 2.4411 | 3910760.0 |
| 2006-08-17 11:40:00 | AAPL | Stock | 2.4414 | 2.4429 | 2.4386 | 2.4414 | 2649724.0 |
| 2006-08-17 11:45:00 | AAPL | Stock | 2.4414 | 2.4429 | 2.4407 | 2.4429 | 2352224.0 |
| 2006-08-17 11:50:00 | AAPL | Stock | 2.4432 | 2.445 | 2.4389 | 2.4407 | 5616156.0 |
> showing 50 of 225,573 rows — these rows as CSV