PREVIEW / stock_5min / 2007-05-17
file: by_date/stock_5min/2007/2007-05-17.parquet size: 3.9 MB rows: 291,590 symbols: 2,993
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-17 09:30:00 | AAPL | Stock | 3.8268 | 3.8475 | 3.8268 | 3.8433 | 14470204.0 |
| 2007-05-17 09:35:00 | AAPL | Stock | 3.8432 | 3.8561 | 3.8432 | 3.8557 | 12674816.0 |
| 2007-05-17 09:40:00 | AAPL | Stock | 3.8561 | 3.875 | 3.8561 | 3.8604 | 21614516.0 |
| 2007-05-17 09:45:00 | AAPL | Stock | 3.8607 | 3.8711 | 3.8561 | 3.8611 | 15839348.0 |
| 2007-05-17 09:50:00 | AAPL | Stock | 3.8607 | 3.8668 | 3.8479 | 3.8543 | 11244800.0 |
| 2007-05-17 09:55:00 | AAPL | Stock | 3.8536 | 3.8654 | 3.8525 | 3.8626 | 8459948.0 |
| 2007-05-17 10:00:00 | AAPL | Stock | 3.8625 | 3.8704 | 3.8561 | 3.8685 | 10427592.0 |
| 2007-05-17 10:05:00 | AAPL | Stock | 3.8682 | 3.875 | 3.8671 | 3.8721 | 14915320.0 |
| 2007-05-17 10:10:00 | AAPL | Stock | 3.8718 | 3.8732 | 3.8668 | 3.8725 | 8198680.0 |
| 2007-05-17 10:15:00 | AAPL | Stock | 3.8725 | 3.8779 | 3.8639 | 3.8664 | 14473956.0 |
| 2007-05-17 10:20:00 | AAPL | Stock | 3.8668 | 3.8739 | 3.8643 | 3.8696 | 7166572.0 |
| 2007-05-17 10:25:00 | AAPL | Stock | 3.87 | 3.8707 | 3.8618 | 3.8621 | 6039012.0 |
| 2007-05-17 10:30:00 | AAPL | Stock | 3.8621 | 3.8654 | 3.8593 | 3.8607 | 6944896.0 |
| 2007-05-17 10:35:00 | AAPL | Stock | 3.8609 | 3.8632 | 3.8536 | 3.8582 | 10283868.0 |
| 2007-05-17 10:40:00 | AAPL | Stock | 3.8582 | 3.8629 | 3.8554 | 3.8571 | 4957456.0 |
| 2007-05-17 10:45:00 | AAPL | Stock | 3.8571 | 3.8621 | 3.8554 | 3.8613 | 6078212.0 |
| 2007-05-17 10:50:00 | AAPL | Stock | 3.8614 | 3.8679 | 3.8589 | 3.8646 | 5231408.0 |
| 2007-05-17 10:55:00 | AAPL | Stock | 3.8643 | 3.8675 | 3.8604 | 3.8675 | 4381860.0 |
| 2007-05-17 11:00:00 | AAPL | Stock | 3.8671 | 3.8704 | 3.8607 | 3.8629 | 8487024.0 |
| 2007-05-17 11:05:00 | AAPL | Stock | 3.8629 | 3.8664 | 3.8607 | 3.8632 | 5372164.0 |
| 2007-05-17 11:10:00 | AAPL | Stock | 3.8632 | 3.8657 | 3.8607 | 3.8636 | 3217452.0 |
| 2007-05-17 11:15:00 | AAPL | Stock | 3.8632 | 3.8636 | 3.8607 | 3.8607 | 2196852.0 |
| 2007-05-17 11:20:00 | AAPL | Stock | 3.8611 | 3.8618 | 3.8536 | 3.8564 | 7397124.0 |
| 2007-05-17 11:25:00 | AAPL | Stock | 3.8568 | 3.8593 | 3.8536 | 3.8536 | 3826144.0 |
| 2007-05-17 11:30:00 | AAPL | Stock | 3.8536 | 3.8586 | 3.8504 | 3.8575 | 5879720.0 |
| 2007-05-17 11:35:00 | AAPL | Stock | 3.8579 | 3.8611 | 3.8539 | 3.8582 | 4015872.0 |
| 2007-05-17 11:40:00 | AAPL | Stock | 3.8582 | 3.8596 | 3.8557 | 3.8571 | 3416028.0 |
| 2007-05-17 11:45:00 | AAPL | Stock | 3.8571 | 3.865 | 3.8564 | 3.8596 | 6827744.0 |
| 2007-05-17 11:50:00 | AAPL | Stock | 3.86 | 3.8607 | 3.8564 | 3.8571 | 4529168.0 |
| 2007-05-17 11:55:00 | AAPL | Stock | 3.8571 | 3.86 | 3.8561 | 3.8575 | 1973860.0 |
| 2007-05-17 12:00:00 | AAPL | Stock | 3.8579 | 3.8604 | 3.8514 | 3.8564 | 7409332.0 |
| 2007-05-17 12:05:00 | AAPL | Stock | 3.8564 | 3.8568 | 3.8518 | 3.8522 | 3063004.0 |
| 2007-05-17 12:10:00 | AAPL | Stock | 3.8521 | 3.8543 | 3.8468 | 3.8521 | 6775076.0 |
| 2007-05-17 12:15:00 | AAPL | Stock | 3.8518 | 3.8564 | 3.8496 | 3.8543 | 6027028.0 |
| 2007-05-17 12:20:00 | AAPL | Stock | 3.8539 | 3.8546 | 3.8464 | 3.85 | 4739420.0 |
| 2007-05-17 12:25:00 | AAPL | Stock | 3.8504 | 3.8536 | 3.8493 | 3.8507 | 2205504.0 |
| 2007-05-17 12:30:00 | AAPL | Stock | 3.8504 | 3.8507 | 3.8436 | 3.8454 | 4493104.0 |
| 2007-05-17 12:35:00 | AAPL | Stock | 3.8454 | 3.85 | 3.8404 | 3.8486 | 7264264.0 |
| 2007-05-17 12:40:00 | AAPL | Stock | 3.8482 | 3.8486 | 3.8446 | 3.8457 | 2889712.0 |
| 2007-05-17 12:45:00 | AAPL | Stock | 3.8457 | 3.85 | 3.8454 | 3.85 | 3179904.0 |
| 2007-05-17 12:50:00 | AAPL | Stock | 3.85 | 3.8536 | 3.8479 | 3.8504 | 3091732.0 |
| 2007-05-17 12:55:00 | AAPL | Stock | 3.8507 | 3.8507 | 3.845 | 3.8464 | 2326408.0 |
| 2007-05-17 13:00:00 | AAPL | Stock | 3.8461 | 3.8504 | 3.8429 | 3.8496 | 4153380.0 |
| 2007-05-17 13:05:00 | AAPL | Stock | 3.8497 | 3.8532 | 3.8464 | 3.8514 | 3511592.0 |
| 2007-05-17 13:10:00 | AAPL | Stock | 3.8518 | 3.8518 | 3.8475 | 3.8475 | 2142588.0 |
| 2007-05-17 13:15:00 | AAPL | Stock | 3.8479 | 3.8514 | 3.8475 | 3.8514 | 1491028.0 |
| 2007-05-17 13:20:00 | AAPL | Stock | 3.8514 | 3.8525 | 3.8475 | 3.8496 | 3253124.0 |
| 2007-05-17 13:25:00 | AAPL | Stock | 3.8496 | 3.8529 | 3.8489 | 3.8521 | 3193904.0 |
| 2007-05-17 13:30:00 | AAPL | Stock | 3.8521 | 3.8571 | 3.8518 | 3.8561 | 4152792.0 |
| 2007-05-17 13:35:00 | AAPL | Stock | 3.8561 | 3.8564 | 3.8525 | 3.8532 | 3074008.0 |
> showing 50 of 291,590 rows — these rows as CSV