PREVIEW / stock_5min / 2006-02-09
file: by_date/stock_5min/2006/2006-02-09.parquet size: 3.0 MB rows: 216,702 symbols: 2,196
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-02-09 04:15:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.4661 | 2.4661 | 2800.0 |
| 2006-02-09 05:00:00 | AAPL | Stock | 2.4811 | 2.4811 | 2.4811 | 2.4811 | 5600.0 |
| 2006-02-09 07:25:00 | AAPL | Stock | 2.475 | 2.4786 | 2.475 | 2.4754 | 14000.0 |
| 2006-02-09 07:30:00 | AAPL | Stock | 2.4768 | 2.4893 | 2.4768 | 2.4893 | 16800.0 |
| 2006-02-09 07:35:00 | AAPL | Stock | 2.4779 | 2.4782 | 2.4775 | 2.4782 | 42000.0 |
| 2006-02-09 07:40:00 | AAPL | Stock | 2.4775 | 2.4775 | 2.4775 | 2.4775 | 42000.0 |
| 2006-02-09 07:50:00 | AAPL | Stock | 2.4789 | 2.4789 | 2.4789 | 2.4789 | 22400.0 |
| 2006-02-09 08:00:00 | AAPL | Stock | 2.4768 | 2.4782 | 2.4721 | 2.4768 | 500556.0 |
| 2006-02-09 08:05:00 | AAPL | Stock | 2.4764 | 2.4764 | 2.4714 | 2.4718 | 109480.0 |
| 2006-02-09 08:10:00 | AAPL | Stock | 2.4714 | 2.4714 | 2.465 | 2.465 | 218400.0 |
| 2006-02-09 08:15:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4607 | 2.4643 | 352940.0 |
| 2006-02-09 08:20:00 | AAPL | Stock | 2.4593 | 2.4636 | 2.4593 | 2.4636 | 124180.0 |
| 2006-02-09 08:25:00 | AAPL | Stock | 2.4611 | 2.4611 | 2.4536 | 2.4554 | 147000.0 |
| 2006-02-09 08:30:00 | AAPL | Stock | 2.4571 | 2.4636 | 2.4571 | 2.4632 | 81032.0 |
| 2006-02-09 08:35:00 | AAPL | Stock | 2.4639 | 2.4679 | 2.4639 | 2.4661 | 204540.0 |
| 2006-02-09 08:40:00 | AAPL | Stock | 2.4661 | 2.4679 | 2.465 | 2.465 | 147336.0 |
| 2006-02-09 08:45:00 | AAPL | Stock | 2.4661 | 2.4682 | 2.4646 | 2.4679 | 301000.0 |
| 2006-02-09 08:50:00 | AAPL | Stock | 2.4679 | 2.4696 | 2.4679 | 2.4696 | 219128.0 |
| 2006-02-09 08:55:00 | AAPL | Stock | 2.4696 | 2.4696 | 2.4657 | 2.4657 | 99008.0 |
| 2006-02-09 09:00:00 | AAPL | Stock | 2.4675 | 2.4675 | 2.4643 | 2.4643 | 150500.0 |
| 2006-02-09 09:05:00 | AAPL | Stock | 2.4661 | 2.4693 | 2.4643 | 2.4693 | 138908.0 |
| 2006-02-09 09:10:00 | AAPL | Stock | 2.4693 | 2.4696 | 2.4679 | 2.4682 | 144480.0 |
| 2006-02-09 09:15:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.46 | 2.4643 | 162400.0 |
| 2006-02-09 09:20:00 | AAPL | Stock | 2.4643 | 2.4696 | 2.4643 | 2.4661 | 190960.0 |
| 2006-02-09 09:25:00 | AAPL | Stock | 2.4657 | 2.4721 | 2.4611 | 2.4682 | 1483916.0 |
| 2006-02-09 09:30:00 | AAPL | Stock | 2.4679 | 2.4725 | 2.4471 | 2.4614 | 31562468.0 |
| 2006-02-09 09:35:00 | AAPL | Stock | 2.4614 | 2.4707 | 2.4307 | 2.435 | 24155488.0 |
| 2006-02-09 09:40:00 | AAPL | Stock | 2.436 | 2.4432 | 2.4146 | 2.4268 | 26981780.0 |
| 2006-02-09 09:45:00 | AAPL | Stock | 2.4271 | 2.4561 | 2.425 | 2.4514 | 22442196.0 |
| 2006-02-09 09:50:00 | AAPL | Stock | 2.4511 | 2.4614 | 2.4471 | 2.4507 | 25064956.0 |
| 2006-02-09 09:55:00 | AAPL | Stock | 2.4507 | 2.4725 | 2.4507 | 2.4639 | 25500132.0 |
| 2006-02-09 10:00:00 | AAPL | Stock | 2.4646 | 2.4686 | 2.4557 | 2.4614 | 17374952.0 |
| 2006-02-09 10:05:00 | AAPL | Stock | 2.4614 | 2.4679 | 2.4564 | 2.4568 | 14080528.0 |
| 2006-02-09 10:10:00 | AAPL | Stock | 2.4568 | 2.4643 | 2.4536 | 2.4571 | 14713664.0 |
| 2006-02-09 10:15:00 | AAPL | Stock | 2.4571 | 2.4586 | 2.4382 | 2.4482 | 19390672.0 |
| 2006-02-09 10:20:00 | AAPL | Stock | 2.4482 | 2.4511 | 2.44 | 2.4439 | 10338524.0 |
| 2006-02-09 10:25:00 | AAPL | Stock | 2.4432 | 2.4486 | 2.4382 | 2.4461 | 10183936.0 |
| 2006-02-09 10:30:00 | AAPL | Stock | 2.4454 | 2.4532 | 2.4386 | 2.4393 | 8753584.0 |
| 2006-02-09 10:35:00 | AAPL | Stock | 2.4393 | 2.4454 | 2.4318 | 2.4325 | 10564148.0 |
| 2006-02-09 10:40:00 | AAPL | Stock | 2.4336 | 2.4443 | 2.4325 | 2.4382 | 7638288.0 |
| 2006-02-09 10:45:00 | AAPL | Stock | 2.4382 | 2.4404 | 2.4286 | 2.4293 | 8412404.0 |
| 2006-02-09 10:50:00 | AAPL | Stock | 2.4293 | 2.4382 | 2.4293 | 2.4343 | 8704500.0 |
| 2006-02-09 10:55:00 | AAPL | Stock | 2.4336 | 2.4414 | 2.4318 | 2.4411 | 5926844.0 |
| 2006-02-09 11:00:00 | AAPL | Stock | 2.4414 | 2.4443 | 2.4357 | 2.4382 | 7465024.0 |
| 2006-02-09 11:05:00 | AAPL | Stock | 2.4382 | 2.4386 | 2.4204 | 2.4293 | 15805132.0 |
| 2006-02-09 11:10:00 | AAPL | Stock | 2.4293 | 2.4296 | 2.4218 | 2.4246 | 11605216.0 |
| 2006-02-09 11:15:00 | AAPL | Stock | 2.425 | 2.4261 | 2.4196 | 2.4214 | 10298652.0 |
| 2006-02-09 11:20:00 | AAPL | Stock | 2.4211 | 2.4307 | 2.4182 | 2.4286 | 11809308.0 |
| 2006-02-09 11:25:00 | AAPL | Stock | 2.4289 | 2.4368 | 2.4268 | 2.4361 | 9170308.0 |
| 2006-02-09 11:30:00 | AAPL | Stock | 2.4357 | 2.4414 | 2.43 | 2.435 | 11101468.0 |
> showing 50 of 216,702 rows — these rows as CSV