PREVIEW / stock_5min / 2005-01-12
file: by_date/stock_5min/2005/2005-01-12.parquet size: 2.6 MB rows: 192,299 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 |
|---|---|---|---|---|---|---|---|
| 2005-01-12 08:00:00 | AAPL | Stock | 1.167 | 1.1714 | 1.1661 | 1.1696 | 3052784.0 |
| 2005-01-12 08:05:00 | AAPL | Stock | 1.1696 | 1.1718 | 1.1652 | 1.1679 | 1179752.0 |
| 2005-01-12 08:10:00 | AAPL | Stock | 1.1679 | 1.1696 | 1.1673 | 1.1696 | 551992.0 |
| 2005-01-12 08:15:00 | AAPL | Stock | 1.1695 | 1.1704 | 1.1677 | 1.1679 | 371560.0 |
| 2005-01-12 08:20:00 | AAPL | Stock | 1.1696 | 1.1696 | 1.1634 | 1.1636 | 856352.0 |
| 2005-01-12 08:25:00 | AAPL | Stock | 1.1652 | 1.1675 | 1.1616 | 1.1666 | 365120.0 |
| 2005-01-12 08:30:00 | AAPL | Stock | 1.1616 | 1.1661 | 1.1616 | 1.1632 | 238896.0 |
| 2005-01-12 08:35:00 | AAPL | Stock | 1.1652 | 1.1663 | 1.1618 | 1.1661 | 488320.0 |
| 2005-01-12 08:40:00 | AAPL | Stock | 1.1661 | 1.1661 | 1.1652 | 1.1659 | 173600.0 |
| 2005-01-12 08:45:00 | AAPL | Stock | 1.1659 | 1.1661 | 1.1607 | 1.1607 | 958832.0 |
| 2005-01-12 08:50:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1557 | 1.1571 | 499744.0 |
| 2005-01-12 08:55:00 | AAPL | Stock | 1.1571 | 1.1571 | 1.1529 | 1.1554 | 1377880.0 |
| 2005-01-12 09:00:00 | AAPL | Stock | 1.1563 | 1.157 | 1.1554 | 1.1554 | 1316280.0 |
| 2005-01-12 09:05:00 | AAPL | Stock | 1.1554 | 1.158 | 1.1554 | 1.1563 | 581840.0 |
| 2005-01-12 09:10:00 | AAPL | Stock | 1.1563 | 1.1605 | 1.1554 | 1.1596 | 477120.0 |
| 2005-01-12 09:15:00 | AAPL | Stock | 1.1591 | 1.1598 | 1.1571 | 1.1589 | 405440.0 |
| 2005-01-12 09:20:00 | AAPL | Stock | 1.1588 | 1.1589 | 1.1579 | 1.158 | 800800.0 |
| 2005-01-12 09:25:00 | AAPL | Stock | 1.1577 | 1.1713 | 1.157 | 1.1691 | 11556552.0 |
| 2005-01-12 09:30:00 | AAPL | Stock | 1.167 | 1.1707 | 1.1552 | 1.1563 | 82297320.0 |
| 2005-01-12 09:35:00 | AAPL | Stock | 1.1563 | 1.1598 | 1.1304 | 1.1305 | 95643856.0 |
| 2005-01-12 09:40:00 | AAPL | Stock | 1.1309 | 1.1525 | 1.1305 | 1.1446 | 101339784.0 |
| 2005-01-12 09:45:00 | AAPL | Stock | 1.1446 | 1.147 | 1.1388 | 1.1388 | 36403752.0 |
| 2005-01-12 09:50:00 | AAPL | Stock | 1.1391 | 1.1482 | 1.1357 | 1.1393 | 43457568.0 |
| 2005-01-12 09:55:00 | AAPL | Stock | 1.1393 | 1.1493 | 1.1388 | 1.1491 | 33661096.0 |
| 2005-01-12 10:00:00 | AAPL | Stock | 1.1489 | 1.1564 | 1.1445 | 1.1518 | 42369768.0 |
| 2005-01-12 10:05:00 | AAPL | Stock | 1.1516 | 1.1582 | 1.1478 | 1.1504 | 32856488.0 |
| 2005-01-12 10:10:00 | AAPL | Stock | 1.1502 | 1.153 | 1.145 | 1.1498 | 32532080.0 |
| 2005-01-12 10:15:00 | AAPL | Stock | 1.15 | 1.158 | 1.1498 | 1.1521 | 23013032.0 |
| 2005-01-12 10:20:00 | AAPL | Stock | 1.1523 | 1.1538 | 1.1475 | 1.1521 | 20642776.0 |
| 2005-01-12 10:25:00 | AAPL | Stock | 1.1521 | 1.1529 | 1.1486 | 1.1518 | 13742344.0 |
| 2005-01-12 10:30:00 | AAPL | Stock | 1.1505 | 1.1527 | 1.1488 | 1.1525 | 14132216.0 |
| 2005-01-12 10:35:00 | AAPL | Stock | 1.1527 | 1.1559 | 1.1488 | 1.1502 | 23118592.0 |
| 2005-01-12 10:40:00 | AAPL | Stock | 1.1505 | 1.1538 | 1.1493 | 1.152 | 18143384.0 |
| 2005-01-12 10:45:00 | AAPL | Stock | 1.1525 | 1.1582 | 1.1509 | 1.1539 | 25327792.0 |
| 2005-01-12 10:50:00 | AAPL | Stock | 1.1539 | 1.1568 | 1.1464 | 1.1479 | 18089344.0 |
| 2005-01-12 10:55:00 | AAPL | Stock | 1.1471 | 1.1534 | 1.1466 | 1.1507 | 15584240.0 |
| 2005-01-12 11:00:00 | AAPL | Stock | 1.1509 | 1.1513 | 1.1479 | 1.1482 | 10739512.0 |
| 2005-01-12 11:05:00 | AAPL | Stock | 1.1484 | 1.1516 | 1.1393 | 1.1505 | 13826456.0 |
| 2005-01-12 11:10:00 | AAPL | Stock | 1.1511 | 1.1518 | 1.1448 | 1.1455 | 17845352.0 |
| 2005-01-12 11:15:00 | AAPL | Stock | 1.1455 | 1.1486 | 1.1438 | 1.1471 | 17279136.0 |
| 2005-01-12 11:20:00 | AAPL | Stock | 1.147 | 1.1473 | 1.1425 | 1.1439 | 14759024.0 |
| 2005-01-12 11:25:00 | AAPL | Stock | 1.1443 | 1.1448 | 1.14 | 1.1443 | 18611824.0 |
| 2005-01-12 11:30:00 | AAPL | Stock | 1.1441 | 1.1486 | 1.143 | 1.1471 | 18525024.0 |
| 2005-01-12 11:35:00 | AAPL | Stock | 1.1466 | 1.1527 | 1.1461 | 1.1507 | 19475680.0 |
| 2005-01-12 11:40:00 | AAPL | Stock | 1.1513 | 1.1523 | 1.1479 | 1.1495 | 13389768.0 |
| 2005-01-12 11:45:00 | AAPL | Stock | 1.1495 | 1.152 | 1.1464 | 1.1495 | 16792552.0 |
| 2005-01-12 11:50:00 | AAPL | Stock | 1.1495 | 1.1518 | 1.148 | 1.1498 | 7190064.0 |
| 2005-01-12 11:55:00 | AAPL | Stock | 1.1498 | 1.1498 | 1.1434 | 1.1454 | 12775840.0 |
| 2005-01-12 12:00:00 | AAPL | Stock | 1.1454 | 1.1484 | 1.1443 | 1.1457 | 12518352.0 |
| 2005-01-12 12:05:00 | AAPL | Stock | 1.1457 | 1.1468 | 1.1448 | 1.1454 | 6131160.0 |
> showing 50 of 192,299 rows — these rows as CSV