PREVIEW / stock_5min / 2004-12-29
file: by_date/stock_5min/2004/2004-12-29.parquet size: 2.5 MB rows: 183,247 symbols: 1,911
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-29 08:00:00 | AAPL | Stock | 1.1434 | 1.1482 | 1.1434 | 1.1473 | 119280.0 |
| 2004-12-29 08:10:00 | AAPL | Stock | 1.1459 | 1.1459 | 1.1459 | 1.1459 | 11200.0 |
| 2004-12-29 08:15:00 | AAPL | Stock | 1.1457 | 1.1457 | 1.1457 | 1.1457 | 11200.0 |
| 2004-12-29 08:25:00 | AAPL | Stock | 1.1455 | 1.1473 | 1.1455 | 1.1473 | 25200.0 |
| 2004-12-29 08:30:00 | AAPL | Stock | 1.148 | 1.148 | 1.1468 | 1.1473 | 37800.0 |
| 2004-12-29 08:35:00 | AAPL | Stock | 1.1464 | 1.1464 | 1.1464 | 1.1464 | 16800.0 |
| 2004-12-29 08:40:00 | AAPL | Stock | 1.1464 | 1.1464 | 1.1464 | 1.1464 | 24080.0 |
| 2004-12-29 08:45:00 | AAPL | Stock | 1.1457 | 1.1457 | 1.1455 | 1.1455 | 20440.0 |
| 2004-12-29 08:50:00 | AAPL | Stock | 1.1455 | 1.146 | 1.1455 | 1.146 | 39200.0 |
| 2004-12-29 08:55:00 | AAPL | Stock | 1.1446 | 1.1446 | 1.143 | 1.143 | 122640.0 |
| 2004-12-29 09:05:00 | AAPL | Stock | 1.1446 | 1.1446 | 1.1446 | 1.1446 | 5600.0 |
| 2004-12-29 09:10:00 | AAPL | Stock | 1.1446 | 1.1455 | 1.1416 | 1.1418 | 236768.0 |
| 2004-12-29 09:25:00 | AAPL | Stock | 1.1438 | 1.1438 | 1.1402 | 1.1402 | 280000.0 |
| 2004-12-29 09:30:00 | AAPL | Stock | 1.1393 | 1.147 | 1.1384 | 1.1459 | 16951872.0 |
| 2004-12-29 09:35:00 | AAPL | Stock | 1.1459 | 1.1514 | 1.1454 | 1.1498 | 15705088.0 |
| 2004-12-29 09:40:00 | AAPL | Stock | 1.1502 | 1.1504 | 1.146 | 1.1477 | 10538192.0 |
| 2004-12-29 09:45:00 | AAPL | Stock | 1.148 | 1.1491 | 1.1454 | 1.1464 | 15789984.0 |
| 2004-12-29 09:50:00 | AAPL | Stock | 1.1464 | 1.1484 | 1.1459 | 1.1468 | 8223768.0 |
| 2004-12-29 09:55:00 | AAPL | Stock | 1.147 | 1.1479 | 1.1425 | 1.1466 | 8514296.0 |
| 2004-12-29 10:00:00 | AAPL | Stock | 1.1466 | 1.1554 | 1.1448 | 1.1546 | 21691320.0 |
| 2004-12-29 10:05:00 | AAPL | Stock | 1.1546 | 1.1604 | 1.1532 | 1.1557 | 22247064.0 |
| 2004-12-29 10:10:00 | AAPL | Stock | 1.1557 | 1.1589 | 1.1555 | 1.1571 | 9172688.0 |
| 2004-12-29 10:15:00 | AAPL | Stock | 1.1573 | 1.158 | 1.1548 | 1.1557 | 7443968.0 |
| 2004-12-29 10:20:00 | AAPL | Stock | 1.1554 | 1.1561 | 1.153 | 1.1536 | 7266448.0 |
| 2004-12-29 10:25:00 | AAPL | Stock | 1.1534 | 1.1552 | 1.1532 | 1.1541 | 8519448.0 |
| 2004-12-29 10:30:00 | AAPL | Stock | 1.1543 | 1.1563 | 1.1536 | 1.155 | 6068272.0 |
| 2004-12-29 10:35:00 | AAPL | Stock | 1.1548 | 1.155 | 1.1523 | 1.1539 | 3271184.0 |
| 2004-12-29 10:40:00 | AAPL | Stock | 1.1538 | 1.1538 | 1.1495 | 1.1509 | 7133448.0 |
| 2004-12-29 10:45:00 | AAPL | Stock | 1.1509 | 1.1521 | 1.1498 | 1.1498 | 5242384.0 |
| 2004-12-29 10:50:00 | AAPL | Stock | 1.1498 | 1.15 | 1.1455 | 1.1455 | 6511120.0 |
| 2004-12-29 10:55:00 | AAPL | Stock | 1.1455 | 1.1491 | 1.1455 | 1.148 | 6340768.0 |
| 2004-12-29 11:00:00 | AAPL | Stock | 1.148 | 1.1511 | 1.148 | 1.1509 | 3935120.0 |
| 2004-12-29 11:05:00 | AAPL | Stock | 1.1505 | 1.1516 | 1.1491 | 1.1498 | 4902576.0 |
| 2004-12-29 11:10:00 | AAPL | Stock | 1.15 | 1.15 | 1.1479 | 1.1482 | 3079104.0 |
| 2004-12-29 11:15:00 | AAPL | Stock | 1.1482 | 1.1507 | 1.1475 | 1.1493 | 3308088.0 |
| 2004-12-29 11:20:00 | AAPL | Stock | 1.1491 | 1.1496 | 1.1473 | 1.1475 | 2681840.0 |
| 2004-12-29 11:25:00 | AAPL | Stock | 1.1477 | 1.1486 | 1.1475 | 1.148 | 1522136.0 |
| 2004-12-29 11:30:00 | AAPL | Stock | 1.1482 | 1.1489 | 1.1457 | 1.1468 | 7645120.0 |
| 2004-12-29 11:35:00 | AAPL | Stock | 1.1466 | 1.1468 | 1.1438 | 1.144 | 6069392.0 |
| 2004-12-29 11:40:00 | AAPL | Stock | 1.1443 | 1.1446 | 1.1368 | 1.138 | 13828024.0 |
| 2004-12-29 11:45:00 | AAPL | Stock | 1.1375 | 1.1393 | 1.1361 | 1.1377 | 13162296.0 |
| 2004-12-29 11:50:00 | AAPL | Stock | 1.1377 | 1.1393 | 1.1352 | 1.1355 | 6558216.0 |
| 2004-12-29 11:55:00 | AAPL | Stock | 1.1355 | 1.1389 | 1.1354 | 1.1389 | 4045944.0 |
| 2004-12-29 12:00:00 | AAPL | Stock | 1.1389 | 1.142 | 1.1379 | 1.1411 | 6500648.0 |
| 2004-12-29 12:05:00 | AAPL | Stock | 1.1412 | 1.1413 | 1.1389 | 1.1404 | 2618224.0 |
| 2004-12-29 12:10:00 | AAPL | Stock | 1.1402 | 1.1421 | 1.1396 | 1.142 | 3474576.0 |
| 2004-12-29 12:15:00 | AAPL | Stock | 1.1421 | 1.1441 | 1.1411 | 1.1441 | 3901296.0 |
| 2004-12-29 12:20:00 | AAPL | Stock | 1.1441 | 1.1455 | 1.1432 | 1.1434 | 3204992.0 |
| 2004-12-29 12:25:00 | AAPL | Stock | 1.1436 | 1.1438 | 1.1421 | 1.1423 | 3746344.0 |
| 2004-12-29 12:30:00 | AAPL | Stock | 1.1421 | 1.1441 | 1.1421 | 1.1435 | 1635144.0 |
> showing 50 of 183,247 rows — these rows as CSV