PREVIEW / stock_5min / 2004-01-14
file: by_date/stock_5min/2004/2004-01-14.parquet size: 2.4 MB rows: 172,414 symbols: 1,709
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-14 08:05:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 56000.0 |
| 2004-01-14 08:15:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 5600.0 |
| 2004-01-14 08:25:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4348 | 0.4357 | 168000.0 |
| 2004-01-14 08:30:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 56000.0 |
| 2004-01-14 08:35:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4341 | 0.4348 | 128800.0 |
| 2004-01-14 08:40:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 112000.0 |
| 2004-01-14 08:45:00 | AAPL | Stock | 0.4359 | 0.4359 | 0.4359 | 0.4359 | 22400.0 |
| 2004-01-14 08:50:00 | AAPL | Stock | 0.4359 | 0.4364 | 0.4357 | 0.4364 | 39200.0 |
| 2004-01-14 08:55:00 | AAPL | Stock | 0.437 | 0.4373 | 0.437 | 0.4373 | 106400.0 |
| 2004-01-14 09:00:00 | AAPL | Stock | 0.4373 | 0.4375 | 0.4366 | 0.4366 | 358400.0 |
| 2004-01-14 09:05:00 | AAPL | Stock | 0.4371 | 0.4371 | 0.4366 | 0.4366 | 39200.0 |
| 2004-01-14 09:10:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4364 | 0.4364 | 72800.0 |
| 2004-01-14 09:15:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 56000.0 |
| 2004-01-14 09:20:00 | AAPL | Stock | 0.4352 | 0.4357 | 0.4352 | 0.4357 | 95200.0 |
| 2004-01-14 09:25:00 | AAPL | Stock | 0.4334 | 0.4357 | 0.4334 | 0.4357 | 2167200.0 |
| 2004-01-14 09:30:00 | AAPL | Stock | 0.4357 | 0.4375 | 0.4357 | 0.4368 | 25323816.0 |
| 2004-01-14 09:35:00 | AAPL | Stock | 0.4366 | 0.4373 | 0.4352 | 0.437 | 17307304.0 |
| 2004-01-14 09:40:00 | AAPL | Stock | 0.4373 | 0.4382 | 0.4366 | 0.437 | 11528216.0 |
| 2004-01-14 09:45:00 | AAPL | Stock | 0.437 | 0.4375 | 0.4364 | 0.4368 | 10708040.0 |
| 2004-01-14 09:50:00 | AAPL | Stock | 0.4367 | 0.4368 | 0.4349 | 0.4354 | 9279368.0 |
| 2004-01-14 09:55:00 | AAPL | Stock | 0.4355 | 0.4364 | 0.4343 | 0.4347 | 7008344.0 |
| 2004-01-14 10:00:00 | AAPL | Stock | 0.4347 | 0.4352 | 0.4318 | 0.4329 | 11236064.0 |
| 2004-01-14 10:05:00 | AAPL | Stock | 0.433 | 0.4339 | 0.4323 | 0.4336 | 6095488.0 |
| 2004-01-14 10:10:00 | AAPL | Stock | 0.4336 | 0.4339 | 0.433 | 0.4332 | 5297768.0 |
| 2004-01-14 10:15:00 | AAPL | Stock | 0.4333 | 0.4338 | 0.4327 | 0.4336 | 8114680.0 |
| 2004-01-14 10:20:00 | AAPL | Stock | 0.4336 | 0.4339 | 0.4336 | 0.4336 | 6352304.0 |
| 2004-01-14 10:25:00 | AAPL | Stock | 0.4336 | 0.4339 | 0.4327 | 0.4327 | 7705712.0 |
| 2004-01-14 10:30:00 | AAPL | Stock | 0.4327 | 0.4332 | 0.4295 | 0.4298 | 8082200.0 |
| 2004-01-14 10:35:00 | AAPL | Stock | 0.4298 | 0.4304 | 0.4295 | 0.4304 | 4545520.0 |
| 2004-01-14 10:40:00 | AAPL | Stock | 0.4305 | 0.4307 | 0.4302 | 0.4305 | 4163376.0 |
| 2004-01-14 10:45:00 | AAPL | Stock | 0.4304 | 0.4305 | 0.4295 | 0.4297 | 6960016.0 |
| 2004-01-14 10:50:00 | AAPL | Stock | 0.4297 | 0.4298 | 0.4293 | 0.4298 | 2766008.0 |
| 2004-01-14 10:55:00 | AAPL | Stock | 0.4298 | 0.43 | 0.4296 | 0.4296 | 1789480.0 |
| 2004-01-14 11:00:00 | AAPL | Stock | 0.4295 | 0.4325 | 0.4295 | 0.4321 | 6108480.0 |
| 2004-01-14 11:05:00 | AAPL | Stock | 0.4321 | 0.4325 | 0.432 | 0.4323 | 4145120.0 |
| 2004-01-14 11:10:00 | AAPL | Stock | 0.4323 | 0.4325 | 0.4318 | 0.4318 | 7980728.0 |
| 2004-01-14 11:15:00 | AAPL | Stock | 0.4318 | 0.4321 | 0.4306 | 0.4309 | 2557800.0 |
| 2004-01-14 11:20:00 | AAPL | Stock | 0.4311 | 0.432 | 0.4309 | 0.4311 | 10259984.0 |
| 2004-01-14 11:25:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4307 | 0.4307 | 6601840.0 |
| 2004-01-14 11:30:00 | AAPL | Stock | 0.4307 | 0.4309 | 0.43 | 0.4302 | 5518408.0 |
| 2004-01-14 11:35:00 | AAPL | Stock | 0.4302 | 0.4309 | 0.4298 | 0.4307 | 2679488.0 |
| 2004-01-14 11:40:00 | AAPL | Stock | 0.4307 | 0.4309 | 0.4305 | 0.4305 | 1261512.0 |
| 2004-01-14 11:45:00 | AAPL | Stock | 0.4304 | 0.4307 | 0.4294 | 0.4298 | 7398664.0 |
| 2004-01-14 11:50:00 | AAPL | Stock | 0.4298 | 0.4302 | 0.4291 | 0.4293 | 3517528.0 |
| 2004-01-14 11:55:00 | AAPL | Stock | 0.4291 | 0.4296 | 0.428 | 0.4284 | 7975464.0 |
| 2004-01-14 12:00:00 | AAPL | Stock | 0.4284 | 0.4289 | 0.427 | 0.4273 | 10419192.0 |
| 2004-01-14 12:05:00 | AAPL | Stock | 0.4273 | 0.4286 | 0.4273 | 0.4286 | 2119824.0 |
| 2004-01-14 12:10:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4282 | 0.4284 | 2031904.0 |
| 2004-01-14 12:15:00 | AAPL | Stock | 0.4286 | 0.4289 | 0.4282 | 0.4282 | 2481528.0 |
| 2004-01-14 12:20:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.4263 | 0.4268 | 4009096.0 |
> showing 50 of 172,414 rows — these rows as CSV