PREVIEW / stock_1min / 2009-01-22
file: by_date/stock_1min/2009/2009-01-22.parquet size: 11.9 MB rows: 928,042 symbols: 2,672
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-22 04:43:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 4200.0 |
| 2009-01-22 05:19:00 | AAPL | Stock | 3.2129 | 3.2129 | 3.2129 | 3.2129 | 6888.0 |
| 2009-01-22 05:30:00 | AAPL | Stock | 3.2354 | 3.2354 | 3.2354 | 3.2354 | 2800.0 |
| 2009-01-22 06:01:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 8400.0 |
| 2009-01-22 06:46:00 | AAPL | Stock | 3.2193 | 3.2193 | 3.2193 | 3.2193 | 2800.0 |
| 2009-01-22 06:54:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1804 | 3.1804 | 4620.0 |
| 2009-01-22 07:00:00 | AAPL | Stock | 3.1789 | 3.1893 | 3.1786 | 3.1893 | 57960.0 |
| 2009-01-22 07:01:00 | AAPL | Stock | 3.1821 | 3.2064 | 3.1821 | 3.1964 | 53480.0 |
| 2009-01-22 07:02:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 8400.0 |
| 2009-01-22 07:04:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2036 | 3.2036 | 13720.0 |
| 2009-01-22 07:06:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 7112.0 |
| 2009-01-22 07:07:00 | AAPL | Stock | 3.2025 | 3.2025 | 3.2025 | 3.2025 | 2800.0 |
| 2009-01-22 07:09:00 | AAPL | Stock | 3.2025 | 3.2071 | 3.2025 | 3.2071 | 36400.0 |
| 2009-01-22 07:10:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2107 | 3.2143 | 111160.0 |
| 2009-01-22 07:11:00 | AAPL | Stock | 3.2146 | 3.2225 | 3.2143 | 3.2225 | 81900.0 |
| 2009-01-22 07:13:00 | AAPL | Stock | 3.2204 | 3.225 | 3.2189 | 3.2189 | 45640.0 |
| 2009-01-22 07:14:00 | AAPL | Stock | 3.2246 | 3.225 | 3.2225 | 3.2225 | 66276.0 |
| 2009-01-22 07:15:00 | AAPL | Stock | 3.2193 | 3.2275 | 3.2189 | 3.2261 | 85708.0 |
| 2009-01-22 07:16:00 | AAPL | Stock | 3.2279 | 3.2286 | 3.2279 | 3.2286 | 50400.0 |
| 2009-01-22 07:17:00 | AAPL | Stock | 3.2275 | 3.2286 | 3.2232 | 3.2282 | 126000.0 |
| 2009-01-22 07:19:00 | AAPL | Stock | 3.2236 | 3.2236 | 3.2232 | 3.2232 | 5600.0 |
| 2009-01-22 07:20:00 | AAPL | Stock | 3.2264 | 3.2264 | 3.2143 | 3.2146 | 111720.0 |
| 2009-01-22 07:21:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 30520.0 |
| 2009-01-22 07:24:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2161 | 3.2161 | 28000.0 |
| 2009-01-22 07:26:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2107 | 3.2139 | 103824.0 |
| 2009-01-22 07:27:00 | AAPL | Stock | 3.2061 | 3.2061 | 3.1982 | 3.1982 | 206640.0 |
| 2009-01-22 07:28:00 | AAPL | Stock | 3.1968 | 3.2104 | 3.1968 | 3.2054 | 142940.0 |
| 2009-01-22 07:30:00 | AAPL | Stock | 3.2004 | 3.2004 | 3.1964 | 3.1964 | 287896.0 |
| 2009-01-22 07:31:00 | AAPL | Stock | 3.1957 | 3.1964 | 3.1939 | 3.1964 | 75600.0 |
| 2009-01-22 07:32:00 | AAPL | Stock | 3.1957 | 3.1964 | 3.1954 | 3.1964 | 112000.0 |
| 2009-01-22 07:34:00 | AAPL | Stock | 3.2075 | 3.2107 | 3.2039 | 3.2104 | 88872.0 |
| 2009-01-22 07:35:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2018 | 3.2036 | 39200.0 |
| 2009-01-22 07:36:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 14420.0 |
| 2009-01-22 07:39:00 | AAPL | Stock | 3.2011 | 3.2093 | 3.2011 | 3.2093 | 5600.0 |
| 2009-01-22 07:40:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 14000.0 |
| 2009-01-22 07:42:00 | AAPL | Stock | 3.2086 | 3.2086 | 3.2075 | 3.2075 | 8400.0 |
| 2009-01-22 07:43:00 | AAPL | Stock | 3.2039 | 3.2039 | 3.1964 | 3.2 | 156100.0 |
| 2009-01-22 07:44:00 | AAPL | Stock | 3.1946 | 3.1946 | 3.1932 | 3.1932 | 19600.0 |
| 2009-01-22 07:45:00 | AAPL | Stock | 3.1932 | 3.1932 | 3.1932 | 3.1932 | 4228.0 |
| 2009-01-22 07:46:00 | AAPL | Stock | 3.1904 | 3.1925 | 3.1861 | 3.1893 | 112980.0 |
| 2009-01-22 07:47:00 | AAPL | Stock | 3.1861 | 3.1861 | 3.1857 | 3.1857 | 14000.0 |
| 2009-01-22 07:48:00 | AAPL | Stock | 3.1889 | 3.1907 | 3.1875 | 3.1875 | 36400.0 |
| 2009-01-22 07:49:00 | AAPL | Stock | 3.1929 | 3.1957 | 3.1929 | 3.1957 | 30800.0 |
| 2009-01-22 07:50:00 | AAPL | Stock | 3.1932 | 3.1932 | 3.1929 | 3.1929 | 5600.0 |
| 2009-01-22 07:51:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1911 | 3.1911 | 8400.0 |
| 2009-01-22 07:52:00 | AAPL | Stock | 3.1925 | 3.1929 | 3.1925 | 3.1929 | 42000.0 |
| 2009-01-22 07:55:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 11200.0 |
| 2009-01-22 07:56:00 | AAPL | Stock | 3.1925 | 3.1925 | 3.1925 | 3.1925 | 11200.0 |
| 2009-01-22 07:57:00 | AAPL | Stock | 3.1918 | 3.1929 | 3.1918 | 3.1929 | 61600.0 |
| 2009-01-22 07:58:00 | AAPL | Stock | 3.1911 | 3.1921 | 3.1911 | 3.1911 | 8400.0 |
> showing 50 of 928,042 rows — these rows as CSV