PREVIEW / stock_5min / 2000-04-06
file: by_date/stock_5min/2000/2000-04-06.parquet size: 1.2 MB rows: 87,285 symbols: 1,153
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-06 09:30:00 | AAPL | Stock | 1.1663 | 1.1786 | 1.1652 | 1.1786 | 9576000.0 |
| 2000-04-06 09:35:00 | AAPL | Stock | 1.1791 | 1.2009 | 1.1663 | 1.1964 | 9027200.0 |
| 2000-04-06 09:40:00 | AAPL | Stock | 1.1964 | 1.1975 | 1.1797 | 1.1808 | 6238400.0 |
| 2000-04-06 09:45:00 | AAPL | Stock | 1.1786 | 1.1814 | 1.1708 | 1.1708 | 4054400.0 |
| 2000-04-06 09:50:00 | AAPL | Stock | 1.1708 | 1.1738 | 1.1674 | 1.1685 | 4457600.0 |
| 2000-04-06 09:55:00 | AAPL | Stock | 1.1702 | 1.1775 | 1.1657 | 1.1775 | 2788800.0 |
| 2000-04-06 10:00:00 | AAPL | Stock | 1.1766 | 1.1766 | 1.1696 | 1.173 | 2755200.0 |
| 2000-04-06 10:05:00 | AAPL | Stock | 1.173 | 1.1775 | 1.1652 | 1.1719 | 4412800.0 |
| 2000-04-06 10:10:00 | AAPL | Stock | 1.173 | 1.1769 | 1.1708 | 1.1713 | 2273600.0 |
| 2000-04-06 10:15:00 | AAPL | Stock | 1.1713 | 1.1758 | 1.1708 | 1.1738 | 1859200.0 |
| 2000-04-06 10:20:00 | AAPL | Stock | 1.173 | 1.183 | 1.173 | 1.1791 | 3998400.0 |
| 2000-04-06 10:25:00 | AAPL | Stock | 1.1791 | 1.1825 | 1.1769 | 1.1791 | 3035200.0 |
| 2000-04-06 10:30:00 | AAPL | Stock | 1.1786 | 1.1842 | 1.1786 | 1.1786 | 4043200.0 |
| 2000-04-06 10:35:00 | AAPL | Stock | 1.1769 | 1.1797 | 1.1719 | 1.1797 | 1030400.0 |
| 2000-04-06 10:40:00 | AAPL | Stock | 1.1786 | 1.1797 | 1.1735 | 1.178 | 1646400.0 |
| 2000-04-06 10:45:00 | AAPL | Stock | 1.178 | 1.1853 | 1.1752 | 1.1805 | 2116800.0 |
| 2000-04-06 10:50:00 | AAPL | Stock | 1.178 | 1.1819 | 1.1741 | 1.1775 | 425600.0 |
| 2000-04-06 10:55:00 | AAPL | Stock | 1.1775 | 1.1775 | 1.173 | 1.173 | 1915200.0 |
| 2000-04-06 11:00:00 | AAPL | Stock | 1.173 | 1.1735 | 1.1708 | 1.1708 | 1556800.0 |
| 2000-04-06 11:05:00 | AAPL | Stock | 1.1708 | 1.1819 | 1.1708 | 1.1763 | 6339200.0 |
| 2000-04-06 11:10:00 | AAPL | Stock | 1.1763 | 1.1847 | 1.1741 | 1.1842 | 3427200.0 |
| 2000-04-06 11:15:00 | AAPL | Stock | 1.1836 | 1.1842 | 1.1741 | 1.1786 | 5308800.0 |
| 2000-04-06 11:20:00 | AAPL | Stock | 1.1789 | 1.1819 | 1.1741 | 1.1741 | 2654400.0 |
| 2000-04-06 11:25:00 | AAPL | Stock | 1.173 | 1.178 | 1.1696 | 1.1708 | 1982400.0 |
| 2000-04-06 11:30:00 | AAPL | Stock | 1.1708 | 1.1763 | 1.1696 | 1.1747 | 761600.0 |
| 2000-04-06 11:35:00 | AAPL | Stock | 1.1752 | 1.1775 | 1.1696 | 1.1763 | 1008000.0 |
| 2000-04-06 11:40:00 | AAPL | Stock | 1.173 | 1.1752 | 1.1674 | 1.1674 | 1859200.0 |
| 2000-04-06 11:45:00 | AAPL | Stock | 1.1674 | 1.1685 | 1.1563 | 1.1674 | 5656000.0 |
| 2000-04-06 11:50:00 | AAPL | Stock | 1.1641 | 1.1674 | 1.1607 | 1.1649 | 1512000.0 |
| 2000-04-06 11:55:00 | AAPL | Stock | 1.1629 | 1.1646 | 1.159 | 1.1624 | 694400.0 |
| 2000-04-06 12:00:00 | AAPL | Stock | 1.1638 | 1.1638 | 1.1602 | 1.1613 | 11177600.0 |
| 2000-04-06 12:05:00 | AAPL | Stock | 1.1613 | 1.1685 | 1.1613 | 1.1669 | 1444800.0 |
| 2000-04-06 12:10:00 | AAPL | Stock | 1.1674 | 1.168 | 1.1635 | 1.1663 | 302400.0 |
| 2000-04-06 12:15:00 | AAPL | Stock | 1.1674 | 1.1674 | 1.1657 | 1.1663 | 840000.0 |
| 2000-04-06 12:20:00 | AAPL | Stock | 1.1674 | 1.1696 | 1.1663 | 1.1696 | 929600.0 |
| 2000-04-06 12:25:00 | AAPL | Stock | 1.1696 | 1.1719 | 1.168 | 1.1719 | 616000.0 |
| 2000-04-06 12:30:00 | AAPL | Stock | 1.1719 | 1.1741 | 1.1696 | 1.1719 | 1232000.0 |
| 2000-04-06 12:35:00 | AAPL | Stock | 1.1702 | 1.1702 | 1.1652 | 1.1652 | 716800.0 |
| 2000-04-06 12:40:00 | AAPL | Stock | 1.1652 | 1.1674 | 1.1641 | 1.1657 | 1635200.0 |
| 2000-04-06 12:45:00 | AAPL | Stock | 1.1657 | 1.1657 | 1.1585 | 1.159 | 1444800.0 |
| 2000-04-06 12:50:00 | AAPL | Stock | 1.159 | 1.1641 | 1.154 | 1.1629 | 1635200.0 |
| 2000-04-06 12:55:00 | AAPL | Stock | 1.1629 | 1.1669 | 1.1557 | 1.1669 | 604800.0 |
| 2000-04-06 13:00:00 | AAPL | Stock | 1.1657 | 1.1669 | 1.1596 | 1.1618 | 884800.0 |
| 2000-04-06 13:05:00 | AAPL | Stock | 1.1629 | 1.1663 | 1.1613 | 1.1635 | 481600.0 |
| 2000-04-06 13:10:00 | AAPL | Stock | 1.1641 | 1.1657 | 1.1624 | 1.1635 | 952000.0 |
| 2000-04-06 13:15:00 | AAPL | Stock | 1.1629 | 1.1641 | 1.1607 | 1.1618 | 291200.0 |
| 2000-04-06 13:20:00 | AAPL | Stock | 1.1629 | 1.1669 | 1.1607 | 1.1635 | 694400.0 |
| 2000-04-06 13:25:00 | AAPL | Stock | 1.1646 | 1.1652 | 1.1585 | 1.1629 | 1523200.0 |
| 2000-04-06 13:30:00 | AAPL | Stock | 1.1624 | 1.1674 | 1.1624 | 1.1666 | 2139200.0 |
| 2000-04-06 13:35:00 | AAPL | Stock | 1.1613 | 1.1646 | 1.1607 | 1.1624 | 481600.0 |
> showing 50 of 87,285 rows — these rows as CSV