PREVIEW / stock_5min / 2010-11-18
file: by_date/stock_5min/2010/2010-11-18.parquet size: 4.8 MB rows: 331,324 symbols: 3,495
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-18 04:00:00 | AAPL | Stock | 10.8836 | 10.8836 | 10.8836 | 10.8836 | 5600.0 |
| 2010-11-18 04:05:00 | AAPL | Stock | 10.8868 | 10.8868 | 10.8843 | 10.8843 | 8400.0 |
| 2010-11-18 04:10:00 | AAPL | Stock | 10.8839 | 10.8893 | 10.8839 | 10.8893 | 5600.0 |
| 2010-11-18 04:30:00 | AAPL | Stock | 10.8704 | 10.8704 | 10.8704 | 10.8704 | 2800.0 |
| 2010-11-18 04:35:00 | AAPL | Stock | 10.8661 | 10.8661 | 10.8661 | 10.8661 | 2800.0 |
| 2010-11-18 04:50:00 | AAPL | Stock | 10.8679 | 10.8679 | 10.8679 | 10.8679 | 2800.0 |
| 2010-11-18 04:55:00 | AAPL | Stock | 10.8643 | 10.8643 | 10.8643 | 10.8643 | 2800.0 |
| 2010-11-18 05:05:00 | AAPL | Stock | 10.8661 | 10.8661 | 10.8661 | 10.8661 | 2800.0 |
| 2010-11-18 05:25:00 | AAPL | Stock | 10.8571 | 10.8571 | 10.8571 | 10.8571 | 2800.0 |
| 2010-11-18 05:40:00 | AAPL | Stock | 10.8596 | 10.8596 | 10.8596 | 10.8596 | 7560.0 |
| 2010-11-18 05:50:00 | AAPL | Stock | 10.8596 | 10.8596 | 10.8596 | 10.8596 | 11060.0 |
| 2010-11-18 06:00:00 | AAPL | Stock | 10.8654 | 10.8654 | 10.8654 | 10.8654 | 2800.0 |
| 2010-11-18 06:10:00 | AAPL | Stock | 10.8654 | 10.8654 | 10.8654 | 10.8654 | 11200.0 |
| 2010-11-18 06:25:00 | AAPL | Stock | 10.8654 | 10.8654 | 10.8654 | 10.8654 | 2800.0 |
| 2010-11-18 06:40:00 | AAPL | Stock | 10.875 | 10.875 | 10.8686 | 10.8686 | 39200.0 |
| 2010-11-18 06:45:00 | AAPL | Stock | 10.875 | 10.875 | 10.875 | 10.875 | 2800.0 |
| 2010-11-18 06:50:00 | AAPL | Stock | 10.8732 | 10.8746 | 10.8732 | 10.8746 | 5600.0 |
| 2010-11-18 06:55:00 | AAPL | Stock | 10.8743 | 10.8746 | 10.8739 | 10.8743 | 16800.0 |
| 2010-11-18 07:00:00 | AAPL | Stock | 10.8729 | 10.875 | 10.8629 | 10.875 | 86492.0 |
| 2010-11-18 07:05:00 | AAPL | Stock | 10.8854 | 10.8854 | 10.8814 | 10.8814 | 13440.0 |
| 2010-11-18 07:10:00 | AAPL | Stock | 10.8814 | 10.8821 | 10.875 | 10.8757 | 70224.0 |
| 2010-11-18 07:15:00 | AAPL | Stock | 10.8821 | 10.8821 | 10.8739 | 10.8779 | 61600.0 |
| 2010-11-18 07:20:00 | AAPL | Stock | 10.8707 | 10.8707 | 10.8571 | 10.8625 | 161224.0 |
| 2010-11-18 07:25:00 | AAPL | Stock | 10.8625 | 10.8714 | 10.8575 | 10.8646 | 165200.0 |
| 2010-11-18 07:30:00 | AAPL | Stock | 10.8639 | 10.8704 | 10.8618 | 10.8696 | 29120.0 |
| 2010-11-18 07:35:00 | AAPL | Stock | 10.8696 | 10.8696 | 10.8696 | 10.8696 | 8400.0 |
| 2010-11-18 07:40:00 | AAPL | Stock | 10.8696 | 10.8696 | 10.8646 | 10.8646 | 54096.0 |
| 2010-11-18 07:45:00 | AAPL | Stock | 10.8575 | 10.8625 | 10.85 | 10.8536 | 61740.0 |
| 2010-11-18 07:50:00 | AAPL | Stock | 10.8571 | 10.8593 | 10.8543 | 10.8593 | 35000.0 |
| 2010-11-18 07:55:00 | AAPL | Stock | 10.8625 | 10.8625 | 10.86 | 10.86 | 5600.0 |
| 2010-11-18 08:00:00 | AAPL | Stock | 10.8582 | 10.8932 | 10.8521 | 10.8821 | 1175244.0 |
| 2010-11-18 08:05:00 | AAPL | Stock | 10.8786 | 10.8854 | 10.8739 | 10.8786 | 246120.0 |
| 2010-11-18 08:10:00 | AAPL | Stock | 10.8782 | 10.8786 | 10.8571 | 10.8571 | 372176.0 |
| 2010-11-18 08:15:00 | AAPL | Stock | 10.8582 | 10.875 | 10.8571 | 10.8696 | 347844.0 |
| 2010-11-18 08:20:00 | AAPL | Stock | 10.8693 | 10.8821 | 10.8657 | 10.8721 | 288372.0 |
| 2010-11-18 08:25:00 | AAPL | Stock | 10.8743 | 10.8804 | 10.8743 | 10.8804 | 159488.0 |
| 2010-11-18 08:30:00 | AAPL | Stock | 10.8771 | 10.8793 | 10.8711 | 10.875 | 187152.0 |
| 2010-11-18 08:35:00 | AAPL | Stock | 10.8757 | 10.885 | 10.8746 | 10.885 | 295624.0 |
| 2010-11-18 08:40:00 | AAPL | Stock | 10.8839 | 10.8911 | 10.8839 | 10.8871 | 339080.0 |
| 2010-11-18 08:45:00 | AAPL | Stock | 10.8871 | 10.8893 | 10.8804 | 10.8829 | 185640.0 |
| 2010-11-18 08:50:00 | AAPL | Stock | 10.8832 | 10.8836 | 10.875 | 10.8782 | 108220.0 |
| 2010-11-18 08:55:00 | AAPL | Stock | 10.8782 | 10.8804 | 10.8757 | 10.8761 | 117600.0 |
| 2010-11-18 09:00:00 | AAPL | Stock | 10.875 | 10.8779 | 10.8721 | 10.8775 | 258608.0 |
| 2010-11-18 09:05:00 | AAPL | Stock | 10.8764 | 10.8764 | 10.8714 | 10.8757 | 174748.0 |
| 2010-11-18 09:10:00 | AAPL | Stock | 10.8757 | 10.8839 | 10.8725 | 10.8829 | 230580.0 |
| 2010-11-18 09:15:00 | AAPL | Stock | 10.8832 | 10.8861 | 10.8782 | 10.8786 | 123004.0 |
| 2010-11-18 09:20:00 | AAPL | Stock | 10.8786 | 10.8857 | 10.8768 | 10.8839 | 115752.0 |
| 2010-11-18 09:25:00 | AAPL | Stock | 10.8854 | 10.8964 | 10.8768 | 10.8964 | 691628.0 |
| 2010-11-18 09:30:00 | AAPL | Stock | 10.8921 | 10.9464 | 10.8818 | 10.9261 | 30840068.0 |
| 2010-11-18 09:35:00 | AAPL | Stock | 10.9257 | 10.9389 | 10.9118 | 10.9233 | 12511996.0 |
> showing 50 of 331,324 rows — these rows as CSV