PREVIEW / stock_1min / 2008-12-05
file: by_date/stock_1min/2008/2008-12-05.parquet size: 12.5 MB rows: 991,306 symbols: 2,698
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-05 04:27:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 04:35:00 | AAPL | Stock | 3.2714 | 3.2714 | 3.2714 | 3.2714 | 2800.0 |
| 2008-12-05 05:52:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 07:29:00 | AAPL | Stock | 3.2429 | 3.2429 | 3.2429 | 3.2429 | 2800.0 |
| 2008-12-05 07:39:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 14000.0 |
| 2008-12-05 07:52:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 2800.0 |
| 2008-12-05 07:58:00 | AAPL | Stock | 3.2411 | 3.2411 | 3.2411 | 3.2411 | 2800.0 |
| 2008-12-05 08:00:00 | AAPL | Stock | 3.2321 | 3.2411 | 3.2321 | 3.2411 | 22260.0 |
| 2008-12-05 08:01:00 | AAPL | Stock | 3.2321 | 3.2357 | 3.2321 | 3.2357 | 8400.0 |
| 2008-12-05 08:02:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 2800.0 |
| 2008-12-05 08:03:00 | AAPL | Stock | 3.2329 | 3.2329 | 3.2329 | 3.2329 | 2800.0 |
| 2008-12-05 08:04:00 | AAPL | Stock | 3.2321 | 3.2325 | 3.2304 | 3.2304 | 152320.0 |
| 2008-12-05 08:05:00 | AAPL | Stock | 3.2293 | 3.2293 | 3.2286 | 3.2286 | 101136.0 |
| 2008-12-05 08:06:00 | AAPL | Stock | 3.2293 | 3.2321 | 3.2286 | 3.2286 | 29372.0 |
| 2008-12-05 08:07:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 2800.0 |
| 2008-12-05 08:08:00 | AAPL | Stock | 3.2289 | 3.2289 | 3.2289 | 3.2289 | 2800.0 |
| 2008-12-05 08:09:00 | AAPL | Stock | 3.2289 | 3.2314 | 3.2286 | 3.2314 | 16800.0 |
| 2008-12-05 08:11:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2268 | 3.2268 | 5600.0 |
| 2008-12-05 08:12:00 | AAPL | Stock | 3.2232 | 3.2236 | 3.2214 | 3.2214 | 23380.0 |
| 2008-12-05 08:13:00 | AAPL | Stock | 3.2229 | 3.225 | 3.2229 | 3.225 | 16800.0 |
| 2008-12-05 08:16:00 | AAPL | Stock | 3.225 | 3.2279 | 3.225 | 3.2279 | 28000.0 |
| 2008-12-05 08:17:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 5600.0 |
| 2008-12-05 08:18:00 | AAPL | Stock | 3.2275 | 3.2275 | 3.2179 | 3.2225 | 283920.0 |
| 2008-12-05 08:20:00 | AAPL | Stock | 3.2232 | 3.2236 | 3.2232 | 3.2236 | 58800.0 |
| 2008-12-05 08:21:00 | AAPL | Stock | 3.2236 | 3.2236 | 3.2214 | 3.2232 | 80080.0 |
| 2008-12-05 08:23:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 8400.0 |
| 2008-12-05 08:24:00 | AAPL | Stock | 3.2282 | 3.2282 | 3.2282 | 3.2282 | 2800.0 |
| 2008-12-05 08:25:00 | AAPL | Stock | 3.2293 | 3.2393 | 3.2293 | 3.2393 | 23828.0 |
| 2008-12-05 08:26:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2382 | 3.2386 | 72996.0 |
| 2008-12-05 08:27:00 | AAPL | Stock | 3.2386 | 3.2393 | 3.2386 | 3.2386 | 54600.0 |
| 2008-12-05 08:28:00 | AAPL | Stock | 3.2386 | 3.2396 | 3.2321 | 3.2321 | 51520.0 |
| 2008-12-05 08:29:00 | AAPL | Stock | 3.2375 | 3.2404 | 3.2375 | 3.2404 | 46900.0 |
| 2008-12-05 08:30:00 | AAPL | Stock | 3.2404 | 3.2404 | 3.1961 | 3.2075 | 2374288.0 |
| 2008-12-05 08:31:00 | AAPL | Stock | 3.2082 | 3.2157 | 3.2075 | 3.2143 | 180740.0 |
| 2008-12-05 08:32:00 | AAPL | Stock | 3.2157 | 3.2321 | 3.2154 | 3.2232 | 160076.0 |
| 2008-12-05 08:33:00 | AAPL | Stock | 3.2307 | 3.2314 | 3.2232 | 3.2236 | 217924.0 |
| 2008-12-05 08:34:00 | AAPL | Stock | 3.23 | 3.2325 | 3.2279 | 3.2311 | 54600.0 |
| 2008-12-05 08:35:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2232 | 3.2232 | 67200.0 |
| 2008-12-05 08:36:00 | AAPL | Stock | 3.2229 | 3.2246 | 3.2196 | 3.2239 | 203224.0 |
| 2008-12-05 08:37:00 | AAPL | Stock | 3.2193 | 3.2193 | 3.2179 | 3.2186 | 72604.0 |
| 2008-12-05 08:38:00 | AAPL | Stock | 3.2179 | 3.2182 | 3.2079 | 3.21 | 354396.0 |
| 2008-12-05 08:39:00 | AAPL | Stock | 3.2096 | 3.2196 | 3.2096 | 3.2196 | 59332.0 |
| 2008-12-05 08:40:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2146 | 3.2146 | 6720.0 |
| 2008-12-05 08:41:00 | AAPL | Stock | 3.2146 | 3.2179 | 3.2143 | 3.2143 | 98000.0 |
| 2008-12-05 08:42:00 | AAPL | Stock | 3.2132 | 3.2143 | 3.2075 | 3.2075 | 150360.0 |
| 2008-12-05 08:43:00 | AAPL | Stock | 3.2079 | 3.2086 | 3.2079 | 3.2086 | 19600.0 |
| 2008-12-05 08:44:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2075 | 3.2075 | 107800.0 |
| 2008-12-05 08:45:00 | AAPL | Stock | 3.2107 | 3.2157 | 3.2107 | 3.2143 | 119980.0 |
| 2008-12-05 08:46:00 | AAPL | Stock | 3.2114 | 3.2189 | 3.2114 | 3.2189 | 31780.0 |
| 2008-12-05 08:47:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2143 | 3.2143 | 118440.0 |
> showing 50 of 991,306 rows — these rows as CSV