PREVIEW / stock_1min / 2011-09-29
file: by_date/stock_1min/2011/2011-09-29.parquet size: 13.4 MB rows: 1,012,580 symbols: 2,819
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-29 04:00:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 25200.0 |
| 2011-09-29 04:20:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-09-29 04:25:00 | AAPL | Stock | 14.3211 | 14.3211 | 14.3125 | 14.3125 | 5600.0 |
| 2011-09-29 04:28:00 | AAPL | Stock | 14.3125 | 14.3125 | 14.3125 | 14.3125 | 2800.0 |
| 2011-09-29 05:10:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.3036 | 14.3036 | 2800.0 |
| 2011-09-29 05:12:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.25 | 14.25 | 14000.0 |
| 2011-09-29 05:15:00 | AAPL | Stock | 14.3036 | 14.3214 | 14.3036 | 14.3214 | 25200.0 |
| 2011-09-29 06:10:00 | AAPL | Stock | 14.3211 | 14.3211 | 14.3189 | 14.3189 | 5600.0 |
| 2011-09-29 06:12:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 14000.0 |
| 2011-09-29 06:21:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 5600.0 |
| 2011-09-29 06:33:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 4200.0 |
| 2011-09-29 06:56:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 5600.0 |
| 2011-09-29 06:58:00 | AAPL | Stock | 14.2939 | 14.295 | 14.2521 | 14.2521 | 11200.0 |
| 2011-09-29 07:00:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 2800.0 |
| 2011-09-29 07:01:00 | AAPL | Stock | 14.2679 | 14.2768 | 14.2679 | 14.2768 | 16800.0 |
| 2011-09-29 07:02:00 | AAPL | Stock | 14.2914 | 14.2918 | 14.2914 | 14.2918 | 14000.0 |
| 2011-09-29 07:03:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2639 | 14.2639 | 16800.0 |
| 2011-09-29 07:04:00 | AAPL | Stock | 14.2639 | 14.2639 | 14.2639 | 14.2639 | 14000.0 |
| 2011-09-29 07:05:00 | AAPL | Stock | 14.2518 | 14.2586 | 14.2518 | 14.2518 | 11200.0 |
| 2011-09-29 07:06:00 | AAPL | Stock | 14.2518 | 14.2518 | 14.2464 | 14.2464 | 5600.0 |
| 2011-09-29 07:07:00 | AAPL | Stock | 14.2446 | 14.2446 | 14.2446 | 14.2446 | 4060.0 |
| 2011-09-29 07:08:00 | AAPL | Stock | 14.2464 | 14.2464 | 14.2464 | 14.2464 | 5600.0 |
| 2011-09-29 07:12:00 | AAPL | Stock | 14.2479 | 14.2479 | 14.2479 | 14.2479 | 2800.0 |
| 2011-09-29 07:15:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-09-29 07:16:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2675 | 14.2675 | 8400.0 |
| 2011-09-29 07:17:00 | AAPL | Stock | 14.2625 | 14.2625 | 14.2625 | 14.2625 | 2800.0 |
| 2011-09-29 07:18:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2629 | 14.2629 | 8400.0 |
| 2011-09-29 07:20:00 | AAPL | Stock | 14.25 | 14.25 | 14.2429 | 14.2429 | 16800.0 |
| 2011-09-29 07:22:00 | AAPL | Stock | 14.2496 | 14.2496 | 14.2336 | 14.2336 | 28000.0 |
| 2011-09-29 07:25:00 | AAPL | Stock | 14.2386 | 14.2386 | 14.2386 | 14.2386 | 2800.0 |
| 2011-09-29 07:26:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 78400.0 |
| 2011-09-29 07:28:00 | AAPL | Stock | 14.22 | 14.2321 | 14.22 | 14.2321 | 35000.0 |
| 2011-09-29 07:29:00 | AAPL | Stock | 14.2421 | 14.2421 | 14.2421 | 14.2421 | 5600.0 |
| 2011-09-29 07:30:00 | AAPL | Stock | 14.2439 | 14.2582 | 14.2439 | 14.2582 | 16800.0 |
| 2011-09-29 07:31:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2311 | 14.2346 | 8400.0 |
| 2011-09-29 07:35:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2643 | 14.2643 | 2800.0 |
| 2011-09-29 07:37:00 | AAPL | Stock | 14.2375 | 14.2375 | 14.2361 | 14.2361 | 27300.0 |
| 2011-09-29 07:39:00 | AAPL | Stock | 14.2514 | 14.2525 | 14.2514 | 14.2525 | 30100.0 |
| 2011-09-29 07:40:00 | AAPL | Stock | 14.2511 | 14.2511 | 14.25 | 14.25 | 14000.0 |
| 2011-09-29 07:41:00 | AAPL | Stock | 14.2489 | 14.25 | 14.2489 | 14.25 | 42000.0 |
| 2011-09-29 07:43:00 | AAPL | Stock | 14.2518 | 14.2518 | 14.2518 | 14.2518 | 2800.0 |
| 2011-09-29 07:45:00 | AAPL | Stock | 14.2621 | 14.2621 | 14.2554 | 14.2554 | 13356.0 |
| 2011-09-29 07:46:00 | AAPL | Stock | 14.2589 | 14.2589 | 14.2554 | 14.2554 | 16800.0 |
| 2011-09-29 07:47:00 | AAPL | Stock | 14.2625 | 14.2668 | 14.2625 | 14.2668 | 8400.0 |
| 2011-09-29 07:48:00 | AAPL | Stock | 14.2571 | 14.2571 | 14.2571 | 14.2571 | 14000.0 |
| 2011-09-29 07:50:00 | AAPL | Stock | 14.2636 | 14.2636 | 14.2518 | 14.2518 | 8400.0 |
| 2011-09-29 07:51:00 | AAPL | Stock | 14.2607 | 14.2607 | 14.2518 | 14.2518 | 7952.0 |
| 2011-09-29 07:53:00 | AAPL | Stock | 14.2436 | 14.2436 | 14.2429 | 14.2429 | 10080.0 |
| 2011-09-29 07:54:00 | AAPL | Stock | 14.2368 | 14.2368 | 14.2368 | 14.2368 | 2800.0 |
| 2011-09-29 07:59:00 | AAPL | Stock | 14.2275 | 14.2275 | 14.2275 | 14.2275 | 2800.0 |
> showing 50 of 1,012,580 rows — these rows as CSV