PREVIEW / stock_5min / 2001-04-27
file: by_date/stock_5min/2001/2001-04-27.parquet size: 1.5 MB rows: 103,057 symbols: 1,287
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-27 08:25:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 5600.0 |
| 2001-04-27 08:30:00 | AAPL | Stock | 0.4446 | 0.4464 | 0.4446 | 0.4464 | 89600.0 |
| 2001-04-27 08:35:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.4482 | 0.4482 | 28000.0 |
| 2001-04-27 08:40:00 | AAPL | Stock | 0.4554 | 0.4554 | 0.4536 | 0.4543 | 106400.0 |
| 2001-04-27 08:45:00 | AAPL | Stock | 0.4554 | 0.4554 | 0.4554 | 0.4554 | 78400.0 |
| 2001-04-27 08:50:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4536 | 0.4536 | 5600.0 |
| 2001-04-27 08:55:00 | AAPL | Stock | 0.45 | 0.45 | 0.45 | 0.45 | 5600.0 |
| 2001-04-27 09:00:00 | AAPL | Stock | 0.45 | 0.4541 | 0.4464 | 0.4541 | 67200.0 |
| 2001-04-27 09:05:00 | AAPL | Stock | 0.4509 | 0.4509 | 0.4502 | 0.4502 | 61600.0 |
| 2001-04-27 09:10:00 | AAPL | Stock | 0.4502 | 0.4502 | 0.45 | 0.45 | 89600.0 |
| 2001-04-27 09:15:00 | AAPL | Stock | 0.45 | 0.45 | 0.4464 | 0.4464 | 173600.0 |
| 2001-04-27 09:20:00 | AAPL | Stock | 0.4509 | 0.4561 | 0.4504 | 0.4561 | 123200.0 |
| 2001-04-27 09:25:00 | AAPL | Stock | 0.4529 | 0.4529 | 0.4504 | 0.4507 | 201600.0 |
| 2001-04-27 09:30:00 | AAPL | Stock | 0.45 | 0.4518 | 0.4446 | 0.4509 | 8489600.0 |
| 2001-04-27 09:35:00 | AAPL | Stock | 0.4509 | 0.4554 | 0.4509 | 0.4545 | 10819200.0 |
| 2001-04-27 09:40:00 | AAPL | Stock | 0.4546 | 0.4575 | 0.4518 | 0.457 | 8876000.0 |
| 2001-04-27 09:45:00 | AAPL | Stock | 0.4571 | 0.4571 | 0.4509 | 0.4536 | 6165600.0 |
| 2001-04-27 09:50:00 | AAPL | Stock | 0.4529 | 0.4539 | 0.4518 | 0.4532 | 6339200.0 |
| 2001-04-27 09:55:00 | AAPL | Stock | 0.4532 | 0.4563 | 0.4532 | 0.4536 | 7252000.0 |
| 2001-04-27 10:00:00 | AAPL | Stock | 0.4536 | 0.4571 | 0.4536 | 0.4563 | 7901600.0 |
| 2001-04-27 10:05:00 | AAPL | Stock | 0.4559 | 0.458 | 0.4554 | 0.4563 | 9688000.0 |
| 2001-04-27 10:10:00 | AAPL | Stock | 0.4563 | 0.4563 | 0.4545 | 0.4555 | 6776000.0 |
| 2001-04-27 10:15:00 | AAPL | Stock | 0.4555 | 0.4555 | 0.4527 | 0.453 | 4424000.0 |
| 2001-04-27 10:20:00 | AAPL | Stock | 0.453 | 0.4539 | 0.4523 | 0.4534 | 4233600.0 |
| 2001-04-27 10:25:00 | AAPL | Stock | 0.4534 | 0.4541 | 0.4523 | 0.4527 | 3220000.0 |
| 2001-04-27 10:30:00 | AAPL | Stock | 0.4527 | 0.4543 | 0.4525 | 0.4536 | 4552800.0 |
| 2001-04-27 10:35:00 | AAPL | Stock | 0.4536 | 0.4546 | 0.4532 | 0.4541 | 4530400.0 |
| 2001-04-27 10:40:00 | AAPL | Stock | 0.4545 | 0.4545 | 0.452 | 0.4527 | 2408000.0 |
| 2001-04-27 10:45:00 | AAPL | Stock | 0.4527 | 0.4534 | 0.4505 | 0.4505 | 4832800.0 |
| 2001-04-27 10:50:00 | AAPL | Stock | 0.4507 | 0.4514 | 0.4502 | 0.4507 | 6384000.0 |
| 2001-04-27 10:55:00 | AAPL | Stock | 0.4507 | 0.4527 | 0.4507 | 0.4514 | 6568800.0 |
| 2001-04-27 11:00:00 | AAPL | Stock | 0.4518 | 0.4518 | 0.448 | 0.4482 | 3556000.0 |
| 2001-04-27 11:05:00 | AAPL | Stock | 0.4477 | 0.4486 | 0.4473 | 0.4482 | 6109600.0 |
| 2001-04-27 11:10:00 | AAPL | Stock | 0.448 | 0.4482 | 0.447 | 0.448 | 3992800.0 |
| 2001-04-27 11:15:00 | AAPL | Stock | 0.4473 | 0.4482 | 0.4473 | 0.4482 | 2469600.0 |
| 2001-04-27 11:20:00 | AAPL | Stock | 0.4486 | 0.4491 | 0.4457 | 0.4463 | 2503200.0 |
| 2001-04-27 11:25:00 | AAPL | Stock | 0.4463 | 0.4463 | 0.4439 | 0.4443 | 4323200.0 |
| 2001-04-27 11:30:00 | AAPL | Stock | 0.4438 | 0.4439 | 0.442 | 0.4438 | 4911200.0 |
| 2001-04-27 11:35:00 | AAPL | Stock | 0.4436 | 0.4482 | 0.4434 | 0.4473 | 5230400.0 |
| 2001-04-27 11:40:00 | AAPL | Stock | 0.4473 | 0.4475 | 0.4466 | 0.4473 | 3774400.0 |
| 2001-04-27 11:45:00 | AAPL | Stock | 0.4473 | 0.45 | 0.4473 | 0.45 | 4244800.0 |
| 2001-04-27 11:50:00 | AAPL | Stock | 0.4495 | 0.4525 | 0.4491 | 0.4518 | 2900800.0 |
| 2001-04-27 11:55:00 | AAPL | Stock | 0.4516 | 0.4527 | 0.4498 | 0.452 | 4407200.0 |
| 2001-04-27 12:00:00 | AAPL | Stock | 0.452 | 0.4543 | 0.4513 | 0.453 | 4653600.0 |
| 2001-04-27 12:05:00 | AAPL | Stock | 0.453 | 0.453 | 0.4491 | 0.4491 | 1797600.0 |
| 2001-04-27 12:10:00 | AAPL | Stock | 0.4491 | 0.4509 | 0.4489 | 0.4509 | 1932000.0 |
| 2001-04-27 12:15:00 | AAPL | Stock | 0.4514 | 0.4518 | 0.4455 | 0.4457 | 1881600.0 |
| 2001-04-27 12:20:00 | AAPL | Stock | 0.4455 | 0.4484 | 0.445 | 0.4466 | 4356800.0 |
| 2001-04-27 12:25:00 | AAPL | Stock | 0.4466 | 0.448 | 0.4464 | 0.4471 | 2688000.0 |
| 2001-04-27 12:30:00 | AAPL | Stock | 0.4473 | 0.4488 | 0.4464 | 0.4486 | 4620000.0 |
> showing 50 of 103,057 rows — these rows as CSV