PREVIEW / stock_5min / 2010-11-09
file: by_date/stock_5min/2010/2010-11-09.parquet size: 5.0 MB rows: 335,419 symbols: 3,519
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-09 05:20:00 | AAPL | Stock | 11.3321 | 11.3321 | 11.3321 | 11.3321 | 5600.0 |
| 2010-11-09 05:35:00 | AAPL | Stock | 11.3529 | 11.3529 | 11.3529 | 11.3529 | 2800.0 |
| 2010-11-09 05:45:00 | AAPL | Stock | 11.3693 | 11.3693 | 11.3686 | 11.3686 | 5600.0 |
| 2010-11-09 06:05:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3571 | 11.3571 | 2800.0 |
| 2010-11-09 06:20:00 | AAPL | Stock | 11.3604 | 11.3604 | 11.3604 | 11.3604 | 2800.0 |
| 2010-11-09 06:30:00 | AAPL | Stock | 11.375 | 11.375 | 11.375 | 11.375 | 19600.0 |
| 2010-11-09 06:40:00 | AAPL | Stock | 11.375 | 11.375 | 11.375 | 11.375 | 2800.0 |
| 2010-11-09 07:00:00 | AAPL | Stock | 11.4071 | 11.4104 | 11.3968 | 11.4089 | 47740.0 |
| 2010-11-09 07:05:00 | AAPL | Stock | 11.4082 | 11.4282 | 11.4029 | 11.4282 | 119980.0 |
| 2010-11-09 07:10:00 | AAPL | Stock | 11.4218 | 11.4268 | 11.4214 | 11.4218 | 148400.0 |
| 2010-11-09 07:15:00 | AAPL | Stock | 11.4214 | 11.4357 | 11.4214 | 11.4357 | 109200.0 |
| 2010-11-09 07:20:00 | AAPL | Stock | 11.4389 | 11.4425 | 11.4311 | 11.4425 | 92400.0 |
| 2010-11-09 07:25:00 | AAPL | Stock | 11.4425 | 11.4486 | 11.4314 | 11.4411 | 22680.0 |
| 2010-11-09 07:30:00 | AAPL | Stock | 11.4421 | 11.4421 | 11.435 | 11.435 | 11200.0 |
| 2010-11-09 07:35:00 | AAPL | Stock | 11.4375 | 11.4407 | 11.4346 | 11.4346 | 16940.0 |
| 2010-11-09 07:40:00 | AAPL | Stock | 11.4421 | 11.4457 | 11.4339 | 11.4421 | 46200.0 |
| 2010-11-09 07:45:00 | AAPL | Stock | 11.4489 | 11.4489 | 11.4368 | 11.4461 | 18200.0 |
| 2010-11-09 07:50:00 | AAPL | Stock | 11.4464 | 11.4464 | 11.4464 | 11.4464 | 11200.0 |
| 2010-11-09 07:55:00 | AAPL | Stock | 11.4404 | 11.4457 | 11.4404 | 11.4457 | 22400.0 |
| 2010-11-09 08:00:00 | AAPL | Stock | 11.4457 | 11.4464 | 11.4286 | 11.4382 | 708596.0 |
| 2010-11-09 08:05:00 | AAPL | Stock | 11.4364 | 11.4446 | 11.4289 | 11.4429 | 634172.0 |
| 2010-11-09 08:10:00 | AAPL | Stock | 11.4439 | 11.4521 | 11.4429 | 11.4514 | 899192.0 |
| 2010-11-09 08:15:00 | AAPL | Stock | 11.4482 | 11.4536 | 11.4464 | 11.4532 | 425992.0 |
| 2010-11-09 08:20:00 | AAPL | Stock | 11.4532 | 11.4568 | 11.45 | 11.4554 | 318472.0 |
| 2010-11-09 08:25:00 | AAPL | Stock | 11.4571 | 11.4725 | 11.4564 | 11.4664 | 1367548.0 |
| 2010-11-09 08:30:00 | AAPL | Stock | 11.4664 | 11.4696 | 11.4639 | 11.4679 | 573888.0 |
| 2010-11-09 08:35:00 | AAPL | Stock | 11.4679 | 11.4696 | 11.4625 | 11.4625 | 1027292.0 |
| 2010-11-09 08:40:00 | AAPL | Stock | 11.4632 | 11.4643 | 11.4511 | 11.4625 | 439012.0 |
| 2010-11-09 08:45:00 | AAPL | Stock | 11.4611 | 11.4621 | 11.4579 | 11.4593 | 184100.0 |
| 2010-11-09 08:50:00 | AAPL | Stock | 11.46 | 11.4664 | 11.4571 | 11.4604 | 712880.0 |
| 2010-11-09 08:55:00 | AAPL | Stock | 11.46 | 11.4946 | 11.4589 | 11.4589 | 518700.0 |
| 2010-11-09 09:00:00 | AAPL | Stock | 11.4675 | 11.4746 | 11.4657 | 11.4711 | 369460.0 |
| 2010-11-09 09:05:00 | AAPL | Stock | 11.4707 | 11.4886 | 11.4679 | 11.4846 | 444836.0 |
| 2010-11-09 09:10:00 | AAPL | Stock | 11.4857 | 11.4857 | 11.4786 | 11.4825 | 580944.0 |
| 2010-11-09 09:15:00 | AAPL | Stock | 11.4839 | 11.4846 | 11.4768 | 11.4779 | 148400.0 |
| 2010-11-09 09:20:00 | AAPL | Stock | 11.4786 | 11.4814 | 11.4721 | 11.4721 | 78260.0 |
| 2010-11-09 09:25:00 | AAPL | Stock | 11.4718 | 11.4804 | 11.4625 | 11.4657 | 480872.0 |
| 2010-11-09 09:30:00 | AAPL | Stock | 11.4657 | 11.475 | 11.4443 | 11.4479 | 19439588.0 |
| 2010-11-09 09:35:00 | AAPL | Stock | 11.4479 | 11.4589 | 11.4218 | 11.4375 | 12403860.0 |
| 2010-11-09 09:40:00 | AAPL | Stock | 11.4375 | 11.455 | 11.4304 | 11.4439 | 10287620.0 |
| 2010-11-09 09:45:00 | AAPL | Stock | 11.4425 | 11.4464 | 11.4239 | 11.4429 | 7920808.0 |
| 2010-11-09 09:50:00 | AAPL | Stock | 11.4409 | 11.4411 | 11.4293 | 11.4375 | 4118128.0 |
| 2010-11-09 09:55:00 | AAPL | Stock | 11.4375 | 11.4457 | 11.4329 | 11.4454 | 4879168.0 |
| 2010-11-09 10:00:00 | AAPL | Stock | 11.4432 | 11.4564 | 11.4421 | 11.4546 | 7777308.0 |
| 2010-11-09 10:05:00 | AAPL | Stock | 11.4546 | 11.4618 | 11.4411 | 11.4514 | 5934880.0 |
| 2010-11-09 10:10:00 | AAPL | Stock | 11.4493 | 11.4514 | 11.4361 | 11.4361 | 3899140.0 |
| 2010-11-09 10:15:00 | AAPL | Stock | 11.4357 | 11.4496 | 11.4357 | 11.4382 | 3501988.0 |
| 2010-11-09 10:20:00 | AAPL | Stock | 11.4407 | 11.4589 | 11.4375 | 11.4579 | 5337612.0 |
| 2010-11-09 10:25:00 | AAPL | Stock | 11.4557 | 11.4639 | 11.4536 | 11.4596 | 5522944.0 |
| 2010-11-09 10:30:00 | AAPL | Stock | 11.4593 | 11.4607 | 11.4432 | 11.4486 | 3575768.0 |
> showing 50 of 335,419 rows — these rows as CSV