PREVIEW / stock_5min / 2008-07-09
file: by_date/stock_5min/2008/2008-07-09.parquet size: 4.5 MB rows: 315,979 symbols: 3,318
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-09 05:55:00 | AAPL | Stock | 6.4357 | 6.4357 | 6.4357 | 6.4357 | 2800.0 |
| 2008-07-09 06:30:00 | AAPL | Stock | 6.4564 | 6.4564 | 6.4564 | 6.4564 | 5600.0 |
| 2008-07-09 06:40:00 | AAPL | Stock | 6.4739 | 6.4739 | 6.4286 | 6.4286 | 8400.0 |
| 2008-07-09 07:00:00 | AAPL | Stock | 6.4161 | 6.4161 | 6.4136 | 6.4136 | 8400.0 |
| 2008-07-09 07:15:00 | AAPL | Stock | 6.3929 | 6.4021 | 6.375 | 6.4021 | 25200.0 |
| 2008-07-09 07:20:00 | AAPL | Stock | 6.4118 | 6.4125 | 6.4118 | 6.4121 | 96880.0 |
| 2008-07-09 07:25:00 | AAPL | Stock | 6.4121 | 6.4196 | 6.4121 | 6.4196 | 161028.0 |
| 2008-07-09 07:30:00 | AAPL | Stock | 6.4196 | 6.4286 | 6.4196 | 6.4286 | 108640.0 |
| 2008-07-09 07:35:00 | AAPL | Stock | 6.4214 | 6.4214 | 6.4196 | 6.4196 | 20160.0 |
| 2008-07-09 07:40:00 | AAPL | Stock | 6.4207 | 6.4321 | 6.4207 | 6.4321 | 16800.0 |
| 2008-07-09 07:45:00 | AAPL | Stock | 6.425 | 6.4257 | 6.425 | 6.425 | 70000.0 |
| 2008-07-09 07:50:00 | AAPL | Stock | 6.425 | 6.4371 | 6.425 | 6.4371 | 208880.0 |
| 2008-07-09 07:55:00 | AAPL | Stock | 6.4407 | 6.4479 | 6.4407 | 6.4464 | 39200.0 |
| 2008-07-09 08:00:00 | AAPL | Stock | 6.4429 | 6.4679 | 6.4321 | 6.4625 | 1572536.0 |
| 2008-07-09 08:05:00 | AAPL | Stock | 6.4643 | 6.4707 | 6.4536 | 6.4536 | 740432.0 |
| 2008-07-09 08:10:00 | AAPL | Stock | 6.4518 | 6.4607 | 6.4282 | 6.4568 | 2213204.0 |
| 2008-07-09 08:15:00 | AAPL | Stock | 6.4568 | 6.46 | 6.4536 | 6.4554 | 124236.0 |
| 2008-07-09 08:20:00 | AAPL | Stock | 6.4536 | 6.4561 | 6.4393 | 6.4561 | 364364.0 |
| 2008-07-09 08:25:00 | AAPL | Stock | 6.4557 | 6.4675 | 6.4557 | 6.4643 | 605836.0 |
| 2008-07-09 08:30:00 | AAPL | Stock | 6.4643 | 6.4661 | 6.4596 | 6.4629 | 296968.0 |
| 2008-07-09 08:35:00 | AAPL | Stock | 6.4625 | 6.4646 | 6.4604 | 6.4607 | 201740.0 |
| 2008-07-09 08:40:00 | AAPL | Stock | 6.4607 | 6.4611 | 6.4554 | 6.4575 | 416416.0 |
| 2008-07-09 08:45:00 | AAPL | Stock | 6.4571 | 6.4607 | 6.4571 | 6.4607 | 248220.0 |
| 2008-07-09 08:50:00 | AAPL | Stock | 6.4593 | 6.4607 | 6.4496 | 6.4543 | 339640.0 |
| 2008-07-09 08:55:00 | AAPL | Stock | 6.4539 | 6.455 | 6.4471 | 6.4536 | 660380.0 |
| 2008-07-09 09:00:00 | AAPL | Stock | 6.4536 | 6.4568 | 6.4464 | 6.4543 | 398188.0 |
| 2008-07-09 09:05:00 | AAPL | Stock | 6.4554 | 6.4607 | 6.4546 | 6.4579 | 374640.0 |
| 2008-07-09 09:10:00 | AAPL | Stock | 6.4571 | 6.4579 | 6.4175 | 6.4554 | 1029952.0 |
| 2008-07-09 09:15:00 | AAPL | Stock | 6.4554 | 6.4554 | 6.4511 | 6.4532 | 242816.0 |
| 2008-07-09 09:20:00 | AAPL | Stock | 6.4532 | 6.4536 | 6.4393 | 6.4418 | 260736.0 |
| 2008-07-09 09:25:00 | AAPL | Stock | 6.4407 | 6.4464 | 6.4325 | 6.4375 | 832356.0 |
| 2008-07-09 09:30:00 | AAPL | Stock | 6.4357 | 6.4544 | 6.4236 | 6.4421 | 27182092.0 |
| 2008-07-09 09:35:00 | AAPL | Stock | 6.4429 | 6.45 | 6.3932 | 6.4046 | 25305616.0 |
| 2008-07-09 09:40:00 | AAPL | Stock | 6.4046 | 6.4357 | 6.4018 | 6.4357 | 17676540.0 |
| 2008-07-09 09:45:00 | AAPL | Stock | 6.435 | 6.4461 | 6.4225 | 6.425 | 17897712.0 |
| 2008-07-09 09:50:00 | AAPL | Stock | 6.4257 | 6.4257 | 6.3946 | 6.4111 | 17671892.0 |
| 2008-07-09 09:55:00 | AAPL | Stock | 6.4121 | 6.4411 | 6.4107 | 6.4321 | 13652100.0 |
| 2008-07-09 10:00:00 | AAPL | Stock | 6.4321 | 6.4325 | 6.3979 | 6.4072 | 13352612.0 |
| 2008-07-09 10:05:00 | AAPL | Stock | 6.4075 | 6.4393 | 6.4032 | 6.435 | 10904880.0 |
| 2008-07-09 10:10:00 | AAPL | Stock | 6.4354 | 6.4611 | 6.4314 | 6.4404 | 16461424.0 |
| 2008-07-09 10:15:00 | AAPL | Stock | 6.4404 | 6.4532 | 6.4304 | 6.44 | 12814284.0 |
| 2008-07-09 10:20:00 | AAPL | Stock | 6.4411 | 6.4454 | 6.425 | 6.4318 | 13241620.0 |
| 2008-07-09 10:25:00 | AAPL | Stock | 6.4318 | 6.4607 | 6.4318 | 6.4471 | 13174560.0 |
| 2008-07-09 10:30:00 | AAPL | Stock | 6.4471 | 6.4479 | 6.4307 | 6.44 | 10181528.0 |
| 2008-07-09 10:35:00 | AAPL | Stock | 6.4393 | 6.445 | 6.4171 | 6.42 | 15203944.0 |
| 2008-07-09 10:40:00 | AAPL | Stock | 6.4189 | 6.4268 | 6.4018 | 6.4107 | 15889132.0 |
| 2008-07-09 10:45:00 | AAPL | Stock | 6.41 | 6.4264 | 6.4046 | 6.4157 | 8444296.0 |
| 2008-07-09 10:50:00 | AAPL | Stock | 6.4157 | 6.4279 | 6.4118 | 6.4218 | 6627572.0 |
| 2008-07-09 10:55:00 | AAPL | Stock | 6.4218 | 6.4357 | 6.42 | 6.4232 | 9003624.0 |
| 2008-07-09 11:00:00 | AAPL | Stock | 6.4236 | 6.4421 | 6.4161 | 6.4364 | 11708088.0 |
> showing 50 of 315,979 rows — these rows as CSV