PREVIEW / stock_5min / 2004-12-01
file: by_date/stock_5min/2004/2004-12-01.parquet size: 2.7 MB rows: 200,873 symbols: 1,895
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-01 08:00:00 | AAPL | Stock | 1.2054 | 1.2095 | 1.2054 | 1.2089 | 145768.0 |
| 2004-12-01 08:05:00 | AAPL | Stock | 1.2089 | 1.2089 | 1.2066 | 1.2071 | 32480.0 |
| 2004-12-01 08:10:00 | AAPL | Stock | 1.2071 | 1.2073 | 1.2071 | 1.2071 | 76048.0 |
| 2004-12-01 08:15:00 | AAPL | Stock | 1.2077 | 1.2079 | 1.1973 | 1.1973 | 231168.0 |
| 2004-12-01 08:20:00 | AAPL | Stock | 1.2073 | 1.2073 | 1.2073 | 1.2073 | 20272.0 |
| 2004-12-01 08:25:00 | AAPL | Stock | 1.2057 | 1.2064 | 1.1973 | 1.2054 | 442064.0 |
| 2004-12-01 08:30:00 | AAPL | Stock | 1.2054 | 1.2054 | 1.2014 | 1.2014 | 65184.0 |
| 2004-12-01 08:35:00 | AAPL | Stock | 1.2043 | 1.2071 | 1.2043 | 1.2057 | 95200.0 |
| 2004-12-01 08:40:00 | AAPL | Stock | 1.2071 | 1.208 | 1.2071 | 1.2071 | 123760.0 |
| 2004-12-01 08:45:00 | AAPL | Stock | 1.2063 | 1.2079 | 1.2063 | 1.2079 | 61488.0 |
| 2004-12-01 08:50:00 | AAPL | Stock | 1.2071 | 1.2071 | 1.2071 | 1.2071 | 21560.0 |
| 2004-12-01 08:55:00 | AAPL | Stock | 1.2054 | 1.2063 | 1.1975 | 1.2043 | 719600.0 |
| 2004-12-01 09:00:00 | AAPL | Stock | 1.2018 | 1.2054 | 1.1973 | 1.2054 | 134792.0 |
| 2004-12-01 09:05:00 | AAPL | Stock | 1.2054 | 1.2054 | 1.2036 | 1.2036 | 56000.0 |
| 2004-12-01 09:10:00 | AAPL | Stock | 1.2045 | 1.2045 | 1.1973 | 1.1973 | 28000.0 |
| 2004-12-01 09:25:00 | AAPL | Stock | 1.2027 | 1.2113 | 1.2027 | 1.2107 | 744688.0 |
| 2004-12-01 09:30:00 | AAPL | Stock | 1.2105 | 1.2134 | 1.2016 | 1.212 | 39955944.0 |
| 2004-12-01 09:35:00 | AAPL | Stock | 1.2121 | 1.2121 | 1.2032 | 1.2048 | 19719672.0 |
| 2004-12-01 09:40:00 | AAPL | Stock | 1.2052 | 1.2063 | 1.1916 | 1.1945 | 35402640.0 |
| 2004-12-01 09:45:00 | AAPL | Stock | 1.1946 | 1.1964 | 1.1859 | 1.1873 | 37892792.0 |
| 2004-12-01 09:50:00 | AAPL | Stock | 1.187 | 1.1909 | 1.1834 | 1.1907 | 35834848.0 |
| 2004-12-01 09:55:00 | AAPL | Stock | 1.1904 | 1.2025 | 1.19 | 1.2006 | 30075864.0 |
| 2004-12-01 10:00:00 | AAPL | Stock | 1.2005 | 1.2007 | 1.1945 | 1.1954 | 23437680.0 |
| 2004-12-01 10:05:00 | AAPL | Stock | 1.1955 | 1.1979 | 1.192 | 1.1927 | 18573296.0 |
| 2004-12-01 10:10:00 | AAPL | Stock | 1.1923 | 1.1939 | 1.1893 | 1.1911 | 14066920.0 |
| 2004-12-01 10:15:00 | AAPL | Stock | 1.1911 | 1.1927 | 1.1875 | 1.1904 | 12959744.0 |
| 2004-12-01 10:20:00 | AAPL | Stock | 1.1907 | 1.1925 | 1.1873 | 1.1916 | 9824080.0 |
| 2004-12-01 10:25:00 | AAPL | Stock | 1.1918 | 1.1954 | 1.1898 | 1.1909 | 10695888.0 |
| 2004-12-01 10:30:00 | AAPL | Stock | 1.1909 | 1.1946 | 1.1909 | 1.1939 | 8984808.0 |
| 2004-12-01 10:35:00 | AAPL | Stock | 1.1939 | 1.1964 | 1.1938 | 1.1955 | 12265232.0 |
| 2004-12-01 10:40:00 | AAPL | Stock | 1.1954 | 1.197 | 1.1936 | 1.197 | 8088528.0 |
| 2004-12-01 10:45:00 | AAPL | Stock | 1.197 | 1.2025 | 1.1963 | 1.197 | 24615416.0 |
| 2004-12-01 10:50:00 | AAPL | Stock | 1.197 | 1.198 | 1.1948 | 1.1954 | 7234864.0 |
| 2004-12-01 10:55:00 | AAPL | Stock | 1.1954 | 1.1954 | 1.1913 | 1.1938 | 9412144.0 |
| 2004-12-01 11:00:00 | AAPL | Stock | 1.1934 | 1.1946 | 1.1923 | 1.1943 | 5179384.0 |
| 2004-12-01 11:05:00 | AAPL | Stock | 1.1943 | 1.197 | 1.193 | 1.195 | 5326160.0 |
| 2004-12-01 11:10:00 | AAPL | Stock | 1.195 | 1.2009 | 1.1939 | 1.1973 | 17621576.0 |
| 2004-12-01 11:15:00 | AAPL | Stock | 1.1975 | 1.1993 | 1.1973 | 1.1988 | 8536416.0 |
| 2004-12-01 11:20:00 | AAPL | Stock | 1.1984 | 1.2011 | 1.1984 | 1.1995 | 13281800.0 |
| 2004-12-01 11:25:00 | AAPL | Stock | 1.1993 | 1.2007 | 1.1986 | 1.1993 | 5793648.0 |
| 2004-12-01 11:30:00 | AAPL | Stock | 1.1993 | 1.2 | 1.1977 | 1.1993 | 5185152.0 |
| 2004-12-01 11:35:00 | AAPL | Stock | 1.1993 | 1.2013 | 1.1971 | 1.2009 | 6236944.0 |
| 2004-12-01 11:40:00 | AAPL | Stock | 1.2009 | 1.2036 | 1.2 | 1.2021 | 8681624.0 |
| 2004-12-01 11:45:00 | AAPL | Stock | 1.2021 | 1.2023 | 1.1993 | 1.2004 | 3554152.0 |
| 2004-12-01 11:50:00 | AAPL | Stock | 1.2005 | 1.2036 | 1.2 | 1.2016 | 5789672.0 |
| 2004-12-01 11:55:00 | AAPL | Stock | 1.2014 | 1.2016 | 1.1993 | 1.2004 | 5030144.0 |
| 2004-12-01 12:00:00 | AAPL | Stock | 1.2002 | 1.2004 | 1.1945 | 1.1964 | 8006656.0 |
| 2004-12-01 12:05:00 | AAPL | Stock | 1.1966 | 1.1971 | 1.1952 | 1.1968 | 5204248.0 |
| 2004-12-01 12:10:00 | AAPL | Stock | 1.1968 | 1.2025 | 1.1966 | 1.2011 | 8970920.0 |
| 2004-12-01 12:15:00 | AAPL | Stock | 1.2011 | 1.202 | 1.1991 | 1.1991 | 3235904.0 |
> showing 50 of 200,873 rows — these rows as CSV