PREVIEW / stock_5min / 2002-05-17
file: by_date/stock_5min/2002/2002-05-17.parquet size: 1.7 MB rows: 119,060 symbols: 1,416
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-17 08:00:00 | AAPL | Stock | 0.4496 | 0.4496 | 0.4496 | 0.4496 | 5600.0 |
| 2002-05-17 08:20:00 | AAPL | Stock | 0.4563 | 0.4563 | 0.4563 | 0.4563 | 56000.0 |
| 2002-05-17 08:35:00 | AAPL | Stock | 0.4571 | 0.4571 | 0.4571 | 0.4571 | 5600.0 |
| 2002-05-17 08:40:00 | AAPL | Stock | 0.4568 | 0.4571 | 0.4568 | 0.4571 | 67200.0 |
| 2002-05-17 08:45:00 | AAPL | Stock | 0.4563 | 0.4563 | 0.4563 | 0.4563 | 5600.0 |
| 2002-05-17 08:50:00 | AAPL | Stock | 0.4563 | 0.4563 | 0.4563 | 0.4563 | 39200.0 |
| 2002-05-17 08:55:00 | AAPL | Stock | 0.4579 | 0.458 | 0.4571 | 0.458 | 168000.0 |
| 2002-05-17 09:05:00 | AAPL | Stock | 0.4577 | 0.4577 | 0.4577 | 0.4577 | 28000.0 |
| 2002-05-17 09:20:00 | AAPL | Stock | 0.4529 | 0.4529 | 0.4529 | 0.4529 | 11200.0 |
| 2002-05-17 09:25:00 | AAPL | Stock | 0.4527 | 0.4557 | 0.4527 | 0.455 | 1355200.0 |
| 2002-05-17 09:30:00 | AAPL | Stock | 0.4552 | 0.4604 | 0.4514 | 0.46 | 11015200.0 |
| 2002-05-17 09:35:00 | AAPL | Stock | 0.4589 | 0.4595 | 0.4554 | 0.4571 | 7576800.0 |
| 2002-05-17 09:40:00 | AAPL | Stock | 0.4568 | 0.4575 | 0.4554 | 0.4568 | 15691200.0 |
| 2002-05-17 09:45:00 | AAPL | Stock | 0.4564 | 0.4577 | 0.4546 | 0.4577 | 7280000.0 |
| 2002-05-17 09:50:00 | AAPL | Stock | 0.4577 | 0.458 | 0.4555 | 0.4563 | 5118400.0 |
| 2002-05-17 09:55:00 | AAPL | Stock | 0.4566 | 0.4566 | 0.4534 | 0.4534 | 4065600.0 |
| 2002-05-17 10:00:00 | AAPL | Stock | 0.4537 | 0.4563 | 0.4527 | 0.455 | 3186400.0 |
| 2002-05-17 10:05:00 | AAPL | Stock | 0.4549 | 0.4566 | 0.4538 | 0.4566 | 2760800.0 |
| 2002-05-17 10:10:00 | AAPL | Stock | 0.457 | 0.457 | 0.4536 | 0.4545 | 3892000.0 |
| 2002-05-17 10:15:00 | AAPL | Stock | 0.4545 | 0.4552 | 0.4532 | 0.4548 | 1724800.0 |
| 2002-05-17 10:20:00 | AAPL | Stock | 0.4548 | 0.4548 | 0.4505 | 0.4511 | 2900800.0 |
| 2002-05-17 10:25:00 | AAPL | Stock | 0.4511 | 0.4511 | 0.4477 | 0.4498 | 3466400.0 |
| 2002-05-17 10:30:00 | AAPL | Stock | 0.4498 | 0.4516 | 0.4495 | 0.4502 | 1999200.0 |
| 2002-05-17 10:35:00 | AAPL | Stock | 0.4505 | 0.4507 | 0.4482 | 0.4484 | 3169600.0 |
| 2002-05-17 10:40:00 | AAPL | Stock | 0.4482 | 0.4488 | 0.4439 | 0.4439 | 4821600.0 |
| 2002-05-17 10:45:00 | AAPL | Stock | 0.444 | 0.4457 | 0.4429 | 0.4439 | 4272800.0 |
| 2002-05-17 10:50:00 | AAPL | Stock | 0.4434 | 0.4448 | 0.4423 | 0.4441 | 4026400.0 |
| 2002-05-17 10:55:00 | AAPL | Stock | 0.444 | 0.4471 | 0.4433 | 0.4468 | 2094400.0 |
| 2002-05-17 11:00:00 | AAPL | Stock | 0.447 | 0.4482 | 0.4463 | 0.4471 | 2301600.0 |
| 2002-05-17 11:05:00 | AAPL | Stock | 0.4473 | 0.4475 | 0.4457 | 0.4471 | 2116800.0 |
| 2002-05-17 11:10:00 | AAPL | Stock | 0.4464 | 0.4502 | 0.4464 | 0.4479 | 3735200.0 |
| 2002-05-17 11:15:00 | AAPL | Stock | 0.4477 | 0.45 | 0.4477 | 0.4491 | 1355200.0 |
| 2002-05-17 11:20:00 | AAPL | Stock | 0.4491 | 0.4491 | 0.4448 | 0.4464 | 2805600.0 |
| 2002-05-17 11:25:00 | AAPL | Stock | 0.4464 | 0.4468 | 0.4454 | 0.4454 | 616000.0 |
| 2002-05-17 11:30:00 | AAPL | Stock | 0.445 | 0.4463 | 0.4438 | 0.4458 | 2816800.0 |
| 2002-05-17 11:35:00 | AAPL | Stock | 0.4459 | 0.4464 | 0.4445 | 0.4459 | 1702400.0 |
| 2002-05-17 11:40:00 | AAPL | Stock | 0.4461 | 0.4464 | 0.4441 | 0.4443 | 1075200.0 |
| 2002-05-17 11:45:00 | AAPL | Stock | 0.4448 | 0.4457 | 0.4445 | 0.4446 | 1484000.0 |
| 2002-05-17 11:50:00 | AAPL | Stock | 0.4445 | 0.4446 | 0.443 | 0.4444 | 2822400.0 |
| 2002-05-17 11:55:00 | AAPL | Stock | 0.4444 | 0.4445 | 0.4416 | 0.4416 | 2486400.0 |
| 2002-05-17 12:00:00 | AAPL | Stock | 0.4414 | 0.4427 | 0.4402 | 0.4423 | 3371200.0 |
| 2002-05-17 12:05:00 | AAPL | Stock | 0.4423 | 0.4429 | 0.4411 | 0.4425 | 1512000.0 |
| 2002-05-17 12:10:00 | AAPL | Stock | 0.4427 | 0.4446 | 0.4427 | 0.4443 | 2419200.0 |
| 2002-05-17 12:15:00 | AAPL | Stock | 0.4443 | 0.4446 | 0.4434 | 0.4438 | 1495200.0 |
| 2002-05-17 12:20:00 | AAPL | Stock | 0.4439 | 0.4443 | 0.4427 | 0.4427 | 324800.0 |
| 2002-05-17 12:25:00 | AAPL | Stock | 0.4425 | 0.4427 | 0.4418 | 0.4423 | 1299200.0 |
| 2002-05-17 12:30:00 | AAPL | Stock | 0.442 | 0.4439 | 0.442 | 0.4439 | 756000.0 |
| 2002-05-17 12:35:00 | AAPL | Stock | 0.4434 | 0.4439 | 0.4434 | 0.4439 | 912800.0 |
| 2002-05-17 12:40:00 | AAPL | Stock | 0.4439 | 0.4455 | 0.4438 | 0.4446 | 1332800.0 |
| 2002-05-17 12:45:00 | AAPL | Stock | 0.4445 | 0.4453 | 0.4441 | 0.4448 | 2637600.0 |
> showing 50 of 119,060 rows — these rows as CSV