PREVIEW / stock_5min / 2004-09-08
file: by_date/stock_5min/2004/2004-09-08.parquet size: 2.4 MB rows: 175,677 symbols: 1,836
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-08 08:40:00 | AAPL | Stock | 0.6386 | 0.6386 | 0.6386 | 0.6386 | 11200.0 |
| 2004-09-08 09:10:00 | AAPL | Stock | 0.6373 | 0.6373 | 0.6373 | 0.6373 | 7840.0 |
| 2004-09-08 09:20:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6373 | 0.6373 | 165088.0 |
| 2004-09-08 09:25:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6373 | 0.6375 | 322000.0 |
| 2004-09-08 09:30:00 | AAPL | Stock | 0.6375 | 0.6418 | 0.6375 | 0.6409 | 9655016.0 |
| 2004-09-08 09:35:00 | AAPL | Stock | 0.6405 | 0.6414 | 0.64 | 0.6414 | 4058264.0 |
| 2004-09-08 09:40:00 | AAPL | Stock | 0.6414 | 0.6455 | 0.6414 | 0.6448 | 11492992.0 |
| 2004-09-08 09:45:00 | AAPL | Stock | 0.6448 | 0.6455 | 0.643 | 0.6452 | 8186808.0 |
| 2004-09-08 09:50:00 | AAPL | Stock | 0.6454 | 0.6454 | 0.6429 | 0.6446 | 5357520.0 |
| 2004-09-08 09:55:00 | AAPL | Stock | 0.6446 | 0.6448 | 0.643 | 0.6434 | 2868992.0 |
| 2004-09-08 10:00:00 | AAPL | Stock | 0.6436 | 0.6468 | 0.6416 | 0.6468 | 8614200.0 |
| 2004-09-08 10:05:00 | AAPL | Stock | 0.6468 | 0.6473 | 0.6454 | 0.6471 | 8280440.0 |
| 2004-09-08 10:10:00 | AAPL | Stock | 0.6473 | 0.6504 | 0.6466 | 0.65 | 10765776.0 |
| 2004-09-08 10:15:00 | AAPL | Stock | 0.6504 | 0.6518 | 0.6459 | 0.6459 | 13783448.0 |
| 2004-09-08 10:20:00 | AAPL | Stock | 0.6459 | 0.6509 | 0.6459 | 0.6502 | 5356736.0 |
| 2004-09-08 10:25:00 | AAPL | Stock | 0.6505 | 0.6525 | 0.6498 | 0.6518 | 6773256.0 |
| 2004-09-08 10:30:00 | AAPL | Stock | 0.6521 | 0.653 | 0.6498 | 0.6507 | 10554656.0 |
| 2004-09-08 10:35:00 | AAPL | Stock | 0.6505 | 0.6527 | 0.6489 | 0.6507 | 5888680.0 |
| 2004-09-08 10:40:00 | AAPL | Stock | 0.6504 | 0.6511 | 0.648 | 0.648 | 7379512.0 |
| 2004-09-08 10:45:00 | AAPL | Stock | 0.6482 | 0.6484 | 0.6463 | 0.6466 | 6734448.0 |
| 2004-09-08 10:50:00 | AAPL | Stock | 0.6463 | 0.6482 | 0.6459 | 0.6473 | 7595224.0 |
| 2004-09-08 10:55:00 | AAPL | Stock | 0.6473 | 0.6486 | 0.6464 | 0.648 | 3445232.0 |
| 2004-09-08 11:00:00 | AAPL | Stock | 0.6482 | 0.6482 | 0.647 | 0.647 | 3013360.0 |
| 2004-09-08 11:05:00 | AAPL | Stock | 0.647 | 0.6484 | 0.6466 | 0.6484 | 3798704.0 |
| 2004-09-08 11:10:00 | AAPL | Stock | 0.6484 | 0.6525 | 0.6482 | 0.6518 | 4647832.0 |
| 2004-09-08 11:15:00 | AAPL | Stock | 0.6516 | 0.6518 | 0.6498 | 0.6507 | 2816352.0 |
| 2004-09-08 11:20:00 | AAPL | Stock | 0.6509 | 0.6509 | 0.6491 | 0.6493 | 3525816.0 |
| 2004-09-08 11:25:00 | AAPL | Stock | 0.6493 | 0.6495 | 0.6479 | 0.6482 | 3723608.0 |
| 2004-09-08 11:30:00 | AAPL | Stock | 0.648 | 0.6489 | 0.6477 | 0.6489 | 2427040.0 |
| 2004-09-08 11:35:00 | AAPL | Stock | 0.6484 | 0.6513 | 0.6479 | 0.6495 | 4216408.0 |
| 2004-09-08 11:40:00 | AAPL | Stock | 0.6493 | 0.6495 | 0.6488 | 0.6489 | 2205224.0 |
| 2004-09-08 11:45:00 | AAPL | Stock | 0.6491 | 0.6495 | 0.6491 | 0.6495 | 924000.0 |
| 2004-09-08 11:50:00 | AAPL | Stock | 0.6495 | 0.6495 | 0.6473 | 0.6473 | 3811304.0 |
| 2004-09-08 11:55:00 | AAPL | Stock | 0.6473 | 0.6475 | 0.6455 | 0.6459 | 4538744.0 |
| 2004-09-08 12:00:00 | AAPL | Stock | 0.6461 | 0.6475 | 0.6455 | 0.6473 | 1837416.0 |
| 2004-09-08 12:05:00 | AAPL | Stock | 0.6473 | 0.6479 | 0.6455 | 0.6479 | 3446184.0 |
| 2004-09-08 12:10:00 | AAPL | Stock | 0.6473 | 0.6486 | 0.6473 | 0.6473 | 1361136.0 |
| 2004-09-08 12:15:00 | AAPL | Stock | 0.6473 | 0.6475 | 0.6464 | 0.6473 | 2486624.0 |
| 2004-09-08 12:20:00 | AAPL | Stock | 0.6473 | 0.6473 | 0.6461 | 0.6461 | 2455152.0 |
| 2004-09-08 12:25:00 | AAPL | Stock | 0.6461 | 0.6461 | 0.6448 | 0.6459 | 2166808.0 |
| 2004-09-08 12:30:00 | AAPL | Stock | 0.6454 | 0.6466 | 0.6441 | 0.6446 | 6503560.0 |
| 2004-09-08 12:35:00 | AAPL | Stock | 0.6446 | 0.6455 | 0.6436 | 0.6441 | 2730616.0 |
| 2004-09-08 12:40:00 | AAPL | Stock | 0.6441 | 0.645 | 0.6432 | 0.645 | 2419368.0 |
| 2004-09-08 12:45:00 | AAPL | Stock | 0.645 | 0.6471 | 0.6448 | 0.6466 | 1882384.0 |
| 2004-09-08 12:50:00 | AAPL | Stock | 0.6464 | 0.647 | 0.6459 | 0.6459 | 1471400.0 |
| 2004-09-08 12:55:00 | AAPL | Stock | 0.6459 | 0.6459 | 0.6445 | 0.6452 | 1272768.0 |
| 2004-09-08 13:00:00 | AAPL | Stock | 0.6452 | 0.6471 | 0.645 | 0.6463 | 2396744.0 |
| 2004-09-08 13:05:00 | AAPL | Stock | 0.6466 | 0.6471 | 0.6459 | 0.6471 | 1982512.0 |
| 2004-09-08 13:10:00 | AAPL | Stock | 0.647 | 0.6477 | 0.6466 | 0.6475 | 1128736.0 |
| 2004-09-08 13:15:00 | AAPL | Stock | 0.6475 | 0.6479 | 0.6464 | 0.6479 | 1533560.0 |
> showing 50 of 175,677 rows — these rows as CSV