PREVIEW / stock_5min / 2005-05-27
file: by_date/stock_5min/2005/2005-05-27.parquet size: 2.5 MB rows: 185,860 symbols: 1,973
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-27 08:00:00 | AAPL | Stock | 1.4571 | 1.4621 | 1.455 | 1.4571 | 101724.0 |
| 2005-05-27 08:05:00 | AAPL | Stock | 1.4589 | 1.4607 | 1.4589 | 1.4589 | 47600.0 |
| 2005-05-27 08:10:00 | AAPL | Stock | 1.4589 | 1.4589 | 1.4571 | 1.4575 | 82600.0 |
| 2005-05-27 08:15:00 | AAPL | Stock | 1.4575 | 1.4575 | 1.4571 | 1.4571 | 183400.0 |
| 2005-05-27 08:25:00 | AAPL | Stock | 1.4571 | 1.4571 | 1.4571 | 1.4571 | 103600.0 |
| 2005-05-27 08:30:00 | AAPL | Stock | 1.4571 | 1.4571 | 1.4571 | 1.4571 | 68600.0 |
| 2005-05-27 08:35:00 | AAPL | Stock | 1.4575 | 1.4593 | 1.4575 | 1.4593 | 87500.0 |
| 2005-05-27 08:40:00 | AAPL | Stock | 1.4593 | 1.4604 | 1.4593 | 1.4593 | 19600.0 |
| 2005-05-27 08:50:00 | AAPL | Stock | 1.4579 | 1.4582 | 1.4579 | 1.4579 | 39984.0 |
| 2005-05-27 08:55:00 | AAPL | Stock | 1.4575 | 1.4589 | 1.4571 | 1.4589 | 157136.0 |
| 2005-05-27 09:00:00 | AAPL | Stock | 1.4604 | 1.4604 | 1.46 | 1.46 | 24080.0 |
| 2005-05-27 09:05:00 | AAPL | Stock | 1.4589 | 1.4589 | 1.4586 | 1.4586 | 11200.0 |
| 2005-05-27 09:10:00 | AAPL | Stock | 1.4571 | 1.4586 | 1.4571 | 1.4586 | 106400.0 |
| 2005-05-27 09:15:00 | AAPL | Stock | 1.4589 | 1.4589 | 1.4561 | 1.4575 | 67200.0 |
| 2005-05-27 09:20:00 | AAPL | Stock | 1.4564 | 1.4564 | 1.4543 | 1.4543 | 11200.0 |
| 2005-05-27 09:25:00 | AAPL | Stock | 1.4532 | 1.4579 | 1.4486 | 1.4536 | 1010884.0 |
| 2005-05-27 09:30:00 | AAPL | Stock | 1.4514 | 1.4568 | 1.4489 | 1.4511 | 14351876.0 |
| 2005-05-27 09:35:00 | AAPL | Stock | 1.4518 | 1.4532 | 1.4507 | 1.4507 | 7629048.0 |
| 2005-05-27 09:40:00 | AAPL | Stock | 1.4511 | 1.4511 | 1.4447 | 1.4486 | 7988232.0 |
| 2005-05-27 09:45:00 | AAPL | Stock | 1.4486 | 1.4493 | 1.4436 | 1.4454 | 9626120.0 |
| 2005-05-27 09:50:00 | AAPL | Stock | 1.445 | 1.4454 | 1.4304 | 1.4332 | 25142824.0 |
| 2005-05-27 09:55:00 | AAPL | Stock | 1.4336 | 1.4371 | 1.4311 | 1.435 | 11434416.0 |
| 2005-05-27 10:00:00 | AAPL | Stock | 1.435 | 1.4411 | 1.4346 | 1.4404 | 12865412.0 |
| 2005-05-27 10:05:00 | AAPL | Stock | 1.4404 | 1.4425 | 1.4368 | 1.4378 | 8302980.0 |
| 2005-05-27 10:10:00 | AAPL | Stock | 1.4375 | 1.4386 | 1.4346 | 1.4346 | 7199724.0 |
| 2005-05-27 10:15:00 | AAPL | Stock | 1.4346 | 1.435 | 1.4289 | 1.43 | 11757088.0 |
| 2005-05-27 10:20:00 | AAPL | Stock | 1.4296 | 1.4332 | 1.4293 | 1.4314 | 7337820.0 |
| 2005-05-27 10:25:00 | AAPL | Stock | 1.4321 | 1.4364 | 1.4314 | 1.4364 | 8648080.0 |
| 2005-05-27 10:30:00 | AAPL | Stock | 1.4364 | 1.4389 | 1.4354 | 1.4386 | 6101396.0 |
| 2005-05-27 10:35:00 | AAPL | Stock | 1.4389 | 1.4396 | 1.435 | 1.4364 | 5061812.0 |
| 2005-05-27 10:40:00 | AAPL | Stock | 1.4364 | 1.4393 | 1.4354 | 1.4389 | 5194840.0 |
| 2005-05-27 10:45:00 | AAPL | Stock | 1.4389 | 1.4393 | 1.435 | 1.4371 | 3406620.0 |
| 2005-05-27 10:50:00 | AAPL | Stock | 1.4371 | 1.4407 | 1.4371 | 1.4393 | 4025280.0 |
| 2005-05-27 10:55:00 | AAPL | Stock | 1.4389 | 1.4411 | 1.4382 | 1.4396 | 3118220.0 |
| 2005-05-27 11:00:00 | AAPL | Stock | 1.4396 | 1.4421 | 1.4396 | 1.4421 | 3524332.0 |
| 2005-05-27 11:05:00 | AAPL | Stock | 1.4421 | 1.4436 | 1.4404 | 1.4407 | 5114200.0 |
| 2005-05-27 11:10:00 | AAPL | Stock | 1.4407 | 1.4414 | 1.4389 | 1.4404 | 3238368.0 |
| 2005-05-27 11:15:00 | AAPL | Stock | 1.4404 | 1.4414 | 1.4403 | 1.4411 | 900956.0 |
| 2005-05-27 11:20:00 | AAPL | Stock | 1.4411 | 1.4418 | 1.4404 | 1.4418 | 1482376.0 |
| 2005-05-27 11:25:00 | AAPL | Stock | 1.4414 | 1.4429 | 1.4414 | 1.4429 | 2046856.0 |
| 2005-05-27 11:30:00 | AAPL | Stock | 1.4425 | 1.4436 | 1.4411 | 1.4414 | 2305268.0 |
| 2005-05-27 11:35:00 | AAPL | Stock | 1.4414 | 1.4418 | 1.4393 | 1.4393 | 2517144.0 |
| 2005-05-27 11:40:00 | AAPL | Stock | 1.4393 | 1.44 | 1.4382 | 1.4389 | 1974448.0 |
| 2005-05-27 11:45:00 | AAPL | Stock | 1.4389 | 1.4396 | 1.4382 | 1.4393 | 1474732.0 |
| 2005-05-27 11:50:00 | AAPL | Stock | 1.4389 | 1.4393 | 1.4382 | 1.4386 | 2270436.0 |
| 2005-05-27 11:55:00 | AAPL | Stock | 1.4389 | 1.4393 | 1.4382 | 1.4393 | 1745800.0 |
| 2005-05-27 12:00:00 | AAPL | Stock | 1.4393 | 1.4425 | 1.4389 | 1.4396 | 5904976.0 |
| 2005-05-27 12:05:00 | AAPL | Stock | 1.4396 | 1.4404 | 1.4389 | 1.4404 | 846328.0 |
| 2005-05-27 12:10:00 | AAPL | Stock | 1.44 | 1.4418 | 1.44 | 1.4411 | 1494724.0 |
| 2005-05-27 12:15:00 | AAPL | Stock | 1.4407 | 1.4418 | 1.4404 | 1.4418 | 1148224.0 |
> showing 50 of 185,860 rows — these rows as CSV