PREVIEW / stock_1min / 2013-12-30
file: by_date/stock_1min/2013/2013-12-30.parquet size: 13.8 MB rows: 1,003,762 symbols: 2,872
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-30 04:23:00 | AAPL | Stock | 19.95 | 19.9643 | 19.95 | 19.9643 | 17360.0 |
| 2013-12-30 04:24:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 8400.0 |
| 2013-12-30 04:25:00 | AAPL | Stock | 19.9618 | 19.9643 | 19.9618 | 19.9643 | 11200.0 |
| 2013-12-30 04:29:00 | AAPL | Stock | 19.9671 | 19.9671 | 19.9671 | 19.9671 | 2800.0 |
| 2013-12-30 04:30:00 | AAPL | Stock | 19.97 | 19.97 | 19.97 | 19.97 | 2800.0 |
| 2013-12-30 04:38:00 | AAPL | Stock | 19.9546 | 19.9643 | 19.9546 | 19.9643 | 14000.0 |
| 2013-12-30 05:00:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 2800.0 |
| 2013-12-30 05:13:00 | AAPL | Stock | 19.9714 | 19.9714 | 19.9714 | 19.9714 | 2800.0 |
| 2013-12-30 05:30:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 20776.0 |
| 2013-12-30 05:56:00 | AAPL | Stock | 19.9643 | 19.9686 | 19.9643 | 19.9686 | 19600.0 |
| 2013-12-30 06:14:00 | AAPL | Stock | 19.9464 | 19.9464 | 19.9464 | 19.9464 | 5600.0 |
| 2013-12-30 06:15:00 | AAPL | Stock | 19.9464 | 19.9464 | 19.9464 | 19.9464 | 14000.0 |
| 2013-12-30 06:16:00 | AAPL | Stock | 19.9464 | 19.9464 | 19.9464 | 19.9464 | 5600.0 |
| 2013-12-30 06:26:00 | AAPL | Stock | 19.9286 | 19.9286 | 19.9286 | 19.9286 | 6972.0 |
| 2013-12-30 06:29:00 | AAPL | Stock | 19.9286 | 19.9286 | 19.9286 | 19.9286 | 14000.0 |
| 2013-12-30 06:47:00 | AAPL | Stock | 19.9032 | 19.9032 | 19.9032 | 19.9032 | 2800.0 |
| 2013-12-30 06:48:00 | AAPL | Stock | 19.9032 | 19.9032 | 19.9032 | 19.9032 | 2800.0 |
| 2013-12-30 06:50:00 | AAPL | Stock | 19.8771 | 19.8771 | 19.8771 | 19.8771 | 2800.0 |
| 2013-12-30 06:56:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8936 | 19.8936 | 2800.0 |
| 2013-12-30 06:58:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8936 | 19.8936 | 6020.0 |
| 2013-12-30 07:00:00 | AAPL | Stock | 19.8925 | 19.8925 | 19.8925 | 19.8925 | 5600.0 |
| 2013-12-30 07:01:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8936 | 19.8936 | 2800.0 |
| 2013-12-30 07:03:00 | AAPL | Stock | 19.9068 | 19.9068 | 19.9068 | 19.9068 | 2800.0 |
| 2013-12-30 07:04:00 | AAPL | Stock | 19.9107 | 19.9107 | 19.9107 | 19.9107 | 5600.0 |
| 2013-12-30 07:05:00 | AAPL | Stock | 19.9071 | 19.9071 | 19.9071 | 19.9071 | 2800.0 |
| 2013-12-30 07:07:00 | AAPL | Stock | 19.9114 | 19.9114 | 19.9114 | 19.9114 | 2800.0 |
| 2013-12-30 07:09:00 | AAPL | Stock | 19.9182 | 19.9182 | 19.9182 | 19.9182 | 2800.0 |
| 2013-12-30 07:12:00 | AAPL | Stock | 19.9114 | 19.9114 | 19.9018 | 19.9054 | 28000.0 |
| 2013-12-30 07:13:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 14000.0 |
| 2013-12-30 07:14:00 | AAPL | Stock | 19.9032 | 19.9054 | 19.8839 | 19.8839 | 11200.0 |
| 2013-12-30 07:17:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8893 | 19.8893 | 14000.0 |
| 2013-12-30 07:18:00 | AAPL | Stock | 19.8925 | 19.8929 | 19.8925 | 19.8929 | 6748.0 |
| 2013-12-30 07:19:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8807 | 19.8807 | 48076.0 |
| 2013-12-30 07:20:00 | AAPL | Stock | 19.8786 | 19.8786 | 19.8786 | 19.8786 | 2800.0 |
| 2013-12-30 07:21:00 | AAPL | Stock | 19.8786 | 19.8786 | 19.8786 | 19.8786 | 11816.0 |
| 2013-12-30 07:22:00 | AAPL | Stock | 19.8786 | 19.8786 | 19.8786 | 19.8786 | 7336.0 |
| 2013-12-30 07:24:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.875 | 19.8768 | 54040.0 |
| 2013-12-30 07:25:00 | AAPL | Stock | 19.8818 | 19.8839 | 19.8668 | 19.8839 | 28196.0 |
| 2013-12-30 07:26:00 | AAPL | Stock | 19.8857 | 19.8893 | 19.8857 | 19.8893 | 5600.0 |
| 2013-12-30 07:27:00 | AAPL | Stock | 19.8893 | 19.8929 | 19.8893 | 19.8929 | 59668.0 |
| 2013-12-30 07:30:00 | AAPL | Stock | 19.9029 | 19.9068 | 19.9029 | 19.9068 | 5600.0 |
| 2013-12-30 07:32:00 | AAPL | Stock | 19.9 | 19.9 | 19.9 | 19.9 | 2800.0 |
| 2013-12-30 07:34:00 | AAPL | Stock | 19.8982 | 19.8982 | 19.8982 | 19.8982 | 2800.0 |
| 2013-12-30 07:35:00 | AAPL | Stock | 19.8957 | 19.8957 | 19.8857 | 19.8857 | 21672.0 |
| 2013-12-30 07:41:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 2800.0 |
| 2013-12-30 07:44:00 | AAPL | Stock | 19.8954 | 19.8954 | 19.8954 | 19.8954 | 2800.0 |
| 2013-12-30 07:50:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 8400.0 |
| 2013-12-30 07:52:00 | AAPL | Stock | 19.8929 | 19.9 | 19.8929 | 19.9 | 25200.0 |
| 2013-12-30 07:53:00 | AAPL | Stock | 19.8929 | 19.9 | 19.8929 | 19.9 | 21280.0 |
| 2013-12-30 07:54:00 | AAPL | Stock | 19.9 | 19.9 | 19.9 | 19.9 | 11200.0 |
> showing 50 of 1,003,762 rows — these rows as CSV