PREVIEW / stock_5min / 2004-12-08
file: by_date/stock_5min/2004/2004-12-08.parquet size: 2.6 MB rows: 189,417 symbols: 1,883
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-08 08:00:00 | AAPL | Stock | 1.1205 | 1.125 | 1.1205 | 1.123 | 91280.0 |
| 2004-12-08 08:05:00 | AAPL | Stock | 1.1248 | 1.1248 | 1.123 | 1.123 | 51520.0 |
| 2004-12-08 08:10:00 | AAPL | Stock | 1.1232 | 1.1232 | 1.123 | 1.123 | 33600.0 |
| 2004-12-08 08:15:00 | AAPL | Stock | 1.123 | 1.1248 | 1.123 | 1.1248 | 44800.0 |
| 2004-12-08 08:20:00 | AAPL | Stock | 1.125 | 1.125 | 1.125 | 1.125 | 175840.0 |
| 2004-12-08 08:25:00 | AAPL | Stock | 1.125 | 1.125 | 1.125 | 1.125 | 268800.0 |
| 2004-12-08 08:30:00 | AAPL | Stock | 1.125 | 1.1268 | 1.125 | 1.1268 | 41440.0 |
| 2004-12-08 08:35:00 | AAPL | Stock | 1.1268 | 1.1334 | 1.1268 | 1.1286 | 72800.0 |
| 2004-12-08 08:40:00 | AAPL | Stock | 1.1286 | 1.1295 | 1.1268 | 1.1271 | 485800.0 |
| 2004-12-08 08:45:00 | AAPL | Stock | 1.1275 | 1.1291 | 1.1275 | 1.1286 | 175000.0 |
| 2004-12-08 08:50:00 | AAPL | Stock | 1.1291 | 1.1291 | 1.1282 | 1.1286 | 114800.0 |
| 2004-12-08 08:55:00 | AAPL | Stock | 1.1286 | 1.1295 | 1.1286 | 1.1295 | 142800.0 |
| 2004-12-08 09:00:00 | AAPL | Stock | 1.1296 | 1.1296 | 1.1286 | 1.1286 | 39200.0 |
| 2004-12-08 09:05:00 | AAPL | Stock | 1.1291 | 1.1295 | 1.1291 | 1.1291 | 56000.0 |
| 2004-12-08 09:10:00 | AAPL | Stock | 1.1295 | 1.1298 | 1.1293 | 1.1295 | 215600.0 |
| 2004-12-08 09:15:00 | AAPL | Stock | 1.1313 | 1.132 | 1.13 | 1.13 | 277200.0 |
| 2004-12-08 09:20:00 | AAPL | Stock | 1.1295 | 1.1295 | 1.1289 | 1.1291 | 80024.0 |
| 2004-12-08 09:25:00 | AAPL | Stock | 1.1241 | 1.1295 | 1.1241 | 1.1277 | 456512.0 |
| 2004-12-08 09:30:00 | AAPL | Stock | 1.1264 | 1.1302 | 1.1254 | 1.1288 | 27710088.0 |
| 2004-12-08 09:35:00 | AAPL | Stock | 1.1286 | 1.13 | 1.1089 | 1.1089 | 28111552.0 |
| 2004-12-08 09:40:00 | AAPL | Stock | 1.1089 | 1.1214 | 1.108 | 1.1195 | 23526608.0 |
| 2004-12-08 09:45:00 | AAPL | Stock | 1.12 | 1.1205 | 1.1129 | 1.1168 | 20937896.0 |
| 2004-12-08 09:50:00 | AAPL | Stock | 1.1168 | 1.1195 | 1.1116 | 1.1179 | 15523032.0 |
| 2004-12-08 09:55:00 | AAPL | Stock | 1.1177 | 1.123 | 1.1163 | 1.1225 | 11486832.0 |
| 2004-12-08 10:00:00 | AAPL | Stock | 1.1225 | 1.1313 | 1.122 | 1.1248 | 20423424.0 |
| 2004-12-08 10:05:00 | AAPL | Stock | 1.1246 | 1.13 | 1.123 | 1.1286 | 11473392.0 |
| 2004-12-08 10:10:00 | AAPL | Stock | 1.1291 | 1.1384 | 1.128 | 1.1366 | 24915800.0 |
| 2004-12-08 10:15:00 | AAPL | Stock | 1.1366 | 1.1425 | 1.1354 | 1.1386 | 21770392.0 |
| 2004-12-08 10:20:00 | AAPL | Stock | 1.1384 | 1.1429 | 1.1366 | 1.1393 | 18915120.0 |
| 2004-12-08 10:25:00 | AAPL | Stock | 1.1393 | 1.142 | 1.1361 | 1.1371 | 12402488.0 |
| 2004-12-08 10:30:00 | AAPL | Stock | 1.1375 | 1.142 | 1.1341 | 1.1359 | 17795008.0 |
| 2004-12-08 10:35:00 | AAPL | Stock | 1.1357 | 1.1455 | 1.1354 | 1.1446 | 19165776.0 |
| 2004-12-08 10:40:00 | AAPL | Stock | 1.1445 | 1.1452 | 1.1405 | 1.1409 | 13310472.0 |
| 2004-12-08 10:45:00 | AAPL | Stock | 1.1405 | 1.1445 | 1.1379 | 1.1399 | 13362944.0 |
| 2004-12-08 10:50:00 | AAPL | Stock | 1.1393 | 1.1404 | 1.1359 | 1.1388 | 10337040.0 |
| 2004-12-08 10:55:00 | AAPL | Stock | 1.1388 | 1.1411 | 1.137 | 1.1377 | 7493584.0 |
| 2004-12-08 11:00:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1325 | 1.1331 | 11027464.0 |
| 2004-12-08 11:05:00 | AAPL | Stock | 1.133 | 1.1373 | 1.1329 | 1.1364 | 5851328.0 |
| 2004-12-08 11:10:00 | AAPL | Stock | 1.1364 | 1.1373 | 1.1343 | 1.1368 | 3828160.0 |
| 2004-12-08 11:15:00 | AAPL | Stock | 1.137 | 1.1393 | 1.1361 | 1.1388 | 3357984.0 |
| 2004-12-08 11:20:00 | AAPL | Stock | 1.1388 | 1.1441 | 1.1387 | 1.1423 | 7614040.0 |
| 2004-12-08 11:25:00 | AAPL | Stock | 1.142 | 1.1434 | 1.14 | 1.1407 | 3826424.0 |
| 2004-12-08 11:30:00 | AAPL | Stock | 1.1413 | 1.1414 | 1.1389 | 1.1411 | 3061184.0 |
| 2004-12-08 11:35:00 | AAPL | Stock | 1.1411 | 1.1443 | 1.1398 | 1.1438 | 4569208.0 |
| 2004-12-08 11:40:00 | AAPL | Stock | 1.1436 | 1.1441 | 1.142 | 1.1438 | 4473784.0 |
| 2004-12-08 11:45:00 | AAPL | Stock | 1.1438 | 1.1505 | 1.1436 | 1.1498 | 17814552.0 |
| 2004-12-08 11:50:00 | AAPL | Stock | 1.1493 | 1.15 | 1.1453 | 1.1464 | 6246352.0 |
| 2004-12-08 11:55:00 | AAPL | Stock | 1.1466 | 1.1466 | 1.1413 | 1.1439 | 7285376.0 |
| 2004-12-08 12:00:00 | AAPL | Stock | 1.1445 | 1.1464 | 1.1425 | 1.1445 | 5797568.0 |
| 2004-12-08 12:05:00 | AAPL | Stock | 1.1441 | 1.1446 | 1.1425 | 1.1446 | 5934656.0 |
> showing 50 of 189,417 rows — these rows as CSV