PREVIEW / stock_5min / 2007-06-25
file: by_date/stock_5min/2007/2007-06-25.parquet size: 4.2 MB rows: 303,047 symbols: 3,042
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-25 09:30:00 | AAPL | Stock | 4.4354 | 4.4407 | 4.4125 | 4.4212 | 24330684.0 |
| 2007-06-25 09:35:00 | AAPL | Stock | 4.4218 | 4.425 | 4.4043 | 4.4082 | 17870076.0 |
| 2007-06-25 09:40:00 | AAPL | Stock | 4.4082 | 4.4264 | 4.3929 | 4.3986 | 21836892.0 |
| 2007-06-25 09:45:00 | AAPL | Stock | 4.3989 | 4.4154 | 4.3943 | 4.4132 | 14606200.0 |
| 2007-06-25 09:50:00 | AAPL | Stock | 4.413 | 4.4154 | 4.3964 | 4.4136 | 15948828.0 |
| 2007-06-25 09:55:00 | AAPL | Stock | 4.4136 | 4.4196 | 4.4043 | 4.4169 | 11456284.0 |
| 2007-06-25 10:00:00 | AAPL | Stock | 4.4168 | 4.425 | 4.4107 | 4.415 | 9893856.0 |
| 2007-06-25 10:05:00 | AAPL | Stock | 4.415 | 4.4161 | 4.4057 | 4.4093 | 8201928.0 |
| 2007-06-25 10:10:00 | AAPL | Stock | 4.4096 | 4.4296 | 4.4075 | 4.4229 | 12403412.0 |
| 2007-06-25 10:15:00 | AAPL | Stock | 4.4229 | 4.4325 | 4.4146 | 4.4304 | 14155932.0 |
| 2007-06-25 10:20:00 | AAPL | Stock | 4.4307 | 4.4318 | 4.4218 | 4.4246 | 8773352.0 |
| 2007-06-25 10:25:00 | AAPL | Stock | 4.4245 | 4.4282 | 4.4211 | 4.4221 | 8130528.0 |
| 2007-06-25 10:30:00 | AAPL | Stock | 4.4221 | 4.4336 | 4.4221 | 4.4246 | 9942744.0 |
| 2007-06-25 10:35:00 | AAPL | Stock | 4.4254 | 4.4279 | 4.4186 | 4.4279 | 8732892.0 |
| 2007-06-25 10:40:00 | AAPL | Stock | 4.4273 | 4.43 | 4.4189 | 4.4275 | 9176076.0 |
| 2007-06-25 10:45:00 | AAPL | Stock | 4.4275 | 4.4325 | 4.4232 | 4.4271 | 9845192.0 |
| 2007-06-25 10:50:00 | AAPL | Stock | 4.4275 | 4.4504 | 4.4275 | 4.4493 | 30313752.0 |
| 2007-06-25 10:55:00 | AAPL | Stock | 4.4493 | 4.4639 | 4.4489 | 4.4639 | 26837608.0 |
| 2007-06-25 11:00:00 | AAPL | Stock | 4.4639 | 4.4643 | 4.4514 | 4.4586 | 20285580.0 |
| 2007-06-25 11:05:00 | AAPL | Stock | 4.4586 | 4.4632 | 4.45 | 4.4529 | 12017964.0 |
| 2007-06-25 11:10:00 | AAPL | Stock | 4.4525 | 4.4593 | 4.4493 | 4.4579 | 11153464.0 |
| 2007-06-25 11:15:00 | AAPL | Stock | 4.4582 | 4.4621 | 4.4457 | 4.4479 | 15344924.0 |
| 2007-06-25 11:20:00 | AAPL | Stock | 4.4479 | 4.4514 | 4.4386 | 4.4429 | 11763556.0 |
| 2007-06-25 11:25:00 | AAPL | Stock | 4.4425 | 4.4507 | 4.4404 | 4.4496 | 8017912.0 |
| 2007-06-25 11:30:00 | AAPL | Stock | 4.4489 | 4.4504 | 4.4446 | 4.4471 | 6846560.0 |
| 2007-06-25 11:35:00 | AAPL | Stock | 4.4464 | 4.4561 | 4.4443 | 4.4546 | 8483608.0 |
| 2007-06-25 11:40:00 | AAPL | Stock | 4.4554 | 4.4557 | 4.4454 | 4.4493 | 8781276.0 |
| 2007-06-25 11:45:00 | AAPL | Stock | 4.4489 | 4.4546 | 4.4471 | 4.4529 | 6952092.0 |
| 2007-06-25 11:50:00 | AAPL | Stock | 4.4525 | 4.4571 | 4.4518 | 4.4571 | 6398084.0 |
| 2007-06-25 11:55:00 | AAPL | Stock | 4.4568 | 4.4618 | 4.4554 | 4.4602 | 6727336.0 |
| 2007-06-25 12:00:00 | AAPL | Stock | 4.4604 | 4.4639 | 4.4589 | 4.4603 | 8009568.0 |
| 2007-06-25 12:05:00 | AAPL | Stock | 4.46 | 4.4675 | 4.4596 | 4.4639 | 10235204.0 |
| 2007-06-25 12:10:00 | AAPL | Stock | 4.4639 | 4.4664 | 4.4568 | 4.4607 | 10459428.0 |
| 2007-06-25 12:15:00 | AAPL | Stock | 4.4614 | 4.4632 | 4.4561 | 4.4593 | 5759152.0 |
| 2007-06-25 12:20:00 | AAPL | Stock | 4.4586 | 4.4596 | 4.4518 | 4.4591 | 5891704.0 |
| 2007-06-25 12:25:00 | AAPL | Stock | 4.4586 | 4.4611 | 4.4536 | 4.4543 | 3938564.0 |
| 2007-06-25 12:30:00 | AAPL | Stock | 4.455 | 4.4582 | 4.4539 | 4.4554 | 3246908.0 |
| 2007-06-25 12:35:00 | AAPL | Stock | 4.4554 | 4.46 | 4.4543 | 4.4589 | 2686376.0 |
| 2007-06-25 12:40:00 | AAPL | Stock | 4.4586 | 4.4607 | 4.4557 | 4.4564 | 3485972.0 |
| 2007-06-25 12:45:00 | AAPL | Stock | 4.4564 | 4.4571 | 4.4529 | 4.4564 | 3135412.0 |
| 2007-06-25 12:50:00 | AAPL | Stock | 4.4564 | 4.4589 | 4.4539 | 4.4561 | 3333848.0 |
| 2007-06-25 12:55:00 | AAPL | Stock | 4.4564 | 4.4571 | 4.4475 | 4.4525 | 7473480.0 |
| 2007-06-25 13:00:00 | AAPL | Stock | 4.4525 | 4.4539 | 4.4436 | 4.4439 | 5458348.0 |
| 2007-06-25 13:05:00 | AAPL | Stock | 4.4439 | 4.4514 | 4.4436 | 4.4493 | 5320896.0 |
| 2007-06-25 13:10:00 | AAPL | Stock | 4.4496 | 4.4532 | 4.4493 | 4.4514 | 3105088.0 |
| 2007-06-25 13:15:00 | AAPL | Stock | 4.4514 | 4.4514 | 4.4457 | 4.4486 | 4101412.0 |
| 2007-06-25 13:20:00 | AAPL | Stock | 4.4489 | 4.4521 | 4.4468 | 4.4507 | 3561656.0 |
| 2007-06-25 13:25:00 | AAPL | Stock | 4.4507 | 4.4521 | 4.4448 | 4.445 | 5384176.0 |
| 2007-06-25 13:30:00 | AAPL | Stock | 4.445 | 4.4493 | 4.4411 | 4.4436 | 8976548.0 |
| 2007-06-25 13:35:00 | AAPL | Stock | 4.4436 | 4.4464 | 4.4414 | 4.4443 | 4719008.0 |
> showing 50 of 303,047 rows — these rows as CSV