PREVIEW / stock_5min / 2010-11-02
file: by_date/stock_5min/2010/2010-11-02.parquet size: 4.8 MB rows: 328,531 symbols: 3,502
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-02 04:00:00 | AAPL | Stock | 10.8896 | 10.8896 | 10.8896 | 10.8896 | 2800.0 |
| 2010-11-02 04:10:00 | AAPL | Stock | 10.8893 | 10.8893 | 10.8893 | 10.8893 | 5600.0 |
| 2010-11-02 04:40:00 | AAPL | Stock | 10.8929 | 10.8929 | 10.8929 | 10.8929 | 2800.0 |
| 2010-11-02 05:05:00 | AAPL | Stock | 10.9018 | 10.9018 | 10.9018 | 10.9018 | 2800.0 |
| 2010-11-02 05:20:00 | AAPL | Stock | 10.8964 | 10.8964 | 10.8964 | 10.8964 | 2800.0 |
| 2010-11-02 05:25:00 | AAPL | Stock | 10.8982 | 10.9018 | 10.8982 | 10.9018 | 6440.0 |
| 2010-11-02 05:45:00 | AAPL | Stock | 10.9018 | 10.9018 | 10.9018 | 10.9018 | 2800.0 |
| 2010-11-02 05:50:00 | AAPL | Stock | 10.8982 | 10.8982 | 10.8982 | 10.8982 | 2800.0 |
| 2010-11-02 05:55:00 | AAPL | Stock | 10.8982 | 10.8982 | 10.8929 | 10.8929 | 5600.0 |
| 2010-11-02 06:20:00 | AAPL | Stock | 10.9007 | 10.9007 | 10.9007 | 10.9007 | 5600.0 |
| 2010-11-02 06:25:00 | AAPL | Stock | 10.9007 | 10.9007 | 10.9007 | 10.9007 | 2800.0 |
| 2010-11-02 06:35:00 | AAPL | Stock | 10.8936 | 10.8939 | 10.8936 | 10.8939 | 78680.0 |
| 2010-11-02 06:40:00 | AAPL | Stock | 10.8893 | 10.8893 | 10.8893 | 10.8893 | 7980.0 |
| 2010-11-02 06:45:00 | AAPL | Stock | 10.9082 | 10.9082 | 10.9082 | 10.9082 | 2800.0 |
| 2010-11-02 06:50:00 | AAPL | Stock | 10.9082 | 10.9082 | 10.9082 | 10.9082 | 2800.0 |
| 2010-11-02 06:55:00 | AAPL | Stock | 10.9164 | 10.9164 | 10.9164 | 10.9164 | 2800.0 |
| 2010-11-02 07:05:00 | AAPL | Stock | 10.9107 | 10.9107 | 10.9107 | 10.9107 | 2800.0 |
| 2010-11-02 07:10:00 | AAPL | Stock | 10.9107 | 10.9107 | 10.9107 | 10.9107 | 2800.0 |
| 2010-11-02 07:15:00 | AAPL | Stock | 10.9104 | 10.9104 | 10.9104 | 10.9104 | 11200.0 |
| 2010-11-02 07:20:00 | AAPL | Stock | 10.9104 | 10.9107 | 10.9104 | 10.9104 | 16800.0 |
| 2010-11-02 07:25:00 | AAPL | Stock | 10.9054 | 10.9121 | 10.9054 | 10.9121 | 60200.0 |
| 2010-11-02 07:30:00 | AAPL | Stock | 10.9186 | 10.9243 | 10.9154 | 10.9179 | 26320.0 |
| 2010-11-02 07:35:00 | AAPL | Stock | 10.9179 | 10.9246 | 10.9179 | 10.9179 | 43400.0 |
| 2010-11-02 07:40:00 | AAPL | Stock | 10.9264 | 10.9307 | 10.9264 | 10.9307 | 44800.0 |
| 2010-11-02 07:45:00 | AAPL | Stock | 10.9375 | 10.9407 | 10.9375 | 10.9407 | 5600.0 |
| 2010-11-02 07:50:00 | AAPL | Stock | 10.935 | 10.9375 | 10.9321 | 10.9321 | 57176.0 |
| 2010-11-02 07:55:00 | AAPL | Stock | 10.9325 | 10.9346 | 10.9325 | 10.9346 | 5600.0 |
| 2010-11-02 08:00:00 | AAPL | Stock | 10.9357 | 10.9389 | 10.9189 | 10.9193 | 626080.0 |
| 2010-11-02 08:05:00 | AAPL | Stock | 10.9232 | 10.925 | 10.9186 | 10.9243 | 235200.0 |
| 2010-11-02 08:10:00 | AAPL | Stock | 10.9218 | 10.9232 | 10.9154 | 10.9179 | 241080.0 |
| 2010-11-02 08:15:00 | AAPL | Stock | 10.9232 | 10.9346 | 10.9232 | 10.9343 | 497868.0 |
| 2010-11-02 08:20:00 | AAPL | Stock | 10.9343 | 10.9343 | 10.925 | 10.925 | 212940.0 |
| 2010-11-02 08:25:00 | AAPL | Stock | 10.9275 | 10.9304 | 10.9243 | 10.9304 | 136500.0 |
| 2010-11-02 08:30:00 | AAPL | Stock | 10.9282 | 10.9339 | 10.9179 | 10.9318 | 199472.0 |
| 2010-11-02 08:35:00 | AAPL | Stock | 10.9314 | 10.9321 | 10.9225 | 10.9286 | 307692.0 |
| 2010-11-02 08:40:00 | AAPL | Stock | 10.9293 | 10.9307 | 10.9289 | 10.9293 | 43960.0 |
| 2010-11-02 08:45:00 | AAPL | Stock | 10.9293 | 10.9336 | 10.9286 | 10.9321 | 355096.0 |
| 2010-11-02 08:50:00 | AAPL | Stock | 10.9321 | 10.9339 | 10.9304 | 10.9332 | 150360.0 |
| 2010-11-02 08:55:00 | AAPL | Stock | 10.9329 | 10.9329 | 10.9304 | 10.9304 | 126420.0 |
| 2010-11-02 09:00:00 | AAPL | Stock | 10.9307 | 10.9461 | 10.9304 | 10.9429 | 930720.0 |
| 2010-11-02 09:05:00 | AAPL | Stock | 10.9436 | 10.9786 | 10.9429 | 10.9721 | 1220884.0 |
| 2010-11-02 09:10:00 | AAPL | Stock | 10.9754 | 10.9782 | 10.96 | 10.9696 | 827736.0 |
| 2010-11-02 09:15:00 | AAPL | Stock | 10.9679 | 10.9704 | 10.9661 | 10.9693 | 441588.0 |
| 2010-11-02 09:20:00 | AAPL | Stock | 10.9682 | 10.9696 | 10.9625 | 10.9675 | 264740.0 |
| 2010-11-02 09:25:00 | AAPL | Stock | 10.9679 | 10.9746 | 10.9629 | 10.9732 | 1109276.0 |
| 2010-11-02 09:30:00 | AAPL | Stock | 10.9743 | 11.0436 | 10.9643 | 11.0207 | 31589544.0 |
| 2010-11-02 09:35:00 | AAPL | Stock | 11.0207 | 11.0589 | 11.0186 | 11.0271 | 25159120.0 |
| 2010-11-02 09:40:00 | AAPL | Stock | 11.0284 | 11.0557 | 11.0189 | 11.0357 | 13649748.0 |
| 2010-11-02 09:45:00 | AAPL | Stock | 11.0343 | 11.0479 | 11.0218 | 11.0348 | 9444484.0 |
| 2010-11-02 09:50:00 | AAPL | Stock | 11.0334 | 11.0404 | 11.0232 | 11.0286 | 8525804.0 |
> showing 50 of 328,531 rows — these rows as CSV