PREVIEW / stock_5min / 2004-12-13
file: by_date/stock_5min/2004/2004-12-13.parquet size: 2.6 MB rows: 191,427 symbols: 1,893
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-13 08:00:00 | AAPL | Stock | 1.1639 | 1.1639 | 1.1639 | 1.1639 | 11144.0 |
| 2004-12-13 08:05:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1643 | 1.1643 | 5600.0 |
| 2004-12-13 08:10:00 | AAPL | Stock | 1.1645 | 1.1645 | 1.1643 | 1.1643 | 84000.0 |
| 2004-12-13 08:15:00 | AAPL | Stock | 1.1645 | 1.1645 | 1.1643 | 1.1643 | 61600.0 |
| 2004-12-13 08:20:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1639 | 1.1643 | 59920.0 |
| 2004-12-13 08:25:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1643 | 1.1643 | 7280.0 |
| 2004-12-13 08:30:00 | AAPL | Stock | 1.1679 | 1.1679 | 1.167 | 1.167 | 112000.0 |
| 2004-12-13 08:35:00 | AAPL | Stock | 1.1691 | 1.173 | 1.1691 | 1.1714 | 274344.0 |
| 2004-12-13 08:40:00 | AAPL | Stock | 1.1718 | 1.1732 | 1.1718 | 1.1732 | 126000.0 |
| 2004-12-13 08:45:00 | AAPL | Stock | 1.1732 | 1.1732 | 1.1727 | 1.173 | 100800.0 |
| 2004-12-13 08:50:00 | AAPL | Stock | 1.173 | 1.173 | 1.1696 | 1.1696 | 267680.0 |
| 2004-12-13 08:55:00 | AAPL | Stock | 1.1714 | 1.1723 | 1.1714 | 1.1721 | 138880.0 |
| 2004-12-13 09:00:00 | AAPL | Stock | 1.1714 | 1.1721 | 1.1713 | 1.1714 | 301840.0 |
| 2004-12-13 09:05:00 | AAPL | Stock | 1.1716 | 1.1723 | 1.1705 | 1.1723 | 711200.0 |
| 2004-12-13 09:10:00 | AAPL | Stock | 1.1721 | 1.1721 | 1.1698 | 1.17 | 100184.0 |
| 2004-12-13 09:15:00 | AAPL | Stock | 1.1698 | 1.1698 | 1.1696 | 1.1696 | 271600.0 |
| 2004-12-13 09:20:00 | AAPL | Stock | 1.1698 | 1.1711 | 1.1688 | 1.1711 | 70392.0 |
| 2004-12-13 09:25:00 | AAPL | Stock | 1.1654 | 1.1741 | 1.1648 | 1.1741 | 769272.0 |
| 2004-12-13 09:30:00 | AAPL | Stock | 1.1739 | 1.1768 | 1.1696 | 1.1754 | 17079664.0 |
| 2004-12-13 09:35:00 | AAPL | Stock | 1.1752 | 1.1759 | 1.1652 | 1.1688 | 14129864.0 |
| 2004-12-13 09:40:00 | AAPL | Stock | 1.1688 | 1.1709 | 1.1661 | 1.1666 | 10405752.0 |
| 2004-12-13 09:45:00 | AAPL | Stock | 1.1663 | 1.1688 | 1.1638 | 1.1679 | 10889704.0 |
| 2004-12-13 09:50:00 | AAPL | Stock | 1.1673 | 1.1679 | 1.1618 | 1.1623 | 13922888.0 |
| 2004-12-13 09:55:00 | AAPL | Stock | 1.1627 | 1.1684 | 1.1625 | 1.1666 | 8859816.0 |
| 2004-12-13 10:00:00 | AAPL | Stock | 1.1663 | 1.1688 | 1.1639 | 1.1666 | 7781704.0 |
| 2004-12-13 10:05:00 | AAPL | Stock | 1.1666 | 1.1686 | 1.1661 | 1.1668 | 4545912.0 |
| 2004-12-13 10:10:00 | AAPL | Stock | 1.1666 | 1.168 | 1.1661 | 1.1675 | 5009592.0 |
| 2004-12-13 10:15:00 | AAPL | Stock | 1.1679 | 1.1684 | 1.1655 | 1.1666 | 4980136.0 |
| 2004-12-13 10:20:00 | AAPL | Stock | 1.1661 | 1.1679 | 1.1641 | 1.1668 | 4588248.0 |
| 2004-12-13 10:25:00 | AAPL | Stock | 1.167 | 1.1671 | 1.1634 | 1.1638 | 5104792.0 |
| 2004-12-13 10:30:00 | AAPL | Stock | 1.1639 | 1.1643 | 1.1598 | 1.162 | 12510680.0 |
| 2004-12-13 10:35:00 | AAPL | Stock | 1.1618 | 1.1618 | 1.1563 | 1.1582 | 15776376.0 |
| 2004-12-13 10:40:00 | AAPL | Stock | 1.1584 | 1.1591 | 1.1564 | 1.1575 | 8624896.0 |
| 2004-12-13 10:45:00 | AAPL | Stock | 1.1577 | 1.1588 | 1.1566 | 1.1571 | 5615624.0 |
| 2004-12-13 10:50:00 | AAPL | Stock | 1.1571 | 1.158 | 1.1563 | 1.1575 | 3979472.0 |
| 2004-12-13 10:55:00 | AAPL | Stock | 1.1577 | 1.1584 | 1.1575 | 1.1575 | 2626624.0 |
| 2004-12-13 11:00:00 | AAPL | Stock | 1.1575 | 1.1588 | 1.1571 | 1.1577 | 4352152.0 |
| 2004-12-13 11:05:00 | AAPL | Stock | 1.1577 | 1.1588 | 1.1568 | 1.1577 | 3434144.0 |
| 2004-12-13 11:10:00 | AAPL | Stock | 1.1577 | 1.1582 | 1.1564 | 1.1564 | 3845744.0 |
| 2004-12-13 11:15:00 | AAPL | Stock | 1.1564 | 1.1571 | 1.1536 | 1.1539 | 11745048.0 |
| 2004-12-13 11:20:00 | AAPL | Stock | 1.1538 | 1.1563 | 1.1538 | 1.1548 | 6107192.0 |
| 2004-12-13 11:25:00 | AAPL | Stock | 1.1552 | 1.1559 | 1.1545 | 1.155 | 2954392.0 |
| 2004-12-13 11:30:00 | AAPL | Stock | 1.1554 | 1.1575 | 1.1543 | 1.157 | 3688496.0 |
| 2004-12-13 11:35:00 | AAPL | Stock | 1.157 | 1.1577 | 1.1546 | 1.1573 | 4406416.0 |
| 2004-12-13 11:40:00 | AAPL | Stock | 1.1571 | 1.1596 | 1.1563 | 1.1573 | 5005280.0 |
| 2004-12-13 11:45:00 | AAPL | Stock | 1.1572 | 1.1573 | 1.1539 | 1.1561 | 3617824.0 |
| 2004-12-13 11:50:00 | AAPL | Stock | 1.1561 | 1.157 | 1.1555 | 1.1568 | 3129000.0 |
| 2004-12-13 11:55:00 | AAPL | Stock | 1.157 | 1.1589 | 1.1568 | 1.1589 | 6114248.0 |
| 2004-12-13 12:00:00 | AAPL | Stock | 1.1588 | 1.1623 | 1.1584 | 1.1607 | 8410976.0 |
| 2004-12-13 12:05:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1588 | 1.1602 | 2399880.0 |
> showing 50 of 191,427 rows — these rows as CSV