PREVIEW / stock_5min / 2009-09-02
file: by_date/stock_5min/2009/2009-09-02.parquet size: 4.6 MB rows: 319,434 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-02 04:35:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8214 | 5.8214 | 28000.0 |
| 2009-09-02 05:40:00 | AAPL | Stock | 5.8482 | 5.8482 | 5.8482 | 5.8482 | 2800.0 |
| 2009-09-02 06:35:00 | AAPL | Stock | 5.8682 | 5.8682 | 5.8675 | 5.8675 | 19600.0 |
| 2009-09-02 06:50:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.875 | 5.875 | 27944.0 |
| 2009-09-02 07:00:00 | AAPL | Stock | 5.8757 | 5.8786 | 5.8757 | 5.8786 | 14000.0 |
| 2009-09-02 07:05:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 10192.0 |
| 2009-09-02 07:20:00 | AAPL | Stock | 5.8821 | 5.8839 | 5.8821 | 5.8821 | 29372.0 |
| 2009-09-02 07:25:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 3836.0 |
| 2009-09-02 07:35:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2800.0 |
| 2009-09-02 07:45:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8875 | 5.8875 | 11200.0 |
| 2009-09-02 07:50:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 14000.0 |
| 2009-09-02 08:00:00 | AAPL | Stock | 5.8929 | 5.8964 | 5.8911 | 5.8932 | 37996.0 |
| 2009-09-02 08:05:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8893 | 5.8893 | 74340.0 |
| 2009-09-02 08:10:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8896 | 5.8929 | 86912.0 |
| 2009-09-02 08:15:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8857 | 5.8911 | 87696.0 |
| 2009-09-02 08:20:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8893 | 5.8896 | 36568.0 |
| 2009-09-02 08:25:00 | AAPL | Stock | 5.8893 | 5.8907 | 5.8843 | 5.8907 | 28560.0 |
| 2009-09-02 08:30:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8839 | 5.8929 | 72268.0 |
| 2009-09-02 08:35:00 | AAPL | Stock | 5.8936 | 5.9 | 5.8936 | 5.8996 | 28700.0 |
| 2009-09-02 08:40:00 | AAPL | Stock | 5.8996 | 5.9 | 5.8982 | 5.8982 | 56084.0 |
| 2009-09-02 08:45:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.8939 | 5.8946 | 81984.0 |
| 2009-09-02 08:50:00 | AAPL | Stock | 5.8943 | 5.8961 | 5.8943 | 5.8961 | 15400.0 |
| 2009-09-02 08:55:00 | AAPL | Stock | 5.8957 | 5.8968 | 5.8954 | 5.8954 | 40936.0 |
| 2009-09-02 09:00:00 | AAPL | Stock | 5.8964 | 5.8968 | 5.895 | 5.895 | 11200.0 |
| 2009-09-02 09:05:00 | AAPL | Stock | 5.8968 | 5.9 | 5.8968 | 5.8975 | 34384.0 |
| 2009-09-02 09:10:00 | AAPL | Stock | 5.8975 | 5.8986 | 5.895 | 5.8961 | 58800.0 |
| 2009-09-02 09:15:00 | AAPL | Stock | 5.8939 | 5.8939 | 5.8911 | 5.8911 | 129388.0 |
| 2009-09-02 09:20:00 | AAPL | Stock | 5.8911 | 5.8932 | 5.8893 | 5.8893 | 70000.0 |
| 2009-09-02 09:25:00 | AAPL | Stock | 5.885 | 5.8907 | 5.8711 | 5.8757 | 562408.0 |
| 2009-09-02 09:30:00 | AAPL | Stock | 5.8793 | 5.8964 | 5.8611 | 5.8917 | 11053140.0 |
| 2009-09-02 09:35:00 | AAPL | Stock | 5.8921 | 5.9007 | 5.8818 | 5.8875 | 11922652.0 |
| 2009-09-02 09:40:00 | AAPL | Stock | 5.8875 | 5.9271 | 5.8829 | 5.9246 | 14604072.0 |
| 2009-09-02 09:45:00 | AAPL | Stock | 5.925 | 5.9571 | 5.9227 | 5.9457 | 16581768.0 |
| 2009-09-02 09:50:00 | AAPL | Stock | 5.9479 | 5.9782 | 5.9461 | 5.9625 | 15809444.0 |
| 2009-09-02 09:55:00 | AAPL | Stock | 5.9625 | 5.9626 | 5.9286 | 5.9318 | 10988824.0 |
| 2009-09-02 10:00:00 | AAPL | Stock | 5.9318 | 5.9425 | 5.9011 | 5.9246 | 12572812.0 |
| 2009-09-02 10:05:00 | AAPL | Stock | 5.9268 | 5.9575 | 5.9246 | 5.9557 | 9890440.0 |
| 2009-09-02 10:10:00 | AAPL | Stock | 5.9557 | 5.9621 | 5.9375 | 5.9475 | 7258328.0 |
| 2009-09-02 10:15:00 | AAPL | Stock | 5.9475 | 5.9475 | 5.9371 | 5.9471 | 4764928.0 |
| 2009-09-02 10:20:00 | AAPL | Stock | 5.9461 | 5.9607 | 5.9386 | 5.9586 | 10589264.0 |
| 2009-09-02 10:25:00 | AAPL | Stock | 5.9575 | 5.9643 | 5.9418 | 5.9467 | 8117648.0 |
| 2009-09-02 10:30:00 | AAPL | Stock | 5.9468 | 5.9557 | 5.9429 | 5.9464 | 8044820.0 |
| 2009-09-02 10:35:00 | AAPL | Stock | 5.9479 | 5.9696 | 5.9461 | 5.9636 | 6321756.0 |
| 2009-09-02 10:40:00 | AAPL | Stock | 5.9625 | 5.9814 | 5.9621 | 5.9768 | 6684384.0 |
| 2009-09-02 10:45:00 | AAPL | Stock | 5.9768 | 5.9861 | 5.9704 | 5.9704 | 5497296.0 |
| 2009-09-02 10:50:00 | AAPL | Stock | 5.9711 | 5.9732 | 5.9579 | 5.9642 | 5248488.0 |
| 2009-09-02 10:55:00 | AAPL | Stock | 5.9636 | 5.975 | 5.9615 | 5.9704 | 3535588.0 |
| 2009-09-02 11:00:00 | AAPL | Stock | 5.9707 | 5.9711 | 5.9596 | 5.9611 | 4020800.0 |
| 2009-09-02 11:05:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9489 | 5.9575 | 5121284.0 |
| 2009-09-02 11:10:00 | AAPL | Stock | 5.9571 | 5.9693 | 5.9561 | 5.9632 | 3964184.0 |
> showing 50 of 319,434 rows — these rows as CSV