PREVIEW / stock_1min / 2008-08-21
file: by_date/stock_1min/2008/2008-08-21.parquet size: 11.5 MB rows: 936,567 symbols: 2,679
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-21 04:42:00 | AAPL | Stock | 6.2504 | 6.2504 | 6.2504 | 6.2504 | 5600.0 |
| 2008-08-21 05:58:00 | AAPL | Stock | 6.2236 | 6.2236 | 6.2236 | 6.2236 | 19600.0 |
| 2008-08-21 07:34:00 | AAPL | Stock | 6.2711 | 6.2711 | 6.2711 | 6.2711 | 4200.0 |
| 2008-08-21 07:37:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 11200.0 |
| 2008-08-21 07:52:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2393 | 6.2393 | 28000.0 |
| 2008-08-21 07:55:00 | AAPL | Stock | 6.2393 | 6.2396 | 6.2393 | 6.2396 | 5600.0 |
| 2008-08-21 07:58:00 | AAPL | Stock | 6.2396 | 6.2396 | 6.2396 | 6.2396 | 2800.0 |
| 2008-08-21 08:00:00 | AAPL | Stock | 6.2482 | 6.25 | 6.2464 | 6.2464 | 97160.0 |
| 2008-08-21 08:01:00 | AAPL | Stock | 6.2489 | 6.2489 | 6.2475 | 6.2475 | 28000.0 |
| 2008-08-21 08:02:00 | AAPL | Stock | 6.2475 | 6.25 | 6.2411 | 6.2411 | 20496.0 |
| 2008-08-21 08:04:00 | AAPL | Stock | 6.2404 | 6.2404 | 6.2404 | 6.2404 | 5600.0 |
| 2008-08-21 08:05:00 | AAPL | Stock | 6.2396 | 6.2396 | 6.2396 | 6.2396 | 4620.0 |
| 2008-08-21 08:06:00 | AAPL | Stock | 6.2429 | 6.2432 | 6.2429 | 6.2429 | 8400.0 |
| 2008-08-21 08:07:00 | AAPL | Stock | 6.2471 | 6.2475 | 6.2429 | 6.2429 | 44800.0 |
| 2008-08-21 08:08:00 | AAPL | Stock | 6.2464 | 6.2482 | 6.2464 | 6.2482 | 22400.0 |
| 2008-08-21 08:09:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 27944.0 |
| 2008-08-21 08:10:00 | AAPL | Stock | 6.2507 | 6.2511 | 6.25 | 6.2511 | 28000.0 |
| 2008-08-21 08:11:00 | AAPL | Stock | 6.2554 | 6.2554 | 6.25 | 6.2511 | 84000.0 |
| 2008-08-21 08:12:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 2800.0 |
| 2008-08-21 08:13:00 | AAPL | Stock | 6.25 | 6.2511 | 6.25 | 6.2511 | 33600.0 |
| 2008-08-21 08:14:00 | AAPL | Stock | 6.2504 | 6.2568 | 6.25 | 6.2568 | 11200.0 |
| 2008-08-21 08:16:00 | AAPL | Stock | 6.2511 | 6.2511 | 6.2464 | 6.2464 | 24444.0 |
| 2008-08-21 08:18:00 | AAPL | Stock | 6.24 | 6.24 | 6.24 | 6.24 | 2800.0 |
| 2008-08-21 08:19:00 | AAPL | Stock | 6.24 | 6.24 | 6.24 | 6.24 | 2800.0 |
| 2008-08-21 08:24:00 | AAPL | Stock | 6.2521 | 6.2521 | 6.2521 | 6.2521 | 5600.0 |
| 2008-08-21 08:29:00 | AAPL | Stock | 6.2514 | 6.2532 | 6.2457 | 6.2457 | 61600.0 |
| 2008-08-21 08:30:00 | AAPL | Stock | 6.245 | 6.2614 | 6.2439 | 6.2482 | 82600.0 |
| 2008-08-21 08:31:00 | AAPL | Stock | 6.2482 | 6.2504 | 6.2461 | 6.25 | 56000.0 |
| 2008-08-21 08:32:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 2800.0 |
| 2008-08-21 08:34:00 | AAPL | Stock | 6.2471 | 6.2471 | 6.2446 | 6.2446 | 11200.0 |
| 2008-08-21 08:35:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2411 | 6.2425 | 84028.0 |
| 2008-08-21 08:36:00 | AAPL | Stock | 6.2446 | 6.2446 | 6.2436 | 6.2436 | 5600.0 |
| 2008-08-21 08:37:00 | AAPL | Stock | 6.2446 | 6.2446 | 6.2446 | 6.2446 | 7000.0 |
| 2008-08-21 08:38:00 | AAPL | Stock | 6.2436 | 6.2464 | 6.2436 | 6.2457 | 11984.0 |
| 2008-08-21 08:39:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2464 | 6.2464 | 11760.0 |
| 2008-08-21 08:40:00 | AAPL | Stock | 6.2482 | 6.2482 | 6.2482 | 6.2482 | 8960.0 |
| 2008-08-21 08:42:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2464 | 6.2464 | 42000.0 |
| 2008-08-21 08:43:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2464 | 6.2464 | 8652.0 |
| 2008-08-21 08:44:00 | AAPL | Stock | 6.2493 | 6.25 | 6.2493 | 6.25 | 11200.0 |
| 2008-08-21 08:49:00 | AAPL | Stock | 6.2454 | 6.2454 | 6.2446 | 6.2446 | 8400.0 |
| 2008-08-21 08:51:00 | AAPL | Stock | 6.245 | 6.245 | 6.2436 | 6.2439 | 33600.0 |
| 2008-08-21 08:52:00 | AAPL | Stock | 6.2439 | 6.2439 | 6.2439 | 6.2439 | 5600.0 |
| 2008-08-21 08:53:00 | AAPL | Stock | 6.2436 | 6.2436 | 6.2364 | 6.2364 | 336140.0 |
| 2008-08-21 08:54:00 | AAPL | Stock | 6.2371 | 6.2371 | 6.2371 | 6.2371 | 2800.0 |
| 2008-08-21 08:55:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2375 | 6.2375 | 11760.0 |
| 2008-08-21 08:56:00 | AAPL | Stock | 6.2407 | 6.2407 | 6.2407 | 6.2407 | 2800.0 |
| 2008-08-21 08:57:00 | AAPL | Stock | 6.2396 | 6.2396 | 6.2396 | 6.2396 | 3360.0 |
| 2008-08-21 08:59:00 | AAPL | Stock | 6.2414 | 6.2436 | 6.2393 | 6.2396 | 22344.0 |
| 2008-08-21 09:00:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2321 | 6.2321 | 284312.0 |
| 2008-08-21 09:01:00 | AAPL | Stock | 6.2357 | 6.2357 | 6.2357 | 6.2357 | 14000.0 |
> showing 50 of 936,567 rows — these rows as CSV