PREVIEW / stock_5min / 2002-05-14
file: by_date/stock_5min/2002/2002-05-14.parquet size: 1.9 MB rows: 131,387 symbols: 1,417
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-14 08:00:00 | AAPL | Stock | 0.4274 | 0.4274 | 0.4274 | 0.4274 | 28000.0 |
| 2002-05-14 08:30:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.425 | 0.425 | 11200.0 |
| 2002-05-14 08:35:00 | AAPL | Stock | 0.4311 | 0.432 | 0.4311 | 0.432 | 61600.0 |
| 2002-05-14 08:40:00 | AAPL | Stock | 0.4328 | 0.4339 | 0.4316 | 0.4339 | 436800.0 |
| 2002-05-14 08:45:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 5600.0 |
| 2002-05-14 08:50:00 | AAPL | Stock | 0.4346 | 0.4346 | 0.4346 | 0.4346 | 5600.0 |
| 2002-05-14 08:55:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 28000.0 |
| 2002-05-14 09:00:00 | AAPL | Stock | 0.4346 | 0.4364 | 0.4346 | 0.4364 | 28000.0 |
| 2002-05-14 09:05:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4354 | 0.4354 | 425600.0 |
| 2002-05-14 09:20:00 | AAPL | Stock | 0.433 | 0.433 | 0.4329 | 0.4329 | 67200.0 |
| 2002-05-14 09:25:00 | AAPL | Stock | 0.4338 | 0.4364 | 0.4338 | 0.4357 | 1092000.0 |
| 2002-05-14 09:30:00 | AAPL | Stock | 0.4366 | 0.4368 | 0.4325 | 0.433 | 8439200.0 |
| 2002-05-14 09:35:00 | AAPL | Stock | 0.433 | 0.4361 | 0.433 | 0.4343 | 5448800.0 |
| 2002-05-14 09:40:00 | AAPL | Stock | 0.4343 | 0.4366 | 0.4343 | 0.4363 | 3332000.0 |
| 2002-05-14 09:45:00 | AAPL | Stock | 0.4361 | 0.4364 | 0.4345 | 0.4348 | 3080000.0 |
| 2002-05-14 09:50:00 | AAPL | Stock | 0.4346 | 0.4373 | 0.4346 | 0.4359 | 5712000.0 |
| 2002-05-14 09:55:00 | AAPL | Stock | 0.4359 | 0.4384 | 0.4355 | 0.4375 | 13955200.0 |
| 2002-05-14 10:00:00 | AAPL | Stock | 0.4373 | 0.4382 | 0.4357 | 0.4372 | 3007200.0 |
| 2002-05-14 10:05:00 | AAPL | Stock | 0.4371 | 0.4371 | 0.4348 | 0.4354 | 4048800.0 |
| 2002-05-14 10:10:00 | AAPL | Stock | 0.435 | 0.4375 | 0.4348 | 0.4367 | 5812800.0 |
| 2002-05-14 10:15:00 | AAPL | Stock | 0.437 | 0.4373 | 0.4361 | 0.4373 | 1646400.0 |
| 2002-05-14 10:20:00 | AAPL | Stock | 0.4371 | 0.4375 | 0.4363 | 0.4371 | 3141600.0 |
| 2002-05-14 10:25:00 | AAPL | Stock | 0.4371 | 0.4395 | 0.4359 | 0.4393 | 10824800.0 |
| 2002-05-14 10:30:00 | AAPL | Stock | 0.4388 | 0.4391 | 0.4377 | 0.4388 | 2464000.0 |
| 2002-05-14 10:35:00 | AAPL | Stock | 0.4377 | 0.4389 | 0.4375 | 0.438 | 2060800.0 |
| 2002-05-14 10:40:00 | AAPL | Stock | 0.4382 | 0.4396 | 0.4375 | 0.4396 | 2984800.0 |
| 2002-05-14 10:45:00 | AAPL | Stock | 0.4396 | 0.4407 | 0.4384 | 0.4404 | 2503200.0 |
| 2002-05-14 10:50:00 | AAPL | Stock | 0.4402 | 0.4413 | 0.4395 | 0.4411 | 5980800.0 |
| 2002-05-14 10:55:00 | AAPL | Stock | 0.4407 | 0.4432 | 0.4407 | 0.442 | 9609600.0 |
| 2002-05-14 11:00:00 | AAPL | Stock | 0.4425 | 0.4446 | 0.4425 | 0.4441 | 8036000.0 |
| 2002-05-14 11:05:00 | AAPL | Stock | 0.4441 | 0.4454 | 0.4436 | 0.4439 | 7918400.0 |
| 2002-05-14 11:10:00 | AAPL | Stock | 0.444 | 0.4454 | 0.4436 | 0.4436 | 5180000.0 |
| 2002-05-14 11:15:00 | AAPL | Stock | 0.4438 | 0.4441 | 0.4427 | 0.4438 | 1926400.0 |
| 2002-05-14 11:20:00 | AAPL | Stock | 0.4438 | 0.4438 | 0.4429 | 0.4436 | 11435200.0 |
| 2002-05-14 11:25:00 | AAPL | Stock | 0.4434 | 0.4434 | 0.4413 | 0.442 | 2072000.0 |
| 2002-05-14 11:30:00 | AAPL | Stock | 0.4425 | 0.443 | 0.4413 | 0.4418 | 845600.0 |
| 2002-05-14 11:35:00 | AAPL | Stock | 0.4418 | 0.4455 | 0.4418 | 0.4455 | 4569600.0 |
| 2002-05-14 11:40:00 | AAPL | Stock | 0.4454 | 0.4459 | 0.4443 | 0.4455 | 4480000.0 |
| 2002-05-14 11:45:00 | AAPL | Stock | 0.4455 | 0.4463 | 0.445 | 0.4461 | 4720800.0 |
| 2002-05-14 11:50:00 | AAPL | Stock | 0.4463 | 0.4463 | 0.4455 | 0.4459 | 7649600.0 |
| 2002-05-14 11:55:00 | AAPL | Stock | 0.4463 | 0.4463 | 0.4448 | 0.4452 | 9228800.0 |
| 2002-05-14 12:00:00 | AAPL | Stock | 0.4452 | 0.4464 | 0.4452 | 0.4457 | 3830400.0 |
| 2002-05-14 12:05:00 | AAPL | Stock | 0.4461 | 0.4461 | 0.4454 | 0.4455 | 2648800.0 |
| 2002-05-14 12:10:00 | AAPL | Stock | 0.4455 | 0.4464 | 0.445 | 0.4455 | 5208000.0 |
| 2002-05-14 12:15:00 | AAPL | Stock | 0.4459 | 0.4464 | 0.4455 | 0.4459 | 5280800.0 |
| 2002-05-14 12:20:00 | AAPL | Stock | 0.4457 | 0.4461 | 0.4454 | 0.4455 | 1400000.0 |
| 2002-05-14 12:25:00 | AAPL | Stock | 0.4454 | 0.4461 | 0.445 | 0.4456 | 2889600.0 |
| 2002-05-14 12:30:00 | AAPL | Stock | 0.4455 | 0.4459 | 0.4454 | 0.4454 | 554400.0 |
| 2002-05-14 12:35:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.4452 | 0.4452 | 1478400.0 |
| 2002-05-14 12:40:00 | AAPL | Stock | 0.4452 | 0.4461 | 0.4452 | 0.4452 | 2704800.0 |
> showing 50 of 131,387 rows — these rows as CSV