PREVIEW / stock_5min / 2006-05-12
file: by_date/stock_5min/2006/2006-05-12.parquet size: 3.2 MB rows: 230,925 symbols: 2,263
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-05-12 05:40:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4268 | 2.4268 | 186200.0 |
| 2006-05-12 07:20:00 | AAPL | Stock | 2.4289 | 2.4289 | 2.4236 | 2.4236 | 5600.0 |
| 2006-05-12 07:40:00 | AAPL | Stock | 2.425 | 2.425 | 2.425 | 2.425 | 14000.0 |
| 2006-05-12 08:00:00 | AAPL | Stock | 2.4182 | 2.4286 | 2.4182 | 2.4214 | 247800.0 |
| 2006-05-12 08:05:00 | AAPL | Stock | 2.4214 | 2.4229 | 2.4207 | 2.4207 | 113400.0 |
| 2006-05-12 08:10:00 | AAPL | Stock | 2.4207 | 2.4229 | 2.4182 | 2.4196 | 197400.0 |
| 2006-05-12 08:15:00 | AAPL | Stock | 2.4196 | 2.42 | 2.4193 | 2.42 | 64400.0 |
| 2006-05-12 08:25:00 | AAPL | Stock | 2.4193 | 2.4229 | 2.4193 | 2.4229 | 79296.0 |
| 2006-05-12 08:30:00 | AAPL | Stock | 2.425 | 2.4257 | 2.4218 | 2.4232 | 50400.0 |
| 2006-05-12 08:35:00 | AAPL | Stock | 2.4214 | 2.425 | 2.42 | 2.425 | 114464.0 |
| 2006-05-12 08:40:00 | AAPL | Stock | 2.4257 | 2.4289 | 2.4257 | 2.4271 | 158200.0 |
| 2006-05-12 08:45:00 | AAPL | Stock | 2.4271 | 2.4275 | 2.4257 | 2.4257 | 65800.0 |
| 2006-05-12 08:50:00 | AAPL | Stock | 2.4271 | 2.4282 | 2.4264 | 2.4282 | 91140.0 |
| 2006-05-12 08:55:00 | AAPL | Stock | 2.4282 | 2.4304 | 2.4257 | 2.4257 | 173628.0 |
| 2006-05-12 09:00:00 | AAPL | Stock | 2.4257 | 2.4257 | 2.4221 | 2.425 | 30828.0 |
| 2006-05-12 09:05:00 | AAPL | Stock | 2.425 | 2.4257 | 2.4211 | 2.4211 | 129668.0 |
| 2006-05-12 09:10:00 | AAPL | Stock | 2.4211 | 2.425 | 2.4211 | 2.4214 | 276668.0 |
| 2006-05-12 09:15:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4214 | 2.4214 | 30800.0 |
| 2006-05-12 09:20:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 70000.0 |
| 2006-05-12 09:25:00 | AAPL | Stock | 2.4225 | 2.4246 | 2.4164 | 2.4186 | 260400.0 |
| 2006-05-12 09:30:00 | AAPL | Stock | 2.4232 | 2.4257 | 2.3879 | 2.4075 | 25369428.0 |
| 2006-05-12 09:35:00 | AAPL | Stock | 2.4082 | 2.4168 | 2.3968 | 2.4168 | 12981836.0 |
| 2006-05-12 09:40:00 | AAPL | Stock | 2.4168 | 2.4179 | 2.3964 | 2.4028 | 20134940.0 |
| 2006-05-12 09:45:00 | AAPL | Stock | 2.4032 | 2.4186 | 2.3968 | 2.4168 | 18362344.0 |
| 2006-05-12 09:50:00 | AAPL | Stock | 2.4168 | 2.4171 | 2.4018 | 2.4068 | 12953248.0 |
| 2006-05-12 09:55:00 | AAPL | Stock | 2.4071 | 2.4321 | 2.4064 | 2.4293 | 23966516.0 |
| 2006-05-12 10:00:00 | AAPL | Stock | 2.4296 | 2.4321 | 2.4139 | 2.4171 | 16548364.0 |
| 2006-05-12 10:05:00 | AAPL | Stock | 2.4161 | 2.4189 | 2.4086 | 2.4096 | 13170948.0 |
| 2006-05-12 10:10:00 | AAPL | Stock | 2.41 | 2.4411 | 2.4089 | 2.4357 | 15061284.0 |
| 2006-05-12 10:15:00 | AAPL | Stock | 2.4357 | 2.4375 | 2.4225 | 2.43 | 10189284.0 |
| 2006-05-12 10:20:00 | AAPL | Stock | 2.43 | 2.4318 | 2.4214 | 2.4225 | 8352596.0 |
| 2006-05-12 10:25:00 | AAPL | Stock | 2.4225 | 2.4257 | 2.4146 | 2.4189 | 7352436.0 |
| 2006-05-12 10:30:00 | AAPL | Stock | 2.4182 | 2.4204 | 2.4118 | 2.4168 | 7220948.0 |
| 2006-05-12 10:35:00 | AAPL | Stock | 2.4161 | 2.4189 | 2.4111 | 2.4189 | 7027496.0 |
| 2006-05-12 10:40:00 | AAPL | Stock | 2.4189 | 2.4207 | 2.4096 | 2.4096 | 6989192.0 |
| 2006-05-12 10:45:00 | AAPL | Stock | 2.4101 | 2.4107 | 2.4043 | 2.4079 | 6565860.0 |
| 2006-05-12 10:50:00 | AAPL | Stock | 2.4082 | 2.4089 | 2.4 | 2.4086 | 9703680.0 |
| 2006-05-12 10:55:00 | AAPL | Stock | 2.4089 | 2.4143 | 2.4061 | 2.4111 | 7041524.0 |
| 2006-05-12 11:00:00 | AAPL | Stock | 2.4104 | 2.4204 | 2.4086 | 2.4161 | 7752472.0 |
| 2006-05-12 11:05:00 | AAPL | Stock | 2.4161 | 2.4232 | 2.4129 | 2.4225 | 6978132.0 |
| 2006-05-12 11:10:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4107 | 2.4123 | 6372240.0 |
| 2006-05-12 11:15:00 | AAPL | Stock | 2.4129 | 2.4179 | 2.4107 | 2.4168 | 3648008.0 |
| 2006-05-12 11:20:00 | AAPL | Stock | 2.4168 | 2.4261 | 2.4161 | 2.421 | 8158444.0 |
| 2006-05-12 11:25:00 | AAPL | Stock | 2.4207 | 2.4243 | 2.4164 | 2.4239 | 6035820.0 |
| 2006-05-12 11:30:00 | AAPL | Stock | 2.4239 | 2.4293 | 2.4196 | 2.4264 | 6202168.0 |
| 2006-05-12 11:35:00 | AAPL | Stock | 2.4268 | 2.4268 | 2.4221 | 2.4239 | 5486824.0 |
| 2006-05-12 11:40:00 | AAPL | Stock | 2.4239 | 2.4246 | 2.4136 | 2.4193 | 7033124.0 |
| 2006-05-12 11:45:00 | AAPL | Stock | 2.4187 | 2.4232 | 2.4136 | 2.4182 | 5147436.0 |
| 2006-05-12 11:50:00 | AAPL | Stock | 2.4175 | 2.4211 | 2.415 | 2.4204 | 2508296.0 |
| 2006-05-12 11:55:00 | AAPL | Stock | 2.42 | 2.4304 | 2.42 | 2.4246 | 7265272.0 |
> showing 50 of 230,925 rows — these rows as CSV