PREVIEW / stock_1min / 2011-06-07
file: by_date/stock_1min/2011/2011-06-07.parquet size: 13.3 MB rows: 1,007,821 symbols: 2,875
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-06-07 04:00:00 | AAPL | Stock | 12.1107 | 12.1107 | 12.1107 | 12.1107 | 2800.0 |
| 2011-06-07 04:38:00 | AAPL | Stock | 12.1425 | 12.1425 | 12.1425 | 12.1425 | 2800.0 |
| 2011-06-07 04:56:00 | AAPL | Stock | 12.1425 | 12.1425 | 12.1425 | 12.1425 | 2800.0 |
| 2011-06-07 06:00:00 | AAPL | Stock | 12.1382 | 12.1425 | 12.1382 | 12.1425 | 14000.0 |
| 2011-06-07 06:20:00 | AAPL | Stock | 12.1354 | 12.1354 | 12.1354 | 12.1354 | 2800.0 |
| 2011-06-07 07:01:00 | AAPL | Stock | 12.1107 | 12.1143 | 12.1107 | 12.1143 | 16800.0 |
| 2011-06-07 07:02:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 5600.0 |
| 2011-06-07 07:03:00 | AAPL | Stock | 12.0893 | 12.1071 | 12.0893 | 12.1071 | 6020.0 |
| 2011-06-07 07:04:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 3248.0 |
| 2011-06-07 07:10:00 | AAPL | Stock | 12.1118 | 12.1118 | 12.1071 | 12.1071 | 5600.0 |
| 2011-06-07 07:11:00 | AAPL | Stock | 12.1107 | 12.1118 | 12.1107 | 12.1118 | 14000.0 |
| 2011-06-07 07:15:00 | AAPL | Stock | 12.1118 | 12.1118 | 12.1118 | 12.1118 | 13720.0 |
| 2011-06-07 07:19:00 | AAPL | Stock | 12.1107 | 12.1107 | 12.11 | 12.1104 | 27860.0 |
| 2011-06-07 07:21:00 | AAPL | Stock | 12.1114 | 12.1114 | 12.1114 | 12.1114 | 2800.0 |
| 2011-06-07 07:22:00 | AAPL | Stock | 12.1114 | 12.1114 | 12.1071 | 12.1071 | 5600.0 |
| 2011-06-07 07:23:00 | AAPL | Stock | 12.1061 | 12.1071 | 12.1061 | 12.1071 | 16800.0 |
| 2011-06-07 07:28:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 3500.0 |
| 2011-06-07 07:29:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-06-07 07:31:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 15680.0 |
| 2011-06-07 07:33:00 | AAPL | Stock | 12.1118 | 12.1118 | 12.1071 | 12.1071 | 22372.0 |
| 2011-06-07 07:35:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 8400.0 |
| 2011-06-07 07:36:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-06-07 07:38:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1064 | 12.1064 | 8400.0 |
| 2011-06-07 07:39:00 | AAPL | Stock | 12.1068 | 12.1068 | 12.1068 | 12.1068 | 11200.0 |
| 2011-06-07 07:40:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 22288.0 |
| 2011-06-07 07:42:00 | AAPL | Stock | 12.0964 | 12.0964 | 12.0964 | 12.0964 | 44800.0 |
| 2011-06-07 07:44:00 | AAPL | Stock | 12.1029 | 12.1029 | 12.0936 | 12.0971 | 14000.0 |
| 2011-06-07 07:46:00 | AAPL | Stock | 12.1046 | 12.1046 | 12.1046 | 12.1046 | 3220.0 |
| 2011-06-07 07:47:00 | AAPL | Stock | 12.1046 | 12.1071 | 12.1046 | 12.1071 | 12180.0 |
| 2011-06-07 07:48:00 | AAPL | Stock | 12.1071 | 12.1193 | 12.1071 | 12.1179 | 43400.0 |
| 2011-06-07 07:49:00 | AAPL | Stock | 12.1154 | 12.1154 | 12.1154 | 12.1154 | 11200.0 |
| 2011-06-07 07:51:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 8400.0 |
| 2011-06-07 07:53:00 | AAPL | Stock | 12.1143 | 12.1143 | 12.1143 | 12.1143 | 2800.0 |
| 2011-06-07 07:54:00 | AAPL | Stock | 12.115 | 12.115 | 12.1143 | 12.1143 | 14000.0 |
| 2011-06-07 07:55:00 | AAPL | Stock | 12.1157 | 12.1179 | 12.1157 | 12.1179 | 16800.0 |
| 2011-06-07 07:56:00 | AAPL | Stock | 12.1161 | 12.1204 | 12.1161 | 12.1204 | 16800.0 |
| 2011-06-07 07:57:00 | AAPL | Stock | 12.1239 | 12.1261 | 12.1239 | 12.1261 | 23912.0 |
| 2011-06-07 07:58:00 | AAPL | Stock | 12.125 | 12.1332 | 12.125 | 12.1332 | 36400.0 |
| 2011-06-07 07:59:00 | AAPL | Stock | 12.1254 | 12.1254 | 12.1161 | 12.1161 | 152992.0 |
| 2011-06-07 08:00:00 | AAPL | Stock | 12.1175 | 12.1214 | 12.1107 | 12.1182 | 60648.0 |
| 2011-06-07 08:01:00 | AAPL | Stock | 12.1175 | 12.1175 | 12.1157 | 12.1168 | 14000.0 |
| 2011-06-07 08:02:00 | AAPL | Stock | 12.1089 | 12.1089 | 12.1089 | 12.1089 | 5600.0 |
| 2011-06-07 08:03:00 | AAPL | Stock | 12.1082 | 12.1082 | 12.1043 | 12.1043 | 19600.0 |
| 2011-06-07 08:04:00 | AAPL | Stock | 12.1043 | 12.1071 | 12.1043 | 12.1043 | 8400.0 |
| 2011-06-07 08:05:00 | AAPL | Stock | 12.1036 | 12.1043 | 12.1036 | 12.1036 | 11200.0 |
| 2011-06-07 08:06:00 | AAPL | Stock | 12.1032 | 12.1036 | 12.1032 | 12.1036 | 11200.0 |
| 2011-06-07 08:07:00 | AAPL | Stock | 12.1036 | 12.1071 | 12.1036 | 12.1036 | 36400.0 |
| 2011-06-07 08:08:00 | AAPL | Stock | 12.1068 | 12.1104 | 12.1068 | 12.1104 | 29260.0 |
| 2011-06-07 08:09:00 | AAPL | Stock | 12.115 | 12.1179 | 12.1107 | 12.1107 | 28280.0 |
| 2011-06-07 08:10:00 | AAPL | Stock | 12.1114 | 12.1136 | 12.1114 | 12.1136 | 8400.0 |
> showing 50 of 1,007,821 rows — these rows as CSV