PREVIEW / stock_1min / 2011-03-11
file: by_date/stock_1min/2011/2011-03-11.parquet size: 13.3 MB rows: 994,158 symbols: 2,833
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-03-11 04:04:00 | AAPL | Stock | 12.3246 | 12.3246 | 12.3246 | 12.3246 | 5600.0 |
| 2011-03-11 04:28:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 12292.0 |
| 2011-03-11 04:41:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 5600.0 |
| 2011-03-11 04:44:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-03-11 04:52:00 | AAPL | Stock | 12.2661 | 12.2661 | 12.2661 | 12.2661 | 2800.0 |
| 2011-03-11 04:56:00 | AAPL | Stock | 12.2729 | 12.2729 | 12.2729 | 12.2729 | 2800.0 |
| 2011-03-11 05:03:00 | AAPL | Stock | 12.2511 | 12.2511 | 12.2511 | 12.2511 | 2800.0 |
| 2011-03-11 05:19:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 7000.0 |
| 2011-03-11 05:24:00 | AAPL | Stock | 12.2236 | 12.2236 | 12.2214 | 12.2214 | 13300.0 |
| 2011-03-11 05:26:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2464 | 12.2464 | 2800.0 |
| 2011-03-11 05:29:00 | AAPL | Stock | 12.2489 | 12.2489 | 12.2489 | 12.2489 | 4200.0 |
| 2011-03-11 05:34:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2286 | 12.2289 | 56000.0 |
| 2011-03-11 05:40:00 | AAPL | Stock | 12.2579 | 12.2579 | 12.2579 | 12.2579 | 2800.0 |
| 2011-03-11 05:41:00 | AAPL | Stock | 12.245 | 12.245 | 12.245 | 12.245 | 2800.0 |
| 2011-03-11 05:42:00 | AAPL | Stock | 12.2443 | 12.2482 | 12.2218 | 12.2461 | 70000.0 |
| 2011-03-11 05:43:00 | AAPL | Stock | 12.2439 | 12.2482 | 12.2439 | 12.2482 | 28000.0 |
| 2011-03-11 05:44:00 | AAPL | Stock | 12.2482 | 12.2482 | 12.2454 | 12.2475 | 44800.0 |
| 2011-03-11 05:45:00 | AAPL | Stock | 12.2468 | 12.2468 | 12.2468 | 12.2468 | 42000.0 |
| 2011-03-11 05:48:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 8400.0 |
| 2011-03-11 05:51:00 | AAPL | Stock | 12.2364 | 12.2375 | 12.2364 | 12.2375 | 28000.0 |
| 2011-03-11 06:02:00 | AAPL | Stock | 12.25 | 12.25 | 12.2464 | 12.2464 | 24920.0 |
| 2011-03-11 06:05:00 | AAPL | Stock | 12.2425 | 12.2679 | 12.2425 | 12.2679 | 71344.0 |
| 2011-03-11 06:06:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 11200.0 |
| 2011-03-11 06:07:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 2800.0 |
| 2011-03-11 06:09:00 | AAPL | Stock | 12.2579 | 12.2679 | 12.2579 | 12.2679 | 8400.0 |
| 2011-03-11 06:12:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 2800.0 |
| 2011-03-11 06:14:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 28000.0 |
| 2011-03-11 06:25:00 | AAPL | Stock | 12.2518 | 12.2518 | 12.2511 | 12.2511 | 8400.0 |
| 2011-03-11 06:26:00 | AAPL | Stock | 12.2275 | 12.2275 | 12.2275 | 12.2275 | 7560.0 |
| 2011-03-11 06:29:00 | AAPL | Stock | 12.2336 | 12.2336 | 12.2336 | 12.2336 | 2800.0 |
| 2011-03-11 06:30:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2464 | 12.2464 | 33600.0 |
| 2011-03-11 06:45:00 | AAPL | Stock | 12.2679 | 12.2714 | 12.2668 | 12.2714 | 19600.0 |
| 2011-03-11 06:47:00 | AAPL | Stock | 12.2804 | 12.2804 | 12.2804 | 12.2804 | 2800.0 |
| 2011-03-11 06:48:00 | AAPL | Stock | 12.2804 | 12.2804 | 12.2804 | 12.2804 | 2800.0 |
| 2011-03-11 06:54:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 28000.0 |
| 2011-03-11 06:57:00 | AAPL | Stock | 12.2939 | 12.2939 | 12.2939 | 12.2939 | 42000.0 |
| 2011-03-11 07:00:00 | AAPL | Stock | 12.2939 | 12.2939 | 12.2929 | 12.2929 | 14000.0 |
| 2011-03-11 07:01:00 | AAPL | Stock | 12.3032 | 12.3032 | 12.3011 | 12.3011 | 16520.0 |
| 2011-03-11 07:02:00 | AAPL | Stock | 12.2996 | 12.3036 | 12.2996 | 12.3036 | 47600.0 |
| 2011-03-11 07:03:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.2943 | 12.2943 | 14000.0 |
| 2011-03-11 07:05:00 | AAPL | Stock | 12.2943 | 12.2943 | 12.2943 | 12.2943 | 27608.0 |
| 2011-03-11 07:07:00 | AAPL | Stock | 12.2875 | 12.2875 | 12.2786 | 12.2786 | 5600.0 |
| 2011-03-11 07:08:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.2768 | 12.2768 | 7756.0 |
| 2011-03-11 07:09:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2714 | 12.2714 | 14420.0 |
| 2011-03-11 07:11:00 | AAPL | Stock | 12.2961 | 12.2961 | 12.2961 | 12.2961 | 26600.0 |
| 2011-03-11 07:12:00 | AAPL | Stock | 12.2893 | 12.2925 | 12.2893 | 12.2925 | 5600.0 |
| 2011-03-11 07:13:00 | AAPL | Stock | 12.2786 | 12.2786 | 12.2786 | 12.2786 | 8400.0 |
| 2011-03-11 07:14:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 16800.0 |
| 2011-03-11 07:15:00 | AAPL | Stock | 12.2868 | 12.2868 | 12.2864 | 12.2864 | 5600.0 |
| 2011-03-11 07:16:00 | AAPL | Stock | 12.2946 | 12.2946 | 12.2946 | 12.2946 | 5600.0 |
> showing 50 of 994,158 rows — these rows as CSV