PREVIEW / stock_5min / 2006-04-11
file: by_date/stock_5min/2006/2006-04-11.parquet size: 3.1 MB rows: 224,063 symbols: 2,226
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-11 07:55:00 | AAPL | Stock | 2.4421 | 2.4421 | 2.4421 | 2.4421 | 19600.0 |
| 2006-04-11 08:00:00 | AAPL | Stock | 2.4421 | 2.4429 | 2.4393 | 2.4393 | 151200.0 |
| 2006-04-11 08:05:00 | AAPL | Stock | 2.4421 | 2.4421 | 2.4393 | 2.4393 | 176568.0 |
| 2006-04-11 08:10:00 | AAPL | Stock | 2.4393 | 2.4421 | 2.4393 | 2.4396 | 46200.0 |
| 2006-04-11 08:15:00 | AAPL | Stock | 2.4446 | 2.4457 | 2.4421 | 2.4446 | 57820.0 |
| 2006-04-11 08:20:00 | AAPL | Stock | 2.4411 | 2.4443 | 2.4411 | 2.4443 | 237496.0 |
| 2006-04-11 08:25:00 | AAPL | Stock | 2.4429 | 2.4446 | 2.4429 | 2.4446 | 148120.0 |
| 2006-04-11 08:30:00 | AAPL | Stock | 2.4446 | 2.4618 | 2.4446 | 2.4586 | 1079960.0 |
| 2006-04-11 08:35:00 | AAPL | Stock | 2.4571 | 2.4679 | 2.4571 | 2.4679 | 723716.0 |
| 2006-04-11 08:40:00 | AAPL | Stock | 2.4668 | 2.4704 | 2.4664 | 2.47 | 1288448.0 |
| 2006-04-11 08:45:00 | AAPL | Stock | 2.4696 | 2.4707 | 2.4632 | 2.4639 | 639576.0 |
| 2006-04-11 08:50:00 | AAPL | Stock | 2.4639 | 2.4693 | 2.4639 | 2.4657 | 437920.0 |
| 2006-04-11 08:55:00 | AAPL | Stock | 2.4657 | 2.4693 | 2.4643 | 2.4693 | 620256.0 |
| 2006-04-11 09:00:00 | AAPL | Stock | 2.4689 | 2.4696 | 2.4661 | 2.4664 | 447160.0 |
| 2006-04-11 09:05:00 | AAPL | Stock | 2.4679 | 2.4686 | 2.4664 | 2.4686 | 759164.0 |
| 2006-04-11 09:10:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4643 | 2.4654 | 278600.0 |
| 2006-04-11 09:15:00 | AAPL | Stock | 2.4664 | 2.4671 | 2.4664 | 2.4671 | 5600.0 |
| 2006-04-11 09:20:00 | AAPL | Stock | 2.4675 | 2.4675 | 2.4607 | 2.4629 | 335300.0 |
| 2006-04-11 09:25:00 | AAPL | Stock | 2.4636 | 2.4675 | 2.4614 | 2.4654 | 302232.0 |
| 2006-04-11 09:30:00 | AAPL | Stock | 2.4639 | 2.475 | 2.4496 | 2.4689 | 26819212.0 |
| 2006-04-11 09:35:00 | AAPL | Stock | 2.4689 | 2.4696 | 2.4568 | 2.4581 | 21679840.0 |
| 2006-04-11 09:40:00 | AAPL | Stock | 2.4586 | 2.4686 | 2.4586 | 2.46 | 17855180.0 |
| 2006-04-11 09:45:00 | AAPL | Stock | 2.4596 | 2.46 | 2.4464 | 2.4468 | 22522192.0 |
| 2006-04-11 09:50:00 | AAPL | Stock | 2.4471 | 2.4489 | 2.425 | 2.4318 | 47639116.0 |
| 2006-04-11 09:55:00 | AAPL | Stock | 2.4325 | 2.4432 | 2.4289 | 2.4314 | 27535480.0 |
| 2006-04-11 10:00:00 | AAPL | Stock | 2.4311 | 2.4354 | 2.4196 | 2.4229 | 30402568.0 |
| 2006-04-11 10:05:00 | AAPL | Stock | 2.4229 | 2.43 | 2.42 | 2.4264 | 19642252.0 |
| 2006-04-11 10:10:00 | AAPL | Stock | 2.4264 | 2.4286 | 2.4154 | 2.4179 | 19344696.0 |
| 2006-04-11 10:15:00 | AAPL | Stock | 2.4175 | 2.4186 | 2.4061 | 2.4107 | 26270272.0 |
| 2006-04-11 10:20:00 | AAPL | Stock | 2.4104 | 2.4107 | 2.3954 | 2.4018 | 38364004.0 |
| 2006-04-11 10:25:00 | AAPL | Stock | 2.4018 | 2.4096 | 2.3979 | 2.4061 | 24343004.0 |
| 2006-04-11 10:30:00 | AAPL | Stock | 2.4057 | 2.4096 | 2.3993 | 2.4071 | 18419492.0 |
| 2006-04-11 10:35:00 | AAPL | Stock | 2.4075 | 2.4136 | 2.4043 | 2.4086 | 14040824.0 |
| 2006-04-11 10:40:00 | AAPL | Stock | 2.4086 | 2.4125 | 2.4025 | 2.4096 | 14649068.0 |
| 2006-04-11 10:45:00 | AAPL | Stock | 2.4096 | 2.4125 | 2.4007 | 2.4089 | 16928128.0 |
| 2006-04-11 10:50:00 | AAPL | Stock | 2.4089 | 2.4239 | 2.4061 | 2.4239 | 23648044.0 |
| 2006-04-11 10:55:00 | AAPL | Stock | 2.4239 | 2.425 | 2.4179 | 2.425 | 13058864.0 |
| 2006-04-11 11:00:00 | AAPL | Stock | 2.4254 | 2.4279 | 2.4168 | 2.4209 | 13084596.0 |
| 2006-04-11 11:05:00 | AAPL | Stock | 2.4211 | 2.4243 | 2.4193 | 2.4211 | 8839096.0 |
| 2006-04-11 11:10:00 | AAPL | Stock | 2.4214 | 2.4232 | 2.4154 | 2.4207 | 9112712.0 |
| 2006-04-11 11:15:00 | AAPL | Stock | 2.4204 | 2.4279 | 2.4161 | 2.4267 | 11574080.0 |
| 2006-04-11 11:20:00 | AAPL | Stock | 2.4268 | 2.4361 | 2.4254 | 2.4329 | 19690328.0 |
| 2006-04-11 11:25:00 | AAPL | Stock | 2.4325 | 2.4357 | 2.4157 | 2.4196 | 17380608.0 |
| 2006-04-11 11:30:00 | AAPL | Stock | 2.42 | 2.4261 | 2.4164 | 2.4229 | 9518936.0 |
| 2006-04-11 11:35:00 | AAPL | Stock | 2.4232 | 2.4296 | 2.4229 | 2.4257 | 6227396.0 |
| 2006-04-11 11:40:00 | AAPL | Stock | 2.4257 | 2.4271 | 2.4211 | 2.4225 | 6047636.0 |
| 2006-04-11 11:45:00 | AAPL | Stock | 2.4221 | 2.4254 | 2.4146 | 2.4171 | 6209588.0 |
| 2006-04-11 11:50:00 | AAPL | Stock | 2.4175 | 2.4218 | 2.4154 | 2.4168 | 4229148.0 |
| 2006-04-11 11:55:00 | AAPL | Stock | 2.4164 | 2.4175 | 2.4129 | 2.4164 | 5186356.0 |
| 2006-04-11 12:00:00 | AAPL | Stock | 2.4168 | 2.4168 | 2.4104 | 2.4118 | 5741652.0 |
> showing 50 of 224,063 rows — these rows as CSV