PREVIEW / stock_5min / 2006-09-05
file: by_date/stock_5min/2006/2006-09-05.parquet size: 3.1 MB rows: 227,675 symbols: 2,359
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-05 06:20:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4357 | 2.4357 | 2800.0 |
| 2006-09-05 06:45:00 | AAPL | Stock | 2.4421 | 2.4421 | 2.4357 | 2.4357 | 9800.0 |
| 2006-09-05 08:00:00 | AAPL | Stock | 2.4429 | 2.4496 | 2.4429 | 2.4443 | 676060.0 |
| 2006-09-05 08:05:00 | AAPL | Stock | 2.45 | 2.4525 | 2.4464 | 2.4525 | 511812.0 |
| 2006-09-05 08:10:00 | AAPL | Stock | 2.4525 | 2.4536 | 2.4525 | 2.4536 | 185500.0 |
| 2006-09-05 08:15:00 | AAPL | Stock | 2.4536 | 2.4554 | 2.4394 | 2.4554 | 400400.0 |
| 2006-09-05 08:20:00 | AAPL | Stock | 2.4525 | 2.4525 | 2.4525 | 2.4525 | 26600.0 |
| 2006-09-05 08:30:00 | AAPL | Stock | 2.4543 | 2.4543 | 2.4543 | 2.4543 | 14000.0 |
| 2006-09-05 08:35:00 | AAPL | Stock | 2.4521 | 2.4543 | 2.4518 | 2.4543 | 39200.0 |
| 2006-09-05 08:40:00 | AAPL | Stock | 2.4536 | 2.4579 | 2.4536 | 2.4571 | 275520.0 |
| 2006-09-05 08:45:00 | AAPL | Stock | 2.4571 | 2.4636 | 2.4571 | 2.4607 | 497980.0 |
| 2006-09-05 08:50:00 | AAPL | Stock | 2.4614 | 2.4625 | 2.46 | 2.4625 | 227500.0 |
| 2006-09-05 08:55:00 | AAPL | Stock | 2.4625 | 2.4643 | 2.4607 | 2.4625 | 335916.0 |
| 2006-09-05 09:00:00 | AAPL | Stock | 2.4618 | 2.4625 | 2.4589 | 2.4589 | 103600.0 |
| 2006-09-05 09:05:00 | AAPL | Stock | 2.4589 | 2.4618 | 2.4589 | 2.4604 | 235900.0 |
| 2006-09-05 09:10:00 | AAPL | Stock | 2.4604 | 2.4618 | 2.4593 | 2.46 | 169400.0 |
| 2006-09-05 09:15:00 | AAPL | Stock | 2.46 | 2.4654 | 2.46 | 2.4643 | 406140.0 |
| 2006-09-05 09:20:00 | AAPL | Stock | 2.4643 | 2.4654 | 2.4614 | 2.4621 | 262080.0 |
| 2006-09-05 09:25:00 | AAPL | Stock | 2.4604 | 2.4646 | 2.4564 | 2.4643 | 959980.0 |
| 2006-09-05 09:30:00 | AAPL | Stock | 2.4632 | 2.4732 | 2.455 | 2.4589 | 24360476.0 |
| 2006-09-05 09:35:00 | AAPL | Stock | 2.4579 | 2.4711 | 2.4575 | 2.4679 | 17099012.0 |
| 2006-09-05 09:40:00 | AAPL | Stock | 2.4682 | 2.4775 | 2.4646 | 2.4735 | 23900436.0 |
| 2006-09-05 09:45:00 | AAPL | Stock | 2.4736 | 2.475 | 2.4554 | 2.46 | 17350788.0 |
| 2006-09-05 09:50:00 | AAPL | Stock | 2.46 | 2.4643 | 2.4564 | 2.4579 | 12401396.0 |
| 2006-09-05 09:55:00 | AAPL | Stock | 2.4582 | 2.4611 | 2.4511 | 2.46 | 13319236.0 |
| 2006-09-05 10:00:00 | AAPL | Stock | 2.46 | 2.4725 | 2.4571 | 2.4718 | 16043888.0 |
| 2006-09-05 10:05:00 | AAPL | Stock | 2.4714 | 2.4796 | 2.47 | 2.471 | 18548684.0 |
| 2006-09-05 10:10:00 | AAPL | Stock | 2.4707 | 2.4732 | 2.4636 | 2.4654 | 10847564.0 |
| 2006-09-05 10:15:00 | AAPL | Stock | 2.4657 | 2.4711 | 2.4607 | 2.4654 | 13780844.0 |
| 2006-09-05 10:20:00 | AAPL | Stock | 2.4654 | 2.4657 | 2.46 | 2.46 | 8412768.0 |
| 2006-09-05 10:25:00 | AAPL | Stock | 2.4604 | 2.4629 | 2.4579 | 2.4604 | 6845944.0 |
| 2006-09-05 10:30:00 | AAPL | Stock | 2.4604 | 2.4682 | 2.4579 | 2.4682 | 8100512.0 |
| 2006-09-05 10:35:00 | AAPL | Stock | 2.4682 | 2.4686 | 2.455 | 2.4554 | 10340260.0 |
| 2006-09-05 10:40:00 | AAPL | Stock | 2.455 | 2.4554 | 2.4489 | 2.4525 | 15530116.0 |
| 2006-09-05 10:45:00 | AAPL | Stock | 2.4525 | 2.4564 | 2.4514 | 2.4521 | 6002304.0 |
| 2006-09-05 10:50:00 | AAPL | Stock | 2.4521 | 2.4568 | 2.4496 | 2.4518 | 6713196.0 |
| 2006-09-05 10:55:00 | AAPL | Stock | 2.4514 | 2.4539 | 2.4482 | 2.4496 | 9446024.0 |
| 2006-09-05 11:00:00 | AAPL | Stock | 2.4498 | 2.4589 | 2.4496 | 2.4581 | 6381592.0 |
| 2006-09-05 11:05:00 | AAPL | Stock | 2.4582 | 2.4618 | 2.4575 | 2.4586 | 6162380.0 |
| 2006-09-05 11:10:00 | AAPL | Stock | 2.4582 | 2.4643 | 2.4554 | 2.4639 | 6361376.0 |
| 2006-09-05 11:15:00 | AAPL | Stock | 2.4639 | 2.4643 | 2.4593 | 2.4607 | 3379292.0 |
| 2006-09-05 11:20:00 | AAPL | Stock | 2.4611 | 2.4657 | 2.4607 | 2.4646 | 8729616.0 |
| 2006-09-05 11:25:00 | AAPL | Stock | 2.4646 | 2.4743 | 2.4646 | 2.4743 | 16475704.0 |
| 2006-09-05 11:30:00 | AAPL | Stock | 2.4743 | 2.4764 | 2.4696 | 2.4736 | 12715808.0 |
| 2006-09-05 11:35:00 | AAPL | Stock | 2.4732 | 2.4732 | 2.4679 | 2.47 | 6717060.0 |
| 2006-09-05 11:40:00 | AAPL | Stock | 2.47 | 2.4707 | 2.4661 | 2.4693 | 15264340.0 |
| 2006-09-05 11:45:00 | AAPL | Stock | 2.4693 | 2.4886 | 2.4693 | 2.4843 | 26719476.0 |
| 2006-09-05 11:50:00 | AAPL | Stock | 2.4846 | 2.4921 | 2.4821 | 2.4904 | 32445532.0 |
| 2006-09-05 11:55:00 | AAPL | Stock | 2.4904 | 2.4961 | 2.4889 | 2.4939 | 20818924.0 |
| 2006-09-05 12:00:00 | AAPL | Stock | 2.4936 | 2.4971 | 2.49 | 2.4907 | 14459508.0 |
> showing 50 of 227,675 rows — these rows as CSV