PREVIEW / stock_1min / 2007-11-26
file: by_date/stock_1min/2007/2007-11-26.parquet size: 12.3 MB rows: 990,959 symbols: 2,619
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-11-26 04:17:00 | AAPL | Stock | 6.1993 | 6.1993 | 6.1993 | 6.1993 | 2800.0 |
| 2007-11-26 05:06:00 | AAPL | Stock | 6.21 | 6.21 | 6.21 | 6.21 | 2800.0 |
| 2007-11-26 06:25:00 | AAPL | Stock | 6.2189 | 6.2218 | 6.2189 | 6.2218 | 5600.0 |
| 2007-11-26 06:28:00 | AAPL | Stock | 6.2304 | 6.2304 | 6.2304 | 6.2304 | 5600.0 |
| 2007-11-26 06:33:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.2218 | 6.2218 | 2800.0 |
| 2007-11-26 06:35:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.2218 | 6.2218 | 2800.0 |
| 2007-11-26 06:39:00 | AAPL | Stock | 6.2211 | 6.2211 | 6.2211 | 6.2211 | 2800.0 |
| 2007-11-26 06:49:00 | AAPL | Stock | 6.22 | 6.22 | 6.22 | 6.22 | 2800.0 |
| 2007-11-26 06:50:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2007-11-26 07:03:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 5600.0 |
| 2007-11-26 07:04:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2007-11-26 07:06:00 | AAPL | Stock | 6.2018 | 6.2018 | 6.2018 | 6.2018 | 2800.0 |
| 2007-11-26 07:09:00 | AAPL | Stock | 6.2086 | 6.2086 | 6.2086 | 6.2086 | 28000.0 |
| 2007-11-26 07:12:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 28000.0 |
| 2007-11-26 07:13:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1875 | 6.1875 | 2800.0 |
| 2007-11-26 07:15:00 | AAPL | Stock | 6.1821 | 6.1821 | 6.1821 | 6.1821 | 8400.0 |
| 2007-11-26 07:19:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1946 | 6.1946 | 2800.0 |
| 2007-11-26 07:20:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 2800.0 |
| 2007-11-26 07:25:00 | AAPL | Stock | 6.1925 | 6.1925 | 6.1925 | 6.1925 | 8400.0 |
| 2007-11-26 07:28:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1929 | 6.1929 | 5600.0 |
| 2007-11-26 07:30:00 | AAPL | Stock | 6.1929 | 6.1961 | 6.1904 | 6.1904 | 28000.0 |
| 2007-11-26 07:31:00 | AAPL | Stock | 6.2 | 6.2043 | 6.2 | 6.2043 | 74284.0 |
| 2007-11-26 07:32:00 | AAPL | Stock | 6.2036 | 6.2043 | 6.2 | 6.2043 | 54516.0 |
| 2007-11-26 07:33:00 | AAPL | Stock | 6.2036 | 6.2043 | 6.2032 | 6.2032 | 186284.0 |
| 2007-11-26 07:34:00 | AAPL | Stock | 6.2 | 6.2 | 6.2 | 6.2 | 26516.0 |
| 2007-11-26 07:35:00 | AAPL | Stock | 6.2039 | 6.2043 | 6.2039 | 6.2043 | 60760.0 |
| 2007-11-26 07:37:00 | AAPL | Stock | 6.2018 | 6.2018 | 6.1964 | 6.1964 | 141484.0 |
| 2007-11-26 07:40:00 | AAPL | Stock | 6.2018 | 6.2089 | 6.2011 | 6.2021 | 554484.0 |
| 2007-11-26 07:43:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1821 | 6.1821 | 81200.0 |
| 2007-11-26 07:44:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1832 | 6.1932 | 36400.0 |
| 2007-11-26 07:45:00 | AAPL | Stock | 6.1804 | 6.1804 | 6.1789 | 6.1789 | 42000.0 |
| 2007-11-26 07:47:00 | AAPL | Stock | 6.1807 | 6.1807 | 6.1807 | 6.1807 | 28000.0 |
| 2007-11-26 07:48:00 | AAPL | Stock | 6.18 | 6.18 | 6.1786 | 6.1786 | 45080.0 |
| 2007-11-26 07:51:00 | AAPL | Stock | 6.1871 | 6.1875 | 6.185 | 6.1875 | 50400.0 |
| 2007-11-26 07:52:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1854 | 6.1854 | 25200.0 |
| 2007-11-26 07:54:00 | AAPL | Stock | 6.1889 | 6.1889 | 6.1889 | 6.1889 | 8400.0 |
| 2007-11-26 07:56:00 | AAPL | Stock | 6.1886 | 6.1886 | 6.1886 | 6.1886 | 2800.0 |
| 2007-11-26 07:59:00 | AAPL | Stock | 6.1889 | 6.1889 | 6.1889 | 6.1889 | 2800.0 |
| 2007-11-26 08:00:00 | AAPL | Stock | 6.1893 | 6.2036 | 6.1807 | 6.1896 | 568484.0 |
| 2007-11-26 08:01:00 | AAPL | Stock | 6.1896 | 6.1929 | 6.1889 | 6.1925 | 182252.0 |
| 2007-11-26 08:02:00 | AAPL | Stock | 6.1925 | 6.1961 | 6.1914 | 6.1929 | 455728.0 |
| 2007-11-26 08:03:00 | AAPL | Stock | 6.1929 | 6.2014 | 6.1911 | 6.1936 | 498428.0 |
| 2007-11-26 08:04:00 | AAPL | Stock | 6.2007 | 6.2036 | 6.1961 | 6.2 | 70140.0 |
| 2007-11-26 08:05:00 | AAPL | Stock | 6.2 | 6.2054 | 6.1989 | 6.2029 | 78400.0 |
| 2007-11-26 08:06:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.1964 | 6.1964 | 154336.0 |
| 2007-11-26 08:07:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1939 | 6.195 | 135884.0 |
| 2007-11-26 08:08:00 | AAPL | Stock | 6.1982 | 6.2 | 6.1982 | 6.1982 | 32200.0 |
| 2007-11-26 08:09:00 | AAPL | Stock | 6.1996 | 6.2 | 6.1982 | 6.2 | 70000.0 |
| 2007-11-26 08:10:00 | AAPL | Stock | 6.2004 | 6.2071 | 6.2004 | 6.2036 | 134204.0 |
| 2007-11-26 08:11:00 | AAPL | Stock | 6.2064 | 6.2089 | 6.2054 | 6.2071 | 58800.0 |
> showing 50 of 990,959 rows — these rows as CSV