PREVIEW / stock_5min / 2002-03-22
file: by_date/stock_5min/2002/2002-03-22.parquet size: 1.7 MB rows: 119,509 symbols: 1,401
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-22 08:00:00 | AAPL | Stock | 0.4337 | 0.4337 | 0.4337 | 0.4337 | 2352000.0 |
| 2002-03-22 08:20:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4339 | 0.4339 | 11200.0 |
| 2002-03-22 08:25:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 28000.0 |
| 2002-03-22 08:40:00 | AAPL | Stock | 0.4334 | 0.4338 | 0.4334 | 0.4338 | 84000.0 |
| 2002-03-22 09:00:00 | AAPL | Stock | 0.4332 | 0.4332 | 0.4332 | 0.4332 | 16800.0 |
| 2002-03-22 09:05:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 11200.0 |
| 2002-03-22 09:10:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 22400.0 |
| 2002-03-22 09:15:00 | AAPL | Stock | 0.4331 | 0.4331 | 0.433 | 0.433 | 11200.0 |
| 2002-03-22 09:25:00 | AAPL | Stock | 0.433 | 0.433 | 0.4325 | 0.4327 | 341600.0 |
| 2002-03-22 09:30:00 | AAPL | Stock | 0.4325 | 0.4327 | 0.4293 | 0.4318 | 6893600.0 |
| 2002-03-22 09:35:00 | AAPL | Stock | 0.432 | 0.435 | 0.4305 | 0.4348 | 4295200.0 |
| 2002-03-22 09:40:00 | AAPL | Stock | 0.4352 | 0.4354 | 0.4318 | 0.4318 | 7431200.0 |
| 2002-03-22 09:45:00 | AAPL | Stock | 0.432 | 0.4364 | 0.4316 | 0.4359 | 8383200.0 |
| 2002-03-22 09:50:00 | AAPL | Stock | 0.4361 | 0.437 | 0.4343 | 0.4346 | 2620800.0 |
| 2002-03-22 09:55:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4321 | 0.4341 | 3494400.0 |
| 2002-03-22 10:00:00 | AAPL | Stock | 0.4336 | 0.4346 | 0.433 | 0.4339 | 3096800.0 |
| 2002-03-22 10:05:00 | AAPL | Stock | 0.4339 | 0.4354 | 0.4329 | 0.4339 | 2592800.0 |
| 2002-03-22 10:10:00 | AAPL | Stock | 0.4343 | 0.4343 | 0.4321 | 0.4321 | 1876000.0 |
| 2002-03-22 10:15:00 | AAPL | Stock | 0.4323 | 0.4336 | 0.4313 | 0.4332 | 3752000.0 |
| 2002-03-22 10:20:00 | AAPL | Stock | 0.4332 | 0.4332 | 0.4323 | 0.4327 | 3068800.0 |
| 2002-03-22 10:25:00 | AAPL | Stock | 0.4327 | 0.433 | 0.4309 | 0.432 | 3875200.0 |
| 2002-03-22 10:30:00 | AAPL | Stock | 0.432 | 0.4323 | 0.4307 | 0.4316 | 3903200.0 |
| 2002-03-22 10:35:00 | AAPL | Stock | 0.4316 | 0.4316 | 0.4304 | 0.4304 | 2296000.0 |
| 2002-03-22 10:40:00 | AAPL | Stock | 0.4304 | 0.4309 | 0.4289 | 0.4293 | 2161600.0 |
| 2002-03-22 10:45:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4288 | 0.4291 | 1288000.0 |
| 2002-03-22 10:50:00 | AAPL | Stock | 0.4291 | 0.43 | 0.4286 | 0.4288 | 733600.0 |
| 2002-03-22 10:55:00 | AAPL | Stock | 0.4286 | 0.4298 | 0.4277 | 0.4288 | 1769600.0 |
| 2002-03-22 11:00:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4288 | 0.4289 | 1069600.0 |
| 2002-03-22 11:05:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4289 | 0.4289 | 845600.0 |
| 2002-03-22 11:10:00 | AAPL | Stock | 0.4288 | 0.4302 | 0.4286 | 0.4289 | 856800.0 |
| 2002-03-22 11:15:00 | AAPL | Stock | 0.4288 | 0.4289 | 0.4288 | 0.4289 | 1433600.0 |
| 2002-03-22 11:20:00 | AAPL | Stock | 0.4289 | 0.4295 | 0.4282 | 0.4291 | 2469600.0 |
| 2002-03-22 11:25:00 | AAPL | Stock | 0.4291 | 0.4293 | 0.4286 | 0.4286 | 700000.0 |
| 2002-03-22 11:30:00 | AAPL | Stock | 0.4286 | 0.4289 | 0.4286 | 0.4286 | 2637600.0 |
| 2002-03-22 11:35:00 | AAPL | Stock | 0.4282 | 0.4286 | 0.4263 | 0.4268 | 2637600.0 |
| 2002-03-22 11:40:00 | AAPL | Stock | 0.427 | 0.4278 | 0.4268 | 0.4268 | 1024800.0 |
| 2002-03-22 11:45:00 | AAPL | Stock | 0.4268 | 0.4271 | 0.4267 | 0.4268 | 845600.0 |
| 2002-03-22 11:50:00 | AAPL | Stock | 0.4268 | 0.427 | 0.4264 | 0.4264 | 2441600.0 |
| 2002-03-22 11:55:00 | AAPL | Stock | 0.4264 | 0.427 | 0.4263 | 0.4268 | 1926400.0 |
| 2002-03-22 12:00:00 | AAPL | Stock | 0.4268 | 0.4291 | 0.4268 | 0.4286 | 1540000.0 |
| 2002-03-22 12:05:00 | AAPL | Stock | 0.4286 | 0.4293 | 0.4286 | 0.4291 | 812000.0 |
| 2002-03-22 12:10:00 | AAPL | Stock | 0.4289 | 0.4291 | 0.4284 | 0.4288 | 985600.0 |
| 2002-03-22 12:15:00 | AAPL | Stock | 0.4286 | 0.4321 | 0.4286 | 0.432 | 2010400.0 |
| 2002-03-22 12:20:00 | AAPL | Stock | 0.432 | 0.4334 | 0.4304 | 0.4332 | 3253600.0 |
| 2002-03-22 12:25:00 | AAPL | Stock | 0.4332 | 0.4332 | 0.4305 | 0.4309 | 2452800.0 |
| 2002-03-22 12:30:00 | AAPL | Stock | 0.4307 | 0.4323 | 0.4305 | 0.4321 | 1405600.0 |
| 2002-03-22 12:35:00 | AAPL | Stock | 0.4323 | 0.4348 | 0.4323 | 0.4348 | 3197600.0 |
| 2002-03-22 12:40:00 | AAPL | Stock | 0.4348 | 0.4386 | 0.4346 | 0.438 | 8708000.0 |
| 2002-03-22 12:45:00 | AAPL | Stock | 0.438 | 0.4382 | 0.4361 | 0.4363 | 1304800.0 |
| 2002-03-22 12:50:00 | AAPL | Stock | 0.4363 | 0.4363 | 0.4359 | 0.4359 | 621600.0 |
> showing 50 of 119,509 rows — these rows as CSV