PREVIEW / stock_5min / 2004-09-16
file: by_date/stock_5min/2004/2004-09-16.parquet size: 2.3 MB rows: 171,756 symbols: 1,820
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-16 08:55:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6293 | 0.6293 | 16800.0 |
| 2004-09-16 09:15:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6293 | 0.6293 | 33600.0 |
| 2004-09-16 09:20:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6286 | 0.6286 | 11200.0 |
| 2004-09-16 09:25:00 | AAPL | Stock | 0.6289 | 0.6368 | 0.6257 | 0.6302 | 950936.0 |
| 2004-09-16 09:30:00 | AAPL | Stock | 0.6286 | 0.6341 | 0.6271 | 0.6338 | 8683080.0 |
| 2004-09-16 09:35:00 | AAPL | Stock | 0.6338 | 0.6361 | 0.6334 | 0.635 | 6244728.0 |
| 2004-09-16 09:40:00 | AAPL | Stock | 0.6339 | 0.6363 | 0.6336 | 0.6363 | 3436272.0 |
| 2004-09-16 09:45:00 | AAPL | Stock | 0.6364 | 0.6402 | 0.6363 | 0.6391 | 13328840.0 |
| 2004-09-16 09:50:00 | AAPL | Stock | 0.6389 | 0.6398 | 0.6384 | 0.6384 | 9638216.0 |
| 2004-09-16 09:55:00 | AAPL | Stock | 0.6382 | 0.6393 | 0.637 | 0.6391 | 7249928.0 |
| 2004-09-16 10:00:00 | AAPL | Stock | 0.6393 | 0.64 | 0.6377 | 0.6382 | 9677024.0 |
| 2004-09-16 10:05:00 | AAPL | Stock | 0.6382 | 0.6402 | 0.6379 | 0.6393 | 5295248.0 |
| 2004-09-16 10:10:00 | AAPL | Stock | 0.6393 | 0.6411 | 0.6393 | 0.6411 | 5504128.0 |
| 2004-09-16 10:15:00 | AAPL | Stock | 0.6411 | 0.6455 | 0.6411 | 0.6452 | 13137320.0 |
| 2004-09-16 10:20:00 | AAPL | Stock | 0.6454 | 0.6461 | 0.6445 | 0.6457 | 10563560.0 |
| 2004-09-16 10:25:00 | AAPL | Stock | 0.6457 | 0.6509 | 0.6455 | 0.6507 | 10605616.0 |
| 2004-09-16 10:30:00 | AAPL | Stock | 0.6509 | 0.6563 | 0.6502 | 0.6561 | 22641864.0 |
| 2004-09-16 10:35:00 | AAPL | Stock | 0.6563 | 0.6564 | 0.6496 | 0.6498 | 18682664.0 |
| 2004-09-16 10:40:00 | AAPL | Stock | 0.6495 | 0.6536 | 0.6495 | 0.6536 | 8888992.0 |
| 2004-09-16 10:45:00 | AAPL | Stock | 0.6536 | 0.6546 | 0.6516 | 0.652 | 9811480.0 |
| 2004-09-16 10:50:00 | AAPL | Stock | 0.652 | 0.652 | 0.6502 | 0.6504 | 4224696.0 |
| 2004-09-16 10:55:00 | AAPL | Stock | 0.6504 | 0.6505 | 0.6473 | 0.6477 | 10025120.0 |
| 2004-09-16 11:00:00 | AAPL | Stock | 0.6475 | 0.6477 | 0.6446 | 0.6448 | 10292408.0 |
| 2004-09-16 11:05:00 | AAPL | Stock | 0.6448 | 0.647 | 0.6443 | 0.647 | 9009000.0 |
| 2004-09-16 11:10:00 | AAPL | Stock | 0.647 | 0.6491 | 0.6468 | 0.6477 | 9533160.0 |
| 2004-09-16 11:15:00 | AAPL | Stock | 0.6477 | 0.6491 | 0.6473 | 0.6489 | 3538584.0 |
| 2004-09-16 11:20:00 | AAPL | Stock | 0.6488 | 0.65 | 0.6482 | 0.65 | 1617952.0 |
| 2004-09-16 11:25:00 | AAPL | Stock | 0.65 | 0.6518 | 0.6498 | 0.6516 | 5526304.0 |
| 2004-09-16 11:30:00 | AAPL | Stock | 0.6518 | 0.6518 | 0.6509 | 0.6511 | 5687360.0 |
| 2004-09-16 11:35:00 | AAPL | Stock | 0.6513 | 0.6516 | 0.6484 | 0.6488 | 3010784.0 |
| 2004-09-16 11:40:00 | AAPL | Stock | 0.6489 | 0.6495 | 0.6475 | 0.6475 | 2291240.0 |
| 2004-09-16 11:45:00 | AAPL | Stock | 0.648 | 0.6488 | 0.648 | 0.648 | 1172360.0 |
| 2004-09-16 11:50:00 | AAPL | Stock | 0.6482 | 0.6489 | 0.6477 | 0.6482 | 949648.0 |
| 2004-09-16 11:55:00 | AAPL | Stock | 0.6482 | 0.6482 | 0.6468 | 0.647 | 1876896.0 |
| 2004-09-16 12:00:00 | AAPL | Stock | 0.647 | 0.6473 | 0.6439 | 0.6463 | 7416360.0 |
| 2004-09-16 12:05:00 | AAPL | Stock | 0.6464 | 0.6496 | 0.6463 | 0.648 | 4701872.0 |
| 2004-09-16 12:10:00 | AAPL | Stock | 0.6482 | 0.6496 | 0.6482 | 0.6495 | 2423120.0 |
| 2004-09-16 12:15:00 | AAPL | Stock | 0.6491 | 0.6502 | 0.6488 | 0.6498 | 2199400.0 |
| 2004-09-16 12:20:00 | AAPL | Stock | 0.6498 | 0.6507 | 0.6491 | 0.6507 | 2334192.0 |
| 2004-09-16 12:25:00 | AAPL | Stock | 0.6507 | 0.6511 | 0.6502 | 0.6509 | 2144072.0 |
| 2004-09-16 12:30:00 | AAPL | Stock | 0.6509 | 0.653 | 0.6509 | 0.653 | 4514496.0 |
| 2004-09-16 12:35:00 | AAPL | Stock | 0.653 | 0.6536 | 0.652 | 0.6529 | 3613736.0 |
| 2004-09-16 12:40:00 | AAPL | Stock | 0.6527 | 0.6532 | 0.6514 | 0.6518 | 5928216.0 |
| 2004-09-16 12:45:00 | AAPL | Stock | 0.6516 | 0.6518 | 0.6493 | 0.6495 | 6115704.0 |
| 2004-09-16 12:50:00 | AAPL | Stock | 0.6493 | 0.6498 | 0.6491 | 0.6493 | 3633952.0 |
| 2004-09-16 12:55:00 | AAPL | Stock | 0.6495 | 0.6495 | 0.6482 | 0.6486 | 1474256.0 |
| 2004-09-16 13:00:00 | AAPL | Stock | 0.6486 | 0.65 | 0.6482 | 0.6496 | 1430912.0 |
| 2004-09-16 13:05:00 | AAPL | Stock | 0.6496 | 0.6498 | 0.6491 | 0.6495 | 3952424.0 |
| 2004-09-16 13:10:00 | AAPL | Stock | 0.6498 | 0.65 | 0.6495 | 0.6498 | 2039016.0 |
| 2004-09-16 13:15:00 | AAPL | Stock | 0.6498 | 0.6502 | 0.6496 | 0.65 | 2179520.0 |
> showing 50 of 171,756 rows — these rows as CSV