PREVIEW / stock_5min / 2005-01-06
file: by_date/stock_5min/2005/2005-01-06.parquet size: 2.6 MB rows: 191,439 symbols: 1,915
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-06 08:00:00 | AAPL | Stock | 1.1607 | 1.1611 | 1.1573 | 1.1589 | 372960.0 |
| 2005-01-06 08:05:00 | AAPL | Stock | 1.1575 | 1.1588 | 1.1563 | 1.1586 | 305368.0 |
| 2005-01-06 08:10:00 | AAPL | Stock | 1.1584 | 1.1589 | 1.1584 | 1.1589 | 134400.0 |
| 2005-01-06 08:15:00 | AAPL | Stock | 1.1584 | 1.1584 | 1.1584 | 1.1584 | 56000.0 |
| 2005-01-06 08:20:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1589 | 1.1589 | 43120.0 |
| 2005-01-06 08:25:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.1571 | 1.1571 | 33600.0 |
| 2005-01-06 08:30:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.1563 | 1.1563 | 480312.0 |
| 2005-01-06 08:35:00 | AAPL | Stock | 1.1557 | 1.1557 | 1.1518 | 1.1518 | 746480.0 |
| 2005-01-06 08:45:00 | AAPL | Stock | 1.1527 | 1.1552 | 1.1527 | 1.1552 | 31920.0 |
| 2005-01-06 08:50:00 | AAPL | Stock | 1.1563 | 1.1566 | 1.1552 | 1.1554 | 67200.0 |
| 2005-01-06 08:55:00 | AAPL | Stock | 1.1566 | 1.1571 | 1.1532 | 1.1538 | 214368.0 |
| 2005-01-06 09:00:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1545 | 1.1554 | 673288.0 |
| 2005-01-06 09:10:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.157 | 1.157 | 95200.0 |
| 2005-01-06 09:15:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1545 | 1.1545 | 123200.0 |
| 2005-01-06 09:20:00 | AAPL | Stock | 1.1545 | 1.1545 | 1.1539 | 1.1545 | 162400.0 |
| 2005-01-06 09:25:00 | AAPL | Stock | 1.1539 | 1.1571 | 1.1539 | 1.157 | 1540952.0 |
| 2005-01-06 09:30:00 | AAPL | Stock | 1.1551 | 1.158 | 1.1518 | 1.158 | 24606288.0 |
| 2005-01-06 09:35:00 | AAPL | Stock | 1.1577 | 1.1588 | 1.1454 | 1.1475 | 24096240.0 |
| 2005-01-06 09:40:00 | AAPL | Stock | 1.1477 | 1.1495 | 1.1355 | 1.1404 | 33664344.0 |
| 2005-01-06 09:45:00 | AAPL | Stock | 1.1407 | 1.1482 | 1.1402 | 1.145 | 17478944.0 |
| 2005-01-06 09:50:00 | AAPL | Stock | 1.1448 | 1.1461 | 1.1411 | 1.1438 | 13473600.0 |
| 2005-01-06 09:55:00 | AAPL | Stock | 1.1438 | 1.1439 | 1.1309 | 1.137 | 25793544.0 |
| 2005-01-06 10:00:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.1316 | 1.1366 | 18439624.0 |
| 2005-01-06 10:05:00 | AAPL | Stock | 1.1364 | 1.1414 | 1.1364 | 1.1391 | 13846000.0 |
| 2005-01-06 10:10:00 | AAPL | Stock | 1.1391 | 1.1418 | 1.1346 | 1.1405 | 12691840.0 |
| 2005-01-06 10:15:00 | AAPL | Stock | 1.1404 | 1.1457 | 1.1396 | 1.142 | 14786800.0 |
| 2005-01-06 10:20:00 | AAPL | Stock | 1.142 | 1.1446 | 1.1402 | 1.1438 | 13547744.0 |
| 2005-01-06 10:25:00 | AAPL | Stock | 1.1439 | 1.1523 | 1.1438 | 1.1475 | 24843280.0 |
| 2005-01-06 10:30:00 | AAPL | Stock | 1.1477 | 1.1488 | 1.1436 | 1.1461 | 31072944.0 |
| 2005-01-06 10:35:00 | AAPL | Stock | 1.1459 | 1.148 | 1.1429 | 1.1466 | 7237776.0 |
| 2005-01-06 10:40:00 | AAPL | Stock | 1.1466 | 1.1466 | 1.1386 | 1.1404 | 11324600.0 |
| 2005-01-06 10:45:00 | AAPL | Stock | 1.14 | 1.1405 | 1.1382 | 1.1396 | 28398384.0 |
| 2005-01-06 10:50:00 | AAPL | Stock | 1.1396 | 1.1411 | 1.1386 | 1.1404 | 8858192.0 |
| 2005-01-06 10:55:00 | AAPL | Stock | 1.1404 | 1.142 | 1.1388 | 1.1395 | 10460016.0 |
| 2005-01-06 11:00:00 | AAPL | Stock | 1.1395 | 1.1454 | 1.1386 | 1.145 | 25170488.0 |
| 2005-01-06 11:05:00 | AAPL | Stock | 1.145 | 1.1484 | 1.1429 | 1.1479 | 11463816.0 |
| 2005-01-06 11:10:00 | AAPL | Stock | 1.1475 | 1.148 | 1.1448 | 1.1464 | 7015120.0 |
| 2005-01-06 11:15:00 | AAPL | Stock | 1.1466 | 1.1521 | 1.1454 | 1.1498 | 8380400.0 |
| 2005-01-06 11:20:00 | AAPL | Stock | 1.1496 | 1.1509 | 1.1479 | 1.1496 | 8119496.0 |
| 2005-01-06 11:25:00 | AAPL | Stock | 1.1493 | 1.152 | 1.1473 | 1.1518 | 5352760.0 |
| 2005-01-06 11:30:00 | AAPL | Stock | 1.152 | 1.1536 | 1.1496 | 1.15 | 12655384.0 |
| 2005-01-06 11:35:00 | AAPL | Stock | 1.15 | 1.1513 | 1.1477 | 1.1484 | 7249536.0 |
| 2005-01-06 11:40:00 | AAPL | Stock | 1.1482 | 1.1502 | 1.1473 | 1.1489 | 2960384.0 |
| 2005-01-06 11:45:00 | AAPL | Stock | 1.1486 | 1.1536 | 1.1478 | 1.1532 | 5603696.0 |
| 2005-01-06 11:50:00 | AAPL | Stock | 1.1534 | 1.1536 | 1.15 | 1.1514 | 5592888.0 |
| 2005-01-06 11:55:00 | AAPL | Stock | 1.1513 | 1.1514 | 1.1496 | 1.1511 | 3415384.0 |
| 2005-01-06 12:00:00 | AAPL | Stock | 1.1509 | 1.1511 | 1.1493 | 1.1502 | 2731288.0 |
| 2005-01-06 12:05:00 | AAPL | Stock | 1.1504 | 1.1505 | 1.1477 | 1.1486 | 3092600.0 |
| 2005-01-06 12:10:00 | AAPL | Stock | 1.1485 | 1.1493 | 1.1473 | 1.1486 | 4203976.0 |
| 2005-01-06 12:15:00 | AAPL | Stock | 1.1484 | 1.15 | 1.148 | 1.15 | 1320368.0 |
> showing 50 of 191,439 rows — these rows as CSV