PREVIEW / stock_5min / 2006-03-23
file: by_date/stock_5min/2006/2006-03-23.parquet size: 3.0 MB rows: 217,755 symbols: 2,213
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-03-23 04:15:00 | AAPL | Stock | 2.2036 | 2.2036 | 2.2036 | 2.2036 | 28000.0 |
| 2006-03-23 06:50:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 2800.0 |
| 2006-03-23 07:10:00 | AAPL | Stock | 2.1929 | 2.1929 | 2.1929 | 2.1929 | 2800.0 |
| 2006-03-23 07:15:00 | AAPL | Stock | 2.1961 | 2.1961 | 2.1961 | 2.1961 | 8400.0 |
| 2006-03-23 07:35:00 | AAPL | Stock | 2.1929 | 2.1929 | 2.1929 | 2.1929 | 2800.0 |
| 2006-03-23 07:40:00 | AAPL | Stock | 2.1911 | 2.1911 | 2.1893 | 2.1893 | 9800.0 |
| 2006-03-23 07:45:00 | AAPL | Stock | 2.1939 | 2.1957 | 2.1939 | 2.1957 | 28000.0 |
| 2006-03-23 07:55:00 | AAPL | Stock | 2.1893 | 2.1964 | 2.1893 | 2.195 | 30800.0 |
| 2006-03-23 08:00:00 | AAPL | Stock | 2.1957 | 2.1982 | 2.1921 | 2.1968 | 420000.0 |
| 2006-03-23 08:05:00 | AAPL | Stock | 2.1968 | 2.2004 | 2.1946 | 2.2 | 403592.0 |
| 2006-03-23 08:10:00 | AAPL | Stock | 2.1982 | 2.2018 | 2.1982 | 2.1993 | 526400.0 |
| 2006-03-23 08:15:00 | AAPL | Stock | 2.2014 | 2.2018 | 2.2 | 2.2 | 69300.0 |
| 2006-03-23 08:20:00 | AAPL | Stock | 2.1993 | 2.2036 | 2.1993 | 2.2018 | 306600.0 |
| 2006-03-23 08:25:00 | AAPL | Stock | 2.2021 | 2.2043 | 2.2 | 2.2039 | 228200.0 |
| 2006-03-23 08:30:00 | AAPL | Stock | 2.2046 | 2.2093 | 2.1964 | 2.2043 | 882084.0 |
| 2006-03-23 08:35:00 | AAPL | Stock | 2.2036 | 2.2107 | 2.2036 | 2.2107 | 381220.0 |
| 2006-03-23 08:40:00 | AAPL | Stock | 2.2089 | 2.2111 | 2.2054 | 2.2057 | 204400.0 |
| 2006-03-23 08:45:00 | AAPL | Stock | 2.2054 | 2.2057 | 2.2043 | 2.2057 | 278600.0 |
| 2006-03-23 08:50:00 | AAPL | Stock | 2.2057 | 2.2086 | 2.2057 | 2.2082 | 189700.0 |
| 2006-03-23 08:55:00 | AAPL | Stock | 2.2075 | 2.2075 | 2.2036 | 2.2036 | 309092.0 |
| 2006-03-23 09:00:00 | AAPL | Stock | 2.2036 | 2.2054 | 2.2036 | 2.2054 | 183260.0 |
| 2006-03-23 09:05:00 | AAPL | Stock | 2.2054 | 2.2054 | 2.2043 | 2.2043 | 91000.0 |
| 2006-03-23 09:10:00 | AAPL | Stock | 2.205 | 2.2054 | 2.2036 | 2.2043 | 87668.0 |
| 2006-03-23 09:20:00 | AAPL | Stock | 2.2057 | 2.2079 | 2.2057 | 2.2079 | 28420.0 |
| 2006-03-23 09:25:00 | AAPL | Stock | 2.2089 | 2.2089 | 2.2032 | 2.2089 | 1077300.0 |
| 2006-03-23 09:30:00 | AAPL | Stock | 2.2079 | 2.2107 | 2.1929 | 2.1946 | 26924492.0 |
| 2006-03-23 09:35:00 | AAPL | Stock | 2.1946 | 2.2068 | 2.1907 | 2.2054 | 19313252.0 |
| 2006-03-23 09:40:00 | AAPL | Stock | 2.205 | 2.2057 | 2.1929 | 2.1975 | 19224800.0 |
| 2006-03-23 09:45:00 | AAPL | Stock | 2.1975 | 2.1982 | 2.1879 | 2.1929 | 21821324.0 |
| 2006-03-23 09:50:00 | AAPL | Stock | 2.1929 | 2.1964 | 2.1804 | 2.185 | 28245616.0 |
| 2006-03-23 09:55:00 | AAPL | Stock | 2.185 | 2.1871 | 2.1721 | 2.1771 | 39038440.0 |
| 2006-03-23 10:00:00 | AAPL | Stock | 2.1771 | 2.1861 | 2.1754 | 2.1814 | 20315120.0 |
| 2006-03-23 10:05:00 | AAPL | Stock | 2.1814 | 2.1832 | 2.1725 | 2.1786 | 19770436.0 |
| 2006-03-23 10:10:00 | AAPL | Stock | 2.1782 | 2.1854 | 2.1764 | 2.1796 | 13136228.0 |
| 2006-03-23 10:15:00 | AAPL | Stock | 2.1793 | 2.1839 | 2.1711 | 2.1807 | 24418184.0 |
| 2006-03-23 10:20:00 | AAPL | Stock | 2.1807 | 2.1811 | 2.1771 | 2.18 | 10960096.0 |
| 2006-03-23 10:25:00 | AAPL | Stock | 2.18 | 2.1829 | 2.1711 | 2.1764 | 17388224.0 |
| 2006-03-23 10:30:00 | AAPL | Stock | 2.1768 | 2.1771 | 2.1668 | 2.1711 | 22456420.0 |
| 2006-03-23 10:35:00 | AAPL | Stock | 2.1714 | 2.1761 | 2.1636 | 2.1668 | 22752100.0 |
| 2006-03-23 10:40:00 | AAPL | Stock | 2.1671 | 2.1768 | 2.1661 | 2.1725 | 15731044.0 |
| 2006-03-23 10:45:00 | AAPL | Stock | 2.1721 | 2.1739 | 2.1682 | 2.1711 | 13332732.0 |
| 2006-03-23 10:50:00 | AAPL | Stock | 2.1707 | 2.1786 | 2.17 | 2.1757 | 10165232.0 |
| 2006-03-23 10:55:00 | AAPL | Stock | 2.1757 | 2.1761 | 2.1707 | 2.1729 | 9013536.0 |
| 2006-03-23 11:00:00 | AAPL | Stock | 2.1729 | 2.1732 | 2.1625 | 2.1679 | 16060212.0 |
| 2006-03-23 11:05:00 | AAPL | Stock | 2.1682 | 2.1739 | 2.1671 | 2.1725 | 10514140.0 |
| 2006-03-23 11:10:00 | AAPL | Stock | 2.1725 | 2.1771 | 2.1714 | 2.1743 | 10999828.0 |
| 2006-03-23 11:15:00 | AAPL | Stock | 2.1746 | 2.1761 | 2.1696 | 2.1711 | 9737392.0 |
| 2006-03-23 11:20:00 | AAPL | Stock | 2.1707 | 2.1714 | 2.1618 | 2.1661 | 23036636.0 |
| 2006-03-23 11:25:00 | AAPL | Stock | 2.1654 | 2.1686 | 2.1636 | 2.1686 | 12575248.0 |
| 2006-03-23 11:30:00 | AAPL | Stock | 2.1686 | 2.1689 | 2.1593 | 2.1593 | 22472492.0 |
> showing 50 of 217,755 rows — these rows as CSV