PREVIEW / stock_1min / 2006-11-24
file: by_date/stock_1min/2006/2006-11-24.parquet size: 4.4 MB rows: 344,797 symbols: 1,932
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-11-24 05:10:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 8400.0 |
| 2006-11-24 05:27:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2006-11-24 05:37:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 16800.0 |
| 2006-11-24 05:38:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 56000.0 |
| 2006-11-24 06:03:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 2800.0 |
| 2006-11-24 06:05:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 2800.0 |
| 2006-11-24 07:29:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.2032 | 3.2032 | 5600.0 |
| 2006-11-24 07:35:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.2032 | 3.2032 | 8036.0 |
| 2006-11-24 07:46:00 | AAPL | Stock | 3.1993 | 3.1993 | 3.1993 | 3.1993 | 2800.0 |
| 2006-11-24 07:50:00 | AAPL | Stock | 3.1986 | 3.1986 | 3.1986 | 3.1986 | 5600.0 |
| 2006-11-24 07:53:00 | AAPL | Stock | 3.2014 | 3.2014 | 3.1964 | 3.1964 | 33600.0 |
| 2006-11-24 07:56:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1961 | 3.1961 | 19964.0 |
| 2006-11-24 07:59:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 11200.0 |
| 2006-11-24 08:00:00 | AAPL | Stock | 3.2 | 3.2125 | 3.1946 | 3.2125 | 312200.0 |
| 2006-11-24 08:01:00 | AAPL | Stock | 3.2118 | 3.2125 | 3.2071 | 3.2107 | 389200.0 |
| 2006-11-24 08:02:00 | AAPL | Stock | 3.2107 | 3.2161 | 3.21 | 3.2161 | 255528.0 |
| 2006-11-24 08:03:00 | AAPL | Stock | 3.2143 | 3.2175 | 3.2143 | 3.2143 | 123200.0 |
| 2006-11-24 08:04:00 | AAPL | Stock | 3.2161 | 3.2179 | 3.2114 | 3.2114 | 192724.0 |
| 2006-11-24 08:05:00 | AAPL | Stock | 3.2129 | 3.2132 | 3.21 | 3.21 | 334964.0 |
| 2006-11-24 08:06:00 | AAPL | Stock | 3.21 | 3.21 | 3.2093 | 3.2096 | 167160.0 |
| 2006-11-24 08:07:00 | AAPL | Stock | 3.2093 | 3.2107 | 3.2093 | 3.2107 | 44800.0 |
| 2006-11-24 08:08:00 | AAPL | Stock | 3.2125 | 3.2143 | 3.2114 | 3.2114 | 166600.0 |
| 2006-11-24 08:09:00 | AAPL | Stock | 3.2118 | 3.2132 | 3.2114 | 3.2132 | 33600.0 |
| 2006-11-24 08:10:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 33600.0 |
| 2006-11-24 08:11:00 | AAPL | Stock | 3.2143 | 3.2154 | 3.2143 | 3.2154 | 152180.0 |
| 2006-11-24 08:12:00 | AAPL | Stock | 3.2154 | 3.2154 | 3.2143 | 3.2143 | 88256.0 |
| 2006-11-24 08:13:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2139 | 3.2139 | 70364.0 |
| 2006-11-24 08:14:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 11200.0 |
| 2006-11-24 08:15:00 | AAPL | Stock | 3.2136 | 3.2154 | 3.2136 | 3.2154 | 65492.0 |
| 2006-11-24 08:16:00 | AAPL | Stock | 3.2179 | 3.2182 | 3.2161 | 3.2161 | 103600.0 |
| 2006-11-24 08:19:00 | AAPL | Stock | 3.2164 | 3.2164 | 3.2161 | 3.2161 | 46200.0 |
| 2006-11-24 08:21:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 11200.0 |
| 2006-11-24 08:22:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 2800.0 |
| 2006-11-24 08:24:00 | AAPL | Stock | 3.215 | 3.215 | 3.215 | 3.215 | 8400.0 |
| 2006-11-24 08:27:00 | AAPL | Stock | 3.2132 | 3.2143 | 3.2132 | 3.2136 | 43400.0 |
| 2006-11-24 08:30:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2129 | 3.2129 | 30492.0 |
| 2006-11-24 08:33:00 | AAPL | Stock | 3.2132 | 3.2132 | 3.2125 | 3.2125 | 61908.0 |
| 2006-11-24 08:34:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.2118 | 3.2118 | 49308.0 |
| 2006-11-24 08:35:00 | AAPL | Stock | 3.2118 | 3.2143 | 3.2118 | 3.2143 | 42308.0 |
| 2006-11-24 08:37:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2107 | 3.2107 | 134400.0 |
| 2006-11-24 08:38:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2107 | 3.2107 | 9044.0 |
| 2006-11-24 08:39:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2104 | 3.2104 | 29232.0 |
| 2006-11-24 08:40:00 | AAPL | Stock | 3.2104 | 3.2107 | 3.2104 | 3.2107 | 123060.0 |
| 2006-11-24 08:41:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2089 | 3.2089 | 169960.0 |
| 2006-11-24 08:42:00 | AAPL | Stock | 3.2086 | 3.2089 | 3.2086 | 3.2089 | 108360.0 |
| 2006-11-24 08:44:00 | AAPL | Stock | 3.2093 | 3.2093 | 3.2093 | 3.2093 | 5600.0 |
| 2006-11-24 08:45:00 | AAPL | Stock | 3.2096 | 3.2107 | 3.2096 | 3.2107 | 23800.0 |
| 2006-11-24 08:46:00 | AAPL | Stock | 3.2107 | 3.2118 | 3.2107 | 3.2118 | 64764.0 |
| 2006-11-24 08:47:00 | AAPL | Stock | 3.2118 | 3.2118 | 3.2107 | 3.2107 | 12600.0 |
| 2006-11-24 08:48:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.21 | 3.21 | 37072.0 |
> showing 50 of 344,797 rows — these rows as CSV