PREVIEW / stock_5min / 2005-05-31
file: by_date/stock_5min/2005/2005-05-31.parquet size: 2.7 MB rows: 197,884 symbols: 1,994
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-31 08:00:00 | AAPL | Stock | 1.4429 | 1.4443 | 1.4429 | 1.4443 | 23660.0 |
| 2005-05-31 08:05:00 | AAPL | Stock | 1.44 | 1.4414 | 1.4389 | 1.4393 | 58800.0 |
| 2005-05-31 08:10:00 | AAPL | Stock | 1.4414 | 1.4443 | 1.4386 | 1.4443 | 112000.0 |
| 2005-05-31 08:15:00 | AAPL | Stock | 1.4439 | 1.4439 | 1.4439 | 1.4439 | 14000.0 |
| 2005-05-31 08:25:00 | AAPL | Stock | 1.4418 | 1.4418 | 1.4418 | 1.4418 | 2800.0 |
| 2005-05-31 08:30:00 | AAPL | Stock | 1.4414 | 1.4418 | 1.4393 | 1.4414 | 42000.0 |
| 2005-05-31 08:45:00 | AAPL | Stock | 1.4411 | 1.4429 | 1.4411 | 1.4429 | 47600.0 |
| 2005-05-31 09:00:00 | AAPL | Stock | 1.4411 | 1.4411 | 1.4411 | 1.4411 | 14000.0 |
| 2005-05-31 09:05:00 | AAPL | Stock | 1.4443 | 1.4443 | 1.4439 | 1.4443 | 63140.0 |
| 2005-05-31 09:10:00 | AAPL | Stock | 1.4432 | 1.4432 | 1.4432 | 1.4432 | 14000.0 |
| 2005-05-31 09:20:00 | AAPL | Stock | 1.4454 | 1.4454 | 1.4446 | 1.4446 | 56000.0 |
| 2005-05-31 09:25:00 | AAPL | Stock | 1.4454 | 1.4554 | 1.4454 | 1.4532 | 440944.0 |
| 2005-05-31 09:30:00 | AAPL | Stock | 1.4521 | 1.455 | 1.4468 | 1.4475 | 7682612.0 |
| 2005-05-31 09:35:00 | AAPL | Stock | 1.4471 | 1.452 | 1.4421 | 1.4464 | 5658324.0 |
| 2005-05-31 09:40:00 | AAPL | Stock | 1.4468 | 1.4468 | 1.4371 | 1.44 | 9780680.0 |
| 2005-05-31 09:45:00 | AAPL | Stock | 1.44 | 1.4418 | 1.4393 | 1.4396 | 6780032.0 |
| 2005-05-31 09:50:00 | AAPL | Stock | 1.4396 | 1.4404 | 1.4375 | 1.4382 | 4848228.0 |
| 2005-05-31 09:55:00 | AAPL | Stock | 1.4379 | 1.4439 | 1.4354 | 1.4371 | 11765908.0 |
| 2005-05-31 10:00:00 | AAPL | Stock | 1.4375 | 1.4414 | 1.4364 | 1.4389 | 5999756.0 |
| 2005-05-31 10:05:00 | AAPL | Stock | 1.4389 | 1.4436 | 1.4389 | 1.4421 | 5656840.0 |
| 2005-05-31 10:10:00 | AAPL | Stock | 1.4421 | 1.4432 | 1.4386 | 1.4418 | 4810988.0 |
| 2005-05-31 10:15:00 | AAPL | Stock | 1.4421 | 1.4432 | 1.4393 | 1.4396 | 3506608.0 |
| 2005-05-31 10:20:00 | AAPL | Stock | 1.4396 | 1.44 | 1.4379 | 1.4393 | 3280480.0 |
| 2005-05-31 10:25:00 | AAPL | Stock | 1.4396 | 1.445 | 1.4393 | 1.4436 | 4918732.0 |
| 2005-05-31 10:30:00 | AAPL | Stock | 1.4439 | 1.4482 | 1.4439 | 1.4479 | 7263060.0 |
| 2005-05-31 10:35:00 | AAPL | Stock | 1.4479 | 1.45 | 1.4469 | 1.4489 | 7011676.0 |
| 2005-05-31 10:40:00 | AAPL | Stock | 1.4486 | 1.4518 | 1.4479 | 1.45 | 3023384.0 |
| 2005-05-31 10:45:00 | AAPL | Stock | 1.4504 | 1.4532 | 1.4493 | 1.4496 | 5602968.0 |
| 2005-05-31 10:50:00 | AAPL | Stock | 1.45 | 1.4507 | 1.4471 | 1.4471 | 4195772.0 |
| 2005-05-31 10:55:00 | AAPL | Stock | 1.4471 | 1.4475 | 1.4425 | 1.4429 | 5361888.0 |
| 2005-05-31 11:00:00 | AAPL | Stock | 1.4429 | 1.445 | 1.4414 | 1.4443 | 4703272.0 |
| 2005-05-31 11:05:00 | AAPL | Stock | 1.4443 | 1.4446 | 1.4386 | 1.4393 | 5988528.0 |
| 2005-05-31 11:10:00 | AAPL | Stock | 1.4393 | 1.4432 | 1.4386 | 1.4411 | 4603088.0 |
| 2005-05-31 11:15:00 | AAPL | Stock | 1.4407 | 1.4418 | 1.4393 | 1.4404 | 2493624.0 |
| 2005-05-31 11:20:00 | AAPL | Stock | 1.44 | 1.4411 | 1.4386 | 1.4396 | 2544528.0 |
| 2005-05-31 11:25:00 | AAPL | Stock | 1.4396 | 1.4418 | 1.4393 | 1.4414 | 2316188.0 |
| 2005-05-31 11:30:00 | AAPL | Stock | 1.4418 | 1.4429 | 1.4414 | 1.4421 | 1704612.0 |
| 2005-05-31 11:35:00 | AAPL | Stock | 1.4421 | 1.4486 | 1.4396 | 1.4411 | 2232356.0 |
| 2005-05-31 11:40:00 | AAPL | Stock | 1.4411 | 1.4471 | 1.4375 | 1.4382 | 4672556.0 |
| 2005-05-31 11:45:00 | AAPL | Stock | 1.4382 | 1.44 | 1.4375 | 1.44 | 2278864.0 |
| 2005-05-31 11:50:00 | AAPL | Stock | 1.44 | 1.4404 | 1.4382 | 1.4382 | 2580900.0 |
| 2005-05-31 11:55:00 | AAPL | Stock | 1.4382 | 1.4471 | 1.4382 | 1.4389 | 2163056.0 |
| 2005-05-31 12:00:00 | AAPL | Stock | 1.4389 | 1.4396 | 1.4382 | 1.4386 | 2007824.0 |
| 2005-05-31 12:05:00 | AAPL | Stock | 1.4386 | 1.4396 | 1.4371 | 1.4389 | 3689196.0 |
| 2005-05-31 12:10:00 | AAPL | Stock | 1.4393 | 1.4407 | 1.4386 | 1.4386 | 1889216.0 |
| 2005-05-31 12:15:00 | AAPL | Stock | 1.4389 | 1.4429 | 1.4386 | 1.4421 | 2275868.0 |
| 2005-05-31 12:20:00 | AAPL | Stock | 1.4421 | 1.4432 | 1.4411 | 1.4418 | 2853200.0 |
| 2005-05-31 12:25:00 | AAPL | Stock | 1.4418 | 1.4421 | 1.4414 | 1.4421 | 2324532.0 |
| 2005-05-31 12:30:00 | AAPL | Stock | 1.4418 | 1.4421 | 1.44 | 1.44 | 2001384.0 |
| 2005-05-31 12:35:00 | AAPL | Stock | 1.44 | 1.4407 | 1.4393 | 1.4393 | 2161600.0 |
> showing 50 of 197,884 rows — these rows as CSV