PREVIEW / stock_5min / 2002-03-07
file: by_date/stock_5min/2002/2002-03-07.parquet size: 1.7 MB rows: 119,449 symbols: 1,396
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-03-07 08:00:00 | AAPL | Stock | 0.4299 | 0.4299 | 0.4299 | 0.4299 | 3416000.0 |
| 2002-03-07 08:30:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 5600.0 |
| 2002-03-07 09:05:00 | AAPL | Stock | 0.4309 | 0.4309 | 0.4309 | 0.4309 | 56000.0 |
| 2002-03-07 09:10:00 | AAPL | Stock | 0.4309 | 0.4309 | 0.4309 | 0.4309 | 11200.0 |
| 2002-03-07 09:15:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 5600.0 |
| 2002-03-07 09:20:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4302 | 0.4302 | 95200.0 |
| 2002-03-07 09:30:00 | AAPL | Stock | 0.4296 | 0.4298 | 0.4277 | 0.4289 | 7548800.0 |
| 2002-03-07 09:35:00 | AAPL | Stock | 0.4293 | 0.4295 | 0.428 | 0.4282 | 5409600.0 |
| 2002-03-07 09:40:00 | AAPL | Stock | 0.4291 | 0.4321 | 0.4291 | 0.4311 | 3046400.0 |
| 2002-03-07 09:45:00 | AAPL | Stock | 0.4311 | 0.4316 | 0.4286 | 0.4286 | 3920000.0 |
| 2002-03-07 09:50:00 | AAPL | Stock | 0.4284 | 0.4286 | 0.4252 | 0.4257 | 2839200.0 |
| 2002-03-07 09:55:00 | AAPL | Stock | 0.4256 | 0.4259 | 0.4223 | 0.4232 | 4020800.0 |
| 2002-03-07 10:00:00 | AAPL | Stock | 0.4229 | 0.4257 | 0.4223 | 0.4238 | 4424000.0 |
| 2002-03-07 10:05:00 | AAPL | Stock | 0.4238 | 0.4277 | 0.4234 | 0.4234 | 3880800.0 |
| 2002-03-07 10:10:00 | AAPL | Stock | 0.4234 | 0.4243 | 0.4216 | 0.4229 | 2884000.0 |
| 2002-03-07 10:15:00 | AAPL | Stock | 0.4232 | 0.4234 | 0.4227 | 0.4234 | 3763200.0 |
| 2002-03-07 10:20:00 | AAPL | Stock | 0.4229 | 0.4239 | 0.4221 | 0.4232 | 3455200.0 |
| 2002-03-07 10:25:00 | AAPL | Stock | 0.4238 | 0.4254 | 0.423 | 0.4254 | 2284800.0 |
| 2002-03-07 10:30:00 | AAPL | Stock | 0.4255 | 0.4279 | 0.4243 | 0.4243 | 3091200.0 |
| 2002-03-07 10:35:00 | AAPL | Stock | 0.4243 | 0.4252 | 0.4223 | 0.425 | 5320000.0 |
| 2002-03-07 10:40:00 | AAPL | Stock | 0.4252 | 0.4268 | 0.4246 | 0.4255 | 4737600.0 |
| 2002-03-07 10:45:00 | AAPL | Stock | 0.4255 | 0.4268 | 0.4245 | 0.4257 | 7688800.0 |
| 2002-03-07 10:50:00 | AAPL | Stock | 0.4257 | 0.4279 | 0.4257 | 0.4275 | 2951200.0 |
| 2002-03-07 10:55:00 | AAPL | Stock | 0.4275 | 0.4277 | 0.4259 | 0.4264 | 1052800.0 |
| 2002-03-07 11:00:00 | AAPL | Stock | 0.427 | 0.4289 | 0.427 | 0.4286 | 1724800.0 |
| 2002-03-07 11:05:00 | AAPL | Stock | 0.4286 | 0.4298 | 0.4284 | 0.4293 | 3208800.0 |
| 2002-03-07 11:10:00 | AAPL | Stock | 0.4293 | 0.4304 | 0.4286 | 0.4291 | 1568000.0 |
| 2002-03-07 11:15:00 | AAPL | Stock | 0.4288 | 0.4321 | 0.4279 | 0.4304 | 3791200.0 |
| 2002-03-07 11:20:00 | AAPL | Stock | 0.4302 | 0.4316 | 0.4298 | 0.4302 | 1170400.0 |
| 2002-03-07 11:25:00 | AAPL | Stock | 0.4302 | 0.4309 | 0.4302 | 0.4302 | 487200.0 |
| 2002-03-07 11:30:00 | AAPL | Stock | 0.4302 | 0.4307 | 0.4284 | 0.4284 | 957600.0 |
| 2002-03-07 11:35:00 | AAPL | Stock | 0.4288 | 0.4288 | 0.4261 | 0.4264 | 1741600.0 |
| 2002-03-07 11:40:00 | AAPL | Stock | 0.4264 | 0.4266 | 0.4245 | 0.4246 | 3533600.0 |
| 2002-03-07 11:45:00 | AAPL | Stock | 0.4252 | 0.4273 | 0.4252 | 0.4273 | 1428000.0 |
| 2002-03-07 11:50:00 | AAPL | Stock | 0.4268 | 0.4282 | 0.4264 | 0.4264 | 952000.0 |
| 2002-03-07 11:55:00 | AAPL | Stock | 0.4264 | 0.4264 | 0.4255 | 0.4255 | 907200.0 |
| 2002-03-07 12:00:00 | AAPL | Stock | 0.4252 | 0.4254 | 0.4245 | 0.425 | 481600.0 |
| 2002-03-07 12:05:00 | AAPL | Stock | 0.425 | 0.425 | 0.4241 | 0.4246 | 274400.0 |
| 2002-03-07 12:10:00 | AAPL | Stock | 0.4248 | 0.4248 | 0.4227 | 0.4234 | 2979200.0 |
| 2002-03-07 12:15:00 | AAPL | Stock | 0.4234 | 0.4273 | 0.4232 | 0.4255 | 1148000.0 |
| 2002-03-07 12:20:00 | AAPL | Stock | 0.4257 | 0.4261 | 0.4254 | 0.4254 | 442400.0 |
| 2002-03-07 12:25:00 | AAPL | Stock | 0.4254 | 0.4268 | 0.4241 | 0.4268 | 616000.0 |
| 2002-03-07 12:30:00 | AAPL | Stock | 0.4261 | 0.4273 | 0.4261 | 0.4268 | 1164800.0 |
| 2002-03-07 12:35:00 | AAPL | Stock | 0.4268 | 0.4282 | 0.4268 | 0.4282 | 1237600.0 |
| 2002-03-07 12:40:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.427 | 0.4273 | 1019200.0 |
| 2002-03-07 12:45:00 | AAPL | Stock | 0.427 | 0.4282 | 0.4266 | 0.4282 | 1097600.0 |
| 2002-03-07 12:50:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.4264 | 0.4264 | 1125600.0 |
| 2002-03-07 12:55:00 | AAPL | Stock | 0.4268 | 0.4268 | 0.4264 | 0.4264 | 347200.0 |
| 2002-03-07 13:00:00 | AAPL | Stock | 0.4264 | 0.4266 | 0.4252 | 0.4252 | 201600.0 |
| 2002-03-07 13:05:00 | AAPL | Stock | 0.4255 | 0.4264 | 0.4252 | 0.4261 | 380800.0 |
> showing 50 of 119,449 rows — these rows as CSV