PREVIEW / stock_5min / 2004-12-16
file: by_date/stock_5min/2004/2004-12-16.parquet size: 2.7 MB rows: 191,633 symbols: 1,901
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-16 08:00:00 | AAPL | Stock | 1.1696 | 1.1768 | 1.1696 | 1.1768 | 170800.0 |
| 2004-12-16 08:05:00 | AAPL | Stock | 1.1768 | 1.1786 | 1.1732 | 1.1748 | 483280.0 |
| 2004-12-16 08:10:00 | AAPL | Stock | 1.1766 | 1.1766 | 1.175 | 1.1766 | 100240.0 |
| 2004-12-16 08:15:00 | AAPL | Stock | 1.1773 | 1.1775 | 1.1752 | 1.1771 | 328272.0 |
| 2004-12-16 08:20:00 | AAPL | Stock | 1.1771 | 1.1777 | 1.1759 | 1.1759 | 328160.0 |
| 2004-12-16 08:25:00 | AAPL | Stock | 1.1775 | 1.178 | 1.1768 | 1.1768 | 451360.0 |
| 2004-12-16 08:30:00 | AAPL | Stock | 1.1777 | 1.1804 | 1.1777 | 1.1802 | 852320.0 |
| 2004-12-16 08:35:00 | AAPL | Stock | 1.1786 | 1.1804 | 1.1786 | 1.1802 | 282800.0 |
| 2004-12-16 08:40:00 | AAPL | Stock | 1.1802 | 1.1802 | 1.1786 | 1.1786 | 716800.0 |
| 2004-12-16 08:45:00 | AAPL | Stock | 1.1795 | 1.1804 | 1.1786 | 1.1795 | 173600.0 |
| 2004-12-16 08:50:00 | AAPL | Stock | 1.1804 | 1.1814 | 1.1786 | 1.1814 | 789600.0 |
| 2004-12-16 08:55:00 | AAPL | Stock | 1.1816 | 1.183 | 1.1805 | 1.1816 | 358736.0 |
| 2004-12-16 09:00:00 | AAPL | Stock | 1.1816 | 1.1816 | 1.1654 | 1.18 | 1407560.0 |
| 2004-12-16 09:05:00 | AAPL | Stock | 1.1798 | 1.1798 | 1.1786 | 1.1795 | 870800.0 |
| 2004-12-16 09:10:00 | AAPL | Stock | 1.1802 | 1.1807 | 1.1764 | 1.1807 | 2688000.0 |
| 2004-12-16 09:15:00 | AAPL | Stock | 1.1821 | 1.1821 | 1.1804 | 1.1804 | 84616.0 |
| 2004-12-16 09:20:00 | AAPL | Stock | 1.1804 | 1.1805 | 1.1795 | 1.1804 | 408240.0 |
| 2004-12-16 09:25:00 | AAPL | Stock | 1.1786 | 1.185 | 1.1654 | 1.1825 | 97106072.0 |
| 2004-12-16 09:30:00 | AAPL | Stock | 1.1829 | 1.1952 | 1.1795 | 1.1891 | 54966296.0 |
| 2004-12-16 09:35:00 | AAPL | Stock | 1.1891 | 1.2041 | 1.1863 | 1.1966 | 53786264.0 |
| 2004-12-16 09:40:00 | AAPL | Stock | 1.1966 | 1.2027 | 1.1938 | 1.1945 | 36899856.0 |
| 2004-12-16 09:45:00 | AAPL | Stock | 1.1943 | 1.1963 | 1.1875 | 1.1888 | 27329512.0 |
| 2004-12-16 09:50:00 | AAPL | Stock | 1.1888 | 1.1909 | 1.1857 | 1.1879 | 33081272.0 |
| 2004-12-16 09:55:00 | AAPL | Stock | 1.1875 | 1.1879 | 1.1827 | 1.1863 | 17101000.0 |
| 2004-12-16 10:00:00 | AAPL | Stock | 1.1861 | 1.1866 | 1.1829 | 1.1848 | 17492720.0 |
| 2004-12-16 10:05:00 | AAPL | Stock | 1.1843 | 1.1848 | 1.1807 | 1.1832 | 27343288.0 |
| 2004-12-16 10:10:00 | AAPL | Stock | 1.1832 | 1.1886 | 1.183 | 1.1875 | 16569168.0 |
| 2004-12-16 10:15:00 | AAPL | Stock | 1.1875 | 1.1884 | 1.1805 | 1.1816 | 25485656.0 |
| 2004-12-16 10:20:00 | AAPL | Stock | 1.1818 | 1.1829 | 1.1804 | 1.182 | 12279904.0 |
| 2004-12-16 10:25:00 | AAPL | Stock | 1.182 | 1.187 | 1.1818 | 1.1864 | 10037832.0 |
| 2004-12-16 10:30:00 | AAPL | Stock | 1.1861 | 1.1864 | 1.1832 | 1.1839 | 8654072.0 |
| 2004-12-16 10:35:00 | AAPL | Stock | 1.1834 | 1.19 | 1.1832 | 1.1889 | 25024104.0 |
| 2004-12-16 10:40:00 | AAPL | Stock | 1.1888 | 1.1896 | 1.1861 | 1.1882 | 6494096.0 |
| 2004-12-16 10:45:00 | AAPL | Stock | 1.1882 | 1.1888 | 1.1843 | 1.1866 | 6575576.0 |
| 2004-12-16 10:50:00 | AAPL | Stock | 1.1866 | 1.19 | 1.1866 | 1.1882 | 6187104.0 |
| 2004-12-16 10:55:00 | AAPL | Stock | 1.1882 | 1.1905 | 1.1871 | 1.1904 | 9164400.0 |
| 2004-12-16 11:00:00 | AAPL | Stock | 1.1902 | 1.1916 | 1.1896 | 1.1909 | 9348584.0 |
| 2004-12-16 11:05:00 | AAPL | Stock | 1.1905 | 1.1914 | 1.1868 | 1.1873 | 7636888.0 |
| 2004-12-16 11:10:00 | AAPL | Stock | 1.1877 | 1.1902 | 1.1868 | 1.1896 | 5376168.0 |
| 2004-12-16 11:15:00 | AAPL | Stock | 1.1896 | 1.19 | 1.188 | 1.1896 | 6117272.0 |
| 2004-12-16 11:20:00 | AAPL | Stock | 1.1898 | 1.1925 | 1.1895 | 1.1911 | 10795120.0 |
| 2004-12-16 11:25:00 | AAPL | Stock | 1.1909 | 1.1929 | 1.1909 | 1.192 | 8946672.0 |
| 2004-12-16 11:30:00 | AAPL | Stock | 1.1923 | 1.1961 | 1.1921 | 1.195 | 12279736.0 |
| 2004-12-16 11:35:00 | AAPL | Stock | 1.1946 | 1.1991 | 1.1946 | 1.1989 | 19042184.0 |
| 2004-12-16 11:40:00 | AAPL | Stock | 1.1989 | 1.1991 | 1.195 | 1.1957 | 13175064.0 |
| 2004-12-16 11:45:00 | AAPL | Stock | 1.1957 | 1.1991 | 1.195 | 1.1989 | 8897504.0 |
| 2004-12-16 11:50:00 | AAPL | Stock | 1.1989 | 1.1991 | 1.1952 | 1.1952 | 8683416.0 |
| 2004-12-16 11:55:00 | AAPL | Stock | 1.1952 | 1.1963 | 1.1929 | 1.1938 | 9480856.0 |
| 2004-12-16 12:00:00 | AAPL | Stock | 1.1938 | 1.1979 | 1.1934 | 1.1973 | 12657176.0 |
| 2004-12-16 12:05:00 | AAPL | Stock | 1.1971 | 1.1975 | 1.1941 | 1.1964 | 6465144.0 |
> showing 50 of 191,633 rows — these rows as CSV