PREVIEW / stock_1min / 2011-10-11
file: by_date/stock_1min/2011/2011-10-11.parquet size: 12.8 MB rows: 972,794 symbols: 2,830
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-10-11 04:01:00 | AAPL | Stock | 13.8854 | 13.8854 | 13.8854 | 13.8854 | 5600.0 |
| 2011-10-11 04:09:00 | AAPL | Stock | 13.8989 | 13.8989 | 13.8989 | 13.8989 | 5600.0 |
| 2011-10-11 04:10:00 | AAPL | Stock | 13.8893 | 13.8986 | 13.8857 | 13.8986 | 11200.0 |
| 2011-10-11 04:18:00 | AAPL | Stock | 13.8914 | 13.8914 | 13.8857 | 13.8857 | 11200.0 |
| 2011-10-11 04:19:00 | AAPL | Stock | 13.9093 | 13.9111 | 13.9093 | 13.9111 | 5600.0 |
| 2011-10-11 04:21:00 | AAPL | Stock | 13.8957 | 13.8957 | 13.8957 | 13.8957 | 5600.0 |
| 2011-10-11 04:26:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 5600.0 |
| 2011-10-11 04:27:00 | AAPL | Stock | 13.9111 | 13.9111 | 13.9111 | 13.9111 | 2800.0 |
| 2011-10-11 04:35:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-10-11 04:40:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 8400.0 |
| 2011-10-11 04:41:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-10-11 04:45:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 5600.0 |
| 2011-10-11 04:47:00 | AAPL | Stock | 13.87 | 13.87 | 13.87 | 13.87 | 2800.0 |
| 2011-10-11 04:48:00 | AAPL | Stock | 13.8611 | 13.8611 | 13.8611 | 13.8611 | 2800.0 |
| 2011-10-11 04:51:00 | AAPL | Stock | 13.8779 | 13.8821 | 13.8779 | 13.8779 | 10360.0 |
| 2011-10-11 04:57:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8836 | 13.8836 | 5600.0 |
| 2011-10-11 04:58:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8836 | 13.8836 | 8400.0 |
| 2011-10-11 05:14:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-10-11 05:47:00 | AAPL | Stock | 13.8914 | 13.8914 | 13.8914 | 13.8914 | 2800.0 |
| 2011-10-11 06:06:00 | AAPL | Stock | 13.9082 | 13.9082 | 13.9082 | 13.9082 | 5600.0 |
| 2011-10-11 06:07:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 2800.0 |
| 2011-10-11 06:32:00 | AAPL | Stock | 13.8839 | 13.8839 | 13.8839 | 13.8839 | 7000.0 |
| 2011-10-11 07:00:00 | AAPL | Stock | 13.8668 | 13.9107 | 13.8668 | 13.9107 | 11200.0 |
| 2011-10-11 07:03:00 | AAPL | Stock | 13.91 | 13.91 | 13.91 | 13.91 | 2800.0 |
| 2011-10-11 07:07:00 | AAPL | Stock | 13.9018 | 13.9018 | 13.8971 | 13.8971 | 5600.0 |
| 2011-10-11 07:08:00 | AAPL | Stock | 13.91 | 13.91 | 13.91 | 13.91 | 19600.0 |
| 2011-10-11 07:09:00 | AAPL | Stock | 13.9157 | 13.9236 | 13.9157 | 13.9236 | 5600.0 |
| 2011-10-11 07:12:00 | AAPL | Stock | 13.9239 | 13.9239 | 13.9239 | 13.9239 | 5600.0 |
| 2011-10-11 07:13:00 | AAPL | Stock | 13.9232 | 13.9232 | 13.9157 | 13.9157 | 5600.0 |
| 2011-10-11 07:14:00 | AAPL | Stock | 13.9232 | 13.9286 | 13.9232 | 13.9286 | 65800.0 |
| 2011-10-11 07:15:00 | AAPL | Stock | 13.9107 | 13.9286 | 13.9107 | 13.9286 | 7532.0 |
| 2011-10-11 07:16:00 | AAPL | Stock | 13.9318 | 13.9325 | 13.9318 | 13.9325 | 5600.0 |
| 2011-10-11 07:17:00 | AAPL | Stock | 13.9325 | 13.9325 | 13.9325 | 13.9325 | 2800.0 |
| 2011-10-11 07:18:00 | AAPL | Stock | 13.9196 | 13.9196 | 13.9157 | 13.9157 | 28000.0 |
| 2011-10-11 07:20:00 | AAPL | Stock | 13.9057 | 13.9057 | 13.8939 | 13.8939 | 12376.0 |
| 2011-10-11 07:21:00 | AAPL | Stock | 13.9196 | 13.9207 | 13.9196 | 13.9207 | 14000.0 |
| 2011-10-11 07:28:00 | AAPL | Stock | 13.9129 | 13.9129 | 13.9129 | 13.9129 | 2800.0 |
| 2011-10-11 07:32:00 | AAPL | Stock | 13.9275 | 13.9275 | 13.9275 | 13.9275 | 2800.0 |
| 2011-10-11 07:33:00 | AAPL | Stock | 13.9132 | 13.9225 | 13.9071 | 13.9071 | 27860.0 |
| 2011-10-11 07:34:00 | AAPL | Stock | 13.9061 | 13.9061 | 13.9043 | 13.9043 | 8400.0 |
| 2011-10-11 07:35:00 | AAPL | Stock | 13.8954 | 13.9036 | 13.8954 | 13.9036 | 8400.0 |
| 2011-10-11 07:42:00 | AAPL | Stock | 13.9168 | 13.9179 | 13.9168 | 13.9179 | 14000.0 |
| 2011-10-11 07:43:00 | AAPL | Stock | 13.9175 | 13.9175 | 13.9175 | 13.9175 | 2800.0 |
| 2011-10-11 07:45:00 | AAPL | Stock | 13.9271 | 13.9443 | 13.9271 | 13.9296 | 40908.0 |
| 2011-10-11 07:47:00 | AAPL | Stock | 13.9354 | 13.9354 | 13.9214 | 13.9214 | 11200.0 |
| 2011-10-11 07:48:00 | AAPL | Stock | 13.9193 | 13.9193 | 13.9179 | 13.9179 | 14000.0 |
| 2011-10-11 07:50:00 | AAPL | Stock | 13.9289 | 13.9289 | 13.9286 | 13.9286 | 5600.0 |
| 2011-10-11 07:51:00 | AAPL | Stock | 13.9282 | 13.9282 | 13.9282 | 13.9282 | 2800.0 |
| 2011-10-11 07:52:00 | AAPL | Stock | 13.9189 | 13.92 | 13.9179 | 13.9186 | 19600.0 |
| 2011-10-11 07:53:00 | AAPL | Stock | 13.9182 | 13.9182 | 13.9182 | 13.9182 | 2800.0 |
> showing 50 of 972,794 rows — these rows as CSV