PREVIEW / stock_1min / 2008-04-14
file: by_date/stock_1min/2008/2008-04-14.parquet size: 11.6 MB rows: 951,067 symbols: 2,701
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-04-14 06:19:00 | AAPL | Stock | 5.2418 | 5.2418 | 5.2418 | 5.2418 | 18900.0 |
| 2008-04-14 06:25:00 | AAPL | Stock | 5.2536 | 5.2721 | 5.2536 | 5.2721 | 16800.0 |
| 2008-04-14 06:50:00 | AAPL | Stock | 5.2386 | 5.2386 | 5.2386 | 5.2386 | 2800.0 |
| 2008-04-14 07:02:00 | AAPL | Stock | 5.23 | 5.23 | 5.23 | 5.23 | 11900.0 |
| 2008-04-14 07:21:00 | AAPL | Stock | 5.2475 | 5.2475 | 5.2475 | 5.2475 | 2800.0 |
| 2008-04-14 07:24:00 | AAPL | Stock | 5.2339 | 5.2339 | 5.2321 | 5.2321 | 42000.0 |
| 2008-04-14 07:25:00 | AAPL | Stock | 5.2329 | 5.2329 | 5.2329 | 5.2329 | 2800.0 |
| 2008-04-14 07:26:00 | AAPL | Stock | 5.2329 | 5.2329 | 5.2329 | 5.2329 | 5600.0 |
| 2008-04-14 07:27:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2464 | 5.2464 | 2800.0 |
| 2008-04-14 07:33:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2329 | 5.2329 | 5600.0 |
| 2008-04-14 07:45:00 | AAPL | Stock | 5.2332 | 5.2332 | 5.2332 | 5.2332 | 2800.0 |
| 2008-04-14 07:46:00 | AAPL | Stock | 5.2336 | 5.2336 | 5.2336 | 5.2336 | 6580.0 |
| 2008-04-14 07:47:00 | AAPL | Stock | 5.2336 | 5.2336 | 5.2336 | 5.2336 | 5600.0 |
| 2008-04-14 07:48:00 | AAPL | Stock | 5.2271 | 5.2271 | 5.2271 | 5.2271 | 8400.0 |
| 2008-04-14 07:49:00 | AAPL | Stock | 5.2271 | 5.2271 | 5.2271 | 5.2271 | 10920.0 |
| 2008-04-14 07:51:00 | AAPL | Stock | 5.2275 | 5.2275 | 5.2271 | 5.2271 | 16800.0 |
| 2008-04-14 07:56:00 | AAPL | Stock | 5.2236 | 5.2236 | 5.2236 | 5.2236 | 6916.0 |
| 2008-04-14 07:58:00 | AAPL | Stock | 5.2236 | 5.2236 | 5.2236 | 5.2236 | 15484.0 |
| 2008-04-14 07:59:00 | AAPL | Stock | 5.2304 | 5.2321 | 5.2304 | 5.2321 | 28000.0 |
| 2008-04-14 08:00:00 | AAPL | Stock | 5.2289 | 5.2314 | 5.2204 | 5.2275 | 135716.0 |
| 2008-04-14 08:01:00 | AAPL | Stock | 5.2279 | 5.2289 | 5.2279 | 5.2289 | 42000.0 |
| 2008-04-14 08:02:00 | AAPL | Stock | 5.2232 | 5.2236 | 5.2232 | 5.2236 | 24500.0 |
| 2008-04-14 08:03:00 | AAPL | Stock | 5.225 | 5.225 | 5.2214 | 5.225 | 37800.0 |
| 2008-04-14 08:04:00 | AAPL | Stock | 5.2204 | 5.2211 | 5.2143 | 5.2204 | 72800.0 |
| 2008-04-14 08:05:00 | AAPL | Stock | 5.2204 | 5.2214 | 5.2168 | 5.2214 | 36400.0 |
| 2008-04-14 08:06:00 | AAPL | Stock | 5.2204 | 5.2204 | 5.2179 | 5.2179 | 28000.0 |
| 2008-04-14 08:07:00 | AAPL | Stock | 5.2154 | 5.2157 | 5.21 | 5.2143 | 93660.0 |
| 2008-04-14 08:08:00 | AAPL | Stock | 5.2139 | 5.2139 | 5.2075 | 5.2104 | 108864.0 |
| 2008-04-14 08:09:00 | AAPL | Stock | 5.21 | 5.2104 | 5.2089 | 5.2089 | 67368.0 |
| 2008-04-14 08:10:00 | AAPL | Stock | 5.2089 | 5.2089 | 5.2054 | 5.2071 | 120596.0 |
| 2008-04-14 08:11:00 | AAPL | Stock | 5.2089 | 5.2104 | 5.2064 | 5.2071 | 53452.0 |
| 2008-04-14 08:12:00 | AAPL | Stock | 5.2089 | 5.2089 | 5.2089 | 5.2089 | 8400.0 |
| 2008-04-14 08:13:00 | AAPL | Stock | 5.2089 | 5.2107 | 5.2086 | 5.2107 | 128100.0 |
| 2008-04-14 08:14:00 | AAPL | Stock | 5.2107 | 5.2129 | 5.2071 | 5.2071 | 47600.0 |
| 2008-04-14 08:15:00 | AAPL | Stock | 5.21 | 5.21 | 5.21 | 5.21 | 3696.0 |
| 2008-04-14 08:16:00 | AAPL | Stock | 5.2107 | 5.2114 | 5.2093 | 5.2093 | 28000.0 |
| 2008-04-14 08:18:00 | AAPL | Stock | 5.2107 | 5.2107 | 5.2107 | 5.2107 | 5600.0 |
| 2008-04-14 08:20:00 | AAPL | Stock | 5.2107 | 5.2107 | 5.2071 | 5.2071 | 73976.0 |
| 2008-04-14 08:21:00 | AAPL | Stock | 5.2089 | 5.2107 | 5.2089 | 5.2107 | 29400.0 |
| 2008-04-14 08:24:00 | AAPL | Stock | 5.2107 | 5.2107 | 5.2104 | 5.2104 | 15960.0 |
| 2008-04-14 08:25:00 | AAPL | Stock | 5.2079 | 5.2089 | 5.2025 | 5.2025 | 158480.0 |
| 2008-04-14 08:26:00 | AAPL | Stock | 5.2036 | 5.2075 | 5.1989 | 5.1989 | 13748.0 |
| 2008-04-14 08:27:00 | AAPL | Stock | 5.2025 | 5.2071 | 5.2025 | 5.2071 | 8400.0 |
| 2008-04-14 08:28:00 | AAPL | Stock | 5.2054 | 5.2079 | 5.2054 | 5.2054 | 31360.0 |
| 2008-04-14 08:29:00 | AAPL | Stock | 5.2068 | 5.2071 | 5.2068 | 5.2071 | 26544.0 |
| 2008-04-14 08:30:00 | AAPL | Stock | 5.2068 | 5.2286 | 5.2054 | 5.2221 | 411292.0 |
| 2008-04-14 08:31:00 | AAPL | Stock | 5.2218 | 5.2275 | 5.2189 | 5.2275 | 104580.0 |
| 2008-04-14 08:32:00 | AAPL | Stock | 5.2271 | 5.2271 | 5.2214 | 5.2214 | 61600.0 |
| 2008-04-14 08:33:00 | AAPL | Stock | 5.2218 | 5.2232 | 5.2196 | 5.2214 | 86268.0 |
| 2008-04-14 08:34:00 | AAPL | Stock | 5.2214 | 5.2214 | 5.2182 | 5.2193 | 39340.0 |
> showing 50 of 951,067 rows — these rows as CSV