PREVIEW / stock_1min / 2009-01-12
file: by_date/stock_1min/2009/2009-01-12.parquet size: 12.0 MB rows: 932,374 symbols: 2,682
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-12 04:47:00 | AAPL | Stock | 3.235 | 3.235 | 3.235 | 3.235 | 5600.0 |
| 2009-01-12 08:00:00 | AAPL | Stock | 3.2321 | 3.235 | 3.2321 | 3.235 | 24864.0 |
| 2009-01-12 08:04:00 | AAPL | Stock | 3.2461 | 3.2496 | 3.2461 | 3.2496 | 21560.0 |
| 2009-01-12 08:06:00 | AAPL | Stock | 3.2375 | 3.2375 | 3.2321 | 3.2321 | 5600.0 |
| 2009-01-12 08:10:00 | AAPL | Stock | 3.2257 | 3.2257 | 3.2257 | 3.2257 | 7000.0 |
| 2009-01-12 08:11:00 | AAPL | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 7840.0 |
| 2009-01-12 08:12:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2229 | 3.2229 | 4760.0 |
| 2009-01-12 08:15:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 17640.0 |
| 2009-01-12 08:17:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2196 | 3.2196 | 18844.0 |
| 2009-01-12 08:18:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 10444.0 |
| 2009-01-12 08:19:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 16800.0 |
| 2009-01-12 08:24:00 | AAPL | Stock | 3.2264 | 3.2268 | 3.2264 | 3.2268 | 5600.0 |
| 2009-01-12 08:26:00 | AAPL | Stock | 3.2268 | 3.2268 | 3.2268 | 3.2268 | 19600.0 |
| 2009-01-12 08:32:00 | AAPL | Stock | 3.225 | 3.2268 | 3.225 | 3.2268 | 5600.0 |
| 2009-01-12 08:33:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 8400.0 |
| 2009-01-12 08:34:00 | AAPL | Stock | 3.2286 | 3.2318 | 3.2286 | 3.2318 | 51800.0 |
| 2009-01-12 08:35:00 | AAPL | Stock | 3.2311 | 3.2321 | 3.2311 | 3.2321 | 28000.0 |
| 2009-01-12 08:36:00 | AAPL | Stock | 3.2304 | 3.2371 | 3.2304 | 3.2368 | 53480.0 |
| 2009-01-12 08:38:00 | AAPL | Stock | 3.2318 | 3.2318 | 3.2286 | 3.2307 | 146860.0 |
| 2009-01-12 08:39:00 | AAPL | Stock | 3.2307 | 3.2307 | 3.2307 | 3.2307 | 20524.0 |
| 2009-01-12 08:40:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2268 | 3.2268 | 48384.0 |
| 2009-01-12 08:41:00 | AAPL | Stock | 3.2243 | 3.2243 | 3.2243 | 3.2243 | 5600.0 |
| 2009-01-12 08:46:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 16800.0 |
| 2009-01-12 08:47:00 | AAPL | Stock | 3.2304 | 3.2325 | 3.2304 | 3.2325 | 28000.0 |
| 2009-01-12 08:49:00 | AAPL | Stock | 3.2304 | 3.2311 | 3.2289 | 3.2289 | 57400.0 |
| 2009-01-12 08:50:00 | AAPL | Stock | 3.2286 | 3.2296 | 3.2286 | 3.2289 | 54600.0 |
| 2009-01-12 08:51:00 | AAPL | Stock | 3.2293 | 3.2293 | 3.2286 | 3.2286 | 67200.0 |
| 2009-01-12 08:52:00 | AAPL | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 2800.0 |
| 2009-01-12 08:54:00 | AAPL | Stock | 3.2236 | 3.2236 | 3.2236 | 3.2236 | 5600.0 |
| 2009-01-12 08:55:00 | AAPL | Stock | 3.2268 | 3.2268 | 3.2232 | 3.2232 | 41440.0 |
| 2009-01-12 08:56:00 | AAPL | Stock | 3.2239 | 3.2239 | 3.2239 | 3.2239 | 2800.0 |
| 2009-01-12 08:57:00 | AAPL | Stock | 3.2243 | 3.2243 | 3.2243 | 3.2243 | 6160.0 |
| 2009-01-12 09:01:00 | AAPL | Stock | 3.2268 | 3.2268 | 3.2268 | 3.2268 | 4200.0 |
| 2009-01-12 09:02:00 | AAPL | Stock | 3.2243 | 3.225 | 3.2243 | 3.225 | 8400.0 |
| 2009-01-12 09:04:00 | AAPL | Stock | 3.2246 | 3.2246 | 3.2243 | 3.2243 | 14000.0 |
| 2009-01-12 09:05:00 | AAPL | Stock | 3.2243 | 3.2243 | 3.2239 | 3.2239 | 36400.0 |
| 2009-01-12 09:06:00 | AAPL | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 2800.0 |
| 2009-01-12 09:07:00 | AAPL | Stock | 3.225 | 3.2268 | 3.225 | 3.2257 | 25900.0 |
| 2009-01-12 09:08:00 | AAPL | Stock | 3.2264 | 3.2268 | 3.2254 | 3.2254 | 22400.0 |
| 2009-01-12 09:09:00 | AAPL | Stock | 3.2254 | 3.2257 | 3.2254 | 3.2257 | 16800.0 |
| 2009-01-12 09:10:00 | AAPL | Stock | 3.2254 | 3.2254 | 3.225 | 3.225 | 14000.0 |
| 2009-01-12 09:13:00 | AAPL | Stock | 3.2264 | 3.2264 | 3.2257 | 3.2257 | 11200.0 |
| 2009-01-12 09:15:00 | AAPL | Stock | 3.2275 | 3.2286 | 3.2275 | 3.2286 | 14000.0 |
| 2009-01-12 09:18:00 | AAPL | Stock | 3.2286 | 3.2329 | 3.2286 | 3.2329 | 75600.0 |
| 2009-01-12 09:19:00 | AAPL | Stock | 3.2318 | 3.2318 | 3.2314 | 3.2314 | 5600.0 |
| 2009-01-12 09:20:00 | AAPL | Stock | 3.2321 | 3.2336 | 3.2321 | 3.2336 | 35840.0 |
| 2009-01-12 09:21:00 | AAPL | Stock | 3.235 | 3.2357 | 3.235 | 3.2357 | 19600.0 |
| 2009-01-12 09:22:00 | AAPL | Stock | 3.2361 | 3.2393 | 3.2361 | 3.2393 | 36400.0 |
| 2009-01-12 09:23:00 | AAPL | Stock | 3.2379 | 3.2379 | 3.2379 | 3.2379 | 2800.0 |
| 2009-01-12 09:25:00 | AAPL | Stock | 3.2386 | 3.2386 | 3.2386 | 3.2386 | 5600.0 |
> showing 50 of 932,374 rows — these rows as CSV