PREVIEW / stock_5min / 2004-01-13
file: by_date/stock_5min/2004/2004-01-13.parquet size: 2.4 MB rows: 172,906 symbols: 1,718
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-13 08:00:00 | AAPL | Stock | 0.4314 | 0.4375 | 0.4305 | 0.4375 | 302400.0 |
| 2004-01-13 08:05:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4339 | 0.4375 | 535192.0 |
| 2004-01-13 08:15:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4361 | 0.4366 | 50400.0 |
| 2004-01-13 08:20:00 | AAPL | Stock | 0.4368 | 0.4368 | 0.4368 | 0.4368 | 56000.0 |
| 2004-01-13 08:25:00 | AAPL | Stock | 0.4375 | 0.4377 | 0.4375 | 0.4377 | 56000.0 |
| 2004-01-13 08:30:00 | AAPL | Stock | 0.4375 | 0.4393 | 0.4375 | 0.4386 | 459200.0 |
| 2004-01-13 08:35:00 | AAPL | Stock | 0.4375 | 0.4402 | 0.4375 | 0.4402 | 638400.0 |
| 2004-01-13 08:40:00 | AAPL | Stock | 0.4375 | 0.4379 | 0.4375 | 0.4379 | 666400.0 |
| 2004-01-13 08:45:00 | AAPL | Stock | 0.4379 | 0.4379 | 0.4375 | 0.4375 | 140000.0 |
| 2004-01-13 08:50:00 | AAPL | Stock | 0.4377 | 0.4377 | 0.4366 | 0.4375 | 420000.0 |
| 2004-01-13 08:55:00 | AAPL | Stock | 0.4375 | 0.4384 | 0.4375 | 0.438 | 490616.0 |
| 2004-01-13 09:00:00 | AAPL | Stock | 0.4384 | 0.4384 | 0.438 | 0.4382 | 112000.0 |
| 2004-01-13 09:05:00 | AAPL | Stock | 0.438 | 0.4391 | 0.4375 | 0.4384 | 806400.0 |
| 2004-01-13 09:10:00 | AAPL | Stock | 0.4382 | 0.4391 | 0.4373 | 0.4384 | 2780624.0 |
| 2004-01-13 09:15:00 | AAPL | Stock | 0.4384 | 0.4393 | 0.4384 | 0.4393 | 1588720.0 |
| 2004-01-13 09:20:00 | AAPL | Stock | 0.4393 | 0.4402 | 0.4393 | 0.4398 | 1579200.0 |
| 2004-01-13 09:25:00 | AAPL | Stock | 0.4398 | 0.4409 | 0.4357 | 0.4404 | 8444800.0 |
| 2004-01-13 09:30:00 | AAPL | Stock | 0.4411 | 0.4411 | 0.4384 | 0.4389 | 52806712.0 |
| 2004-01-13 09:35:00 | AAPL | Stock | 0.4389 | 0.4395 | 0.4371 | 0.4377 | 21818664.0 |
| 2004-01-13 09:40:00 | AAPL | Stock | 0.4377 | 0.4396 | 0.4375 | 0.4393 | 23142840.0 |
| 2004-01-13 09:45:00 | AAPL | Stock | 0.4391 | 0.4411 | 0.4386 | 0.4407 | 21847056.0 |
| 2004-01-13 09:50:00 | AAPL | Stock | 0.4407 | 0.4436 | 0.4396 | 0.4405 | 22407392.0 |
| 2004-01-13 09:55:00 | AAPL | Stock | 0.4405 | 0.4414 | 0.4377 | 0.4382 | 15978200.0 |
| 2004-01-13 10:00:00 | AAPL | Stock | 0.4379 | 0.4393 | 0.4379 | 0.4384 | 10925824.0 |
| 2004-01-13 10:05:00 | AAPL | Stock | 0.4388 | 0.4388 | 0.4345 | 0.4352 | 20719720.0 |
| 2004-01-13 10:10:00 | AAPL | Stock | 0.4355 | 0.438 | 0.4352 | 0.437 | 14573944.0 |
| 2004-01-13 10:15:00 | AAPL | Stock | 0.4366 | 0.4375 | 0.4316 | 0.4316 | 17232712.0 |
| 2004-01-13 10:20:00 | AAPL | Stock | 0.4318 | 0.4321 | 0.4296 | 0.4309 | 20413008.0 |
| 2004-01-13 10:25:00 | AAPL | Stock | 0.4314 | 0.4314 | 0.4276 | 0.428 | 16097256.0 |
| 2004-01-13 10:30:00 | AAPL | Stock | 0.428 | 0.4318 | 0.4277 | 0.4295 | 10679088.0 |
| 2004-01-13 10:35:00 | AAPL | Stock | 0.4295 | 0.4338 | 0.4293 | 0.4338 | 9630936.0 |
| 2004-01-13 10:40:00 | AAPL | Stock | 0.4338 | 0.4343 | 0.4333 | 0.4339 | 6002192.0 |
| 2004-01-13 10:45:00 | AAPL | Stock | 0.4341 | 0.4343 | 0.4307 | 0.4307 | 5481504.0 |
| 2004-01-13 10:50:00 | AAPL | Stock | 0.431 | 0.4338 | 0.4295 | 0.4336 | 7735728.0 |
| 2004-01-13 10:55:00 | AAPL | Stock | 0.4336 | 0.4339 | 0.433 | 0.4336 | 5969096.0 |
| 2004-01-13 11:00:00 | AAPL | Stock | 0.4336 | 0.4361 | 0.4336 | 0.4348 | 8074416.0 |
| 2004-01-13 11:05:00 | AAPL | Stock | 0.4348 | 0.4355 | 0.4348 | 0.4351 | 4154192.0 |
| 2004-01-13 11:10:00 | AAPL | Stock | 0.435 | 0.4361 | 0.4348 | 0.4357 | 7294504.0 |
| 2004-01-13 11:15:00 | AAPL | Stock | 0.4363 | 0.4389 | 0.4357 | 0.438 | 15014776.0 |
| 2004-01-13 11:20:00 | AAPL | Stock | 0.4379 | 0.4396 | 0.4375 | 0.438 | 10501568.0 |
| 2004-01-13 11:25:00 | AAPL | Stock | 0.438 | 0.438 | 0.4371 | 0.4371 | 4719232.0 |
| 2004-01-13 11:30:00 | AAPL | Stock | 0.4371 | 0.4373 | 0.4338 | 0.4348 | 6070456.0 |
| 2004-01-13 11:35:00 | AAPL | Stock | 0.4346 | 0.435 | 0.4341 | 0.4341 | 4094496.0 |
| 2004-01-13 11:40:00 | AAPL | Stock | 0.4341 | 0.4346 | 0.4327 | 0.4341 | 3795176.0 |
| 2004-01-13 11:45:00 | AAPL | Stock | 0.4339 | 0.4355 | 0.4336 | 0.435 | 3558632.0 |
| 2004-01-13 11:50:00 | AAPL | Stock | 0.4352 | 0.4354 | 0.433 | 0.433 | 4745440.0 |
| 2004-01-13 11:55:00 | AAPL | Stock | 0.433 | 0.4338 | 0.4313 | 0.4316 | 6162968.0 |
| 2004-01-13 12:00:00 | AAPL | Stock | 0.4313 | 0.4316 | 0.4282 | 0.43 | 11811576.0 |
| 2004-01-13 12:05:00 | AAPL | Stock | 0.43 | 0.4327 | 0.4298 | 0.4325 | 5688536.0 |
| 2004-01-13 12:10:00 | AAPL | Stock | 0.4325 | 0.4329 | 0.4321 | 0.4321 | 8064224.0 |
> showing 50 of 172,906 rows — these rows as CSV