PREVIEW / stock_1min / 2011-03-04
file: by_date/stock_1min/2011/2011-03-04.parquet size: 13.4 MB rows: 999,135 symbols: 2,859
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-03-04 04:13:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 2800.0 |
| 2011-03-04 05:29:00 | AAPL | Stock | 12.9 | 12.9 | 12.9 | 12.9 | 2800.0 |
| 2011-03-04 05:31:00 | AAPL | Stock | 12.9 | 12.9 | 12.9 | 12.9 | 11200.0 |
| 2011-03-04 05:36:00 | AAPL | Stock | 12.9082 | 12.9082 | 12.9082 | 12.9082 | 16100.0 |
| 2011-03-04 06:02:00 | AAPL | Stock | 12.9154 | 12.9154 | 12.9154 | 12.9154 | 5600.0 |
| 2011-03-04 06:27:00 | AAPL | Stock | 12.915 | 12.915 | 12.915 | 12.915 | 2800.0 |
| 2011-03-04 06:39:00 | AAPL | Stock | 12.9154 | 12.9154 | 12.9154 | 12.9154 | 5600.0 |
| 2011-03-04 06:40:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 5600.0 |
| 2011-03-04 06:42:00 | AAPL | Stock | 12.9154 | 12.9154 | 12.9154 | 12.9154 | 5600.0 |
| 2011-03-04 06:48:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 2800.0 |
| 2011-03-04 07:00:00 | AAPL | Stock | 12.9018 | 12.9018 | 12.9018 | 12.9018 | 7840.0 |
| 2011-03-04 07:01:00 | AAPL | Stock | 12.8982 | 12.8982 | 12.8982 | 12.8982 | 201600.0 |
| 2011-03-04 07:02:00 | AAPL | Stock | 12.8982 | 12.9007 | 12.8982 | 12.9007 | 22400.0 |
| 2011-03-04 07:03:00 | AAPL | Stock | 12.9014 | 12.9018 | 12.8929 | 12.8929 | 152040.0 |
| 2011-03-04 07:09:00 | AAPL | Stock | 12.8954 | 12.8954 | 12.8929 | 12.8929 | 17976.0 |
| 2011-03-04 07:11:00 | AAPL | Stock | 12.8736 | 12.8736 | 12.8714 | 12.8714 | 33600.0 |
| 2011-03-04 07:12:00 | AAPL | Stock | 12.8714 | 12.8732 | 12.8714 | 12.8714 | 11200.0 |
| 2011-03-04 07:14:00 | AAPL | Stock | 12.8746 | 12.8746 | 12.8746 | 12.8746 | 11200.0 |
| 2011-03-04 07:15:00 | AAPL | Stock | 12.8821 | 12.8821 | 12.8821 | 12.8821 | 2800.0 |
| 2011-03-04 07:17:00 | AAPL | Stock | 12.8682 | 12.8804 | 12.8682 | 12.8804 | 16464.0 |
| 2011-03-04 07:18:00 | AAPL | Stock | 12.8857 | 12.8857 | 12.8857 | 12.8857 | 2800.0 |
| 2011-03-04 07:22:00 | AAPL | Stock | 12.8871 | 12.8871 | 12.8871 | 12.8871 | 2800.0 |
| 2011-03-04 07:30:00 | AAPL | Stock | 12.8911 | 12.8929 | 12.8911 | 12.8929 | 84000.0 |
| 2011-03-04 07:32:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8914 | 12.8929 | 8400.0 |
| 2011-03-04 07:33:00 | AAPL | Stock | 12.8929 | 12.895 | 12.8929 | 12.895 | 8400.0 |
| 2011-03-04 07:34:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 14000.0 |
| 2011-03-04 07:35:00 | AAPL | Stock | 12.9011 | 12.9011 | 12.9011 | 12.9011 | 2800.0 |
| 2011-03-04 07:36:00 | AAPL | Stock | 12.9007 | 12.9007 | 12.8907 | 12.8907 | 8400.0 |
| 2011-03-04 07:39:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 9800.0 |
| 2011-03-04 07:40:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 5600.0 |
| 2011-03-04 07:42:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 5600.0 |
| 2011-03-04 07:43:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 11200.0 |
| 2011-03-04 07:44:00 | AAPL | Stock | 12.8911 | 12.8929 | 12.8893 | 12.8893 | 37800.0 |
| 2011-03-04 07:45:00 | AAPL | Stock | 12.8843 | 12.8843 | 12.8807 | 12.8807 | 27300.0 |
| 2011-03-04 07:49:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 27300.0 |
| 2011-03-04 07:50:00 | AAPL | Stock | 12.8921 | 12.8921 | 12.8921 | 12.8921 | 5600.0 |
| 2011-03-04 07:59:00 | AAPL | Stock | 12.8918 | 12.895 | 12.8918 | 12.895 | 67424.0 |
| 2011-03-04 08:00:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8668 | 12.8893 | 146132.0 |
| 2011-03-04 08:01:00 | AAPL | Stock | 12.8893 | 12.8893 | 12.8829 | 12.8829 | 27860.0 |
| 2011-03-04 08:02:00 | AAPL | Stock | 12.8893 | 12.8911 | 12.8825 | 12.8893 | 41496.0 |
| 2011-03-04 08:03:00 | AAPL | Stock | 12.8893 | 12.8914 | 12.8843 | 12.8875 | 64400.0 |
| 2011-03-04 08:04:00 | AAPL | Stock | 12.8857 | 12.8857 | 12.8843 | 12.885 | 45920.0 |
| 2011-03-04 08:05:00 | AAPL | Stock | 12.885 | 12.8864 | 12.8825 | 12.8825 | 71344.0 |
| 2011-03-04 08:06:00 | AAPL | Stock | 12.8821 | 12.8871 | 12.8821 | 12.8821 | 100828.0 |
| 2011-03-04 08:07:00 | AAPL | Stock | 12.8821 | 12.8893 | 12.8786 | 12.8879 | 146776.0 |
| 2011-03-04 08:08:00 | AAPL | Stock | 12.8893 | 12.8925 | 12.8839 | 12.8893 | 194208.0 |
| 2011-03-04 08:09:00 | AAPL | Stock | 12.8911 | 12.8925 | 12.8839 | 12.8914 | 135856.0 |
| 2011-03-04 08:10:00 | AAPL | Stock | 12.8914 | 12.8914 | 12.8914 | 12.8914 | 5600.0 |
| 2011-03-04 08:11:00 | AAPL | Stock | 12.8925 | 12.895 | 12.8925 | 12.8932 | 40516.0 |
| 2011-03-04 08:12:00 | AAPL | Stock | 12.8971 | 12.9018 | 12.8971 | 12.8982 | 42000.0 |
> showing 50 of 999,135 rows — these rows as CSV