PREVIEW / stock_5min / 2007-02-23
file: by_date/stock_5min/2007/2007-02-23.parquet size: 3.4 MB rows: 249,815 symbols: 2,540
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-23 06:50:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 8400.0 |
| 2007-02-23 07:20:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 16800.0 |
| 2007-02-23 07:35:00 | AAPL | Stock | 3.1786 | 3.18 | 3.1786 | 3.1786 | 11200.0 |
| 2007-02-23 07:40:00 | AAPL | Stock | 3.1857 | 3.1911 | 3.1857 | 3.1911 | 5600.0 |
| 2007-02-23 08:00:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1836 | 3.1861 | 48300.0 |
| 2007-02-23 08:05:00 | AAPL | Stock | 3.1839 | 3.1911 | 3.1839 | 3.1911 | 10920.0 |
| 2007-02-23 08:10:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 5880.0 |
| 2007-02-23 08:15:00 | AAPL | Stock | 3.1843 | 3.1843 | 3.1843 | 3.1843 | 2800.0 |
| 2007-02-23 08:20:00 | AAPL | Stock | 3.1864 | 3.1864 | 3.1864 | 3.1864 | 4200.0 |
| 2007-02-23 08:25:00 | AAPL | Stock | 3.1854 | 3.1854 | 3.1854 | 3.1854 | 33040.0 |
| 2007-02-23 08:30:00 | AAPL | Stock | 3.1854 | 3.1854 | 3.1843 | 3.1843 | 7700.0 |
| 2007-02-23 08:35:00 | AAPL | Stock | 3.1843 | 3.1857 | 3.1821 | 3.1821 | 91196.0 |
| 2007-02-23 08:40:00 | AAPL | Stock | 3.1821 | 3.1839 | 3.1821 | 3.1825 | 81200.0 |
| 2007-02-23 08:45:00 | AAPL | Stock | 3.1825 | 3.1857 | 3.1821 | 3.1857 | 42000.0 |
| 2007-02-23 08:50:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1857 | 3.1893 | 71400.0 |
| 2007-02-23 08:55:00 | AAPL | Stock | 3.1879 | 3.1929 | 3.1879 | 3.1929 | 61768.0 |
| 2007-02-23 09:00:00 | AAPL | Stock | 3.1929 | 3.1943 | 3.1896 | 3.1896 | 112812.0 |
| 2007-02-23 09:05:00 | AAPL | Stock | 3.1893 | 3.1893 | 3.1875 | 3.1875 | 47740.0 |
| 2007-02-23 09:10:00 | AAPL | Stock | 3.1861 | 3.1861 | 3.1836 | 3.1836 | 74200.0 |
| 2007-02-23 09:15:00 | AAPL | Stock | 3.1854 | 3.1857 | 3.1854 | 3.1857 | 35896.0 |
| 2007-02-23 09:20:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1857 | 3.1857 | 2800.0 |
| 2007-02-23 09:25:00 | AAPL | Stock | 3.1857 | 3.1929 | 3.1857 | 3.1882 | 177156.0 |
| 2007-02-23 09:30:00 | AAPL | Stock | 3.1843 | 3.1961 | 3.1732 | 3.1946 | 17805676.0 |
| 2007-02-23 09:35:00 | AAPL | Stock | 3.1943 | 3.2079 | 3.1871 | 3.2068 | 18763864.0 |
| 2007-02-23 09:40:00 | AAPL | Stock | 3.2079 | 3.2118 | 3.2036 | 3.2075 | 18518528.0 |
| 2007-02-23 09:45:00 | AAPL | Stock | 3.2082 | 3.2096 | 3.1982 | 3.2009 | 10756760.0 |
| 2007-02-23 09:50:00 | AAPL | Stock | 3.2007 | 3.2132 | 3.1996 | 3.2129 | 12173252.0 |
| 2007-02-23 09:55:00 | AAPL | Stock | 3.2129 | 3.2171 | 3.2071 | 3.2071 | 22763440.0 |
| 2007-02-23 10:00:00 | AAPL | Stock | 3.2071 | 3.22 | 3.2057 | 3.2184 | 16149168.0 |
| 2007-02-23 10:05:00 | AAPL | Stock | 3.2184 | 3.2264 | 3.2179 | 3.2229 | 27106548.0 |
| 2007-02-23 10:10:00 | AAPL | Stock | 3.2229 | 3.225 | 3.2086 | 3.21 | 15966972.0 |
| 2007-02-23 10:15:00 | AAPL | Stock | 3.2096 | 3.2161 | 3.2093 | 3.2125 | 12825204.0 |
| 2007-02-23 10:20:00 | AAPL | Stock | 3.2125 | 3.2129 | 3.2025 | 3.2089 | 12312552.0 |
| 2007-02-23 10:25:00 | AAPL | Stock | 3.2093 | 3.2093 | 3.1879 | 3.1896 | 15670312.0 |
| 2007-02-23 10:30:00 | AAPL | Stock | 3.1896 | 3.1954 | 3.1786 | 3.185 | 13279140.0 |
| 2007-02-23 10:35:00 | AAPL | Stock | 3.1861 | 3.195 | 3.1854 | 3.195 | 11793600.0 |
| 2007-02-23 10:40:00 | AAPL | Stock | 3.1954 | 3.1954 | 3.1857 | 3.1914 | 8487920.0 |
| 2007-02-23 10:45:00 | AAPL | Stock | 3.1914 | 3.1939 | 3.1829 | 3.1843 | 13699196.0 |
| 2007-02-23 10:50:00 | AAPL | Stock | 3.1843 | 3.1879 | 3.1807 | 3.1821 | 9884672.0 |
| 2007-02-23 10:55:00 | AAPL | Stock | 3.1821 | 3.1882 | 3.1793 | 3.1875 | 8010968.0 |
| 2007-02-23 11:00:00 | AAPL | Stock | 3.1875 | 3.1929 | 3.1875 | 3.1911 | 6333404.0 |
| 2007-02-23 11:05:00 | AAPL | Stock | 3.1914 | 3.1925 | 3.1825 | 3.1864 | 6392232.0 |
| 2007-02-23 11:10:00 | AAPL | Stock | 3.1864 | 3.1879 | 3.1818 | 3.1861 | 4219992.0 |
| 2007-02-23 11:15:00 | AAPL | Stock | 3.1861 | 3.1957 | 3.1839 | 3.1954 | 7185416.0 |
| 2007-02-23 11:20:00 | AAPL | Stock | 3.1954 | 3.1986 | 3.1925 | 3.1957 | 8359120.0 |
| 2007-02-23 11:25:00 | AAPL | Stock | 3.1957 | 3.2 | 3.195 | 3.1957 | 9523836.0 |
| 2007-02-23 11:30:00 | AAPL | Stock | 3.1957 | 3.2018 | 3.1954 | 3.2011 | 4905180.0 |
| 2007-02-23 11:35:00 | AAPL | Stock | 3.2014 | 3.2071 | 3.2014 | 3.2046 | 9816212.0 |
| 2007-02-23 11:40:00 | AAPL | Stock | 3.205 | 3.2054 | 3.2004 | 3.2032 | 4628680.0 |
| 2007-02-23 11:45:00 | AAPL | Stock | 3.2032 | 3.2046 | 3.1986 | 3.1989 | 6381564.0 |
> showing 50 of 249,815 rows — these rows as CSV