PREVIEW / stock_5min / 2011-05-11
file: by_date/stock_5min/2011/2011-05-11.parquet size: 5.0 MB rows: 334,448 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-11 04:40:00 | AAPL | Stock | 12.4689 | 12.4689 | 12.4689 | 12.4689 | 8400.0 |
| 2011-05-11 05:40:00 | AAPL | Stock | 12.4696 | 12.4696 | 12.4696 | 12.4696 | 2800.0 |
| 2011-05-11 06:25:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 8400.0 |
| 2011-05-11 06:30:00 | AAPL | Stock | 12.4696 | 12.4696 | 12.4696 | 12.4696 | 9520.0 |
| 2011-05-11 06:35:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-05-11 06:50:00 | AAPL | Stock | 12.4636 | 12.4636 | 12.4636 | 12.4636 | 2800.0 |
| 2011-05-11 06:55:00 | AAPL | Stock | 12.4636 | 12.4636 | 12.4636 | 12.4636 | 8400.0 |
| 2011-05-11 07:00:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 14000.0 |
| 2011-05-11 07:05:00 | AAPL | Stock | 12.4521 | 12.4521 | 12.4464 | 12.4464 | 58100.0 |
| 2011-05-11 07:15:00 | AAPL | Stock | 12.4468 | 12.4468 | 12.4464 | 12.4464 | 11900.0 |
| 2011-05-11 07:20:00 | AAPL | Stock | 12.4536 | 12.4543 | 12.4536 | 12.4543 | 8400.0 |
| 2011-05-11 07:25:00 | AAPL | Stock | 12.4543 | 12.4543 | 12.4543 | 12.4543 | 5600.0 |
| 2011-05-11 07:30:00 | AAPL | Stock | 12.4621 | 12.4714 | 12.4621 | 12.4643 | 51800.0 |
| 2011-05-11 07:35:00 | AAPL | Stock | 12.4679 | 12.4679 | 12.4643 | 12.4643 | 29400.0 |
| 2011-05-11 07:50:00 | AAPL | Stock | 12.4671 | 12.4671 | 12.4607 | 12.4607 | 37100.0 |
| 2011-05-11 07:55:00 | AAPL | Stock | 12.4661 | 12.4661 | 12.4571 | 12.4571 | 30940.0 |
| 2011-05-11 08:00:00 | AAPL | Stock | 12.4607 | 12.4643 | 12.4536 | 12.4536 | 200676.0 |
| 2011-05-11 08:05:00 | AAPL | Stock | 12.4546 | 12.4575 | 12.4468 | 12.4571 | 68096.0 |
| 2011-05-11 08:10:00 | AAPL | Stock | 12.4604 | 12.4604 | 12.4514 | 12.4514 | 56812.0 |
| 2011-05-11 08:15:00 | AAPL | Stock | 12.4464 | 12.4468 | 12.4375 | 12.4411 | 143500.0 |
| 2011-05-11 08:20:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4314 | 12.4314 | 65800.0 |
| 2011-05-11 08:25:00 | AAPL | Stock | 12.4289 | 12.4339 | 12.4257 | 12.4268 | 166040.0 |
| 2011-05-11 08:30:00 | AAPL | Stock | 12.4339 | 12.4414 | 12.4289 | 12.4414 | 102760.0 |
| 2011-05-11 08:35:00 | AAPL | Stock | 12.45 | 12.4579 | 12.4464 | 12.4568 | 172172.0 |
| 2011-05-11 08:40:00 | AAPL | Stock | 12.4525 | 12.4589 | 12.4525 | 12.4582 | 229208.0 |
| 2011-05-11 08:45:00 | AAPL | Stock | 12.4564 | 12.4593 | 12.4536 | 12.4536 | 99260.0 |
| 2011-05-11 08:50:00 | AAPL | Stock | 12.4568 | 12.4711 | 12.4546 | 12.4657 | 451080.0 |
| 2011-05-11 08:55:00 | AAPL | Stock | 12.4696 | 12.4732 | 12.4579 | 12.4593 | 140196.0 |
| 2011-05-11 09:00:00 | AAPL | Stock | 12.4632 | 12.4693 | 12.4632 | 12.4657 | 121268.0 |
| 2011-05-11 09:05:00 | AAPL | Stock | 12.4661 | 12.4746 | 12.4661 | 12.4746 | 165116.0 |
| 2011-05-11 09:10:00 | AAPL | Stock | 12.4714 | 12.4764 | 12.4696 | 12.4764 | 453096.0 |
| 2011-05-11 09:15:00 | AAPL | Stock | 12.4761 | 12.4829 | 12.47 | 12.4707 | 380520.0 |
| 2011-05-11 09:20:00 | AAPL | Stock | 12.4707 | 12.4732 | 12.4593 | 12.4732 | 348516.0 |
| 2011-05-11 09:25:00 | AAPL | Stock | 12.4711 | 12.4711 | 12.4625 | 12.4643 | 117600.0 |
| 2011-05-11 09:30:00 | AAPL | Stock | 12.4643 | 12.5 | 12.435 | 12.4395 | 18872980.0 |
| 2011-05-11 09:35:00 | AAPL | Stock | 12.435 | 12.4539 | 12.4214 | 12.4406 | 9580284.0 |
| 2011-05-11 09:40:00 | AAPL | Stock | 12.4382 | 12.4614 | 12.435 | 12.4574 | 7044688.0 |
| 2011-05-11 09:45:00 | AAPL | Stock | 12.4575 | 12.4821 | 12.4571 | 12.465 | 6479844.0 |
| 2011-05-11 09:50:00 | AAPL | Stock | 12.4654 | 12.4864 | 12.4582 | 12.4654 | 5755372.0 |
| 2011-05-11 09:55:00 | AAPL | Stock | 12.4671 | 12.4707 | 12.4571 | 12.4571 | 2960076.0 |
| 2011-05-11 10:00:00 | AAPL | Stock | 12.4571 | 12.4579 | 12.4331 | 12.4411 | 5261984.0 |
| 2011-05-11 10:05:00 | AAPL | Stock | 12.4411 | 12.4603 | 12.4321 | 12.4543 | 4389840.0 |
| 2011-05-11 10:10:00 | AAPL | Stock | 12.4521 | 12.4689 | 12.4364 | 12.4636 | 3866184.0 |
| 2011-05-11 10:15:00 | AAPL | Stock | 12.4654 | 12.4732 | 12.4597 | 12.4661 | 4571616.0 |
| 2011-05-11 10:20:00 | AAPL | Stock | 12.4654 | 12.4686 | 12.4521 | 12.4575 | 3152576.0 |
| 2011-05-11 10:25:00 | AAPL | Stock | 12.4571 | 12.4625 | 12.4504 | 12.4621 | 2353736.0 |
| 2011-05-11 10:30:00 | AAPL | Stock | 12.4596 | 12.4597 | 12.4361 | 12.4457 | 4084192.0 |
| 2011-05-11 10:35:00 | AAPL | Stock | 12.4461 | 12.4461 | 12.4229 | 12.4239 | 6087620.0 |
| 2011-05-11 10:40:00 | AAPL | Stock | 12.425 | 12.4446 | 12.415 | 12.4432 | 4378416.0 |
| 2011-05-11 10:45:00 | AAPL | Stock | 12.4439 | 12.4507 | 12.4411 | 12.4482 | 3456432.0 |
> showing 50 of 334,448 rows — these rows as CSV