PREVIEW / stock_5min / 2009-07-02
file: by_date/stock_5min/2009/2009-07-02.parquet size: 4.6 MB rows: 327,249 symbols: 3,314
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-07-02 07:10:00 | AAPL | Stock | 5.05 | 5.05 | 5.05 | 5.05 | 2800.0 |
| 2009-07-02 07:40:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 2800.0 |
| 2009-07-02 08:00:00 | AAPL | Stock | 5.0768 | 5.0868 | 5.0761 | 5.0761 | 102004.0 |
| 2009-07-02 08:05:00 | AAPL | Stock | 5.0729 | 5.0811 | 5.0714 | 5.0811 | 57960.0 |
| 2009-07-02 08:10:00 | AAPL | Stock | 5.0925 | 5.0975 | 5.0836 | 5.0857 | 70000.0 |
| 2009-07-02 08:15:00 | AAPL | Stock | 5.0875 | 5.0875 | 5.08 | 5.08 | 66360.0 |
| 2009-07-02 08:20:00 | AAPL | Stock | 5.0811 | 5.0893 | 5.0811 | 5.0893 | 104132.0 |
| 2009-07-02 08:25:00 | AAPL | Stock | 5.0968 | 5.0968 | 5.0889 | 5.0964 | 18480.0 |
| 2009-07-02 08:30:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0707 | 5.075 | 141008.0 |
| 2009-07-02 08:35:00 | AAPL | Stock | 5.0732 | 5.0746 | 5.055 | 5.055 | 235480.0 |
| 2009-07-02 08:40:00 | AAPL | Stock | 5.055 | 5.0671 | 5.055 | 5.0632 | 142296.0 |
| 2009-07-02 08:45:00 | AAPL | Stock | 5.0636 | 5.0643 | 5.0536 | 5.0536 | 215208.0 |
| 2009-07-02 08:50:00 | AAPL | Stock | 5.0539 | 5.0539 | 5.0429 | 5.0429 | 263676.0 |
| 2009-07-02 08:55:00 | AAPL | Stock | 5.0404 | 5.0471 | 5.0393 | 5.04 | 103012.0 |
| 2009-07-02 09:00:00 | AAPL | Stock | 5.0411 | 5.05 | 5.0411 | 5.0482 | 85708.0 |
| 2009-07-02 09:05:00 | AAPL | Stock | 5.05 | 5.0511 | 5.0318 | 5.0429 | 644532.0 |
| 2009-07-02 09:10:00 | AAPL | Stock | 5.0393 | 5.0468 | 5.0393 | 5.045 | 429688.0 |
| 2009-07-02 09:15:00 | AAPL | Stock | 5.0457 | 5.0518 | 5.0446 | 5.0504 | 80304.0 |
| 2009-07-02 09:20:00 | AAPL | Stock | 5.05 | 5.05 | 5.0436 | 5.0457 | 221004.0 |
| 2009-07-02 09:25:00 | AAPL | Stock | 5.0489 | 5.05 | 5.0454 | 5.0471 | 145544.0 |
| 2009-07-02 09:30:00 | AAPL | Stock | 5.0446 | 5.0468 | 5.0 | 5.0111 | 19944400.0 |
| 2009-07-02 09:35:00 | AAPL | Stock | 5.0136 | 5.0204 | 4.9971 | 5.0007 | 12811708.0 |
| 2009-07-02 09:40:00 | AAPL | Stock | 4.9996 | 5.0229 | 4.9929 | 5.0189 | 10230500.0 |
| 2009-07-02 09:45:00 | AAPL | Stock | 5.0182 | 5.0339 | 5.0146 | 5.0325 | 6506836.0 |
| 2009-07-02 09:50:00 | AAPL | Stock | 5.0314 | 5.0346 | 5.0032 | 5.005 | 9848720.0 |
| 2009-07-02 09:55:00 | AAPL | Stock | 5.0057 | 5.0071 | 4.9975 | 5.0004 | 8694000.0 |
| 2009-07-02 10:00:00 | AAPL | Stock | 5.0025 | 5.0211 | 5.0017 | 5.0179 | 11419436.0 |
| 2009-07-02 10:05:00 | AAPL | Stock | 5.0171 | 5.0236 | 5.0036 | 5.0087 | 13864900.0 |
| 2009-07-02 10:10:00 | AAPL | Stock | 5.0082 | 5.0143 | 5.0068 | 5.0143 | 6669572.0 |
| 2009-07-02 10:15:00 | AAPL | Stock | 5.0143 | 5.0318 | 5.0086 | 5.0211 | 10328528.0 |
| 2009-07-02 10:20:00 | AAPL | Stock | 5.0214 | 5.0232 | 5.0107 | 5.0196 | 7051548.0 |
| 2009-07-02 10:25:00 | AAPL | Stock | 5.02 | 5.0286 | 5.0179 | 5.0204 | 5052012.0 |
| 2009-07-02 10:30:00 | AAPL | Stock | 5.0204 | 5.0271 | 5.0129 | 5.0261 | 7441084.0 |
| 2009-07-02 10:35:00 | AAPL | Stock | 5.0264 | 5.0357 | 5.0264 | 5.0264 | 7212772.0 |
| 2009-07-02 10:40:00 | AAPL | Stock | 5.0266 | 5.0289 | 5.0179 | 5.0239 | 6488440.0 |
| 2009-07-02 10:45:00 | AAPL | Stock | 5.0239 | 5.0254 | 5.01 | 5.015 | 5437208.0 |
| 2009-07-02 10:50:00 | AAPL | Stock | 5.015 | 5.0193 | 5.0129 | 5.0186 | 3181976.0 |
| 2009-07-02 10:55:00 | AAPL | Stock | 5.0193 | 5.0239 | 5.0132 | 5.0171 | 2937032.0 |
| 2009-07-02 11:00:00 | AAPL | Stock | 5.0178 | 5.0178 | 5.0068 | 5.0079 | 4513264.0 |
| 2009-07-02 11:05:00 | AAPL | Stock | 5.0075 | 5.01 | 5.0068 | 5.0093 | 3445736.0 |
| 2009-07-02 11:10:00 | AAPL | Stock | 5.0093 | 5.0121 | 5.0075 | 5.01 | 2704408.0 |
| 2009-07-02 11:15:00 | AAPL | Stock | 5.0104 | 5.0114 | 5.0011 | 5.0032 | 4638676.0 |
| 2009-07-02 11:20:00 | AAPL | Stock | 5.0029 | 5.0046 | 4.9982 | 4.9982 | 6472788.0 |
| 2009-07-02 11:25:00 | AAPL | Stock | 4.9982 | 5.0029 | 4.9971 | 5.0021 | 5807816.0 |
| 2009-07-02 11:30:00 | AAPL | Stock | 5.0018 | 5.0043 | 4.9986 | 4.9989 | 2559032.0 |
| 2009-07-02 11:35:00 | AAPL | Stock | 4.9986 | 5.0029 | 4.9946 | 5.0029 | 4645564.0 |
| 2009-07-02 11:40:00 | AAPL | Stock | 5.0021 | 5.0029 | 4.9929 | 4.9932 | 5292840.0 |
| 2009-07-02 11:45:00 | AAPL | Stock | 4.9932 | 5.005 | 4.9925 | 5.0046 | 7172732.0 |
| 2009-07-02 11:50:00 | AAPL | Stock | 5.0039 | 5.0125 | 5.0029 | 5.0114 | 5046580.0 |
| 2009-07-02 11:55:00 | AAPL | Stock | 5.0114 | 5.0146 | 5.0075 | 5.0136 | 2125256.0 |
> showing 50 of 327,249 rows — these rows as CSV