PREVIEW / stock_5min / 2006-04-06
file: by_date/stock_5min/2006/2006-04-06.parquet size: 3.1 MB rows: 224,098 symbols: 2,211
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-04-06 04:25:00 | AAPL | Stock | 2.45 | 2.45 | 2.45 | 2.45 | 32200.0 |
| 2006-04-06 04:35:00 | AAPL | Stock | 2.4518 | 2.4586 | 2.4518 | 2.4586 | 64400.0 |
| 2006-04-06 04:40:00 | AAPL | Stock | 2.4586 | 2.4586 | 2.4586 | 2.4586 | 5600.0 |
| 2006-04-06 04:50:00 | AAPL | Stock | 2.4586 | 2.4586 | 2.4586 | 2.4586 | 4452.0 |
| 2006-04-06 04:55:00 | AAPL | Stock | 2.4586 | 2.4607 | 2.4586 | 2.4607 | 43652.0 |
| 2006-04-06 05:00:00 | AAPL | Stock | 2.4607 | 2.4607 | 2.4607 | 2.4607 | 11200.0 |
| 2006-04-06 05:15:00 | AAPL | Stock | 2.4607 | 2.4643 | 2.4607 | 2.4643 | 26600.0 |
| 2006-04-06 05:25:00 | AAPL | Stock | 2.4643 | 2.4643 | 2.4643 | 2.4643 | 5600.0 |
| 2006-04-06 05:40:00 | AAPL | Stock | 2.4611 | 2.4643 | 2.4611 | 2.4643 | 11900.0 |
| 2006-04-06 05:45:00 | AAPL | Stock | 2.4661 | 2.475 | 2.4661 | 2.4679 | 292824.0 |
| 2006-04-06 05:55:00 | AAPL | Stock | 2.4611 | 2.4664 | 2.4611 | 2.4664 | 18228.0 |
| 2006-04-06 06:05:00 | AAPL | Stock | 2.4643 | 2.4643 | 2.4643 | 2.4643 | 28000.0 |
| 2006-04-06 06:20:00 | AAPL | Stock | 2.4625 | 2.4625 | 2.4554 | 2.4554 | 113372.0 |
| 2006-04-06 06:25:00 | AAPL | Stock | 2.4607 | 2.4607 | 2.4607 | 2.4607 | 14000.0 |
| 2006-04-06 06:35:00 | AAPL | Stock | 2.4536 | 2.4536 | 2.4518 | 2.4536 | 84000.0 |
| 2006-04-06 06:45:00 | AAPL | Stock | 2.4536 | 2.4536 | 2.4536 | 2.4536 | 16828.0 |
| 2006-04-06 06:55:00 | AAPL | Stock | 2.4536 | 2.4536 | 2.4518 | 2.4518 | 14000.0 |
| 2006-04-06 07:00:00 | AAPL | Stock | 2.4536 | 2.4536 | 2.4536 | 2.4536 | 5600.0 |
| 2006-04-06 07:05:00 | AAPL | Stock | 2.4518 | 2.4518 | 2.4471 | 2.4479 | 35560.0 |
| 2006-04-06 07:10:00 | AAPL | Stock | 2.4436 | 2.4464 | 2.4375 | 2.4432 | 136584.0 |
| 2006-04-06 07:20:00 | AAPL | Stock | 2.4414 | 2.4414 | 2.4389 | 2.4389 | 56000.0 |
| 2006-04-06 07:25:00 | AAPL | Stock | 2.4393 | 2.4479 | 2.4357 | 2.4464 | 389340.0 |
| 2006-04-06 07:30:00 | AAPL | Stock | 2.4446 | 2.4496 | 2.4418 | 2.4461 | 116200.0 |
| 2006-04-06 07:35:00 | AAPL | Stock | 2.4482 | 2.4482 | 2.4414 | 2.4464 | 192920.0 |
| 2006-04-06 07:40:00 | AAPL | Stock | 2.4464 | 2.4493 | 2.4429 | 2.4429 | 129080.0 |
| 2006-04-06 07:45:00 | AAPL | Stock | 2.4446 | 2.45 | 2.4429 | 2.4446 | 260820.0 |
| 2006-04-06 07:50:00 | AAPL | Stock | 2.4482 | 2.4482 | 2.4457 | 2.4464 | 109200.0 |
| 2006-04-06 07:55:00 | AAPL | Stock | 2.4464 | 2.4511 | 2.4446 | 2.4468 | 557340.0 |
| 2006-04-06 08:00:00 | AAPL | Stock | 2.4464 | 2.4561 | 2.4382 | 2.4386 | 4125856.0 |
| 2006-04-06 08:05:00 | AAPL | Stock | 2.4375 | 2.4411 | 2.4243 | 2.4314 | 2831248.0 |
| 2006-04-06 08:10:00 | AAPL | Stock | 2.4304 | 2.4357 | 2.4304 | 2.4332 | 988624.0 |
| 2006-04-06 08:15:00 | AAPL | Stock | 2.4304 | 2.4339 | 2.4304 | 2.4321 | 525896.0 |
| 2006-04-06 08:20:00 | AAPL | Stock | 2.4321 | 2.4336 | 2.4289 | 2.4311 | 683004.0 |
| 2006-04-06 08:25:00 | AAPL | Stock | 2.4304 | 2.4314 | 2.4254 | 2.4268 | 1356488.0 |
| 2006-04-06 08:30:00 | AAPL | Stock | 2.4275 | 2.4311 | 2.4243 | 2.4296 | 1166172.0 |
| 2006-04-06 08:35:00 | AAPL | Stock | 2.4304 | 2.4357 | 2.4304 | 2.4336 | 2075808.0 |
| 2006-04-06 08:40:00 | AAPL | Stock | 2.4336 | 2.4364 | 2.4329 | 2.4357 | 1148868.0 |
| 2006-04-06 08:45:00 | AAPL | Stock | 2.4354 | 2.4357 | 2.4332 | 2.4332 | 1064196.0 |
| 2006-04-06 08:50:00 | AAPL | Stock | 2.4339 | 2.4368 | 2.4332 | 2.4343 | 1718836.0 |
| 2006-04-06 08:55:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.43 | 2.4343 | 858088.0 |
| 2006-04-06 09:00:00 | AAPL | Stock | 2.4339 | 2.4339 | 2.4286 | 2.43 | 1019340.0 |
| 2006-04-06 09:05:00 | AAPL | Stock | 2.43 | 2.4332 | 2.4271 | 2.4289 | 886060.0 |
| 2006-04-06 09:10:00 | AAPL | Stock | 2.4289 | 2.4325 | 2.4289 | 2.4293 | 552636.0 |
| 2006-04-06 09:15:00 | AAPL | Stock | 2.4307 | 2.4343 | 2.4268 | 2.4343 | 1364776.0 |
| 2006-04-06 09:20:00 | AAPL | Stock | 2.4343 | 2.4357 | 2.42 | 2.4282 | 1599080.0 |
| 2006-04-06 09:25:00 | AAPL | Stock | 2.4254 | 2.4421 | 2.4214 | 2.4393 | 4214644.0 |
| 2006-04-06 09:30:00 | AAPL | Stock | 2.4393 | 2.4625 | 2.4357 | 2.4464 | 111020840.0 |
| 2006-04-06 09:35:00 | AAPL | Stock | 2.4464 | 2.4789 | 2.4414 | 2.4768 | 74473952.0 |
| 2006-04-06 09:40:00 | AAPL | Stock | 2.4779 | 2.4821 | 2.4643 | 2.4657 | 90707652.0 |
| 2006-04-06 09:45:00 | AAPL | Stock | 2.465 | 2.4768 | 2.4564 | 2.4768 | 62162800.0 |
> showing 50 of 224,098 rows — these rows as CSV