PREVIEW / stock_5min / 2006-08-24
file: by_date/stock_5min/2006/2006-08-24.parquet size: 3.0 MB rows: 221,730 symbols: 2,321
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-08-24 04:05:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 6440.0 |
| 2006-08-24 08:00:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4089 | 2.4107 | 133840.0 |
| 2006-08-24 08:05:00 | AAPL | Stock | 2.4146 | 2.4193 | 2.4107 | 2.4143 | 193340.0 |
| 2006-08-24 08:10:00 | AAPL | Stock | 2.415 | 2.4179 | 2.4143 | 2.4143 | 280840.0 |
| 2006-08-24 08:15:00 | AAPL | Stock | 2.4143 | 2.4157 | 2.4143 | 2.4157 | 19600.0 |
| 2006-08-24 08:20:00 | AAPL | Stock | 2.4164 | 2.4182 | 2.4164 | 2.4182 | 178220.0 |
| 2006-08-24 08:25:00 | AAPL | Stock | 2.4186 | 2.4186 | 2.4143 | 2.4143 | 59780.0 |
| 2006-08-24 08:30:00 | AAPL | Stock | 2.4143 | 2.415 | 2.4143 | 2.4143 | 83020.0 |
| 2006-08-24 08:35:00 | AAPL | Stock | 2.4171 | 2.4179 | 2.4146 | 2.4146 | 51240.0 |
| 2006-08-24 08:40:00 | AAPL | Stock | 2.4157 | 2.4157 | 2.4111 | 2.4125 | 111160.0 |
| 2006-08-24 08:45:00 | AAPL | Stock | 2.4143 | 2.4189 | 2.4143 | 2.4189 | 89040.0 |
| 2006-08-24 08:50:00 | AAPL | Stock | 2.4186 | 2.4186 | 2.4186 | 2.4186 | 70000.0 |
| 2006-08-24 08:55:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4179 | 2.4179 | 22820.0 |
| 2006-08-24 09:00:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.4179 | 2.4196 | 43120.0 |
| 2006-08-24 09:05:00 | AAPL | Stock | 2.42 | 2.425 | 2.4196 | 2.425 | 142240.0 |
| 2006-08-24 09:10:00 | AAPL | Stock | 2.425 | 2.4254 | 2.4207 | 2.4207 | 278040.0 |
| 2006-08-24 09:15:00 | AAPL | Stock | 2.4229 | 2.4236 | 2.4214 | 2.4214 | 147000.0 |
| 2006-08-24 09:20:00 | AAPL | Stock | 2.4236 | 2.4257 | 2.4232 | 2.425 | 243600.0 |
| 2006-08-24 09:25:00 | AAPL | Stock | 2.4246 | 2.4264 | 2.4221 | 2.4257 | 150752.0 |
| 2006-08-24 09:30:00 | AAPL | Stock | 2.4246 | 2.4304 | 2.4143 | 2.4179 | 18070080.0 |
| 2006-08-24 09:35:00 | AAPL | Stock | 2.4171 | 2.4246 | 2.4146 | 2.4164 | 7245560.0 |
| 2006-08-24 09:40:00 | AAPL | Stock | 2.4161 | 2.4175 | 2.4114 | 2.4158 | 5845560.0 |
| 2006-08-24 09:45:00 | AAPL | Stock | 2.4157 | 2.425 | 2.415 | 2.4232 | 7924224.0 |
| 2006-08-24 09:50:00 | AAPL | Stock | 2.4232 | 2.4236 | 2.4182 | 2.4214 | 7026376.0 |
| 2006-08-24 09:55:00 | AAPL | Stock | 2.4211 | 2.4221 | 2.4186 | 2.4207 | 3035480.0 |
| 2006-08-24 10:00:00 | AAPL | Stock | 2.4204 | 2.4207 | 2.4129 | 2.4154 | 9619764.0 |
| 2006-08-24 10:05:00 | AAPL | Stock | 2.4157 | 2.425 | 2.4146 | 2.4229 | 9278024.0 |
| 2006-08-24 10:10:00 | AAPL | Stock | 2.4229 | 2.4318 | 2.4211 | 2.4289 | 15828680.0 |
| 2006-08-24 10:15:00 | AAPL | Stock | 2.4293 | 2.4354 | 2.4286 | 2.4311 | 15019760.0 |
| 2006-08-24 10:20:00 | AAPL | Stock | 2.4311 | 2.4325 | 2.4264 | 2.43 | 6791596.0 |
| 2006-08-24 10:25:00 | AAPL | Stock | 2.4304 | 2.4321 | 2.4254 | 2.4271 | 8148056.0 |
| 2006-08-24 10:30:00 | AAPL | Stock | 2.4271 | 2.4275 | 2.4207 | 2.4214 | 10532144.0 |
| 2006-08-24 10:35:00 | AAPL | Stock | 2.4215 | 2.4218 | 2.4182 | 2.4193 | 7114716.0 |
| 2006-08-24 10:40:00 | AAPL | Stock | 2.4189 | 2.4189 | 2.4136 | 2.4146 | 8843128.0 |
| 2006-08-24 10:45:00 | AAPL | Stock | 2.415 | 2.4196 | 2.4129 | 2.4168 | 5734960.0 |
| 2006-08-24 10:50:00 | AAPL | Stock | 2.4168 | 2.4221 | 2.4168 | 2.4214 | 4010580.0 |
| 2006-08-24 10:55:00 | AAPL | Stock | 2.4214 | 2.4229 | 2.4196 | 2.4211 | 3782632.0 |
| 2006-08-24 11:00:00 | AAPL | Stock | 2.4211 | 2.4221 | 2.4168 | 2.4193 | 4106816.0 |
| 2006-08-24 11:05:00 | AAPL | Stock | 2.4193 | 2.4243 | 2.4189 | 2.4211 | 4727464.0 |
| 2006-08-24 11:10:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4179 | 2.4179 | 2150204.0 |
| 2006-08-24 11:15:00 | AAPL | Stock | 2.4179 | 2.4204 | 2.4168 | 2.4175 | 2174592.0 |
| 2006-08-24 11:20:00 | AAPL | Stock | 2.4179 | 2.4182 | 2.4154 | 2.4161 | 4810708.0 |
| 2006-08-24 11:25:00 | AAPL | Stock | 2.4161 | 2.4196 | 2.415 | 2.415 | 3476872.0 |
| 2006-08-24 11:30:00 | AAPL | Stock | 2.4146 | 2.4175 | 2.4114 | 2.4129 | 5573008.0 |
| 2006-08-24 11:35:00 | AAPL | Stock | 2.4129 | 2.4139 | 2.4086 | 2.4125 | 7104636.0 |
| 2006-08-24 11:40:00 | AAPL | Stock | 2.4129 | 2.4168 | 2.4111 | 2.4132 | 3403484.0 |
| 2006-08-24 11:45:00 | AAPL | Stock | 2.4129 | 2.4136 | 2.4064 | 2.4089 | 7018228.0 |
| 2006-08-24 11:50:00 | AAPL | Stock | 2.4089 | 2.4093 | 2.4043 | 2.4082 | 4204844.0 |
| 2006-08-24 11:55:00 | AAPL | Stock | 2.4086 | 2.4086 | 2.4018 | 2.4036 | 3677996.0 |
| 2006-08-24 12:00:00 | AAPL | Stock | 2.4036 | 2.4042 | 2.3971 | 2.3982 | 7089544.0 |
> showing 50 of 221,730 rows — these rows as CSV