PREVIEW / stock_1min / 2009-12-22
file: by_date/stock_1min/2009/2009-12-22.parquet size: 12.4 MB rows: 932,713 symbols: 2,797
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-22 04:32:00 | AAPL | Stock | 7.0836 | 7.0836 | 7.0836 | 7.0836 | 5600.0 |
| 2009-12-22 05:35:00 | AAPL | Stock | 7.0914 | 7.0914 | 7.0914 | 7.0914 | 8400.0 |
| 2009-12-22 06:26:00 | AAPL | Stock | 7.0882 | 7.0882 | 7.0882 | 7.0882 | 14000.0 |
| 2009-12-22 06:30:00 | AAPL | Stock | 7.0961 | 7.0961 | 7.0961 | 7.0961 | 4200.0 |
| 2009-12-22 06:31:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 5600.0 |
| 2009-12-22 06:57:00 | AAPL | Stock | 7.0811 | 7.0811 | 7.0811 | 7.0811 | 14000.0 |
| 2009-12-22 07:00:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0893 | 7.0893 | 2800.0 |
| 2009-12-22 07:01:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 2800.0 |
| 2009-12-22 07:02:00 | AAPL | Stock | 7.0804 | 7.0804 | 7.0804 | 7.0804 | 2800.0 |
| 2009-12-22 07:05:00 | AAPL | Stock | 7.0893 | 7.0907 | 7.0893 | 7.0907 | 34832.0 |
| 2009-12-22 07:20:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 4900.0 |
| 2009-12-22 07:22:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1071 | 7.1071 | 5600.0 |
| 2009-12-22 07:23:00 | AAPL | Stock | 7.1175 | 7.1175 | 7.1175 | 7.1175 | 2800.0 |
| 2009-12-22 07:30:00 | AAPL | Stock | 7.1161 | 7.1171 | 7.1143 | 7.1143 | 30800.0 |
| 2009-12-22 07:33:00 | AAPL | Stock | 7.1157 | 7.1157 | 7.1157 | 7.1157 | 2800.0 |
| 2009-12-22 07:34:00 | AAPL | Stock | 7.1136 | 7.1154 | 7.1136 | 7.1154 | 30800.0 |
| 2009-12-22 07:37:00 | AAPL | Stock | 7.1111 | 7.1121 | 7.1111 | 7.1121 | 8400.0 |
| 2009-12-22 07:38:00 | AAPL | Stock | 7.1111 | 7.1111 | 7.1107 | 7.1107 | 11200.0 |
| 2009-12-22 07:44:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1143 | 7.1143 | 54320.0 |
| 2009-12-22 07:46:00 | AAPL | Stock | 7.1121 | 7.1121 | 7.1121 | 7.1121 | 2800.0 |
| 2009-12-22 07:47:00 | AAPL | Stock | 7.1132 | 7.1132 | 7.1132 | 7.1132 | 14000.0 |
| 2009-12-22 07:49:00 | AAPL | Stock | 7.1114 | 7.1114 | 7.1114 | 7.1114 | 14000.0 |
| 2009-12-22 07:51:00 | AAPL | Stock | 7.1114 | 7.1125 | 7.1114 | 7.1125 | 5600.0 |
| 2009-12-22 07:52:00 | AAPL | Stock | 7.1114 | 7.1114 | 7.11 | 7.11 | 16016.0 |
| 2009-12-22 07:56:00 | AAPL | Stock | 7.1093 | 7.1093 | 7.1093 | 7.1093 | 2800.0 |
| 2009-12-22 07:58:00 | AAPL | Stock | 7.1132 | 7.1143 | 7.1132 | 7.1132 | 100100.0 |
| 2009-12-22 07:59:00 | AAPL | Stock | 7.1132 | 7.1132 | 7.1132 | 7.1132 | 19600.0 |
| 2009-12-22 08:00:00 | AAPL | Stock | 7.1143 | 7.1161 | 7.1132 | 7.1161 | 185304.0 |
| 2009-12-22 08:01:00 | AAPL | Stock | 7.1154 | 7.1179 | 7.1154 | 7.1168 | 52080.0 |
| 2009-12-22 08:02:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1114 | 7.1114 | 48580.0 |
| 2009-12-22 08:03:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1125 | 7.1125 | 29624.0 |
| 2009-12-22 08:04:00 | AAPL | Stock | 7.1125 | 7.1143 | 7.1125 | 7.1143 | 35000.0 |
| 2009-12-22 08:05:00 | AAPL | Stock | 7.1157 | 7.1171 | 7.1107 | 7.115 | 77000.0 |
| 2009-12-22 08:06:00 | AAPL | Stock | 7.1175 | 7.1179 | 7.1161 | 7.1161 | 36400.0 |
| 2009-12-22 08:07:00 | AAPL | Stock | 7.1175 | 7.1182 | 7.1161 | 7.1182 | 77000.0 |
| 2009-12-22 08:08:00 | AAPL | Stock | 7.1186 | 7.1193 | 7.115 | 7.115 | 67844.0 |
| 2009-12-22 08:09:00 | AAPL | Stock | 7.1161 | 7.1168 | 7.0796 | 7.1168 | 134680.0 |
| 2009-12-22 08:10:00 | AAPL | Stock | 7.1171 | 7.1186 | 7.1157 | 7.1157 | 16800.0 |
| 2009-12-22 08:11:00 | AAPL | Stock | 7.1161 | 7.1164 | 7.1161 | 7.1161 | 175420.0 |
| 2009-12-22 08:12:00 | AAPL | Stock | 7.115 | 7.1161 | 7.1125 | 7.1125 | 102088.0 |
| 2009-12-22 08:13:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1143 | 7.1143 | 2800.0 |
| 2009-12-22 08:14:00 | AAPL | Stock | 7.1129 | 7.1129 | 7.1125 | 7.1129 | 14000.0 |
| 2009-12-22 08:16:00 | AAPL | Stock | 7.1136 | 7.1136 | 7.1125 | 7.1125 | 25200.0 |
| 2009-12-22 08:17:00 | AAPL | Stock | 7.1136 | 7.1136 | 7.1136 | 7.1136 | 2800.0 |
| 2009-12-22 08:18:00 | AAPL | Stock | 7.1154 | 7.1154 | 7.1089 | 7.1107 | 55384.0 |
| 2009-12-22 08:19:00 | AAPL | Stock | 7.1143 | 7.1161 | 7.1143 | 7.1154 | 57820.0 |
| 2009-12-22 08:20:00 | AAPL | Stock | 7.1161 | 7.1175 | 7.1161 | 7.1175 | 33600.0 |
| 2009-12-22 08:22:00 | AAPL | Stock | 7.1154 | 7.1161 | 7.1154 | 7.1161 | 32480.0 |
| 2009-12-22 08:23:00 | AAPL | Stock | 7.1161 | 7.1161 | 7.1143 | 7.1143 | 28000.0 |
| 2009-12-22 08:24:00 | AAPL | Stock | 7.1157 | 7.1161 | 7.1157 | 7.1161 | 18536.0 |
> showing 50 of 932,713 rows — these rows as CSV