PREVIEW / stock_1min / 2012-12-10
file: by_date/stock_1min/2012/2012-12-10.parquet size: 12.4 MB rows: 924,087 symbols: 2,840
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-10 04:05:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 3584.0 |
| 2012-12-10 04:06:00 | AAPL | Stock | 19.1018 | 19.1018 | 19.0832 | 19.0832 | 11200.0 |
| 2012-12-10 04:09:00 | AAPL | Stock | 19.0846 | 19.0846 | 19.0846 | 19.0846 | 2800.0 |
| 2012-12-10 04:21:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0964 | 19.0964 | 2800.0 |
| 2012-12-10 04:22:00 | AAPL | Stock | 19.0782 | 19.0782 | 19.0757 | 19.0757 | 5600.0 |
| 2012-12-10 04:23:00 | AAPL | Stock | 19.075 | 19.075 | 19.075 | 19.075 | 2800.0 |
| 2012-12-10 04:41:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0696 | 19.0696 | 5600.0 |
| 2012-12-10 04:47:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2012-12-10 05:13:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 2800.0 |
| 2012-12-10 05:22:00 | AAPL | Stock | 19.0314 | 19.0314 | 19.0314 | 19.0314 | 2800.0 |
| 2012-12-10 05:23:00 | AAPL | Stock | 19.0004 | 19.0004 | 19.0004 | 19.0004 | 2800.0 |
| 2012-12-10 05:52:00 | AAPL | Stock | 18.9775 | 18.9775 | 18.9775 | 18.9775 | 2800.0 |
| 2012-12-10 05:53:00 | AAPL | Stock | 18.975 | 18.975 | 18.975 | 18.975 | 2800.0 |
| 2012-12-10 05:55:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 9800.0 |
| 2012-12-10 05:57:00 | AAPL | Stock | 19.0 | 19.0 | 19.0 | 19.0 | 2800.0 |
| 2012-12-10 05:58:00 | AAPL | Stock | 18.9696 | 18.9696 | 18.9696 | 18.9696 | 16800.0 |
| 2012-12-10 06:01:00 | AAPL | Stock | 18.9696 | 18.9696 | 18.9696 | 18.9696 | 2800.0 |
| 2012-12-10 06:02:00 | AAPL | Stock | 18.9821 | 18.9821 | 18.97 | 18.97 | 5600.0 |
| 2012-12-10 06:03:00 | AAPL | Stock | 18.9696 | 18.9696 | 18.9696 | 18.9696 | 8400.0 |
| 2012-12-10 06:07:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9464 | 18.9464 | 39200.0 |
| 2012-12-10 06:18:00 | AAPL | Stock | 18.9675 | 18.9675 | 18.9639 | 18.9639 | 8400.0 |
| 2012-12-10 06:23:00 | AAPL | Stock | 18.9375 | 18.9375 | 18.9375 | 18.9375 | 2800.0 |
| 2012-12-10 06:24:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9464 | 18.9464 | 2800.0 |
| 2012-12-10 06:30:00 | AAPL | Stock | 18.9764 | 18.9764 | 18.9764 | 18.9764 | 5600.0 |
| 2012-12-10 06:37:00 | AAPL | Stock | 18.9475 | 18.9475 | 18.9475 | 18.9475 | 2800.0 |
| 2012-12-10 06:45:00 | AAPL | Stock | 18.9482 | 18.9482 | 18.9482 | 18.9482 | 2800.0 |
| 2012-12-10 06:48:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 2800.0 |
| 2012-12-10 06:51:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2012-12-10 06:54:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2012-12-10 07:00:00 | AAPL | Stock | 18.9571 | 18.9571 | 18.9571 | 18.9571 | 5600.0 |
| 2012-12-10 07:01:00 | AAPL | Stock | 18.9411 | 18.9411 | 18.9411 | 18.9411 | 2800.0 |
| 2012-12-10 07:02:00 | AAPL | Stock | 18.9379 | 18.9379 | 18.9379 | 18.9379 | 2800.0 |
| 2012-12-10 07:04:00 | AAPL | Stock | 18.9361 | 18.9361 | 18.9361 | 18.9361 | 5600.0 |
| 2012-12-10 07:05:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9286 | 18.9286 | 123200.0 |
| 2012-12-10 07:07:00 | AAPL | Stock | 18.8964 | 18.9054 | 18.8929 | 18.9054 | 24192.0 |
| 2012-12-10 07:08:00 | AAPL | Stock | 18.8936 | 18.9214 | 18.8936 | 18.9214 | 34720.0 |
| 2012-12-10 07:09:00 | AAPL | Stock | 18.9204 | 18.9204 | 18.8932 | 18.8932 | 54096.0 |
| 2012-12-10 07:10:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8896 | 18.8896 | 5600.0 |
| 2012-12-10 07:11:00 | AAPL | Stock | 18.875 | 18.9286 | 18.875 | 18.9286 | 44800.0 |
| 2012-12-10 07:12:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 18200.0 |
| 2012-12-10 07:13:00 | AAPL | Stock | 18.9214 | 18.9375 | 18.9214 | 18.9286 | 64400.0 |
| 2012-12-10 07:14:00 | AAPL | Stock | 18.9321 | 18.9464 | 18.9321 | 18.9321 | 11200.0 |
| 2012-12-10 07:15:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 17752.0 |
| 2012-12-10 07:17:00 | AAPL | Stock | 18.9161 | 18.9161 | 18.9161 | 18.9161 | 8400.0 |
| 2012-12-10 07:18:00 | AAPL | Stock | 18.8846 | 18.8929 | 18.8846 | 18.8929 | 28000.0 |
| 2012-12-10 07:20:00 | AAPL | Stock | 18.8929 | 18.9107 | 18.8929 | 18.9107 | 25536.0 |
| 2012-12-10 07:24:00 | AAPL | Stock | 18.9071 | 18.9071 | 18.9071 | 18.9071 | 2800.0 |
| 2012-12-10 07:27:00 | AAPL | Stock | 18.9207 | 18.9207 | 18.9207 | 18.9207 | 3640.0 |
| 2012-12-10 07:30:00 | AAPL | Stock | 18.9286 | 18.9357 | 18.9286 | 18.9357 | 19600.0 |
| 2012-12-10 07:31:00 | AAPL | Stock | 18.9396 | 18.9643 | 18.9396 | 18.9586 | 33600.0 |
> showing 50 of 924,087 rows — these rows as CSV