PREVIEW / stock_5min / 2002-05-13
file: by_date/stock_5min/2002/2002-05-13.parquet size: 1.8 MB rows: 123,496 symbols: 1,416
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-13 09:15:00 | AAPL | Stock | 0.4196 | 0.4205 | 0.4195 | 0.4205 | 44800.0 |
| 2002-05-13 09:25:00 | AAPL | Stock | 0.4198 | 0.4198 | 0.4195 | 0.4195 | 39200.0 |
| 2002-05-13 09:30:00 | AAPL | Stock | 0.42 | 0.42 | 0.417 | 0.417 | 5146400.0 |
| 2002-05-13 09:35:00 | AAPL | Stock | 0.4175 | 0.4177 | 0.4125 | 0.4127 | 4295200.0 |
| 2002-05-13 09:40:00 | AAPL | Stock | 0.4127 | 0.4138 | 0.4118 | 0.4136 | 3824800.0 |
| 2002-05-13 09:45:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4096 | 0.4098 | 6966400.0 |
| 2002-05-13 09:50:00 | AAPL | Stock | 0.4107 | 0.4129 | 0.4102 | 0.4116 | 5073600.0 |
| 2002-05-13 09:55:00 | AAPL | Stock | 0.4116 | 0.4129 | 0.4111 | 0.4121 | 3533600.0 |
| 2002-05-13 10:00:00 | AAPL | Stock | 0.4123 | 0.4143 | 0.4121 | 0.414 | 3640000.0 |
| 2002-05-13 10:05:00 | AAPL | Stock | 0.4139 | 0.4143 | 0.4134 | 0.4138 | 2469600.0 |
| 2002-05-13 10:10:00 | AAPL | Stock | 0.4136 | 0.4161 | 0.4136 | 0.4159 | 3981600.0 |
| 2002-05-13 10:15:00 | AAPL | Stock | 0.4159 | 0.4197 | 0.4157 | 0.4196 | 7873600.0 |
| 2002-05-13 10:20:00 | AAPL | Stock | 0.4195 | 0.4196 | 0.4179 | 0.4188 | 5964000.0 |
| 2002-05-13 10:25:00 | AAPL | Stock | 0.4188 | 0.4209 | 0.4182 | 0.4209 | 2984800.0 |
| 2002-05-13 10:30:00 | AAPL | Stock | 0.4211 | 0.4232 | 0.4211 | 0.4223 | 5051200.0 |
| 2002-05-13 10:35:00 | AAPL | Stock | 0.4221 | 0.4232 | 0.4209 | 0.423 | 10399200.0 |
| 2002-05-13 10:40:00 | AAPL | Stock | 0.422 | 0.425 | 0.422 | 0.4236 | 5415200.0 |
| 2002-05-13 10:45:00 | AAPL | Stock | 0.4238 | 0.4248 | 0.4229 | 0.423 | 2374400.0 |
| 2002-05-13 10:50:00 | AAPL | Stock | 0.4234 | 0.4239 | 0.4221 | 0.4239 | 10791200.0 |
| 2002-05-13 10:55:00 | AAPL | Stock | 0.4239 | 0.4254 | 0.4229 | 0.423 | 2755200.0 |
| 2002-05-13 11:00:00 | AAPL | Stock | 0.423 | 0.4238 | 0.4223 | 0.4234 | 1629600.0 |
| 2002-05-13 11:05:00 | AAPL | Stock | 0.4235 | 0.4236 | 0.4225 | 0.4236 | 3152800.0 |
| 2002-05-13 11:10:00 | AAPL | Stock | 0.4236 | 0.4236 | 0.423 | 0.4232 | 728000.0 |
| 2002-05-13 11:15:00 | AAPL | Stock | 0.4234 | 0.4241 | 0.4234 | 0.4236 | 308000.0 |
| 2002-05-13 11:20:00 | AAPL | Stock | 0.4236 | 0.4282 | 0.4234 | 0.4268 | 5202400.0 |
| 2002-05-13 11:25:00 | AAPL | Stock | 0.4268 | 0.4277 | 0.425 | 0.4277 | 4261600.0 |
| 2002-05-13 11:30:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4259 | 0.4263 | 1601600.0 |
| 2002-05-13 11:35:00 | AAPL | Stock | 0.4263 | 0.4273 | 0.4259 | 0.4273 | 4317600.0 |
| 2002-05-13 11:40:00 | AAPL | Stock | 0.427 | 0.4271 | 0.4259 | 0.4268 | 2111200.0 |
| 2002-05-13 11:45:00 | AAPL | Stock | 0.4268 | 0.4273 | 0.4264 | 0.4273 | 1853600.0 |
| 2002-05-13 11:50:00 | AAPL | Stock | 0.4275 | 0.4284 | 0.4257 | 0.4257 | 9245600.0 |
| 2002-05-13 11:55:00 | AAPL | Stock | 0.4261 | 0.4264 | 0.4254 | 0.4263 | 1864800.0 |
| 2002-05-13 12:00:00 | AAPL | Stock | 0.4261 | 0.4261 | 0.4245 | 0.4259 | 3483200.0 |
| 2002-05-13 12:05:00 | AAPL | Stock | 0.4261 | 0.4261 | 0.4246 | 0.4252 | 812000.0 |
| 2002-05-13 12:10:00 | AAPL | Stock | 0.4248 | 0.4255 | 0.4245 | 0.4248 | 2284800.0 |
| 2002-05-13 12:15:00 | AAPL | Stock | 0.4248 | 0.4259 | 0.4232 | 0.4243 | 3998400.0 |
| 2002-05-13 12:20:00 | AAPL | Stock | 0.4238 | 0.4248 | 0.4234 | 0.4248 | 2206400.0 |
| 2002-05-13 12:25:00 | AAPL | Stock | 0.4246 | 0.4248 | 0.4243 | 0.4245 | 1360800.0 |
| 2002-05-13 12:30:00 | AAPL | Stock | 0.4248 | 0.4257 | 0.4241 | 0.4252 | 2447200.0 |
| 2002-05-13 12:35:00 | AAPL | Stock | 0.4257 | 0.4261 | 0.425 | 0.4252 | 1495200.0 |
| 2002-05-13 12:40:00 | AAPL | Stock | 0.425 | 0.4254 | 0.4236 | 0.4236 | 1724800.0 |
| 2002-05-13 12:45:00 | AAPL | Stock | 0.4234 | 0.4234 | 0.4209 | 0.4218 | 3354400.0 |
| 2002-05-13 12:50:00 | AAPL | Stock | 0.422 | 0.4232 | 0.4214 | 0.4228 | 1344000.0 |
| 2002-05-13 12:55:00 | AAPL | Stock | 0.4227 | 0.4257 | 0.4227 | 0.4257 | 1719200.0 |
| 2002-05-13 13:00:00 | AAPL | Stock | 0.4257 | 0.4257 | 0.4243 | 0.4248 | 1198400.0 |
| 2002-05-13 13:05:00 | AAPL | Stock | 0.4248 | 0.4264 | 0.4245 | 0.4254 | 2240000.0 |
| 2002-05-13 13:10:00 | AAPL | Stock | 0.4257 | 0.4264 | 0.4255 | 0.4264 | 1041600.0 |
| 2002-05-13 13:15:00 | AAPL | Stock | 0.4265 | 0.4277 | 0.4257 | 0.4277 | 2828000.0 |
| 2002-05-13 13:20:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4259 | 0.4259 | 1478400.0 |
| 2002-05-13 13:25:00 | AAPL | Stock | 0.4259 | 0.4275 | 0.4254 | 0.4268 | 1584800.0 |
> showing 50 of 123,496 rows — these rows as CSV