PREVIEW / stock_1min / 2009-01-08
file: by_date/stock_1min/2009/2009-01-08.parquet size: 12.0 MB rows: 936,261 symbols: 2,670
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-08 07:24:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 4760.0 |
| 2009-01-08 07:28:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 7000.0 |
| 2009-01-08 07:36:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 2800.0 |
| 2009-01-08 07:46:00 | AAPL | Stock | 3.2164 | 3.2164 | 3.2164 | 3.2164 | 9800.0 |
| 2009-01-08 07:51:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 12292.0 |
| 2009-01-08 07:58:00 | AAPL | Stock | 3.2282 | 3.2282 | 3.2282 | 3.2282 | 2800.0 |
| 2009-01-08 08:00:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2143 | 3.2154 | 188664.0 |
| 2009-01-08 08:01:00 | AAPL | Stock | 3.2143 | 3.2146 | 3.2143 | 3.2143 | 82796.0 |
| 2009-01-08 08:03:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2157 | 3.2157 | 27440.0 |
| 2009-01-08 08:04:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 5600.0 |
| 2009-01-08 08:05:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 5600.0 |
| 2009-01-08 08:06:00 | AAPL | Stock | 3.2232 | 3.2296 | 3.2232 | 3.2296 | 14000.0 |
| 2009-01-08 08:07:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2161 | 3.2164 | 23884.0 |
| 2009-01-08 08:08:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2161 | 3.2161 | 61348.0 |
| 2009-01-08 08:10:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 16632.0 |
| 2009-01-08 08:11:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 2800.0 |
| 2009-01-08 08:12:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 5600.0 |
| 2009-01-08 08:13:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 7000.0 |
| 2009-01-08 08:15:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 5600.0 |
| 2009-01-08 08:16:00 | AAPL | Stock | 3.22 | 3.22 | 3.22 | 3.22 | 18900.0 |
| 2009-01-08 08:17:00 | AAPL | Stock | 3.22 | 3.22 | 3.22 | 3.22 | 2800.0 |
| 2009-01-08 08:19:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.22 | 3.22 | 37800.0 |
| 2009-01-08 08:20:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2182 | 3.2186 | 20272.0 |
| 2009-01-08 08:21:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2164 | 3.2164 | 49000.0 |
| 2009-01-08 08:22:00 | AAPL | Stock | 3.2161 | 3.2179 | 3.2161 | 3.2179 | 33600.0 |
| 2009-01-08 08:23:00 | AAPL | Stock | 3.2164 | 3.2179 | 3.2164 | 3.2179 | 42812.0 |
| 2009-01-08 08:24:00 | AAPL | Stock | 3.2175 | 3.2179 | 3.2171 | 3.2179 | 19600.0 |
| 2009-01-08 08:25:00 | AAPL | Stock | 3.2175 | 3.2204 | 3.2164 | 3.2204 | 42420.0 |
| 2009-01-08 08:26:00 | AAPL | Stock | 3.2193 | 3.2196 | 3.2168 | 3.2196 | 54740.0 |
| 2009-01-08 08:27:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2189 | 3.2189 | 19600.0 |
| 2009-01-08 08:28:00 | AAPL | Stock | 3.2171 | 3.2175 | 3.2164 | 3.2164 | 21392.0 |
| 2009-01-08 08:29:00 | AAPL | Stock | 3.2175 | 3.2175 | 3.2157 | 3.2157 | 89572.0 |
| 2009-01-08 08:30:00 | AAPL | Stock | 3.2168 | 3.2196 | 3.2168 | 3.2196 | 125580.0 |
| 2009-01-08 08:31:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 3920.0 |
| 2009-01-08 08:32:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2168 | 3.2168 | 22400.0 |
| 2009-01-08 08:33:00 | AAPL | Stock | 3.2193 | 3.2207 | 3.2175 | 3.2175 | 14000.0 |
| 2009-01-08 08:35:00 | AAPL | Stock | 3.2211 | 3.2211 | 3.2204 | 3.2207 | 23100.0 |
| 2009-01-08 08:36:00 | AAPL | Stock | 3.2193 | 3.2196 | 3.2179 | 3.2196 | 18200.0 |
| 2009-01-08 08:37:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2179 | 3.2179 | 5600.0 |
| 2009-01-08 08:38:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 33180.0 |
| 2009-01-08 08:41:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 5600.0 |
| 2009-01-08 08:44:00 | AAPL | Stock | 3.2196 | 3.2204 | 3.2196 | 3.2204 | 8400.0 |
| 2009-01-08 08:46:00 | AAPL | Stock | 3.2196 | 3.2221 | 3.2196 | 3.2221 | 54432.0 |
| 2009-01-08 08:47:00 | AAPL | Stock | 3.2229 | 3.2286 | 3.2229 | 3.2264 | 90160.0 |
| 2009-01-08 08:48:00 | AAPL | Stock | 3.2261 | 3.2268 | 3.2261 | 3.2261 | 8400.0 |
| 2009-01-08 08:49:00 | AAPL | Stock | 3.23 | 3.2318 | 3.2293 | 3.2293 | 32200.0 |
| 2009-01-08 08:50:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2286 | 3.2286 | 16800.0 |
| 2009-01-08 08:51:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2268 | 3.2268 | 77000.0 |
| 2009-01-08 08:52:00 | AAPL | Stock | 3.2232 | 3.2239 | 3.2232 | 3.2239 | 13832.0 |
| 2009-01-08 08:53:00 | AAPL | Stock | 3.2279 | 3.2293 | 3.2279 | 3.2293 | 14000.0 |
> showing 50 of 936,261 rows — these rows as CSV