PREVIEW / stock_5min / 2008-08-27
file: by_date/stock_5min/2008/2008-08-27.parquet size: 4.2 MB rows: 307,841 symbols: 3,299
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-27 07:20:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2036 | 6.2036 | 2800.0 |
| 2008-08-27 07:30:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 3920.0 |
| 2008-08-27 07:55:00 | AAPL | Stock | 6.1968 | 6.1968 | 6.1968 | 6.1968 | 5600.0 |
| 2008-08-27 08:00:00 | AAPL | Stock | 6.1932 | 6.1932 | 6.1764 | 6.1768 | 136920.0 |
| 2008-08-27 08:05:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 35028.0 |
| 2008-08-27 08:10:00 | AAPL | Stock | 6.1861 | 6.1861 | 6.1857 | 6.1857 | 16800.0 |
| 2008-08-27 08:15:00 | AAPL | Stock | 6.1839 | 6.1839 | 6.1786 | 6.1786 | 172620.0 |
| 2008-08-27 08:20:00 | AAPL | Stock | 6.1786 | 6.1821 | 6.1786 | 6.1786 | 32060.0 |
| 2008-08-27 08:25:00 | AAPL | Stock | 6.1789 | 6.1796 | 6.1786 | 6.1786 | 28700.0 |
| 2008-08-27 08:30:00 | AAPL | Stock | 6.1821 | 6.2139 | 6.1821 | 6.1907 | 279608.0 |
| 2008-08-27 08:35:00 | AAPL | Stock | 6.2014 | 6.2189 | 6.2014 | 6.2118 | 299544.0 |
| 2008-08-27 08:40:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.21 | 6.2107 | 166600.0 |
| 2008-08-27 08:45:00 | AAPL | Stock | 6.2107 | 6.2132 | 6.21 | 6.2132 | 91000.0 |
| 2008-08-27 08:50:00 | AAPL | Stock | 6.2132 | 6.2139 | 6.2093 | 6.2104 | 102200.0 |
| 2008-08-27 08:55:00 | AAPL | Stock | 6.2093 | 6.2139 | 6.2082 | 6.2089 | 295484.0 |
| 2008-08-27 09:00:00 | AAPL | Stock | 6.2089 | 6.2104 | 6.2068 | 6.2068 | 116340.0 |
| 2008-08-27 09:05:00 | AAPL | Stock | 6.2029 | 6.2082 | 6.2029 | 6.2082 | 37576.0 |
| 2008-08-27 09:10:00 | AAPL | Stock | 6.2082 | 6.2082 | 6.2021 | 6.2021 | 70000.0 |
| 2008-08-27 09:15:00 | AAPL | Stock | 6.2032 | 6.2039 | 6.2021 | 6.2039 | 31416.0 |
| 2008-08-27 09:20:00 | AAPL | Stock | 6.2064 | 6.2071 | 6.2007 | 6.2007 | 49616.0 |
| 2008-08-27 09:25:00 | AAPL | Stock | 6.2011 | 6.2057 | 6.1882 | 6.1882 | 389200.0 |
| 2008-08-27 09:30:00 | AAPL | Stock | 6.19 | 6.2014 | 6.1736 | 6.1893 | 9522660.0 |
| 2008-08-27 09:35:00 | AAPL | Stock | 6.1882 | 6.2121 | 6.1821 | 6.2107 | 9011688.0 |
| 2008-08-27 09:40:00 | AAPL | Stock | 6.2096 | 6.2136 | 6.1771 | 6.1854 | 10321388.0 |
| 2008-08-27 09:45:00 | AAPL | Stock | 6.1861 | 6.1882 | 6.16 | 6.1704 | 13022660.0 |
| 2008-08-27 09:50:00 | AAPL | Stock | 6.1704 | 6.1714 | 6.1497 | 6.1654 | 9019836.0 |
| 2008-08-27 09:55:00 | AAPL | Stock | 6.1657 | 6.1732 | 6.155 | 6.1732 | 6741644.0 |
| 2008-08-27 10:00:00 | AAPL | Stock | 6.1732 | 6.1854 | 6.1686 | 6.1789 | 5551280.0 |
| 2008-08-27 10:05:00 | AAPL | Stock | 6.1789 | 6.1893 | 6.1725 | 6.1843 | 6031396.0 |
| 2008-08-27 10:10:00 | AAPL | Stock | 6.1836 | 6.1846 | 6.1654 | 6.1696 | 5528208.0 |
| 2008-08-27 10:15:00 | AAPL | Stock | 6.17 | 6.1932 | 6.1646 | 6.1908 | 6815312.0 |
| 2008-08-27 10:20:00 | AAPL | Stock | 6.1925 | 6.21 | 6.1918 | 6.2025 | 12842200.0 |
| 2008-08-27 10:25:00 | AAPL | Stock | 6.2021 | 6.2175 | 6.1993 | 6.2129 | 8646988.0 |
| 2008-08-27 10:30:00 | AAPL | Stock | 6.2136 | 6.2146 | 6.2 | 6.2036 | 8161552.0 |
| 2008-08-27 10:35:00 | AAPL | Stock | 6.2032 | 6.2086 | 6.1932 | 6.1937 | 9902564.0 |
| 2008-08-27 10:40:00 | AAPL | Stock | 6.1936 | 6.1986 | 6.1879 | 6.1906 | 5838896.0 |
| 2008-08-27 10:45:00 | AAPL | Stock | 6.1896 | 6.1996 | 6.1879 | 6.193 | 5685288.0 |
| 2008-08-27 10:50:00 | AAPL | Stock | 6.1921 | 6.1961 | 6.1825 | 6.1879 | 5063604.0 |
| 2008-08-27 10:55:00 | AAPL | Stock | 6.185 | 6.1989 | 6.1825 | 6.1968 | 3312120.0 |
| 2008-08-27 11:00:00 | AAPL | Stock | 6.1961 | 6.1993 | 6.1861 | 6.19 | 4003608.0 |
| 2008-08-27 11:05:00 | AAPL | Stock | 6.19 | 6.2054 | 6.1893 | 6.1989 | 4330956.0 |
| 2008-08-27 11:10:00 | AAPL | Stock | 6.1987 | 6.2118 | 6.1986 | 6.2071 | 4884880.0 |
| 2008-08-27 11:15:00 | AAPL | Stock | 6.2079 | 6.2164 | 6.2 | 6.2161 | 5424020.0 |
| 2008-08-27 11:20:00 | AAPL | Stock | 6.2164 | 6.2214 | 6.2104 | 6.2125 | 6352276.0 |
| 2008-08-27 11:25:00 | AAPL | Stock | 6.2125 | 6.2125 | 6.2025 | 6.2032 | 4412464.0 |
| 2008-08-27 11:30:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.1918 | 6.2021 | 5001444.0 |
| 2008-08-27 11:35:00 | AAPL | Stock | 6.2016 | 6.2043 | 6.1918 | 6.1925 | 2648352.0 |
| 2008-08-27 11:40:00 | AAPL | Stock | 6.1936 | 6.1946 | 6.1871 | 6.1939 | 3186540.0 |
| 2008-08-27 11:45:00 | AAPL | Stock | 6.1939 | 6.2039 | 6.1904 | 6.2014 | 3884664.0 |
| 2008-08-27 11:50:00 | AAPL | Stock | 6.2015 | 6.2032 | 6.195 | 6.1957 | 1828092.0 |
> showing 50 of 307,841 rows — these rows as CSV