PREVIEW / stock_5min / 2006-12-13
file: by_date/stock_5min/2006/2006-12-13.parquet size: 3.3 MB rows: 240,088 symbols: 2,471
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-13 06:15:00 | AAPL | Stock | 3.0804 | 3.0804 | 3.0804 | 3.0804 | 42000.0 |
| 2006-12-13 06:20:00 | AAPL | Stock | 3.0829 | 3.0846 | 3.0829 | 3.0846 | 47600.0 |
| 2006-12-13 06:25:00 | AAPL | Stock | 3.0846 | 3.1036 | 3.0846 | 3.1036 | 51436.0 |
| 2006-12-13 06:30:00 | AAPL | Stock | 3.0996 | 3.1071 | 3.0996 | 3.1071 | 115836.0 |
| 2006-12-13 06:45:00 | AAPL | Stock | 3.1157 | 3.1157 | 3.1157 | 3.1157 | 5600.0 |
| 2006-12-13 06:50:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 56000.0 |
| 2006-12-13 06:55:00 | AAPL | Stock | 3.1093 | 3.1093 | 3.1093 | 3.1093 | 5600.0 |
| 2006-12-13 07:00:00 | AAPL | Stock | 3.1071 | 3.1075 | 3.1071 | 3.1071 | 41580.0 |
| 2006-12-13 07:05:00 | AAPL | Stock | 3.1139 | 3.1161 | 3.1139 | 3.1161 | 22400.0 |
| 2006-12-13 07:15:00 | AAPL | Stock | 3.1143 | 3.1279 | 3.1143 | 3.125 | 275996.0 |
| 2006-12-13 07:20:00 | AAPL | Stock | 3.1246 | 3.1246 | 3.1164 | 3.1164 | 44884.0 |
| 2006-12-13 07:25:00 | AAPL | Stock | 3.1193 | 3.1193 | 3.1114 | 3.1171 | 45920.0 |
| 2006-12-13 07:30:00 | AAPL | Stock | 3.1104 | 3.1143 | 3.1104 | 3.1129 | 144396.0 |
| 2006-12-13 07:35:00 | AAPL | Stock | 3.1107 | 3.1129 | 3.11 | 3.11 | 36400.0 |
| 2006-12-13 07:40:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 30800.0 |
| 2006-12-13 07:45:00 | AAPL | Stock | 3.1118 | 3.1207 | 3.1089 | 3.1143 | 345800.0 |
| 2006-12-13 07:50:00 | AAPL | Stock | 3.1146 | 3.1189 | 3.1093 | 3.1189 | 299404.0 |
| 2006-12-13 07:55:00 | AAPL | Stock | 3.1179 | 3.1232 | 3.1179 | 3.1214 | 205800.0 |
| 2006-12-13 08:00:00 | AAPL | Stock | 3.1186 | 3.125 | 3.1139 | 3.1189 | 2641184.0 |
| 2006-12-13 08:05:00 | AAPL | Stock | 3.1189 | 3.1214 | 3.1175 | 3.1196 | 609532.0 |
| 2006-12-13 08:10:00 | AAPL | Stock | 3.1207 | 3.1229 | 3.1186 | 3.12 | 1206128.0 |
| 2006-12-13 08:15:00 | AAPL | Stock | 3.1207 | 3.1236 | 3.1196 | 3.1214 | 606452.0 |
| 2006-12-13 08:20:00 | AAPL | Stock | 3.12 | 3.1214 | 3.1182 | 3.12 | 261240.0 |
| 2006-12-13 08:25:00 | AAPL | Stock | 3.1196 | 3.1204 | 3.1161 | 3.1179 | 635180.0 |
| 2006-12-13 08:30:00 | AAPL | Stock | 3.1193 | 3.1218 | 3.1175 | 3.1175 | 716240.0 |
| 2006-12-13 08:35:00 | AAPL | Stock | 3.1193 | 3.1207 | 3.1161 | 3.1179 | 429632.0 |
| 2006-12-13 08:40:00 | AAPL | Stock | 3.1179 | 3.1207 | 3.1161 | 3.1171 | 737240.0 |
| 2006-12-13 08:45:00 | AAPL | Stock | 3.1171 | 3.1214 | 3.1171 | 3.1189 | 983500.0 |
| 2006-12-13 08:50:00 | AAPL | Stock | 3.1196 | 3.1268 | 3.1196 | 3.1243 | 1310008.0 |
| 2006-12-13 08:55:00 | AAPL | Stock | 3.1229 | 3.1282 | 3.12 | 3.1279 | 1027600.0 |
| 2006-12-13 09:00:00 | AAPL | Stock | 3.1279 | 3.1339 | 3.1275 | 3.1336 | 1837248.0 |
| 2006-12-13 09:05:00 | AAPL | Stock | 3.1339 | 3.1357 | 3.1304 | 3.1321 | 1574860.0 |
| 2006-12-13 09:10:00 | AAPL | Stock | 3.1339 | 3.1357 | 3.1304 | 3.1321 | 994084.0 |
| 2006-12-13 09:15:00 | AAPL | Stock | 3.1321 | 3.1375 | 3.1321 | 3.1339 | 623252.0 |
| 2006-12-13 09:20:00 | AAPL | Stock | 3.1336 | 3.1354 | 3.1318 | 3.1336 | 422100.0 |
| 2006-12-13 09:25:00 | AAPL | Stock | 3.1336 | 3.1418 | 3.1336 | 3.1404 | 2696596.0 |
| 2006-12-13 09:30:00 | AAPL | Stock | 3.1411 | 3.1461 | 3.1268 | 3.1454 | 45405024.0 |
| 2006-12-13 09:35:00 | AAPL | Stock | 3.1454 | 3.1482 | 3.1339 | 3.1414 | 25110260.0 |
| 2006-12-13 09:40:00 | AAPL | Stock | 3.1418 | 3.1518 | 3.1407 | 3.1489 | 27340656.0 |
| 2006-12-13 09:45:00 | AAPL | Stock | 3.1489 | 3.1521 | 3.1386 | 3.1386 | 26484052.0 |
| 2006-12-13 09:50:00 | AAPL | Stock | 3.1393 | 3.145 | 3.1368 | 3.1439 | 15500436.0 |
| 2006-12-13 09:55:00 | AAPL | Stock | 3.1436 | 3.1464 | 3.1304 | 3.1336 | 22740648.0 |
| 2006-12-13 10:00:00 | AAPL | Stock | 3.1332 | 3.1339 | 3.125 | 3.1296 | 23613520.0 |
| 2006-12-13 10:05:00 | AAPL | Stock | 3.1296 | 3.1336 | 3.1264 | 3.1286 | 13429948.0 |
| 2006-12-13 10:10:00 | AAPL | Stock | 3.1289 | 3.1379 | 3.1257 | 3.1368 | 20944196.0 |
| 2006-12-13 10:15:00 | AAPL | Stock | 3.1368 | 3.1386 | 3.1304 | 3.1307 | 12343660.0 |
| 2006-12-13 10:20:00 | AAPL | Stock | 3.1304 | 3.1307 | 3.1182 | 3.1221 | 17909724.0 |
| 2006-12-13 10:25:00 | AAPL | Stock | 3.1221 | 3.1257 | 3.1168 | 3.1207 | 14150836.0 |
| 2006-12-13 10:30:00 | AAPL | Stock | 3.1207 | 3.1229 | 3.1125 | 3.1196 | 18889640.0 |
| 2006-12-13 10:35:00 | AAPL | Stock | 3.1196 | 3.1271 | 3.1168 | 3.1225 | 13730444.0 |
> showing 50 of 240,088 rows — these rows as CSV