PREVIEW / stock_5min / 2004-12-21
file: by_date/stock_5min/2004/2004-12-21.parquet size: 2.6 MB rows: 191,511 symbols: 1,910
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-21 08:00:00 | AAPL | Stock | 1.1211 | 1.1341 | 1.1211 | 1.1341 | 631400.0 |
| 2004-12-21 08:05:00 | AAPL | Stock | 1.1339 | 1.1348 | 1.1304 | 1.133 | 1030008.0 |
| 2004-12-21 08:10:00 | AAPL | Stock | 1.1339 | 1.1375 | 1.1338 | 1.1357 | 504560.0 |
| 2004-12-21 08:15:00 | AAPL | Stock | 1.1357 | 1.1361 | 1.1341 | 1.1345 | 702800.0 |
| 2004-12-21 08:20:00 | AAPL | Stock | 1.1345 | 1.1355 | 1.1329 | 1.1348 | 496720.0 |
| 2004-12-21 08:25:00 | AAPL | Stock | 1.1357 | 1.1357 | 1.1339 | 1.1339 | 371336.0 |
| 2004-12-21 08:30:00 | AAPL | Stock | 1.1339 | 1.1339 | 1.1321 | 1.1321 | 123200.0 |
| 2004-12-21 08:35:00 | AAPL | Stock | 1.1321 | 1.133 | 1.1321 | 1.133 | 326872.0 |
| 2004-12-21 08:40:00 | AAPL | Stock | 1.1321 | 1.1321 | 1.1321 | 1.1321 | 5600.0 |
| 2004-12-21 08:45:00 | AAPL | Stock | 1.1321 | 1.1321 | 1.1321 | 1.1321 | 64400.0 |
| 2004-12-21 08:50:00 | AAPL | Stock | 1.1321 | 1.1327 | 1.1321 | 1.1327 | 67200.0 |
| 2004-12-21 08:55:00 | AAPL | Stock | 1.1325 | 1.1339 | 1.1321 | 1.1321 | 693336.0 |
| 2004-12-21 09:00:00 | AAPL | Stock | 1.1321 | 1.1321 | 1.1307 | 1.1314 | 95200.0 |
| 2004-12-21 09:05:00 | AAPL | Stock | 1.132 | 1.1323 | 1.132 | 1.1323 | 41440.0 |
| 2004-12-21 09:10:00 | AAPL | Stock | 1.1321 | 1.1321 | 1.1321 | 1.1321 | 43792.0 |
| 2004-12-21 09:15:00 | AAPL | Stock | 1.1307 | 1.1307 | 1.1304 | 1.1307 | 75600.0 |
| 2004-12-21 09:20:00 | AAPL | Stock | 1.1296 | 1.1307 | 1.1268 | 1.1304 | 177744.0 |
| 2004-12-21 09:25:00 | AAPL | Stock | 1.1282 | 1.1355 | 1.1205 | 1.1336 | 3724168.0 |
| 2004-12-21 09:30:00 | AAPL | Stock | 1.135 | 1.1357 | 1.1207 | 1.1245 | 47400976.0 |
| 2004-12-21 09:35:00 | AAPL | Stock | 1.1245 | 1.125 | 1.113 | 1.1182 | 34222328.0 |
| 2004-12-21 09:40:00 | AAPL | Stock | 1.1186 | 1.1204 | 1.1071 | 1.1084 | 31738224.0 |
| 2004-12-21 09:45:00 | AAPL | Stock | 1.1086 | 1.1123 | 1.1 | 1.1002 | 35179032.0 |
| 2004-12-21 09:50:00 | AAPL | Stock | 1.1 | 1.1107 | 1.1 | 1.1093 | 62789664.0 |
| 2004-12-21 09:55:00 | AAPL | Stock | 1.1096 | 1.1175 | 1.1073 | 1.1163 | 23854936.0 |
| 2004-12-21 10:00:00 | AAPL | Stock | 1.1163 | 1.1175 | 1.1113 | 1.1154 | 16264080.0 |
| 2004-12-21 10:05:00 | AAPL | Stock | 1.1154 | 1.1209 | 1.1141 | 1.1164 | 21804272.0 |
| 2004-12-21 10:10:00 | AAPL | Stock | 1.1164 | 1.1241 | 1.1157 | 1.1232 | 15728944.0 |
| 2004-12-21 10:15:00 | AAPL | Stock | 1.1232 | 1.1314 | 1.1225 | 1.1271 | 39235224.0 |
| 2004-12-21 10:20:00 | AAPL | Stock | 1.1268 | 1.1305 | 1.1261 | 1.1284 | 26089280.0 |
| 2004-12-21 10:25:00 | AAPL | Stock | 1.1286 | 1.1302 | 1.1277 | 1.1284 | 11062576.0 |
| 2004-12-21 10:30:00 | AAPL | Stock | 1.1282 | 1.1286 | 1.1223 | 1.1239 | 19610304.0 |
| 2004-12-21 10:35:00 | AAPL | Stock | 1.1239 | 1.1243 | 1.1216 | 1.1234 | 12417776.0 |
| 2004-12-21 10:40:00 | AAPL | Stock | 1.1234 | 1.1239 | 1.1164 | 1.117 | 13815760.0 |
| 2004-12-21 10:45:00 | AAPL | Stock | 1.1165 | 1.1216 | 1.1132 | 1.1213 | 19001584.0 |
| 2004-12-21 10:50:00 | AAPL | Stock | 1.1211 | 1.1246 | 1.1193 | 1.123 | 10245032.0 |
| 2004-12-21 10:55:00 | AAPL | Stock | 1.123 | 1.1268 | 1.1227 | 1.1255 | 10903368.0 |
| 2004-12-21 11:00:00 | AAPL | Stock | 1.1257 | 1.1302 | 1.1223 | 1.1295 | 10642856.0 |
| 2004-12-21 11:05:00 | AAPL | Stock | 1.1295 | 1.1296 | 1.1257 | 1.1259 | 7115360.0 |
| 2004-12-21 11:10:00 | AAPL | Stock | 1.1259 | 1.1286 | 1.1254 | 1.1284 | 6990368.0 |
| 2004-12-21 11:15:00 | AAPL | Stock | 1.128 | 1.1286 | 1.1264 | 1.1273 | 5935776.0 |
| 2004-12-21 11:20:00 | AAPL | Stock | 1.1277 | 1.1282 | 1.1261 | 1.1271 | 10973144.0 |
| 2004-12-21 11:25:00 | AAPL | Stock | 1.1271 | 1.1275 | 1.1266 | 1.1273 | 5740336.0 |
| 2004-12-21 11:30:00 | AAPL | Stock | 1.1273 | 1.1295 | 1.1261 | 1.1271 | 11110960.0 |
| 2004-12-21 11:35:00 | AAPL | Stock | 1.1273 | 1.1295 | 1.1266 | 1.1291 | 6368768.0 |
| 2004-12-21 11:40:00 | AAPL | Stock | 1.1291 | 1.1314 | 1.1275 | 1.1288 | 13223840.0 |
| 2004-12-21 11:45:00 | AAPL | Stock | 1.1288 | 1.1311 | 1.1264 | 1.1282 | 13680520.0 |
| 2004-12-21 11:50:00 | AAPL | Stock | 1.1279 | 1.1304 | 1.1268 | 1.128 | 8654352.0 |
| 2004-12-21 11:55:00 | AAPL | Stock | 1.128 | 1.13 | 1.1261 | 1.1286 | 8744736.0 |
| 2004-12-21 12:00:00 | AAPL | Stock | 1.1284 | 1.1304 | 1.127 | 1.1288 | 5993568.0 |
| 2004-12-21 12:05:00 | AAPL | Stock | 1.1289 | 1.1289 | 1.1266 | 1.1288 | 7030912.0 |
> showing 50 of 191,511 rows — these rows as CSV