PREVIEW / stock_1min / 2011-08-04
file: by_date/stock_1min/2011/2011-08-04.parquet size: 16.1 MB rows: 1,146,456 symbols: 2,881
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-04 04:08:00 | AAPL | Stock | 13.9964 | 13.9964 | 13.9964 | 13.9964 | 2800.0 |
| 2011-08-04 04:24:00 | AAPL | Stock | 14.0039 | 14.0039 | 14.0039 | 14.0039 | 2800.0 |
| 2011-08-04 04:29:00 | AAPL | Stock | 14.0089 | 14.0089 | 14.0089 | 14.0089 | 5600.0 |
| 2011-08-04 04:34:00 | AAPL | Stock | 14.0211 | 14.0211 | 14.0204 | 14.0204 | 5600.0 |
| 2011-08-04 04:40:00 | AAPL | Stock | 14.0207 | 14.0207 | 14.0207 | 14.0207 | 5600.0 |
| 2011-08-04 05:27:00 | AAPL | Stock | 13.9789 | 13.9789 | 13.9789 | 13.9789 | 2800.0 |
| 2011-08-04 06:03:00 | AAPL | Stock | 13.9761 | 13.9761 | 13.9639 | 13.9639 | 25200.0 |
| 2011-08-04 06:16:00 | AAPL | Stock | 13.9532 | 13.9536 | 13.9532 | 13.9536 | 5600.0 |
| 2011-08-04 06:18:00 | AAPL | Stock | 13.9357 | 13.9357 | 13.9357 | 13.9357 | 19600.0 |
| 2011-08-04 06:24:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-04 06:28:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 5600.0 |
| 2011-08-04 06:29:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 8400.0 |
| 2011-08-04 06:30:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 2800.0 |
| 2011-08-04 06:32:00 | AAPL | Stock | 13.9079 | 13.9079 | 13.9079 | 13.9079 | 8400.0 |
| 2011-08-04 06:41:00 | AAPL | Stock | 13.9221 | 13.9221 | 13.9221 | 13.9221 | 2800.0 |
| 2011-08-04 06:55:00 | AAPL | Stock | 13.9375 | 13.9375 | 13.9375 | 13.9375 | 2800.0 |
| 2011-08-04 07:00:00 | AAPL | Stock | 13.9375 | 13.9382 | 13.9264 | 13.9268 | 148400.0 |
| 2011-08-04 07:01:00 | AAPL | Stock | 13.9268 | 13.9282 | 13.925 | 13.9264 | 38080.0 |
| 2011-08-04 07:02:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9264 | 13.9264 | 5600.0 |
| 2011-08-04 07:03:00 | AAPL | Stock | 13.9425 | 13.9429 | 13.9268 | 13.9268 | 36400.0 |
| 2011-08-04 07:04:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9257 | 13.9268 | 11200.0 |
| 2011-08-04 07:06:00 | AAPL | Stock | 13.9264 | 13.9264 | 13.925 | 13.925 | 36400.0 |
| 2011-08-04 07:09:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9268 | 13.9268 | 8400.0 |
| 2011-08-04 07:10:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9268 | 13.9268 | 2800.0 |
| 2011-08-04 07:12:00 | AAPL | Stock | 13.9268 | 13.9268 | 13.9268 | 13.9268 | 3500.0 |
| 2011-08-04 07:15:00 | AAPL | Stock | 13.9214 | 13.9264 | 13.9214 | 13.9264 | 8400.0 |
| 2011-08-04 07:22:00 | AAPL | Stock | 13.9304 | 13.9304 | 13.925 | 13.925 | 26348.0 |
| 2011-08-04 07:23:00 | AAPL | Stock | 13.925 | 13.925 | 13.9232 | 13.9232 | 5600.0 |
| 2011-08-04 07:26:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 15400.0 |
| 2011-08-04 07:27:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9257 | 13.9257 | 16800.0 |
| 2011-08-04 07:31:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-08-04 07:32:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 5600.0 |
| 2011-08-04 07:34:00 | AAPL | Stock | 13.9396 | 13.9396 | 13.9396 | 13.9396 | 2800.0 |
| 2011-08-04 07:37:00 | AAPL | Stock | 13.9461 | 13.9461 | 13.9461 | 13.9461 | 2800.0 |
| 2011-08-04 07:39:00 | AAPL | Stock | 13.9514 | 13.9514 | 13.9514 | 13.9514 | 5600.0 |
| 2011-08-04 07:42:00 | AAPL | Stock | 13.9482 | 13.9579 | 13.9482 | 13.9579 | 8400.0 |
| 2011-08-04 07:44:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9464 | 13.9464 | 5600.0 |
| 2011-08-04 07:54:00 | AAPL | Stock | 13.9357 | 13.9357 | 13.9339 | 13.9339 | 13216.0 |
| 2011-08-04 07:55:00 | AAPL | Stock | 13.9339 | 13.9339 | 13.9339 | 13.9339 | 2800.0 |
| 2011-08-04 07:59:00 | AAPL | Stock | 13.9521 | 13.9521 | 13.9432 | 13.9432 | 5600.0 |
| 2011-08-04 08:00:00 | AAPL | Stock | 13.9543 | 13.9571 | 13.9339 | 13.9393 | 76860.0 |
| 2011-08-04 08:01:00 | AAPL | Stock | 13.9375 | 13.9393 | 13.9286 | 13.9286 | 67424.0 |
| 2011-08-04 08:02:00 | AAPL | Stock | 13.9286 | 13.9393 | 13.9196 | 13.92 | 29400.0 |
| 2011-08-04 08:03:00 | AAPL | Stock | 13.925 | 13.9282 | 13.925 | 13.9282 | 12600.0 |
| 2011-08-04 08:04:00 | AAPL | Stock | 13.9375 | 13.9375 | 13.9375 | 13.9375 | 30800.0 |
| 2011-08-04 08:05:00 | AAPL | Stock | 13.9393 | 13.9393 | 13.9279 | 13.9286 | 86520.0 |
| 2011-08-04 08:06:00 | AAPL | Stock | 13.9243 | 13.9279 | 13.9182 | 13.9182 | 49700.0 |
| 2011-08-04 08:07:00 | AAPL | Stock | 13.9107 | 13.9121 | 13.9036 | 13.9036 | 83692.0 |
| 2011-08-04 08:08:00 | AAPL | Stock | 13.9018 | 13.9018 | 13.8929 | 13.8929 | 102200.0 |
| 2011-08-04 08:10:00 | AAPL | Stock | 13.8982 | 13.9 | 13.8982 | 13.9 | 18088.0 |
> showing 50 of 1,146,456 rows — these rows as CSV