PREVIEW / stock_5min / 2004-10-19
file: by_date/stock_5min/2004/2004-10-19.parquet size: 2.5 MB rows: 177,518 symbols: 1,842
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-19 08:05:00 | AAPL | Stock | 0.8616 | 0.8616 | 0.8616 | 0.8616 | 19600.0 |
| 2004-10-19 08:10:00 | AAPL | Stock | 0.8589 | 0.8623 | 0.8571 | 0.8591 | 416920.0 |
| 2004-10-19 08:15:00 | AAPL | Stock | 0.8616 | 0.8625 | 0.8593 | 0.8607 | 1355088.0 |
| 2004-10-19 08:20:00 | AAPL | Stock | 0.8598 | 0.8598 | 0.8573 | 0.8588 | 490280.0 |
| 2004-10-19 08:25:00 | AAPL | Stock | 0.8588 | 0.8589 | 0.858 | 0.8589 | 359800.0 |
| 2004-10-19 08:30:00 | AAPL | Stock | 0.858 | 0.8589 | 0.858 | 0.858 | 285040.0 |
| 2004-10-19 08:35:00 | AAPL | Stock | 0.8588 | 0.8589 | 0.8588 | 0.8589 | 761600.0 |
| 2004-10-19 08:40:00 | AAPL | Stock | 0.8589 | 0.8589 | 0.8543 | 0.8589 | 654864.0 |
| 2004-10-19 08:45:00 | AAPL | Stock | 0.8589 | 0.8589 | 0.858 | 0.8582 | 69664.0 |
| 2004-10-19 08:50:00 | AAPL | Stock | 0.8582 | 0.8582 | 0.858 | 0.858 | 115080.0 |
| 2004-10-19 08:55:00 | AAPL | Stock | 0.858 | 0.858 | 0.858 | 0.858 | 116704.0 |
| 2004-10-19 09:00:00 | AAPL | Stock | 0.858 | 0.8591 | 0.858 | 0.8591 | 207200.0 |
| 2004-10-19 09:05:00 | AAPL | Stock | 0.8589 | 0.8598 | 0.8589 | 0.8589 | 348880.0 |
| 2004-10-19 09:10:00 | AAPL | Stock | 0.8591 | 0.8591 | 0.8573 | 0.8591 | 361760.0 |
| 2004-10-19 09:15:00 | AAPL | Stock | 0.8591 | 0.8593 | 0.8589 | 0.8589 | 733600.0 |
| 2004-10-19 09:20:00 | AAPL | Stock | 0.8591 | 0.8595 | 0.8573 | 0.8573 | 224000.0 |
| 2004-10-19 09:25:00 | AAPL | Stock | 0.8573 | 0.8598 | 0.8527 | 0.8589 | 4230856.0 |
| 2004-10-19 09:30:00 | AAPL | Stock | 0.8589 | 0.8614 | 0.8504 | 0.8543 | 37889936.0 |
| 2004-10-19 09:35:00 | AAPL | Stock | 0.8545 | 0.8546 | 0.8496 | 0.8509 | 15733480.0 |
| 2004-10-19 09:40:00 | AAPL | Stock | 0.8504 | 0.857 | 0.8504 | 0.8559 | 12060328.0 |
| 2004-10-19 09:45:00 | AAPL | Stock | 0.8559 | 0.8575 | 0.855 | 0.857 | 13329232.0 |
| 2004-10-19 09:50:00 | AAPL | Stock | 0.8561 | 0.8566 | 0.85 | 0.8518 | 15854216.0 |
| 2004-10-19 09:55:00 | AAPL | Stock | 0.8518 | 0.8539 | 0.85 | 0.8509 | 12397840.0 |
| 2004-10-19 10:00:00 | AAPL | Stock | 0.8511 | 0.8554 | 0.8507 | 0.855 | 11633720.0 |
| 2004-10-19 10:05:00 | AAPL | Stock | 0.855 | 0.8588 | 0.8545 | 0.8579 | 24280816.0 |
| 2004-10-19 10:10:00 | AAPL | Stock | 0.8579 | 0.8613 | 0.8568 | 0.8596 | 15429848.0 |
| 2004-10-19 10:15:00 | AAPL | Stock | 0.86 | 0.8602 | 0.8554 | 0.8571 | 20501824.0 |
| 2004-10-19 10:20:00 | AAPL | Stock | 0.8571 | 0.8589 | 0.8564 | 0.8588 | 10851792.0 |
| 2004-10-19 10:25:00 | AAPL | Stock | 0.8589 | 0.8589 | 0.8566 | 0.8582 | 7307552.0 |
| 2004-10-19 10:30:00 | AAPL | Stock | 0.8579 | 0.8634 | 0.8579 | 0.8589 | 18985344.0 |
| 2004-10-19 10:35:00 | AAPL | Stock | 0.8595 | 0.8598 | 0.8568 | 0.8584 | 16942352.0 |
| 2004-10-19 10:40:00 | AAPL | Stock | 0.8582 | 0.8586 | 0.8555 | 0.8586 | 10188472.0 |
| 2004-10-19 10:45:00 | AAPL | Stock | 0.8588 | 0.8593 | 0.8571 | 0.8584 | 9000824.0 |
| 2004-10-19 10:50:00 | AAPL | Stock | 0.8582 | 0.8586 | 0.8571 | 0.858 | 9268392.0 |
| 2004-10-19 10:55:00 | AAPL | Stock | 0.858 | 0.8588 | 0.8561 | 0.8566 | 7625576.0 |
| 2004-10-19 11:00:00 | AAPL | Stock | 0.8571 | 0.8596 | 0.8566 | 0.8566 | 7910728.0 |
| 2004-10-19 11:05:00 | AAPL | Stock | 0.8566 | 0.8566 | 0.8532 | 0.8545 | 13033328.0 |
| 2004-10-19 11:10:00 | AAPL | Stock | 0.8543 | 0.8566 | 0.8536 | 0.8548 | 8031520.0 |
| 2004-10-19 11:15:00 | AAPL | Stock | 0.8548 | 0.8559 | 0.852 | 0.8521 | 8803312.0 |
| 2004-10-19 11:20:00 | AAPL | Stock | 0.8523 | 0.8536 | 0.8491 | 0.8532 | 10259760.0 |
| 2004-10-19 11:25:00 | AAPL | Stock | 0.8532 | 0.8557 | 0.853 | 0.855 | 9953328.0 |
| 2004-10-19 11:30:00 | AAPL | Stock | 0.855 | 0.8593 | 0.855 | 0.8591 | 10434480.0 |
| 2004-10-19 11:35:00 | AAPL | Stock | 0.8591 | 0.8602 | 0.8577 | 0.8588 | 12692680.0 |
| 2004-10-19 11:40:00 | AAPL | Stock | 0.8588 | 0.8598 | 0.858 | 0.8593 | 7613592.0 |
| 2004-10-19 11:45:00 | AAPL | Stock | 0.8593 | 0.8593 | 0.8561 | 0.8563 | 8062936.0 |
| 2004-10-19 11:50:00 | AAPL | Stock | 0.8563 | 0.8577 | 0.8559 | 0.8571 | 4128768.0 |
| 2004-10-19 11:55:00 | AAPL | Stock | 0.8571 | 0.8571 | 0.8548 | 0.857 | 6013896.0 |
| 2004-10-19 12:00:00 | AAPL | Stock | 0.8563 | 0.8602 | 0.8563 | 0.8598 | 11529000.0 |
| 2004-10-19 12:05:00 | AAPL | Stock | 0.86 | 0.8611 | 0.8589 | 0.8589 | 9710624.0 |
| 2004-10-19 12:10:00 | AAPL | Stock | 0.8591 | 0.8593 | 0.8571 | 0.8573 | 6865040.0 |
> showing 50 of 177,518 rows — these rows as CSV