PREVIEW / stock_5min / 2006-04-27
file: by_date/stock_5min/2006/2006-04-27.parquet size: 3.1 MB rows: 223,164 symbols: 2,237
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-27 07:40:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4196 | 2.4196 | 2800.0 |
| 2006-04-27 07:45:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4143 | 2.4143 | 11200.0 |
| 2006-04-27 08:00:00 | AAPL | Stock | 2.4136 | 2.4196 | 2.4125 | 2.4196 | 139328.0 |
| 2006-04-27 08:05:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4196 | 2.4196 | 50540.0 |
| 2006-04-27 08:10:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.4132 | 2.4171 | 184800.0 |
| 2006-04-27 08:15:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4132 | 2.4132 | 51660.0 |
| 2006-04-27 08:20:00 | AAPL | Stock | 2.4164 | 2.4182 | 2.4164 | 2.4171 | 53900.0 |
| 2006-04-27 08:25:00 | AAPL | Stock | 2.4161 | 2.4179 | 2.4161 | 2.4168 | 109760.0 |
| 2006-04-27 08:30:00 | AAPL | Stock | 2.4175 | 2.4204 | 2.4175 | 2.4204 | 128016.0 |
| 2006-04-27 08:35:00 | AAPL | Stock | 2.4207 | 2.4211 | 2.4171 | 2.4171 | 387464.0 |
| 2006-04-27 08:40:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4168 | 2.4179 | 173628.0 |
| 2006-04-27 08:45:00 | AAPL | Stock | 2.4179 | 2.4193 | 2.4171 | 2.4179 | 121184.0 |
| 2006-04-27 08:50:00 | AAPL | Stock | 2.4179 | 2.4179 | 2.4164 | 2.4168 | 251440.0 |
| 2006-04-27 08:55:00 | AAPL | Stock | 2.415 | 2.415 | 2.415 | 2.415 | 33600.0 |
| 2006-04-27 09:00:00 | AAPL | Stock | 2.4168 | 2.4168 | 2.4168 | 2.4168 | 5600.0 |
| 2006-04-27 09:05:00 | AAPL | Stock | 2.4179 | 2.4179 | 2.4168 | 2.4168 | 262220.0 |
| 2006-04-27 09:10:00 | AAPL | Stock | 2.4168 | 2.4179 | 2.4168 | 2.4179 | 126000.0 |
| 2006-04-27 09:15:00 | AAPL | Stock | 2.4179 | 2.4179 | 2.4161 | 2.4179 | 92120.0 |
| 2006-04-27 09:20:00 | AAPL | Stock | 2.4179 | 2.4179 | 2.4161 | 2.4179 | 106400.0 |
| 2006-04-27 09:25:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.4146 | 2.4196 | 453096.0 |
| 2006-04-27 09:30:00 | AAPL | Stock | 2.4189 | 2.4325 | 2.4125 | 2.4325 | 25350444.0 |
| 2006-04-27 09:35:00 | AAPL | Stock | 2.4325 | 2.4339 | 2.4111 | 2.4154 | 17248784.0 |
| 2006-04-27 09:40:00 | AAPL | Stock | 2.4157 | 2.42 | 2.4107 | 2.4186 | 14187712.0 |
| 2006-04-27 09:45:00 | AAPL | Stock | 2.4182 | 2.4211 | 2.4146 | 2.4186 | 12508832.0 |
| 2006-04-27 09:50:00 | AAPL | Stock | 2.4189 | 2.4189 | 2.4054 | 2.4129 | 20713196.0 |
| 2006-04-27 09:55:00 | AAPL | Stock | 2.4121 | 2.4246 | 2.4096 | 2.4236 | 11100824.0 |
| 2006-04-27 10:00:00 | AAPL | Stock | 2.4232 | 2.4371 | 2.4221 | 2.4257 | 28709436.0 |
| 2006-04-27 10:05:00 | AAPL | Stock | 2.425 | 2.4339 | 2.4179 | 2.4296 | 16285696.0 |
| 2006-04-27 10:10:00 | AAPL | Stock | 2.43 | 2.4471 | 2.4286 | 2.4432 | 25686556.0 |
| 2006-04-27 10:15:00 | AAPL | Stock | 2.4432 | 2.4446 | 2.4357 | 2.4386 | 15640128.0 |
| 2006-04-27 10:20:00 | AAPL | Stock | 2.4389 | 2.4414 | 2.4336 | 2.4411 | 12460756.0 |
| 2006-04-27 10:25:00 | AAPL | Stock | 2.4414 | 2.4475 | 2.4407 | 2.4436 | 12316444.0 |
| 2006-04-27 10:30:00 | AAPL | Stock | 2.4436 | 2.4514 | 2.4418 | 2.4457 | 12263188.0 |
| 2006-04-27 10:35:00 | AAPL | Stock | 2.4457 | 2.4461 | 2.4389 | 2.4389 | 10608864.0 |
| 2006-04-27 10:40:00 | AAPL | Stock | 2.4386 | 2.44 | 2.4246 | 2.4246 | 15138228.0 |
| 2006-04-27 10:45:00 | AAPL | Stock | 2.425 | 2.4336 | 2.4243 | 2.4336 | 11148844.0 |
| 2006-04-27 10:50:00 | AAPL | Stock | 2.4336 | 2.4436 | 2.4329 | 2.4418 | 12254480.0 |
| 2006-04-27 10:55:00 | AAPL | Stock | 2.4418 | 2.4443 | 2.4357 | 2.4421 | 6614188.0 |
| 2006-04-27 11:00:00 | AAPL | Stock | 2.4421 | 2.4461 | 2.4357 | 2.4421 | 9359952.0 |
| 2006-04-27 11:05:00 | AAPL | Stock | 2.4421 | 2.4443 | 2.4382 | 2.4418 | 7472416.0 |
| 2006-04-27 11:10:00 | AAPL | Stock | 2.4418 | 2.4493 | 2.4393 | 2.4493 | 9433284.0 |
| 2006-04-27 11:15:00 | AAPL | Stock | 2.4493 | 2.4593 | 2.4446 | 2.455 | 15836884.0 |
| 2006-04-27 11:20:00 | AAPL | Stock | 2.455 | 2.4739 | 2.4543 | 2.4718 | 24520496.0 |
| 2006-04-27 11:25:00 | AAPL | Stock | 2.4718 | 2.4782 | 2.4679 | 2.4743 | 21562212.0 |
| 2006-04-27 11:30:00 | AAPL | Stock | 2.4746 | 2.4761 | 2.4707 | 2.4729 | 9535904.0 |
| 2006-04-27 11:35:00 | AAPL | Stock | 2.4731 | 2.4746 | 2.4661 | 2.4679 | 10268804.0 |
| 2006-04-27 11:40:00 | AAPL | Stock | 2.4682 | 2.4739 | 2.4359 | 2.4696 | 9445380.0 |
| 2006-04-27 11:45:00 | AAPL | Stock | 2.47 | 2.4732 | 2.4668 | 2.4725 | 5988052.0 |
| 2006-04-27 11:50:00 | AAPL | Stock | 2.4725 | 2.4771 | 2.4689 | 2.4746 | 7814100.0 |
| 2006-04-27 11:55:00 | AAPL | Stock | 2.4746 | 2.4779 | 2.4679 | 2.4714 | 6627180.0 |
> showing 50 of 223,164 rows — these rows as CSV