PREVIEW / stock_5min / 2004-10-21
file: by_date/stock_5min/2004/2004-10-21.parquet size: 2.5 MB rows: 179,718 symbols: 1,846
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-10-21 08:20:00 | AAPL | Stock | 0.8443 | 0.8443 | 0.842 | 0.842 | 22400.0 |
| 2004-10-21 08:35:00 | AAPL | Stock | 0.8482 | 0.8482 | 0.8482 | 0.8482 | 5600.0 |
| 2004-10-21 08:40:00 | AAPL | Stock | 0.8482 | 0.8482 | 0.8482 | 0.8482 | 16800.0 |
| 2004-10-21 08:45:00 | AAPL | Stock | 0.8482 | 0.8482 | 0.8477 | 0.8477 | 11200.0 |
| 2004-10-21 08:50:00 | AAPL | Stock | 0.8482 | 0.8482 | 0.8482 | 0.8482 | 5600.0 |
| 2004-10-21 08:55:00 | AAPL | Stock | 0.8518 | 0.8518 | 0.8482 | 0.8482 | 120960.0 |
| 2004-10-21 09:05:00 | AAPL | Stock | 0.8488 | 0.8488 | 0.8482 | 0.8482 | 319200.0 |
| 2004-10-21 09:20:00 | AAPL | Stock | 0.8491 | 0.8491 | 0.8491 | 0.8491 | 56000.0 |
| 2004-10-21 09:25:00 | AAPL | Stock | 0.8491 | 0.8521 | 0.842 | 0.8521 | 1559152.0 |
| 2004-10-21 09:30:00 | AAPL | Stock | 0.8507 | 0.8523 | 0.8457 | 0.8513 | 22717072.0 |
| 2004-10-21 09:35:00 | AAPL | Stock | 0.8509 | 0.8527 | 0.8482 | 0.8509 | 11714024.0 |
| 2004-10-21 09:40:00 | AAPL | Stock | 0.8513 | 0.8523 | 0.8493 | 0.8516 | 11286296.0 |
| 2004-10-21 09:45:00 | AAPL | Stock | 0.8514 | 0.8571 | 0.8509 | 0.8564 | 18438672.0 |
| 2004-10-21 09:50:00 | AAPL | Stock | 0.8564 | 0.8595 | 0.8563 | 0.8563 | 19211024.0 |
| 2004-10-21 09:55:00 | AAPL | Stock | 0.8563 | 0.8582 | 0.8555 | 0.8564 | 8405712.0 |
| 2004-10-21 10:00:00 | AAPL | Stock | 0.8568 | 0.8588 | 0.855 | 0.855 | 11372256.0 |
| 2004-10-21 10:05:00 | AAPL | Stock | 0.8552 | 0.8557 | 0.8518 | 0.8543 | 11496520.0 |
| 2004-10-21 10:10:00 | AAPL | Stock | 0.8541 | 0.8543 | 0.8495 | 0.8509 | 12409488.0 |
| 2004-10-21 10:15:00 | AAPL | Stock | 0.8511 | 0.8532 | 0.8504 | 0.8518 | 10094056.0 |
| 2004-10-21 10:20:00 | AAPL | Stock | 0.8516 | 0.8527 | 0.8505 | 0.8523 | 4032840.0 |
| 2004-10-21 10:25:00 | AAPL | Stock | 0.8523 | 0.8554 | 0.8521 | 0.8552 | 3222968.0 |
| 2004-10-21 10:30:00 | AAPL | Stock | 0.8548 | 0.8552 | 0.8521 | 0.8546 | 3704736.0 |
| 2004-10-21 10:35:00 | AAPL | Stock | 0.8541 | 0.8545 | 0.8514 | 0.8529 | 4730936.0 |
| 2004-10-21 10:40:00 | AAPL | Stock | 0.8529 | 0.8554 | 0.8527 | 0.8541 | 4353720.0 |
| 2004-10-21 10:45:00 | AAPL | Stock | 0.8541 | 0.8561 | 0.8541 | 0.8559 | 2259040.0 |
| 2004-10-21 10:50:00 | AAPL | Stock | 0.8557 | 0.8559 | 0.8539 | 0.8546 | 3878000.0 |
| 2004-10-21 10:55:00 | AAPL | Stock | 0.8546 | 0.8554 | 0.8545 | 0.8554 | 4695096.0 |
| 2004-10-21 11:00:00 | AAPL | Stock | 0.8554 | 0.8555 | 0.8545 | 0.8546 | 4279744.0 |
| 2004-10-21 11:05:00 | AAPL | Stock | 0.8546 | 0.8557 | 0.8541 | 0.8557 | 8113728.0 |
| 2004-10-21 11:10:00 | AAPL | Stock | 0.8557 | 0.8561 | 0.8546 | 0.855 | 3776864.0 |
| 2004-10-21 11:15:00 | AAPL | Stock | 0.8548 | 0.8552 | 0.8539 | 0.8539 | 3331048.0 |
| 2004-10-21 11:20:00 | AAPL | Stock | 0.8538 | 0.8538 | 0.8525 | 0.8538 | 4458272.0 |
| 2004-10-21 11:25:00 | AAPL | Stock | 0.8536 | 0.8543 | 0.8532 | 0.8539 | 1758064.0 |
| 2004-10-21 11:30:00 | AAPL | Stock | 0.8539 | 0.8545 | 0.8532 | 0.8532 | 5165608.0 |
| 2004-10-21 11:35:00 | AAPL | Stock | 0.8534 | 0.8545 | 0.853 | 0.8541 | 2735992.0 |
| 2004-10-21 11:40:00 | AAPL | Stock | 0.8543 | 0.8548 | 0.8532 | 0.8539 | 2994208.0 |
| 2004-10-21 11:45:00 | AAPL | Stock | 0.8541 | 0.8548 | 0.8532 | 0.8546 | 3594416.0 |
| 2004-10-21 11:50:00 | AAPL | Stock | 0.8548 | 0.8554 | 0.8546 | 0.855 | 1890392.0 |
| 2004-10-21 11:55:00 | AAPL | Stock | 0.855 | 0.8555 | 0.8538 | 0.8555 | 3614240.0 |
| 2004-10-21 12:00:00 | AAPL | Stock | 0.8555 | 0.8561 | 0.8543 | 0.8546 | 13544664.0 |
| 2004-10-21 12:05:00 | AAPL | Stock | 0.8545 | 0.8554 | 0.8527 | 0.8554 | 6717368.0 |
| 2004-10-21 12:10:00 | AAPL | Stock | 0.8554 | 0.8579 | 0.855 | 0.857 | 10111080.0 |
| 2004-10-21 12:15:00 | AAPL | Stock | 0.8568 | 0.8573 | 0.8551 | 0.8557 | 9229640.0 |
| 2004-10-21 12:20:00 | AAPL | Stock | 0.8563 | 0.8571 | 0.8557 | 0.8563 | 3254832.0 |
| 2004-10-21 12:25:00 | AAPL | Stock | 0.8559 | 0.8568 | 0.8523 | 0.8538 | 5103224.0 |
| 2004-10-21 12:30:00 | AAPL | Stock | 0.8539 | 0.8548 | 0.8516 | 0.853 | 5565392.0 |
| 2004-10-21 12:35:00 | AAPL | Stock | 0.853 | 0.8536 | 0.8514 | 0.8525 | 3730440.0 |
| 2004-10-21 12:40:00 | AAPL | Stock | 0.8521 | 0.8545 | 0.8518 | 0.8534 | 4064032.0 |
| 2004-10-21 12:45:00 | AAPL | Stock | 0.8536 | 0.8543 | 0.8523 | 0.8523 | 3428432.0 |
| 2004-10-21 12:50:00 | AAPL | Stock | 0.8525 | 0.8538 | 0.8523 | 0.8536 | 2288216.0 |
> showing 50 of 179,718 rows — these rows as CSV