PREVIEW / stock_5min / 2007-11-12
file: by_date/stock_5min/2007/2007-11-12.parquet size: 4.4 MB rows: 319,416 symbols: 3,175
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-12 04:35:00 | AAPL | Stock | 5.9282 | 5.9282 | 5.9282 | 5.9282 | 5600.0 |
| 2007-11-12 04:50:00 | AAPL | Stock | 5.9282 | 5.9282 | 5.9282 | 5.9282 | 11200.0 |
| 2007-11-12 05:25:00 | AAPL | Stock | 5.9329 | 5.9329 | 5.9329 | 5.9329 | 11200.0 |
| 2007-11-12 05:45:00 | AAPL | Stock | 5.9332 | 5.9332 | 5.9332 | 5.9332 | 3640.0 |
| 2007-11-12 06:00:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 11200.0 |
| 2007-11-12 06:05:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9375 | 5.9375 | 14000.0 |
| 2007-11-12 06:10:00 | AAPL | Stock | 5.9282 | 5.9282 | 5.9107 | 5.9107 | 88844.0 |
| 2007-11-12 06:20:00 | AAPL | Stock | 5.9279 | 5.9279 | 5.9279 | 5.9279 | 28000.0 |
| 2007-11-12 07:00:00 | AAPL | Stock | 5.9279 | 5.9279 | 5.9279 | 5.9279 | 37800.0 |
| 2007-11-12 07:05:00 | AAPL | Stock | 5.9279 | 5.9343 | 5.9279 | 5.9343 | 11200.0 |
| 2007-11-12 07:10:00 | AAPL | Stock | 5.9429 | 5.9429 | 5.9196 | 5.9196 | 38584.0 |
| 2007-11-12 07:15:00 | AAPL | Stock | 5.9196 | 5.9393 | 5.9196 | 5.9286 | 11200.0 |
| 2007-11-12 07:20:00 | AAPL | Stock | 5.9286 | 5.9321 | 5.9286 | 5.9286 | 56504.0 |
| 2007-11-12 07:25:00 | AAPL | Stock | 5.9264 | 5.9268 | 5.9039 | 5.9261 | 213388.0 |
| 2007-11-12 07:30:00 | AAPL | Stock | 5.9268 | 5.9268 | 5.9268 | 5.9268 | 3444.0 |
| 2007-11-12 07:35:00 | AAPL | Stock | 5.9107 | 5.9268 | 5.9107 | 5.925 | 156156.0 |
| 2007-11-12 07:40:00 | AAPL | Stock | 5.9268 | 5.9286 | 5.925 | 5.925 | 67844.0 |
| 2007-11-12 07:45:00 | AAPL | Stock | 5.925 | 5.9375 | 5.925 | 5.9375 | 23044.0 |
| 2007-11-12 07:50:00 | AAPL | Stock | 5.9125 | 5.9125 | 5.9107 | 5.9125 | 89600.0 |
| 2007-11-12 07:55:00 | AAPL | Stock | 5.9129 | 5.9129 | 5.8982 | 5.9089 | 74788.0 |
| 2007-11-12 08:00:00 | AAPL | Stock | 5.9089 | 5.9393 | 5.8793 | 5.8825 | 1399580.0 |
| 2007-11-12 08:05:00 | AAPL | Stock | 5.8854 | 5.8929 | 5.8318 | 5.8454 | 623644.0 |
| 2007-11-12 08:10:00 | AAPL | Stock | 5.8454 | 5.8921 | 5.84 | 5.8907 | 830900.0 |
| 2007-11-12 08:15:00 | AAPL | Stock | 5.8857 | 5.8904 | 5.8464 | 5.8629 | 622412.0 |
| 2007-11-12 08:20:00 | AAPL | Stock | 5.8589 | 5.8714 | 5.8568 | 5.8682 | 333984.0 |
| 2007-11-12 08:25:00 | AAPL | Stock | 5.8732 | 5.8846 | 5.8689 | 5.8846 | 481628.0 |
| 2007-11-12 08:30:00 | AAPL | Stock | 5.8857 | 5.9018 | 5.8796 | 5.8946 | 621908.0 |
| 2007-11-12 08:35:00 | AAPL | Stock | 5.8936 | 5.9411 | 5.8936 | 5.9357 | 1513988.0 |
| 2007-11-12 08:40:00 | AAPL | Stock | 5.9354 | 5.9729 | 5.9354 | 5.9729 | 1768256.0 |
| 2007-11-12 08:45:00 | AAPL | Stock | 5.9686 | 5.9743 | 5.9482 | 5.9721 | 1205484.0 |
| 2007-11-12 08:50:00 | AAPL | Stock | 5.9721 | 5.9789 | 5.9657 | 5.9718 | 1738884.0 |
| 2007-11-12 08:55:00 | AAPL | Stock | 5.9721 | 5.9786 | 5.9682 | 5.9682 | 1393448.0 |
| 2007-11-12 09:00:00 | AAPL | Stock | 5.9707 | 5.9707 | 5.9304 | 5.9357 | 960708.0 |
| 2007-11-12 09:05:00 | AAPL | Stock | 5.935 | 5.9511 | 5.9343 | 5.9393 | 826812.0 |
| 2007-11-12 09:10:00 | AAPL | Stock | 5.9407 | 5.9421 | 5.9179 | 5.9218 | 1061452.0 |
| 2007-11-12 09:15:00 | AAPL | Stock | 5.9204 | 5.9236 | 5.9114 | 5.9164 | 399560.0 |
| 2007-11-12 09:20:00 | AAPL | Stock | 5.9164 | 5.9214 | 5.9061 | 5.9093 | 714140.0 |
| 2007-11-12 09:25:00 | AAPL | Stock | 5.9093 | 5.9096 | 5.8911 | 5.9007 | 1582896.0 |
| 2007-11-12 09:30:00 | AAPL | Stock | 5.9036 | 5.9039 | 5.7704 | 5.8611 | 60404204.0 |
| 2007-11-12 09:35:00 | AAPL | Stock | 5.8582 | 5.9714 | 5.8529 | 5.9629 | 44082332.0 |
| 2007-11-12 09:40:00 | AAPL | Stock | 5.9625 | 5.9893 | 5.8981 | 5.9479 | 37774380.0 |
| 2007-11-12 09:45:00 | AAPL | Stock | 5.9479 | 5.9821 | 5.9318 | 5.9407 | 25153632.0 |
| 2007-11-12 09:50:00 | AAPL | Stock | 5.94 | 5.9411 | 5.8393 | 5.8907 | 29860824.0 |
| 2007-11-12 09:55:00 | AAPL | Stock | 5.8907 | 5.9111 | 5.8518 | 5.9007 | 20788236.0 |
| 2007-11-12 10:00:00 | AAPL | Stock | 5.8989 | 5.9008 | 5.8214 | 5.8389 | 20846168.0 |
| 2007-11-12 10:05:00 | AAPL | Stock | 5.8421 | 5.8929 | 5.7396 | 5.7589 | 30482116.0 |
| 2007-11-12 10:10:00 | AAPL | Stock | 5.7589 | 5.8286 | 5.7586 | 5.7914 | 26519948.0 |
| 2007-11-12 10:15:00 | AAPL | Stock | 5.7936 | 5.8514 | 5.7839 | 5.8436 | 26035156.0 |
| 2007-11-12 10:20:00 | AAPL | Stock | 5.8443 | 5.8632 | 5.7921 | 5.8514 | 20982864.0 |
| 2007-11-12 10:25:00 | AAPL | Stock | 5.8501 | 5.8639 | 5.8079 | 5.82 | 14604184.0 |
> showing 50 of 319,416 rows — these rows as CSV