PREVIEW / stock_5min / 2002-04-18
file: by_date/stock_5min/2002/2002-04-18.parquet size: 1.8 MB rows: 122,079 symbols: 1,388
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-04-18 08:00:00 | AAPL | Stock | 0.458 | 0.458 | 0.4468 | 0.4468 | 78400.0 |
| 2002-04-18 08:05:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4516 | 0.4516 | 33600.0 |
| 2002-04-18 08:25:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4536 | 0.4536 | 33600.0 |
| 2002-04-18 08:30:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4536 | 0.4536 | 5600.0 |
| 2002-04-18 08:35:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4536 | 0.4536 | 72800.0 |
| 2002-04-18 08:40:00 | AAPL | Stock | 0.4536 | 0.4536 | 0.4536 | 0.4536 | 84000.0 |
| 2002-04-18 08:50:00 | AAPL | Stock | 0.4536 | 0.4554 | 0.4536 | 0.4554 | 145600.0 |
| 2002-04-18 08:55:00 | AAPL | Stock | 0.4545 | 0.4545 | 0.4545 | 0.4545 | 16800.0 |
| 2002-04-18 09:00:00 | AAPL | Stock | 0.4554 | 0.4554 | 0.4554 | 0.4554 | 5600.0 |
| 2002-04-18 09:10:00 | AAPL | Stock | 0.4545 | 0.4545 | 0.4527 | 0.4527 | 95200.0 |
| 2002-04-18 09:15:00 | AAPL | Stock | 0.4536 | 0.4552 | 0.4536 | 0.4538 | 179200.0 |
| 2002-04-18 09:20:00 | AAPL | Stock | 0.4552 | 0.4571 | 0.4552 | 0.4571 | 78400.0 |
| 2002-04-18 09:25:00 | AAPL | Stock | 0.4554 | 0.4561 | 0.4554 | 0.4555 | 3024000.0 |
| 2002-04-18 09:30:00 | AAPL | Stock | 0.4554 | 0.4557 | 0.4507 | 0.4539 | 18373600.0 |
| 2002-04-18 09:35:00 | AAPL | Stock | 0.455 | 0.455 | 0.4532 | 0.4541 | 17029600.0 |
| 2002-04-18 09:40:00 | AAPL | Stock | 0.4538 | 0.4554 | 0.4532 | 0.4552 | 8366400.0 |
| 2002-04-18 09:45:00 | AAPL | Stock | 0.4552 | 0.4554 | 0.4527 | 0.4538 | 8209600.0 |
| 2002-04-18 09:50:00 | AAPL | Stock | 0.4536 | 0.4538 | 0.4516 | 0.4516 | 6512800.0 |
| 2002-04-18 09:55:00 | AAPL | Stock | 0.4521 | 0.4521 | 0.4473 | 0.4491 | 8461600.0 |
| 2002-04-18 10:00:00 | AAPL | Stock | 0.4491 | 0.4491 | 0.4466 | 0.4468 | 8920800.0 |
| 2002-04-18 10:05:00 | AAPL | Stock | 0.4469 | 0.4498 | 0.4468 | 0.4493 | 9912000.0 |
| 2002-04-18 10:10:00 | AAPL | Stock | 0.4491 | 0.4534 | 0.4477 | 0.4527 | 8019200.0 |
| 2002-04-18 10:15:00 | AAPL | Stock | 0.4527 | 0.4532 | 0.4504 | 0.4513 | 5471200.0 |
| 2002-04-18 10:20:00 | AAPL | Stock | 0.4514 | 0.4514 | 0.45 | 0.4509 | 3225600.0 |
| 2002-04-18 10:25:00 | AAPL | Stock | 0.4511 | 0.4518 | 0.4505 | 0.4509 | 3365600.0 |
| 2002-04-18 10:30:00 | AAPL | Stock | 0.4507 | 0.4511 | 0.4491 | 0.4491 | 4048800.0 |
| 2002-04-18 10:35:00 | AAPL | Stock | 0.4491 | 0.4496 | 0.4446 | 0.4448 | 8859200.0 |
| 2002-04-18 10:40:00 | AAPL | Stock | 0.4448 | 0.4461 | 0.4443 | 0.4455 | 6748000.0 |
| 2002-04-18 10:45:00 | AAPL | Stock | 0.4455 | 0.4464 | 0.445 | 0.4454 | 3634400.0 |
| 2002-04-18 10:50:00 | AAPL | Stock | 0.4455 | 0.4482 | 0.4454 | 0.4481 | 2228800.0 |
| 2002-04-18 10:55:00 | AAPL | Stock | 0.448 | 0.4482 | 0.4448 | 0.445 | 13669600.0 |
| 2002-04-18 11:00:00 | AAPL | Stock | 0.4455 | 0.4471 | 0.4454 | 0.4455 | 2856000.0 |
| 2002-04-18 11:05:00 | AAPL | Stock | 0.4455 | 0.4479 | 0.4455 | 0.4473 | 4334400.0 |
| 2002-04-18 11:10:00 | AAPL | Stock | 0.4473 | 0.4502 | 0.4466 | 0.4502 | 5846400.0 |
| 2002-04-18 11:15:00 | AAPL | Stock | 0.4504 | 0.452 | 0.45 | 0.4509 | 9576000.0 |
| 2002-04-18 11:20:00 | AAPL | Stock | 0.4511 | 0.452 | 0.4498 | 0.4499 | 7000000.0 |
| 2002-04-18 11:25:00 | AAPL | Stock | 0.45 | 0.4504 | 0.4488 | 0.4491 | 4149600.0 |
| 2002-04-18 11:30:00 | AAPL | Stock | 0.4489 | 0.4504 | 0.4489 | 0.4491 | 4760000.0 |
| 2002-04-18 11:35:00 | AAPL | Stock | 0.4493 | 0.4504 | 0.4493 | 0.4504 | 593600.0 |
| 2002-04-18 11:40:00 | AAPL | Stock | 0.4504 | 0.4511 | 0.4502 | 0.4509 | 1769600.0 |
| 2002-04-18 11:45:00 | AAPL | Stock | 0.4505 | 0.4509 | 0.4504 | 0.4506 | 924000.0 |
| 2002-04-18 11:50:00 | AAPL | Stock | 0.4509 | 0.4513 | 0.4507 | 0.4509 | 4810400.0 |
| 2002-04-18 11:55:00 | AAPL | Stock | 0.4511 | 0.4511 | 0.4464 | 0.4466 | 8192800.0 |
| 2002-04-18 12:00:00 | AAPL | Stock | 0.4466 | 0.4504 | 0.4464 | 0.4495 | 5303200.0 |
| 2002-04-18 12:05:00 | AAPL | Stock | 0.4495 | 0.4518 | 0.4495 | 0.4507 | 6792800.0 |
| 2002-04-18 12:10:00 | AAPL | Stock | 0.4509 | 0.4514 | 0.4488 | 0.4488 | 3119200.0 |
| 2002-04-18 12:15:00 | AAPL | Stock | 0.4488 | 0.4496 | 0.4476 | 0.4479 | 6300000.0 |
| 2002-04-18 12:20:00 | AAPL | Stock | 0.4479 | 0.4516 | 0.4477 | 0.4491 | 5208000.0 |
| 2002-04-18 12:25:00 | AAPL | Stock | 0.4491 | 0.4516 | 0.4488 | 0.4496 | 2755200.0 |
| 2002-04-18 12:30:00 | AAPL | Stock | 0.4502 | 0.4513 | 0.45 | 0.4511 | 2066400.0 |
> showing 50 of 122,079 rows — these rows as CSV