PREVIEW / stock_5min / 2005-11-14
file: by_date/stock_5min/2005/2005-11-14.parquet size: 2.8 MB rows: 205,307 symbols: 2,109
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-11-14 08:00:00 | AAPL | Stock | 2.1943 | 2.1943 | 2.1929 | 2.1929 | 14560.0 |
| 2005-11-14 08:05:00 | AAPL | Stock | 2.1911 | 2.1911 | 2.1893 | 2.1893 | 14112.0 |
| 2005-11-14 08:10:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1857 | 2.1875 | 58688.0 |
| 2005-11-14 08:15:00 | AAPL | Stock | 2.1857 | 2.1875 | 2.1857 | 2.1857 | 48580.0 |
| 2005-11-14 08:20:00 | AAPL | Stock | 2.1889 | 2.1893 | 2.1861 | 2.1861 | 52276.0 |
| 2005-11-14 08:25:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1889 | 2.1893 | 198800.0 |
| 2005-11-14 08:30:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1889 | 2.1889 | 71120.0 |
| 2005-11-14 08:35:00 | AAPL | Stock | 2.1893 | 2.1911 | 2.1879 | 2.1879 | 277200.0 |
| 2005-11-14 08:40:00 | AAPL | Stock | 2.1921 | 2.1929 | 2.1914 | 2.1925 | 528500.0 |
| 2005-11-14 08:45:00 | AAPL | Stock | 2.1929 | 2.1929 | 2.1914 | 2.1921 | 30520.0 |
| 2005-11-14 08:50:00 | AAPL | Stock | 2.1914 | 2.1914 | 2.1914 | 2.1914 | 5600.0 |
| 2005-11-14 08:55:00 | AAPL | Stock | 2.1904 | 2.1914 | 2.1904 | 2.1914 | 33600.0 |
| 2005-11-14 09:00:00 | AAPL | Stock | 2.1921 | 2.1921 | 2.1914 | 2.1914 | 44800.0 |
| 2005-11-14 09:05:00 | AAPL | Stock | 2.1911 | 2.1929 | 2.1911 | 2.1929 | 36820.0 |
| 2005-11-14 09:10:00 | AAPL | Stock | 2.1914 | 2.1914 | 2.1914 | 2.1914 | 11200.0 |
| 2005-11-14 09:15:00 | AAPL | Stock | 2.1914 | 2.1914 | 2.1914 | 2.1914 | 5600.0 |
| 2005-11-14 09:25:00 | AAPL | Stock | 2.1929 | 2.2039 | 2.1929 | 2.1964 | 583996.0 |
| 2005-11-14 09:30:00 | AAPL | Stock | 2.1979 | 2.2082 | 2.1929 | 2.2061 | 13349000.0 |
| 2005-11-14 09:35:00 | AAPL | Stock | 2.2061 | 2.2068 | 2.1957 | 2.1979 | 7624148.0 |
| 2005-11-14 09:40:00 | AAPL | Stock | 2.1979 | 2.2029 | 2.1957 | 2.2 | 4847276.0 |
| 2005-11-14 09:45:00 | AAPL | Stock | 2.2007 | 2.2136 | 2.1996 | 2.2107 | 13099604.0 |
| 2005-11-14 09:50:00 | AAPL | Stock | 2.2104 | 2.2107 | 2.2021 | 2.2032 | 6768496.0 |
| 2005-11-14 09:55:00 | AAPL | Stock | 2.2032 | 2.2046 | 2.1964 | 2.1979 | 10274152.0 |
| 2005-11-14 10:00:00 | AAPL | Stock | 2.1982 | 2.1993 | 2.1918 | 2.1939 | 13762756.0 |
| 2005-11-14 10:05:00 | AAPL | Stock | 2.1943 | 2.1979 | 2.1918 | 2.1921 | 10648736.0 |
| 2005-11-14 10:10:00 | AAPL | Stock | 2.1925 | 2.2036 | 2.1886 | 2.2036 | 10913392.0 |
| 2005-11-14 10:15:00 | AAPL | Stock | 2.2036 | 2.2071 | 2.2 | 2.2014 | 8254344.0 |
| 2005-11-14 10:20:00 | AAPL | Stock | 2.2014 | 2.2068 | 2.2004 | 2.2007 | 5026280.0 |
| 2005-11-14 10:25:00 | AAPL | Stock | 2.2007 | 2.2032 | 2.1957 | 2.1975 | 6053292.0 |
| 2005-11-14 10:30:00 | AAPL | Stock | 2.1979 | 2.2036 | 2.1975 | 2.2036 | 3210396.0 |
| 2005-11-14 10:35:00 | AAPL | Stock | 2.2036 | 2.2054 | 2.2018 | 2.2039 | 4588108.0 |
| 2005-11-14 10:40:00 | AAPL | Stock | 2.2036 | 2.2054 | 2.2011 | 2.2014 | 2600472.0 |
| 2005-11-14 10:45:00 | AAPL | Stock | 2.2012 | 2.2046 | 2.1993 | 2.2042 | 4075204.0 |
| 2005-11-14 10:50:00 | AAPL | Stock | 2.2043 | 2.205 | 2.1996 | 2.2004 | 3953908.0 |
| 2005-11-14 10:55:00 | AAPL | Stock | 2.2004 | 2.2032 | 2.1982 | 2.1993 | 3531752.0 |
| 2005-11-14 11:00:00 | AAPL | Stock | 2.1989 | 2.2018 | 2.1968 | 2.1979 | 4093824.0 |
| 2005-11-14 11:05:00 | AAPL | Stock | 2.1979 | 2.1986 | 2.1954 | 2.1986 | 3029460.0 |
| 2005-11-14 11:10:00 | AAPL | Stock | 2.1982 | 2.2 | 2.1954 | 2.1976 | 3661560.0 |
| 2005-11-14 11:15:00 | AAPL | Stock | 2.1979 | 2.2018 | 2.1961 | 2.1989 | 2205560.0 |
| 2005-11-14 11:20:00 | AAPL | Stock | 2.1993 | 2.2025 | 2.1964 | 2.1971 | 6207684.0 |
| 2005-11-14 11:25:00 | AAPL | Stock | 2.1968 | 2.1971 | 2.1936 | 2.1957 | 3204488.0 |
| 2005-11-14 11:30:00 | AAPL | Stock | 2.1954 | 2.1957 | 2.1893 | 2.1907 | 6468532.0 |
| 2005-11-14 11:35:00 | AAPL | Stock | 2.1907 | 2.1911 | 2.1829 | 2.1839 | 6266596.0 |
| 2005-11-14 11:40:00 | AAPL | Stock | 2.1843 | 2.1871 | 2.18 | 2.1854 | 6720588.0 |
| 2005-11-14 11:45:00 | AAPL | Stock | 2.1854 | 2.1854 | 2.1754 | 2.1768 | 12725132.0 |
| 2005-11-14 11:50:00 | AAPL | Stock | 2.1764 | 2.1836 | 2.1761 | 2.1804 | 6344856.0 |
| 2005-11-14 11:55:00 | AAPL | Stock | 2.18 | 2.1836 | 2.1786 | 2.1836 | 3985436.0 |
| 2005-11-14 12:00:00 | AAPL | Stock | 2.1836 | 2.1868 | 2.1825 | 2.1857 | 5223232.0 |
| 2005-11-14 12:05:00 | AAPL | Stock | 2.1857 | 2.1857 | 2.1821 | 2.1832 | 3764264.0 |
| 2005-11-14 12:10:00 | AAPL | Stock | 2.1832 | 2.1864 | 2.1829 | 2.1839 | 1873816.0 |
> showing 50 of 205,307 rows — these rows as CSV