PREVIEW / stock_5min / 2010-11-22
file: by_date/stock_5min/2010/2010-11-22.parquet size: 4.8 MB rows: 326,597 symbols: 3,521
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-22 05:25:00 | AAPL | Stock | 10.9857 | 10.9857 | 10.9857 | 10.9857 | 2800.0 |
| 2010-11-22 05:30:00 | AAPL | Stock | 11.0 | 11.0 | 11.0 | 11.0 | 11200.0 |
| 2010-11-22 05:50:00 | AAPL | Stock | 11.0 | 11.0 | 11.0 | 11.0 | 22400.0 |
| 2010-11-22 06:30:00 | AAPL | Stock | 10.9925 | 10.9925 | 10.9925 | 10.9925 | 5600.0 |
| 2010-11-22 06:55:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 33600.0 |
| 2010-11-22 07:00:00 | AAPL | Stock | 10.9639 | 10.9639 | 10.9625 | 10.9625 | 53200.0 |
| 2010-11-22 07:05:00 | AAPL | Stock | 10.9636 | 10.9696 | 10.9636 | 10.9696 | 16800.0 |
| 2010-11-22 07:10:00 | AAPL | Stock | 10.9732 | 10.9782 | 10.9696 | 10.975 | 35336.0 |
| 2010-11-22 07:15:00 | AAPL | Stock | 10.9696 | 10.9714 | 10.9693 | 10.9714 | 16800.0 |
| 2010-11-22 07:20:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.96 | 10.96 | 25200.0 |
| 2010-11-22 07:25:00 | AAPL | Stock | 10.9571 | 10.9571 | 10.95 | 10.95 | 12600.0 |
| 2010-11-22 07:40:00 | AAPL | Stock | 10.9679 | 10.9714 | 10.9679 | 10.9679 | 20160.0 |
| 2010-11-22 07:45:00 | AAPL | Stock | 10.9679 | 10.9679 | 10.9679 | 10.9679 | 30744.0 |
| 2010-11-22 07:50:00 | AAPL | Stock | 10.9782 | 10.9782 | 10.9757 | 10.9757 | 8400.0 |
| 2010-11-22 07:55:00 | AAPL | Stock | 10.9743 | 10.975 | 10.9743 | 10.975 | 16800.0 |
| 2010-11-22 08:00:00 | AAPL | Stock | 10.975 | 10.9875 | 10.9718 | 10.9782 | 325920.0 |
| 2010-11-22 08:05:00 | AAPL | Stock | 10.9729 | 11.0 | 10.9539 | 10.9561 | 334684.0 |
| 2010-11-22 08:10:00 | AAPL | Stock | 10.9536 | 10.9554 | 10.9393 | 10.9518 | 215236.0 |
| 2010-11-22 08:15:00 | AAPL | Stock | 10.9554 | 10.9554 | 10.945 | 10.945 | 77028.0 |
| 2010-11-22 08:20:00 | AAPL | Stock | 10.9418 | 10.9518 | 10.9339 | 10.9411 | 274260.0 |
| 2010-11-22 08:25:00 | AAPL | Stock | 10.9507 | 10.9518 | 10.9411 | 10.9411 | 30800.0 |
| 2010-11-22 08:30:00 | AAPL | Stock | 10.9429 | 10.9429 | 10.9393 | 10.9393 | 26180.0 |
| 2010-11-22 08:35:00 | AAPL | Stock | 10.9375 | 10.9375 | 10.9339 | 10.9375 | 69944.0 |
| 2010-11-22 08:40:00 | AAPL | Stock | 10.9461 | 10.9461 | 10.9429 | 10.9429 | 5600.0 |
| 2010-11-22 08:45:00 | AAPL | Stock | 10.9386 | 10.9411 | 10.9375 | 10.9411 | 31444.0 |
| 2010-11-22 08:50:00 | AAPL | Stock | 10.9429 | 10.9429 | 10.9425 | 10.9429 | 16800.0 |
| 2010-11-22 08:55:00 | AAPL | Stock | 10.9418 | 10.9418 | 10.9418 | 10.9418 | 5600.0 |
| 2010-11-22 09:00:00 | AAPL | Stock | 10.9393 | 10.9457 | 10.9321 | 10.9321 | 191436.0 |
| 2010-11-22 09:05:00 | AAPL | Stock | 10.9314 | 10.9343 | 10.9279 | 10.9329 | 234276.0 |
| 2010-11-22 09:10:00 | AAPL | Stock | 10.93 | 10.9364 | 10.9286 | 10.9364 | 65604.0 |
| 2010-11-22 09:15:00 | AAPL | Stock | 10.9339 | 10.9339 | 10.9196 | 10.9232 | 177604.0 |
| 2010-11-22 09:20:00 | AAPL | Stock | 10.9254 | 10.9286 | 10.9164 | 10.9196 | 217000.0 |
| 2010-11-22 09:25:00 | AAPL | Stock | 10.9243 | 10.9464 | 10.9243 | 10.9461 | 266224.0 |
| 2010-11-22 09:30:00 | AAPL | Stock | 10.9454 | 10.975 | 10.9239 | 10.9718 | 9432864.0 |
| 2010-11-22 09:35:00 | AAPL | Stock | 10.9721 | 11.0079 | 10.9661 | 11.0061 | 9114952.0 |
| 2010-11-22 09:40:00 | AAPL | Stock | 11.0061 | 11.0175 | 10.9957 | 11.0 | 7912940.0 |
| 2010-11-22 09:45:00 | AAPL | Stock | 11.0 | 11.0436 | 10.9911 | 11.0204 | 11642708.0 |
| 2010-11-22 09:50:00 | AAPL | Stock | 11.0189 | 11.0625 | 11.0177 | 11.0604 | 7093268.0 |
| 2010-11-22 09:55:00 | AAPL | Stock | 11.0604 | 11.1018 | 11.0604 | 11.0907 | 14950964.0 |
| 2010-11-22 10:00:00 | AAPL | Stock | 11.0893 | 11.0929 | 11.0714 | 11.075 | 7732788.0 |
| 2010-11-22 10:05:00 | AAPL | Stock | 11.0761 | 11.0939 | 11.0714 | 11.0923 | 7238980.0 |
| 2010-11-22 10:10:00 | AAPL | Stock | 11.0929 | 11.0936 | 11.0721 | 11.0771 | 5882464.0 |
| 2010-11-22 10:15:00 | AAPL | Stock | 11.0786 | 11.0929 | 11.0646 | 11.0671 | 6819792.0 |
| 2010-11-22 10:20:00 | AAPL | Stock | 11.0664 | 11.07 | 11.045 | 11.0536 | 7268800.0 |
| 2010-11-22 10:25:00 | AAPL | Stock | 11.0532 | 11.0646 | 11.0314 | 11.0314 | 4955580.0 |
| 2010-11-22 10:30:00 | AAPL | Stock | 11.0311 | 11.0357 | 11.0 | 11.0136 | 9833628.0 |
| 2010-11-22 10:35:00 | AAPL | Stock | 11.0136 | 11.0264 | 10.9946 | 11.025 | 6316688.0 |
| 2010-11-22 10:40:00 | AAPL | Stock | 11.0229 | 11.0257 | 11.0 | 11.0136 | 5105968.0 |
| 2010-11-22 10:45:00 | AAPL | Stock | 11.0111 | 11.0204 | 11.0007 | 11.0132 | 3161452.0 |
| 2010-11-22 10:50:00 | AAPL | Stock | 11.0136 | 11.0386 | 11.0129 | 11.0371 | 4051124.0 |
> showing 50 of 326,597 rows — these rows as CSV