PREVIEW / stock_5min / 2004-12-27
file: by_date/stock_5min/2004/2004-12-27.parquet size: 2.5 MB rows: 180,782 symbols: 1,899
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-27 08:00:00 | AAPL | Stock | 1.15 | 1.1518 | 1.1498 | 1.1509 | 215824.0 |
| 2004-12-27 08:05:00 | AAPL | Stock | 1.1518 | 1.1571 | 1.1518 | 1.1571 | 653968.0 |
| 2004-12-27 08:10:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.1554 | 1.157 | 217000.0 |
| 2004-12-27 08:15:00 | AAPL | Stock | 1.1566 | 1.1566 | 1.1566 | 1.1566 | 28000.0 |
| 2004-12-27 08:20:00 | AAPL | Stock | 1.1545 | 1.1545 | 1.1545 | 1.1545 | 7000.0 |
| 2004-12-27 08:25:00 | AAPL | Stock | 1.1554 | 1.1561 | 1.1536 | 1.1561 | 134400.0 |
| 2004-12-27 08:30:00 | AAPL | Stock | 1.1561 | 1.1561 | 1.1561 | 1.1561 | 33600.0 |
| 2004-12-27 08:35:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1563 | 1.1563 | 32088.0 |
| 2004-12-27 08:40:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1561 | 1.1561 | 39200.0 |
| 2004-12-27 08:45:00 | AAPL | Stock | 1.1563 | 1.157 | 1.1563 | 1.1566 | 125776.0 |
| 2004-12-27 08:50:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1554 | 1.1554 | 22400.0 |
| 2004-12-27 08:55:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1554 | 1.1554 | 5600.0 |
| 2004-12-27 09:00:00 | AAPL | Stock | 1.1563 | 1.1563 | 1.1555 | 1.1555 | 21840.0 |
| 2004-12-27 09:05:00 | AAPL | Stock | 1.1557 | 1.1571 | 1.1555 | 1.1571 | 202608.0 |
| 2004-12-27 09:10:00 | AAPL | Stock | 1.1571 | 1.16 | 1.1571 | 1.1589 | 671552.0 |
| 2004-12-27 09:15:00 | AAPL | Stock | 1.158 | 1.1602 | 1.1571 | 1.1571 | 201600.0 |
| 2004-12-27 09:20:00 | AAPL | Stock | 1.1573 | 1.1573 | 1.1555 | 1.1555 | 28000.0 |
| 2004-12-27 09:25:00 | AAPL | Stock | 1.1464 | 1.1604 | 1.1454 | 1.1584 | 1784216.0 |
| 2004-12-27 09:30:00 | AAPL | Stock | 1.1571 | 1.1634 | 1.1543 | 1.1618 | 27389656.0 |
| 2004-12-27 09:35:00 | AAPL | Stock | 1.1607 | 1.163 | 1.1571 | 1.1584 | 13406624.0 |
| 2004-12-27 09:40:00 | AAPL | Stock | 1.1582 | 1.1582 | 1.1525 | 1.1579 | 11221672.0 |
| 2004-12-27 09:45:00 | AAPL | Stock | 1.1579 | 1.1593 | 1.1546 | 1.1566 | 8809640.0 |
| 2004-12-27 09:50:00 | AAPL | Stock | 1.1568 | 1.1586 | 1.1529 | 1.1554 | 9218720.0 |
| 2004-12-27 09:55:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1536 | 1.1536 | 12455800.0 |
| 2004-12-27 10:00:00 | AAPL | Stock | 1.1536 | 1.1536 | 1.1464 | 1.1468 | 15266720.0 |
| 2004-12-27 10:05:00 | AAPL | Stock | 1.147 | 1.15 | 1.1461 | 1.1489 | 13280736.0 |
| 2004-12-27 10:10:00 | AAPL | Stock | 1.1491 | 1.1504 | 1.1468 | 1.1479 | 5653200.0 |
| 2004-12-27 10:15:00 | AAPL | Stock | 1.1479 | 1.1486 | 1.1434 | 1.1446 | 7354144.0 |
| 2004-12-27 10:20:00 | AAPL | Stock | 1.1443 | 1.1479 | 1.1441 | 1.1466 | 10321080.0 |
| 2004-12-27 10:25:00 | AAPL | Stock | 1.1468 | 1.1479 | 1.1455 | 1.1459 | 4590376.0 |
| 2004-12-27 10:30:00 | AAPL | Stock | 1.1461 | 1.1502 | 1.1459 | 1.1502 | 12769176.0 |
| 2004-12-27 10:35:00 | AAPL | Stock | 1.15 | 1.1509 | 1.1461 | 1.1468 | 8400336.0 |
| 2004-12-27 10:40:00 | AAPL | Stock | 1.1466 | 1.1475 | 1.1441 | 1.1446 | 6932352.0 |
| 2004-12-27 10:45:00 | AAPL | Stock | 1.1446 | 1.1464 | 1.1438 | 1.1458 | 5937792.0 |
| 2004-12-27 10:50:00 | AAPL | Stock | 1.1457 | 1.1467 | 1.1446 | 1.1452 | 4038832.0 |
| 2004-12-27 10:55:00 | AAPL | Stock | 1.1454 | 1.1457 | 1.1432 | 1.1439 | 4627168.0 |
| 2004-12-27 11:00:00 | AAPL | Stock | 1.1439 | 1.1455 | 1.1434 | 1.1439 | 5515832.0 |
| 2004-12-27 11:05:00 | AAPL | Stock | 1.1439 | 1.1446 | 1.1436 | 1.1443 | 2828952.0 |
| 2004-12-27 11:10:00 | AAPL | Stock | 1.1445 | 1.1445 | 1.1314 | 1.1343 | 17771936.0 |
| 2004-12-27 11:15:00 | AAPL | Stock | 1.1343 | 1.1359 | 1.1279 | 1.1311 | 29411368.0 |
| 2004-12-27 11:20:00 | AAPL | Stock | 1.1313 | 1.1327 | 1.1238 | 1.1273 | 28208432.0 |
| 2004-12-27 11:25:00 | AAPL | Stock | 1.127 | 1.1314 | 1.1266 | 1.1307 | 13658232.0 |
| 2004-12-27 11:30:00 | AAPL | Stock | 1.1304 | 1.1304 | 1.125 | 1.125 | 13326376.0 |
| 2004-12-27 11:35:00 | AAPL | Stock | 1.1255 | 1.1295 | 1.1238 | 1.1288 | 14953680.0 |
| 2004-12-27 11:40:00 | AAPL | Stock | 1.1284 | 1.1311 | 1.1273 | 1.1293 | 10751440.0 |
| 2004-12-27 11:45:00 | AAPL | Stock | 1.1291 | 1.1304 | 1.1277 | 1.1302 | 4121544.0 |
| 2004-12-27 11:50:00 | AAPL | Stock | 1.1304 | 1.1311 | 1.1288 | 1.1302 | 5791296.0 |
| 2004-12-27 11:55:00 | AAPL | Stock | 1.1302 | 1.1325 | 1.1302 | 1.1316 | 6211464.0 |
| 2004-12-27 12:00:00 | AAPL | Stock | 1.1316 | 1.1329 | 1.1314 | 1.1329 | 5743528.0 |
| 2004-12-27 12:05:00 | AAPL | Stock | 1.133 | 1.1345 | 1.1304 | 1.1314 | 6970768.0 |
> showing 50 of 180,782 rows — these rows as CSV