PREVIEW / stock_1min / 2008-08-20
file: by_date/stock_1min/2008/2008-08-20.parquet size: 11.8 MB rows: 953,698 symbols: 2,687
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-08-20 07:00:00 | AAPL | Stock | 6.2779 | 6.2779 | 6.2779 | 6.2779 | 8400.0 |
| 2008-08-20 07:01:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 11200.0 |
| 2008-08-20 07:38:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 5600.0 |
| 2008-08-20 07:41:00 | AAPL | Stock | 6.2343 | 6.2343 | 6.2343 | 6.2343 | 2800.0 |
| 2008-08-20 07:42:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2393 | 6.2393 | 2800.0 |
| 2008-08-20 07:48:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.25 | 6.25 | 8400.0 |
| 2008-08-20 07:49:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 16800.0 |
| 2008-08-20 07:58:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.2518 | 6.2518 | 5600.0 |
| 2008-08-20 07:59:00 | AAPL | Stock | 6.2507 | 6.2507 | 6.25 | 6.2507 | 17500.0 |
| 2008-08-20 08:00:00 | AAPL | Stock | 6.2507 | 6.2507 | 6.24 | 6.2407 | 66808.0 |
| 2008-08-20 08:01:00 | AAPL | Stock | 6.2429 | 6.2457 | 6.2411 | 6.2457 | 77252.0 |
| 2008-08-20 08:02:00 | AAPL | Stock | 6.2461 | 6.2461 | 6.2396 | 6.2411 | 67200.0 |
| 2008-08-20 08:03:00 | AAPL | Stock | 6.2396 | 6.2404 | 6.2339 | 6.2375 | 106456.0 |
| 2008-08-20 08:04:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2336 | 6.2346 | 28140.0 |
| 2008-08-20 08:05:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2375 | 6.2375 | 33740.0 |
| 2008-08-20 08:06:00 | AAPL | Stock | 6.2375 | 6.2393 | 6.2375 | 6.2393 | 64400.0 |
| 2008-08-20 08:07:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2375 | 6.2375 | 14000.0 |
| 2008-08-20 08:09:00 | AAPL | Stock | 6.2382 | 6.2382 | 6.2382 | 6.2382 | 5040.0 |
| 2008-08-20 08:10:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2339 | 6.2339 | 30800.0 |
| 2008-08-20 08:11:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 2800.0 |
| 2008-08-20 08:12:00 | AAPL | Stock | 6.2311 | 6.2321 | 6.2268 | 6.2268 | 37800.0 |
| 2008-08-20 08:13:00 | AAPL | Stock | 6.2311 | 6.2314 | 6.2268 | 6.2268 | 28000.0 |
| 2008-08-20 08:14:00 | AAPL | Stock | 6.2314 | 6.2314 | 6.2286 | 6.2311 | 10080.0 |
| 2008-08-20 08:15:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2268 | 6.2268 | 14000.0 |
| 2008-08-20 08:16:00 | AAPL | Stock | 6.2268 | 6.2307 | 6.2268 | 6.2271 | 49000.0 |
| 2008-08-20 08:17:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2268 | 6.2268 | 7000.0 |
| 2008-08-20 08:18:00 | AAPL | Stock | 6.2271 | 6.2271 | 6.225 | 6.2271 | 35700.0 |
| 2008-08-20 08:20:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2268 | 6.2268 | 2800.0 |
| 2008-08-20 08:21:00 | AAPL | Stock | 6.2271 | 6.2271 | 6.2271 | 6.2271 | 7000.0 |
| 2008-08-20 08:22:00 | AAPL | Stock | 6.2271 | 6.2271 | 6.2271 | 6.2271 | 2800.0 |
| 2008-08-20 08:24:00 | AAPL | Stock | 6.2271 | 6.2286 | 6.2271 | 6.2286 | 41020.0 |
| 2008-08-20 08:28:00 | AAPL | Stock | 6.2286 | 6.2321 | 6.2286 | 6.2307 | 21000.0 |
| 2008-08-20 08:30:00 | AAPL | Stock | 6.2293 | 6.2293 | 6.2293 | 6.2293 | 19600.0 |
| 2008-08-20 08:31:00 | AAPL | Stock | 6.2293 | 6.2321 | 6.2293 | 6.2293 | 21000.0 |
| 2008-08-20 08:32:00 | AAPL | Stock | 6.2282 | 6.2282 | 6.2271 | 6.2271 | 22400.0 |
| 2008-08-20 08:33:00 | AAPL | Stock | 6.2257 | 6.2257 | 6.2257 | 6.2257 | 8400.0 |
| 2008-08-20 08:36:00 | AAPL | Stock | 6.2282 | 6.2282 | 6.2282 | 6.2282 | 5600.0 |
| 2008-08-20 08:37:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2268 | 6.2268 | 2800.0 |
| 2008-08-20 08:38:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 14000.0 |
| 2008-08-20 08:39:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2268 | 6.2268 | 6300.0 |
| 2008-08-20 08:40:00 | AAPL | Stock | 6.2282 | 6.2304 | 6.2282 | 6.2304 | 26600.0 |
| 2008-08-20 08:41:00 | AAPL | Stock | 6.2307 | 6.2321 | 6.2304 | 6.2321 | 72940.0 |
| 2008-08-20 08:42:00 | AAPL | Stock | 6.2336 | 6.2336 | 6.2336 | 6.2336 | 33600.0 |
| 2008-08-20 08:43:00 | AAPL | Stock | 6.2339 | 6.2407 | 6.2339 | 6.2407 | 43568.0 |
| 2008-08-20 08:44:00 | AAPL | Stock | 6.2404 | 6.2411 | 6.24 | 6.2407 | 70000.0 |
| 2008-08-20 08:45:00 | AAPL | Stock | 6.2407 | 6.2407 | 6.24 | 6.24 | 42000.0 |
| 2008-08-20 08:46:00 | AAPL | Stock | 6.2393 | 6.2396 | 6.2379 | 6.2379 | 42000.0 |
| 2008-08-20 08:47:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2368 | 6.2368 | 20300.0 |
| 2008-08-20 08:48:00 | AAPL | Stock | 6.2364 | 6.2364 | 6.2364 | 6.2364 | 33600.0 |
| 2008-08-20 08:49:00 | AAPL | Stock | 6.2354 | 6.2361 | 6.2339 | 6.235 | 30800.0 |
> showing 50 of 953,698 rows — these rows as CSV