PREVIEW / stock_5min / 2004-12-17
file: by_date/stock_5min/2004/2004-12-17.parquet size: 2.7 MB rows: 194,837 symbols: 1,896
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-17 08:00:00 | AAPL | Stock | 1.1964 | 1.1964 | 1.1891 | 1.1891 | 139104.0 |
| 2004-12-17 08:05:00 | AAPL | Stock | 1.1875 | 1.1875 | 1.1875 | 1.1875 | 5600.0 |
| 2004-12-17 08:15:00 | AAPL | Stock | 1.1871 | 1.1871 | 1.185 | 1.185 | 40600.0 |
| 2004-12-17 08:20:00 | AAPL | Stock | 1.185 | 1.185 | 1.1843 | 1.1843 | 26040.0 |
| 2004-12-17 08:25:00 | AAPL | Stock | 1.1843 | 1.1843 | 1.1843 | 1.1843 | 35560.0 |
| 2004-12-17 08:30:00 | AAPL | Stock | 1.1843 | 1.1875 | 1.1843 | 1.1875 | 133280.0 |
| 2004-12-17 08:35:00 | AAPL | Stock | 1.1873 | 1.1873 | 1.1873 | 1.1873 | 22400.0 |
| 2004-12-17 08:40:00 | AAPL | Stock | 1.1855 | 1.1855 | 1.185 | 1.185 | 42000.0 |
| 2004-12-17 08:45:00 | AAPL | Stock | 1.1873 | 1.1918 | 1.1873 | 1.1875 | 193200.0 |
| 2004-12-17 08:50:00 | AAPL | Stock | 1.1911 | 1.192 | 1.1911 | 1.192 | 89600.0 |
| 2004-12-17 08:55:00 | AAPL | Stock | 1.1911 | 1.1946 | 1.1911 | 1.1938 | 285600.0 |
| 2004-12-17 09:00:00 | AAPL | Stock | 1.1932 | 1.1932 | 1.1923 | 1.1932 | 83160.0 |
| 2004-12-17 09:05:00 | AAPL | Stock | 1.1932 | 1.1946 | 1.1932 | 1.1946 | 254800.0 |
| 2004-12-17 09:10:00 | AAPL | Stock | 1.1946 | 1.195 | 1.1913 | 1.192 | 683928.0 |
| 2004-12-17 09:15:00 | AAPL | Stock | 1.192 | 1.192 | 1.192 | 1.192 | 33600.0 |
| 2004-12-17 09:20:00 | AAPL | Stock | 1.192 | 1.1929 | 1.192 | 1.192 | 196000.0 |
| 2004-12-17 09:25:00 | AAPL | Stock | 1.1909 | 1.1945 | 1.1909 | 1.1934 | 504000.0 |
| 2004-12-17 09:30:00 | AAPL | Stock | 1.1934 | 1.1971 | 1.1855 | 1.1873 | 44391424.0 |
| 2004-12-17 09:35:00 | AAPL | Stock | 1.1871 | 1.192 | 1.1809 | 1.1821 | 15213912.0 |
| 2004-12-17 09:40:00 | AAPL | Stock | 1.182 | 1.1898 | 1.182 | 1.1891 | 13726104.0 |
| 2004-12-17 09:45:00 | AAPL | Stock | 1.1891 | 1.1911 | 1.188 | 1.1884 | 9354912.0 |
| 2004-12-17 09:50:00 | AAPL | Stock | 1.1884 | 1.19 | 1.1846 | 1.1857 | 10077144.0 |
| 2004-12-17 09:55:00 | AAPL | Stock | 1.1857 | 1.1866 | 1.1821 | 1.1829 | 12041960.0 |
| 2004-12-17 10:00:00 | AAPL | Stock | 1.183 | 1.1877 | 1.1827 | 1.1866 | 6440224.0 |
| 2004-12-17 10:05:00 | AAPL | Stock | 1.1864 | 1.1871 | 1.1839 | 1.1863 | 6746712.0 |
| 2004-12-17 10:10:00 | AAPL | Stock | 1.1863 | 1.1863 | 1.1821 | 1.1825 | 5464984.0 |
| 2004-12-17 10:15:00 | AAPL | Stock | 1.1825 | 1.183 | 1.1746 | 1.1786 | 20189344.0 |
| 2004-12-17 10:20:00 | AAPL | Stock | 1.1782 | 1.182 | 1.1757 | 1.1811 | 8769656.0 |
| 2004-12-17 10:25:00 | AAPL | Stock | 1.1813 | 1.1813 | 1.1793 | 1.1802 | 5483688.0 |
| 2004-12-17 10:30:00 | AAPL | Stock | 1.1802 | 1.1807 | 1.1795 | 1.18 | 6801368.0 |
| 2004-12-17 10:35:00 | AAPL | Stock | 1.1802 | 1.1802 | 1.1777 | 1.1786 | 6704264.0 |
| 2004-12-17 10:40:00 | AAPL | Stock | 1.1786 | 1.1791 | 1.1759 | 1.1761 | 4759552.0 |
| 2004-12-17 10:45:00 | AAPL | Stock | 1.1761 | 1.1771 | 1.1705 | 1.1711 | 15274896.0 |
| 2004-12-17 10:50:00 | AAPL | Stock | 1.1714 | 1.1729 | 1.1711 | 1.172 | 8770048.0 |
| 2004-12-17 10:55:00 | AAPL | Stock | 1.1723 | 1.1736 | 1.1709 | 1.1709 | 7056952.0 |
| 2004-12-17 11:00:00 | AAPL | Stock | 1.1713 | 1.1718 | 1.1682 | 1.1688 | 16269344.0 |
| 2004-12-17 11:05:00 | AAPL | Stock | 1.1689 | 1.1693 | 1.1666 | 1.1686 | 12719448.0 |
| 2004-12-17 11:10:00 | AAPL | Stock | 1.1686 | 1.1698 | 1.1675 | 1.1688 | 6715912.0 |
| 2004-12-17 11:15:00 | AAPL | Stock | 1.1688 | 1.1714 | 1.1673 | 1.1707 | 6957720.0 |
| 2004-12-17 11:20:00 | AAPL | Stock | 1.1704 | 1.1711 | 1.1657 | 1.1661 | 7068320.0 |
| 2004-12-17 11:25:00 | AAPL | Stock | 1.166 | 1.1668 | 1.1625 | 1.1663 | 15452808.0 |
| 2004-12-17 11:30:00 | AAPL | Stock | 1.1663 | 1.1668 | 1.1643 | 1.1648 | 7250040.0 |
| 2004-12-17 11:35:00 | AAPL | Stock | 1.1645 | 1.165 | 1.1627 | 1.1641 | 6321448.0 |
| 2004-12-17 11:40:00 | AAPL | Stock | 1.1636 | 1.165 | 1.1627 | 1.1643 | 7126056.0 |
| 2004-12-17 11:45:00 | AAPL | Stock | 1.1638 | 1.1652 | 1.163 | 1.1634 | 5262712.0 |
| 2004-12-17 11:50:00 | AAPL | Stock | 1.1634 | 1.1634 | 1.1596 | 1.1609 | 18247656.0 |
| 2004-12-17 11:55:00 | AAPL | Stock | 1.1607 | 1.1638 | 1.1607 | 1.1638 | 6473600.0 |
| 2004-12-17 12:00:00 | AAPL | Stock | 1.1638 | 1.1639 | 1.1618 | 1.163 | 5854856.0 |
| 2004-12-17 12:05:00 | AAPL | Stock | 1.1629 | 1.1634 | 1.1623 | 1.163 | 5846456.0 |
| 2004-12-17 12:10:00 | AAPL | Stock | 1.163 | 1.1652 | 1.1629 | 1.1648 | 5655216.0 |
> showing 50 of 194,837 rows — these rows as CSV