PREVIEW / stock_1min / 2006-12-08
file: by_date/stock_1min/2006/2006-12-08.parquet size: 8.6 MB rows: 691,503 symbols: 1,999
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-08 04:15:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 2800.0 |
| 2006-12-08 07:25:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 14000.0 |
| 2006-12-08 07:26:00 | AAPL | Stock | 3.1046 | 3.1046 | 3.1046 | 3.1046 | 5600.0 |
| 2006-12-08 07:31:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 5740.0 |
| 2006-12-08 07:39:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 3808.0 |
| 2006-12-08 07:40:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 2800.0 |
| 2006-12-08 07:50:00 | AAPL | Stock | 3.1032 | 3.1032 | 3.1032 | 3.1032 | 2800.0 |
| 2006-12-08 08:00:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1036 | 3.1036 | 8400.0 |
| 2006-12-08 08:01:00 | AAPL | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 8540.0 |
| 2006-12-08 08:03:00 | AAPL | Stock | 3.1 | 3.1036 | 3.1 | 3.1036 | 60200.0 |
| 2006-12-08 08:04:00 | AAPL | Stock | 3.1036 | 3.115 | 3.1036 | 3.115 | 117992.0 |
| 2006-12-08 08:05:00 | AAPL | Stock | 3.1107 | 3.1114 | 3.1089 | 3.1089 | 64400.0 |
| 2006-12-08 08:06:00 | AAPL | Stock | 3.1071 | 3.1107 | 3.1071 | 3.1107 | 36400.0 |
| 2006-12-08 08:07:00 | AAPL | Stock | 3.1114 | 3.1114 | 3.1107 | 3.1107 | 135800.0 |
| 2006-12-08 08:08:00 | AAPL | Stock | 3.1093 | 3.1093 | 3.1089 | 3.1089 | 16800.0 |
| 2006-12-08 08:09:00 | AAPL | Stock | 3.1107 | 3.1111 | 3.1107 | 3.1107 | 89600.0 |
| 2006-12-08 08:10:00 | AAPL | Stock | 3.1107 | 3.1107 | 3.1071 | 3.1107 | 30940.0 |
| 2006-12-08 08:11:00 | AAPL | Stock | 3.1107 | 3.1143 | 3.1071 | 3.1071 | 166880.0 |
| 2006-12-08 08:12:00 | AAPL | Stock | 3.1107 | 3.1107 | 3.1107 | 3.1107 | 4200.0 |
| 2006-12-08 08:13:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 28000.0 |
| 2006-12-08 08:14:00 | AAPL | Stock | 3.1107 | 3.1129 | 3.1104 | 3.1121 | 102760.0 |
| 2006-12-08 08:15:00 | AAPL | Stock | 3.1071 | 3.1107 | 3.1071 | 3.1107 | 33740.0 |
| 2006-12-08 08:16:00 | AAPL | Stock | 3.1086 | 3.1121 | 3.1086 | 3.1121 | 25200.0 |
| 2006-12-08 08:17:00 | AAPL | Stock | 3.1082 | 3.1082 | 3.1082 | 3.1082 | 7840.0 |
| 2006-12-08 08:18:00 | AAPL | Stock | 3.1107 | 3.1121 | 3.1107 | 3.1121 | 42000.0 |
| 2006-12-08 08:20:00 | AAPL | Stock | 3.11 | 3.11 | 3.1086 | 3.1086 | 54628.0 |
| 2006-12-08 08:21:00 | AAPL | Stock | 3.1107 | 3.1114 | 3.1089 | 3.1114 | 56840.0 |
| 2006-12-08 08:22:00 | AAPL | Stock | 3.1114 | 3.1114 | 3.1086 | 3.1107 | 42000.0 |
| 2006-12-08 08:23:00 | AAPL | Stock | 3.1107 | 3.1107 | 3.1107 | 3.1107 | 27020.0 |
| 2006-12-08 08:24:00 | AAPL | Stock | 3.1107 | 3.1107 | 3.1104 | 3.1104 | 12180.0 |
| 2006-12-08 08:25:00 | AAPL | Stock | 3.1104 | 3.1104 | 3.11 | 3.1104 | 13300.0 |
| 2006-12-08 08:26:00 | AAPL | Stock | 3.1107 | 3.1114 | 3.1104 | 3.1114 | 44520.0 |
| 2006-12-08 08:27:00 | AAPL | Stock | 3.1114 | 3.1136 | 3.1107 | 3.1107 | 167160.0 |
| 2006-12-08 08:28:00 | AAPL | Stock | 3.11 | 3.11 | 3.1029 | 3.1029 | 153104.0 |
| 2006-12-08 08:29:00 | AAPL | Stock | 3.1054 | 3.1054 | 3.1054 | 3.1054 | 18872.0 |
| 2006-12-08 08:30:00 | AAPL | Stock | 3.1071 | 3.1161 | 3.1071 | 3.1161 | 535556.0 |
| 2006-12-08 08:31:00 | AAPL | Stock | 3.1168 | 3.1232 | 3.1161 | 3.1214 | 566748.0 |
| 2006-12-08 08:32:00 | AAPL | Stock | 3.1214 | 3.1243 | 3.1211 | 3.1211 | 611100.0 |
| 2006-12-08 08:33:00 | AAPL | Stock | 3.12 | 3.1218 | 3.1182 | 3.1214 | 258300.0 |
| 2006-12-08 08:34:00 | AAPL | Stock | 3.1189 | 3.1246 | 3.1189 | 3.1221 | 237720.0 |
| 2006-12-08 08:35:00 | AAPL | Stock | 3.1232 | 3.1254 | 3.1225 | 3.125 | 100828.0 |
| 2006-12-08 08:36:00 | AAPL | Stock | 3.1268 | 3.1268 | 3.1225 | 3.1268 | 199080.0 |
| 2006-12-08 08:37:00 | AAPL | Stock | 3.1268 | 3.1286 | 3.125 | 3.1286 | 222712.0 |
| 2006-12-08 08:38:00 | AAPL | Stock | 3.1271 | 3.1304 | 3.1268 | 3.1304 | 403480.0 |
| 2006-12-08 08:39:00 | AAPL | Stock | 3.1304 | 3.1304 | 3.1286 | 3.1293 | 130480.0 |
| 2006-12-08 08:40:00 | AAPL | Stock | 3.1293 | 3.1321 | 3.1282 | 3.1321 | 575344.0 |
| 2006-12-08 08:41:00 | AAPL | Stock | 3.1321 | 3.1332 | 3.1304 | 3.1307 | 130200.0 |
| 2006-12-08 08:42:00 | AAPL | Stock | 3.1304 | 3.1321 | 3.125 | 3.1289 | 233940.0 |
| 2006-12-08 08:43:00 | AAPL | Stock | 3.1286 | 3.1304 | 3.1268 | 3.1289 | 160552.0 |
| 2006-12-08 08:44:00 | AAPL | Stock | 3.1293 | 3.1321 | 3.1293 | 3.1321 | 50120.0 |
> showing 50 of 691,503 rows — these rows as CSV