PREVIEW / stock_5min / 2004-09-07
file: by_date/stock_5min/2004/2004-09-07.parquet size: 2.4 MB rows: 176,800 symbols: 1,826
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-09-07 08:00:00 | AAPL | Stock | 0.6304 | 0.6304 | 0.6304 | 0.6304 | 11200.0 |
| 2004-09-07 08:30:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6339 | 0.6339 | 14000.0 |
| 2004-09-07 08:50:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6339 | 0.6339 | 11200.0 |
| 2004-09-07 09:05:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6339 | 0.6339 | 5600.0 |
| 2004-09-07 09:15:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6339 | 0.6339 | 22400.0 |
| 2004-09-07 09:25:00 | AAPL | Stock | 0.6343 | 0.6343 | 0.6316 | 0.6316 | 140000.0 |
| 2004-09-07 09:30:00 | AAPL | Stock | 0.6321 | 0.6346 | 0.6291 | 0.6346 | 9579024.0 |
| 2004-09-07 09:35:00 | AAPL | Stock | 0.6348 | 0.6352 | 0.6336 | 0.6343 | 8525608.0 |
| 2004-09-07 09:40:00 | AAPL | Stock | 0.6343 | 0.6346 | 0.6339 | 0.6345 | 3053792.0 |
| 2004-09-07 09:45:00 | AAPL | Stock | 0.6343 | 0.6348 | 0.6327 | 0.6346 | 3973032.0 |
| 2004-09-07 09:50:00 | AAPL | Stock | 0.6348 | 0.6361 | 0.6343 | 0.6346 | 3211208.0 |
| 2004-09-07 09:55:00 | AAPL | Stock | 0.6345 | 0.6402 | 0.6343 | 0.6389 | 5634888.0 |
| 2004-09-07 10:00:00 | AAPL | Stock | 0.6393 | 0.6414 | 0.6393 | 0.64 | 6808032.0 |
| 2004-09-07 10:05:00 | AAPL | Stock | 0.64 | 0.64 | 0.6375 | 0.6384 | 6250608.0 |
| 2004-09-07 10:10:00 | AAPL | Stock | 0.6384 | 0.6409 | 0.6379 | 0.6409 | 6843816.0 |
| 2004-09-07 10:15:00 | AAPL | Stock | 0.6409 | 0.6416 | 0.6404 | 0.6409 | 5395992.0 |
| 2004-09-07 10:20:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6407 | 0.6409 | 2256520.0 |
| 2004-09-07 10:25:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6391 | 0.6393 | 3223696.0 |
| 2004-09-07 10:30:00 | AAPL | Stock | 0.6393 | 0.6398 | 0.6348 | 0.6366 | 9509976.0 |
| 2004-09-07 10:35:00 | AAPL | Stock | 0.6364 | 0.6382 | 0.6364 | 0.6368 | 2131696.0 |
| 2004-09-07 10:40:00 | AAPL | Stock | 0.6368 | 0.6377 | 0.6364 | 0.637 | 2551304.0 |
| 2004-09-07 10:45:00 | AAPL | Stock | 0.6368 | 0.6382 | 0.6364 | 0.6371 | 1929200.0 |
| 2004-09-07 10:50:00 | AAPL | Stock | 0.637 | 0.637 | 0.6339 | 0.6341 | 2735208.0 |
| 2004-09-07 10:55:00 | AAPL | Stock | 0.6341 | 0.6366 | 0.6341 | 0.6357 | 2557016.0 |
| 2004-09-07 11:00:00 | AAPL | Stock | 0.6357 | 0.6361 | 0.6346 | 0.635 | 2980040.0 |
| 2004-09-07 11:05:00 | AAPL | Stock | 0.6352 | 0.6371 | 0.6352 | 0.6364 | 2051336.0 |
| 2004-09-07 11:10:00 | AAPL | Stock | 0.6361 | 0.637 | 0.6359 | 0.6363 | 4214616.0 |
| 2004-09-07 11:15:00 | AAPL | Stock | 0.6368 | 0.6384 | 0.6363 | 0.6377 | 1237600.0 |
| 2004-09-07 11:20:00 | AAPL | Stock | 0.6377 | 0.6409 | 0.6377 | 0.6409 | 3807944.0 |
| 2004-09-07 11:25:00 | AAPL | Stock | 0.6407 | 0.6409 | 0.6396 | 0.64 | 1342880.0 |
| 2004-09-07 11:30:00 | AAPL | Stock | 0.64 | 0.6411 | 0.6396 | 0.6404 | 3973592.0 |
| 2004-09-07 11:35:00 | AAPL | Stock | 0.6407 | 0.6411 | 0.6402 | 0.6409 | 1950816.0 |
| 2004-09-07 11:40:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6404 | 0.6407 | 1625064.0 |
| 2004-09-07 11:45:00 | AAPL | Stock | 0.6409 | 0.6413 | 0.6405 | 0.6411 | 2322264.0 |
| 2004-09-07 11:50:00 | AAPL | Stock | 0.6411 | 0.6421 | 0.6409 | 0.6416 | 12468624.0 |
| 2004-09-07 11:55:00 | AAPL | Stock | 0.6416 | 0.6427 | 0.6416 | 0.6421 | 6262592.0 |
| 2004-09-07 12:00:00 | AAPL | Stock | 0.642 | 0.6457 | 0.6418 | 0.6455 | 15187648.0 |
| 2004-09-07 12:05:00 | AAPL | Stock | 0.6455 | 0.6463 | 0.6436 | 0.6441 | 8871800.0 |
| 2004-09-07 12:10:00 | AAPL | Stock | 0.6439 | 0.6445 | 0.643 | 0.6438 | 1864520.0 |
| 2004-09-07 12:15:00 | AAPL | Stock | 0.6438 | 0.6438 | 0.6414 | 0.642 | 3766616.0 |
| 2004-09-07 12:20:00 | AAPL | Stock | 0.642 | 0.6423 | 0.6407 | 0.6407 | 3428936.0 |
| 2004-09-07 12:25:00 | AAPL | Stock | 0.6407 | 0.6423 | 0.6407 | 0.6418 | 1581272.0 |
| 2004-09-07 12:30:00 | AAPL | Stock | 0.6418 | 0.642 | 0.6409 | 0.6418 | 705600.0 |
| 2004-09-07 12:35:00 | AAPL | Stock | 0.642 | 0.6429 | 0.6418 | 0.6429 | 1836296.0 |
| 2004-09-07 12:40:00 | AAPL | Stock | 0.6425 | 0.6429 | 0.642 | 0.6421 | 1444016.0 |
| 2004-09-07 12:45:00 | AAPL | Stock | 0.642 | 0.6425 | 0.6413 | 0.6414 | 2648520.0 |
| 2004-09-07 12:50:00 | AAPL | Stock | 0.6414 | 0.6427 | 0.6411 | 0.6413 | 1515976.0 |
| 2004-09-07 12:55:00 | AAPL | Stock | 0.6414 | 0.6429 | 0.6409 | 0.6421 | 1574440.0 |
| 2004-09-07 13:00:00 | AAPL | Stock | 0.6421 | 0.6429 | 0.642 | 0.6425 | 2463664.0 |
| 2004-09-07 13:05:00 | AAPL | Stock | 0.6425 | 0.6427 | 0.6414 | 0.6414 | 549136.0 |
> showing 50 of 176,800 rows — these rows as CSV