PREVIEW / stock_5min / 2005-09-23
file: by_date/stock_5min/2005/2005-09-23.parquet size: 2.7 MB rows: 197,756 symbols: 2,074
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-23 08:00:00 | AAPL | Stock | 1.8571 | 1.8661 | 1.855 | 1.8611 | 185696.0 |
| 2005-09-23 08:05:00 | AAPL | Stock | 1.8614 | 1.8643 | 1.8614 | 1.8643 | 44800.0 |
| 2005-09-23 08:10:00 | AAPL | Stock | 1.8643 | 1.8682 | 1.8643 | 1.8682 | 149800.0 |
| 2005-09-23 08:15:00 | AAPL | Stock | 1.8661 | 1.8679 | 1.8643 | 1.8643 | 103768.0 |
| 2005-09-23 08:30:00 | AAPL | Stock | 1.8575 | 1.8625 | 1.8575 | 1.8625 | 7980.0 |
| 2005-09-23 08:35:00 | AAPL | Stock | 1.8586 | 1.8586 | 1.8571 | 1.8571 | 50400.0 |
| 2005-09-23 08:40:00 | AAPL | Stock | 1.8575 | 1.8575 | 1.8575 | 1.8575 | 2800.0 |
| 2005-09-23 08:45:00 | AAPL | Stock | 1.8579 | 1.8625 | 1.8575 | 1.8582 | 172900.0 |
| 2005-09-23 08:50:00 | AAPL | Stock | 1.8607 | 1.8643 | 1.8589 | 1.8643 | 48272.0 |
| 2005-09-23 08:55:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8636 | 1.8643 | 221200.0 |
| 2005-09-23 09:00:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8643 | 1.8643 | 14000.0 |
| 2005-09-23 09:05:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8614 | 1.8625 | 42000.0 |
| 2005-09-23 09:10:00 | AAPL | Stock | 1.8618 | 1.8618 | 1.8575 | 1.8579 | 290892.0 |
| 2005-09-23 09:15:00 | AAPL | Stock | 1.8596 | 1.8596 | 1.8589 | 1.8589 | 36092.0 |
| 2005-09-23 09:20:00 | AAPL | Stock | 1.8589 | 1.8589 | 1.8536 | 1.8543 | 386456.0 |
| 2005-09-23 09:25:00 | AAPL | Stock | 1.8546 | 1.8632 | 1.8546 | 1.8607 | 130340.0 |
| 2005-09-23 09:30:00 | AAPL | Stock | 1.8607 | 1.8689 | 1.8557 | 1.8607 | 10905804.0 |
| 2005-09-23 09:35:00 | AAPL | Stock | 1.8596 | 1.8611 | 1.8571 | 1.8579 | 7187740.0 |
| 2005-09-23 09:40:00 | AAPL | Stock | 1.8582 | 1.8607 | 1.8514 | 1.8521 | 7139832.0 |
| 2005-09-23 09:45:00 | AAPL | Stock | 1.8521 | 1.8654 | 1.8521 | 1.8629 | 14932848.0 |
| 2005-09-23 09:50:00 | AAPL | Stock | 1.8632 | 1.8643 | 1.8589 | 1.8604 | 8104348.0 |
| 2005-09-23 09:55:00 | AAPL | Stock | 1.8611 | 1.8675 | 1.86 | 1.8675 | 8368052.0 |
| 2005-09-23 10:00:00 | AAPL | Stock | 1.8671 | 1.875 | 1.8671 | 1.8746 | 17480596.0 |
| 2005-09-23 10:05:00 | AAPL | Stock | 1.8746 | 1.8786 | 1.8693 | 1.8732 | 12038124.0 |
| 2005-09-23 10:10:00 | AAPL | Stock | 1.8729 | 1.8732 | 1.8657 | 1.8696 | 8037260.0 |
| 2005-09-23 10:15:00 | AAPL | Stock | 1.8696 | 1.8696 | 1.8636 | 1.8679 | 6310304.0 |
| 2005-09-23 10:20:00 | AAPL | Stock | 1.8679 | 1.8711 | 1.8668 | 1.8707 | 4533872.0 |
| 2005-09-23 10:25:00 | AAPL | Stock | 1.8707 | 1.8786 | 1.8704 | 1.8775 | 10530548.0 |
| 2005-09-23 10:30:00 | AAPL | Stock | 1.8775 | 1.8779 | 1.8736 | 1.8754 | 5669496.0 |
| 2005-09-23 10:35:00 | AAPL | Stock | 1.8754 | 1.8757 | 1.8707 | 1.8736 | 8167208.0 |
| 2005-09-23 10:40:00 | AAPL | Stock | 1.8732 | 1.8761 | 1.8679 | 1.8682 | 6383748.0 |
| 2005-09-23 10:45:00 | AAPL | Stock | 1.8682 | 1.8707 | 1.8679 | 1.8696 | 3587052.0 |
| 2005-09-23 10:50:00 | AAPL | Stock | 1.87 | 1.8729 | 1.8696 | 1.8721 | 2156560.0 |
| 2005-09-23 10:55:00 | AAPL | Stock | 1.8725 | 1.875 | 1.8707 | 1.875 | 2964388.0 |
| 2005-09-23 11:00:00 | AAPL | Stock | 1.875 | 1.8779 | 1.8743 | 1.8768 | 9082136.0 |
| 2005-09-23 11:05:00 | AAPL | Stock | 1.8768 | 1.8818 | 1.8736 | 1.8786 | 9019640.0 |
| 2005-09-23 11:10:00 | AAPL | Stock | 1.8782 | 1.8821 | 1.8782 | 1.8814 | 6131692.0 |
| 2005-09-23 11:15:00 | AAPL | Stock | 1.8814 | 1.8832 | 1.8782 | 1.8821 | 7350168.0 |
| 2005-09-23 11:20:00 | AAPL | Stock | 1.8829 | 1.8907 | 1.8829 | 1.8896 | 12141416.0 |
| 2005-09-23 11:25:00 | AAPL | Stock | 1.8893 | 1.8896 | 1.8829 | 1.8871 | 10149300.0 |
| 2005-09-23 11:30:00 | AAPL | Stock | 1.8871 | 1.8911 | 1.8854 | 1.8882 | 7060452.0 |
| 2005-09-23 11:35:00 | AAPL | Stock | 1.8882 | 1.8907 | 1.8875 | 1.8882 | 6538280.0 |
| 2005-09-23 11:40:00 | AAPL | Stock | 1.8879 | 1.8907 | 1.8879 | 1.8904 | 3943380.0 |
| 2005-09-23 11:45:00 | AAPL | Stock | 1.8907 | 1.8907 | 1.8879 | 1.8904 | 3262392.0 |
| 2005-09-23 11:50:00 | AAPL | Stock | 1.8904 | 1.8918 | 1.8875 | 1.8914 | 8962828.0 |
| 2005-09-23 11:55:00 | AAPL | Stock | 1.8914 | 1.9014 | 1.8904 | 1.8993 | 16808568.0 |
| 2005-09-23 12:00:00 | AAPL | Stock | 1.8993 | 1.9039 | 1.8968 | 1.8982 | 8817480.0 |
| 2005-09-23 12:05:00 | AAPL | Stock | 1.8982 | 1.8993 | 1.8964 | 1.8975 | 10522988.0 |
| 2005-09-23 12:10:00 | AAPL | Stock | 1.8971 | 1.8982 | 1.8939 | 1.8954 | 5749296.0 |
| 2005-09-23 12:15:00 | AAPL | Stock | 1.8951 | 1.8971 | 1.8911 | 1.895 | 6713952.0 |
> showing 50 of 197,756 rows — these rows as CSV