PREVIEW / stock_5min / 2006-12-14
file: by_date/stock_5min/2006/2006-12-14.parquet size: 3.3 MB rows: 242,721 symbols: 2,479
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-14 07:35:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 28000.0 |
| 2006-12-14 07:40:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 140000.0 |
| 2006-12-14 07:45:00 | AAPL | Stock | 3.1875 | 3.1893 | 3.1875 | 3.1893 | 25200.0 |
| 2006-12-14 07:50:00 | AAPL | Stock | 3.1821 | 3.1875 | 3.1821 | 3.1875 | 11200.0 |
| 2006-12-14 07:55:00 | AAPL | Stock | 3.1857 | 3.1861 | 3.1811 | 3.1811 | 148400.0 |
| 2006-12-14 08:00:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1821 | 3.1839 | 1030036.0 |
| 2006-12-14 08:05:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1739 | 3.1739 | 324156.0 |
| 2006-12-14 08:10:00 | AAPL | Stock | 3.1739 | 3.1786 | 3.1736 | 3.1754 | 220920.0 |
| 2006-12-14 08:15:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1761 | 3.1786 | 190120.0 |
| 2006-12-14 08:20:00 | AAPL | Stock | 3.1779 | 3.1782 | 3.1764 | 3.1768 | 113400.0 |
| 2006-12-14 08:25:00 | AAPL | Stock | 3.1786 | 3.1804 | 3.1764 | 3.1804 | 79660.0 |
| 2006-12-14 08:30:00 | AAPL | Stock | 3.1804 | 3.185 | 3.1804 | 3.1839 | 445200.0 |
| 2006-12-14 08:35:00 | AAPL | Stock | 3.1839 | 3.1857 | 3.1839 | 3.1839 | 296380.0 |
| 2006-12-14 08:40:00 | AAPL | Stock | 3.1829 | 3.1857 | 3.175 | 3.1786 | 505344.0 |
| 2006-12-14 08:45:00 | AAPL | Stock | 3.1754 | 3.18 | 3.175 | 3.1775 | 68600.0 |
| 2006-12-14 08:50:00 | AAPL | Stock | 3.1754 | 3.1807 | 3.175 | 3.1793 | 268800.0 |
| 2006-12-14 08:55:00 | AAPL | Stock | 3.1786 | 3.1804 | 3.1746 | 3.175 | 354284.0 |
| 2006-12-14 09:00:00 | AAPL | Stock | 3.1746 | 3.1821 | 3.1732 | 3.1746 | 806400.0 |
| 2006-12-14 09:05:00 | AAPL | Stock | 3.1779 | 3.1789 | 3.1779 | 3.1779 | 323708.0 |
| 2006-12-14 09:10:00 | AAPL | Stock | 3.1739 | 3.1779 | 3.1739 | 3.175 | 120400.0 |
| 2006-12-14 09:15:00 | AAPL | Stock | 3.1786 | 3.1807 | 3.1786 | 3.1804 | 65800.0 |
| 2006-12-14 09:20:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1736 | 3.175 | 74844.0 |
| 2006-12-14 09:25:00 | AAPL | Stock | 3.18 | 3.1964 | 3.1746 | 3.1804 | 1136380.0 |
| 2006-12-14 09:30:00 | AAPL | Stock | 3.1804 | 3.1864 | 3.1579 | 3.1629 | 30478560.0 |
| 2006-12-14 09:35:00 | AAPL | Stock | 3.1625 | 3.175 | 3.1607 | 3.1654 | 21068768.0 |
| 2006-12-14 09:40:00 | AAPL | Stock | 3.1654 | 3.1729 | 3.1625 | 3.1632 | 17308984.0 |
| 2006-12-14 09:45:00 | AAPL | Stock | 3.1632 | 3.1679 | 3.1557 | 3.1593 | 17131856.0 |
| 2006-12-14 09:50:00 | AAPL | Stock | 3.1586 | 3.1643 | 3.1521 | 3.1597 | 18396392.0 |
| 2006-12-14 09:55:00 | AAPL | Stock | 3.1596 | 3.1714 | 3.1596 | 3.1664 | 29603252.0 |
| 2006-12-14 10:00:00 | AAPL | Stock | 3.1664 | 3.1975 | 3.1654 | 3.1943 | 32945024.0 |
| 2006-12-14 10:05:00 | AAPL | Stock | 3.1946 | 3.2018 | 3.1857 | 3.2 | 35887684.0 |
| 2006-12-14 10:10:00 | AAPL | Stock | 3.1993 | 3.2121 | 3.1993 | 3.2061 | 33770884.0 |
| 2006-12-14 10:15:00 | AAPL | Stock | 3.2061 | 3.2093 | 3.2004 | 3.2032 | 18362260.0 |
| 2006-12-14 10:20:00 | AAPL | Stock | 3.2032 | 3.2143 | 3.2014 | 3.2086 | 21926156.0 |
| 2006-12-14 10:25:00 | AAPL | Stock | 3.2086 | 3.2114 | 3.2014 | 3.2107 | 8911980.0 |
| 2006-12-14 10:30:00 | AAPL | Stock | 3.211 | 3.2121 | 3.2 | 3.2075 | 14696192.0 |
| 2006-12-14 10:35:00 | AAPL | Stock | 3.2071 | 3.2136 | 3.2025 | 3.2129 | 12833380.0 |
| 2006-12-14 10:40:00 | AAPL | Stock | 3.2129 | 3.2136 | 3.2036 | 3.2086 | 11638452.0 |
| 2006-12-14 10:45:00 | AAPL | Stock | 3.2089 | 3.2121 | 3.2032 | 3.2071 | 8392748.0 |
| 2006-12-14 10:50:00 | AAPL | Stock | 3.2071 | 3.2114 | 3.1946 | 3.1975 | 14071176.0 |
| 2006-12-14 10:55:00 | AAPL | Stock | 3.1972 | 3.2071 | 3.1964 | 3.2043 | 8393252.0 |
| 2006-12-14 11:00:00 | AAPL | Stock | 3.2043 | 3.2068 | 3.2021 | 3.2053 | 5708556.0 |
| 2006-12-14 11:05:00 | AAPL | Stock | 3.2054 | 3.2061 | 3.2018 | 3.2025 | 5842424.0 |
| 2006-12-14 11:10:00 | AAPL | Stock | 3.2026 | 3.2029 | 3.1975 | 3.1975 | 7359912.0 |
| 2006-12-14 11:15:00 | AAPL | Stock | 3.1975 | 3.2025 | 3.1929 | 3.1993 | 11096680.0 |
| 2006-12-14 11:20:00 | AAPL | Stock | 3.1989 | 3.1993 | 3.1918 | 3.1932 | 8586452.0 |
| 2006-12-14 11:25:00 | AAPL | Stock | 3.1929 | 3.2007 | 3.1929 | 3.2007 | 7888636.0 |
| 2006-12-14 11:30:00 | AAPL | Stock | 3.2 | 3.2032 | 3.1979 | 3.2004 | 8222060.0 |
| 2006-12-14 11:35:00 | AAPL | Stock | 3.2004 | 3.2039 | 3.1982 | 3.1996 | 6400856.0 |
| 2006-12-14 11:40:00 | AAPL | Stock | 3.1996 | 3.2022 | 3.1964 | 3.1971 | 5349904.0 |
> showing 50 of 242,721 rows — these rows as CSV