PREVIEW / stock_1min / 2008-12-19
file: by_date/stock_1min/2008/2008-12-19.parquet size: 12.9 MB rows: 1,040,356 symbols: 2,758
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-19 07:01:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1896 | 3.1896 | 4200.0 |
| 2008-12-19 07:40:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1896 | 3.1896 | 28000.0 |
| 2008-12-19 07:58:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1896 | 3.1896 | 8400.0 |
| 2008-12-19 08:00:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 5600.0 |
| 2008-12-19 08:03:00 | AAPL | Stock | 3.1968 | 3.1968 | 3.1968 | 3.1968 | 5600.0 |
| 2008-12-19 08:04:00 | AAPL | Stock | 3.1968 | 3.1968 | 3.1961 | 3.1961 | 42700.0 |
| 2008-12-19 08:05:00 | AAPL | Stock | 3.1957 | 3.1957 | 3.1907 | 3.1907 | 15400.0 |
| 2008-12-19 08:06:00 | AAPL | Stock | 3.1904 | 3.1925 | 3.1896 | 3.1896 | 84364.0 |
| 2008-12-19 08:07:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 5600.0 |
| 2008-12-19 08:09:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1786 | 3.1786 | 28000.0 |
| 2008-12-19 08:11:00 | AAPL | Stock | 3.19 | 3.19 | 3.19 | 3.19 | 2800.0 |
| 2008-12-19 08:12:00 | AAPL | Stock | 3.1939 | 3.2 | 3.1939 | 3.2 | 56280.0 |
| 2008-12-19 08:13:00 | AAPL | Stock | 3.2 | 3.2 | 3.1982 | 3.1982 | 15120.0 |
| 2008-12-19 08:15:00 | AAPL | Stock | 3.2032 | 3.2036 | 3.2032 | 3.2036 | 55328.0 |
| 2008-12-19 08:16:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.2054 | 3.2054 | 42000.0 |
| 2008-12-19 08:18:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.2054 | 3.2054 | 2800.0 |
| 2008-12-19 08:20:00 | AAPL | Stock | 3.2054 | 3.2132 | 3.2054 | 3.2132 | 97160.0 |
| 2008-12-19 08:22:00 | AAPL | Stock | 3.2129 | 3.2129 | 3.2129 | 3.2129 | 7000.0 |
| 2008-12-19 08:23:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2118 | 3.2118 | 16800.0 |
| 2008-12-19 08:24:00 | AAPL | Stock | 3.2118 | 3.2125 | 3.2118 | 3.2118 | 19600.0 |
| 2008-12-19 08:25:00 | AAPL | Stock | 3.2118 | 3.2143 | 3.2118 | 3.2143 | 75880.0 |
| 2008-12-19 08:26:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2125 | 3.2125 | 14000.0 |
| 2008-12-19 08:27:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2118 | 3.2118 | 21000.0 |
| 2008-12-19 08:28:00 | AAPL | Stock | 3.2118 | 3.2121 | 3.2118 | 3.2121 | 5600.0 |
| 2008-12-19 08:29:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2107 | 3.2118 | 162120.0 |
| 2008-12-19 08:30:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2093 | 3.2093 | 28000.0 |
| 2008-12-19 08:32:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 8400.0 |
| 2008-12-19 08:33:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 8400.0 |
| 2008-12-19 08:36:00 | AAPL | Stock | 3.2089 | 3.2125 | 3.2089 | 3.2125 | 57176.0 |
| 2008-12-19 08:38:00 | AAPL | Stock | 3.2114 | 3.2143 | 3.2114 | 3.2143 | 32620.0 |
| 2008-12-19 08:41:00 | AAPL | Stock | 3.215 | 3.2164 | 3.2143 | 3.2143 | 16800.0 |
| 2008-12-19 08:43:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 28000.0 |
| 2008-12-19 08:44:00 | AAPL | Stock | 3.215 | 3.215 | 3.2143 | 3.2143 | 19600.0 |
| 2008-12-19 08:45:00 | AAPL | Stock | 3.2143 | 3.2196 | 3.2143 | 3.2193 | 88060.0 |
| 2008-12-19 08:46:00 | AAPL | Stock | 3.2157 | 3.2157 | 3.1939 | 3.1939 | 4964288.0 |
| 2008-12-19 08:47:00 | AAPL | Stock | 3.2175 | 3.2175 | 3.2143 | 3.2143 | 19600.0 |
| 2008-12-19 08:48:00 | AAPL | Stock | 3.2143 | 3.2146 | 3.2125 | 3.2125 | 70000.0 |
| 2008-12-19 08:49:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2125 | 3.2125 | 25200.0 |
| 2008-12-19 08:50:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 7000.0 |
| 2008-12-19 08:51:00 | AAPL | Stock | 3.2104 | 3.2104 | 3.2104 | 3.2104 | 5600.0 |
| 2008-12-19 08:52:00 | AAPL | Stock | 3.2089 | 3.21 | 3.2071 | 3.21 | 30800.0 |
| 2008-12-19 08:53:00 | AAPL | Stock | 3.2104 | 3.2104 | 3.2104 | 3.2104 | 11200.0 |
| 2008-12-19 08:54:00 | AAPL | Stock | 3.2136 | 3.2143 | 3.2107 | 3.2143 | 73920.0 |
| 2008-12-19 08:55:00 | AAPL | Stock | 3.2164 | 3.2164 | 3.215 | 3.215 | 8400.0 |
| 2008-12-19 08:56:00 | AAPL | Stock | 3.2168 | 3.2179 | 3.2168 | 3.2179 | 19600.0 |
| 2008-12-19 08:57:00 | AAPL | Stock | 3.2189 | 3.2214 | 3.2179 | 3.2214 | 56112.0 |
| 2008-12-19 08:58:00 | AAPL | Stock | 3.2196 | 3.2207 | 3.2193 | 3.2196 | 95760.0 |
| 2008-12-19 08:59:00 | AAPL | Stock | 3.2196 | 3.2207 | 3.2196 | 3.2207 | 39200.0 |
| 2008-12-19 09:00:00 | AAPL | Stock | 3.2214 | 3.225 | 3.2214 | 3.225 | 57400.0 |
| 2008-12-19 09:01:00 | AAPL | Stock | 3.225 | 3.225 | 3.2232 | 3.2232 | 28000.0 |
> showing 50 of 1,040,356 rows — these rows as CSV