PREVIEW / stock_1min / 2013-12-04
file: by_date/stock_1min/2013/2013-12-04.parquet size: 14.4 MB rows: 1,049,480 symbols: 2,860
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-04 04:07:00 | AAPL | Stock | 20.2771 | 20.2771 | 20.2771 | 20.2771 | 5600.0 |
| 2013-12-04 04:54:00 | AAPL | Stock | 20.2936 | 20.2936 | 20.2936 | 20.2936 | 7924.0 |
| 2013-12-04 05:38:00 | AAPL | Stock | 20.2986 | 20.2986 | 20.2986 | 20.2986 | 7448.0 |
| 2013-12-04 05:39:00 | AAPL | Stock | 20.2986 | 20.2986 | 20.2986 | 20.2986 | 3640.0 |
| 2013-12-04 06:02:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.3125 | 20.3125 | 5600.0 |
| 2013-12-04 06:13:00 | AAPL | Stock | 20.3029 | 20.3029 | 20.3029 | 20.3029 | 2800.0 |
| 2013-12-04 06:15:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 2800.0 |
| 2013-12-04 06:19:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 2800.0 |
| 2013-12-04 06:21:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.3125 | 20.3125 | 7280.0 |
| 2013-12-04 06:28:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3036 | 20.3036 | 2800.0 |
| 2013-12-04 06:31:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3 | 20.3 | 8400.0 |
| 2013-12-04 06:38:00 | AAPL | Stock | 20.31 | 20.31 | 20.31 | 20.31 | 2800.0 |
| 2013-12-04 06:40:00 | AAPL | Stock | 20.3118 | 20.3118 | 20.3118 | 20.3118 | 5600.0 |
| 2013-12-04 06:41:00 | AAPL | Stock | 20.2864 | 20.3118 | 20.2864 | 20.3118 | 11200.0 |
| 2013-12-04 06:42:00 | AAPL | Stock | 20.2875 | 20.2875 | 20.2875 | 20.2875 | 27188.0 |
| 2013-12-04 06:45:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 24640.0 |
| 2013-12-04 06:46:00 | AAPL | Stock | 20.2889 | 20.2889 | 20.2889 | 20.2889 | 4956.0 |
| 2013-12-04 06:49:00 | AAPL | Stock | 20.2904 | 20.2904 | 20.2904 | 20.2904 | 2800.0 |
| 2013-12-04 06:56:00 | AAPL | Stock | 20.2757 | 20.2757 | 20.2757 | 20.2757 | 2800.0 |
| 2013-12-04 06:57:00 | AAPL | Stock | 20.2757 | 20.2757 | 20.2707 | 20.2707 | 5600.0 |
| 2013-12-04 06:58:00 | AAPL | Stock | 20.2757 | 20.2757 | 20.2757 | 20.2757 | 2800.0 |
| 2013-12-04 07:01:00 | AAPL | Stock | 20.2757 | 20.2904 | 20.2646 | 20.2904 | 64036.0 |
| 2013-12-04 07:02:00 | AAPL | Stock | 20.2946 | 20.2946 | 20.2857 | 20.2857 | 11200.0 |
| 2013-12-04 07:03:00 | AAPL | Stock | 20.2946 | 20.2964 | 20.2857 | 20.2857 | 32200.0 |
| 2013-12-04 07:04:00 | AAPL | Stock | 20.2911 | 20.2911 | 20.2882 | 20.2882 | 12600.0 |
| 2013-12-04 07:05:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2804 | 20.2804 | 11200.0 |
| 2013-12-04 07:06:00 | AAPL | Stock | 20.2946 | 20.2946 | 20.2946 | 20.2946 | 2800.0 |
| 2013-12-04 07:07:00 | AAPL | Stock | 20.2811 | 20.2811 | 20.2804 | 20.2804 | 8400.0 |
| 2013-12-04 07:08:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 18200.0 |
| 2013-12-04 07:09:00 | AAPL | Stock | 20.2964 | 20.3036 | 20.2964 | 20.3036 | 11200.0 |
| 2013-12-04 07:11:00 | AAPL | Stock | 20.2996 | 20.2996 | 20.2996 | 20.2996 | 2800.0 |
| 2013-12-04 07:12:00 | AAPL | Stock | 20.2996 | 20.2996 | 20.2946 | 20.2946 | 8400.0 |
| 2013-12-04 07:13:00 | AAPL | Stock | 20.2982 | 20.2982 | 20.2982 | 20.2982 | 5600.0 |
| 2013-12-04 07:14:00 | AAPL | Stock | 20.3018 | 20.3036 | 20.3018 | 20.3036 | 17836.0 |
| 2013-12-04 07:15:00 | AAPL | Stock | 20.3096 | 20.3107 | 20.3075 | 20.3107 | 16800.0 |
| 2013-12-04 07:16:00 | AAPL | Stock | 20.3121 | 20.3161 | 20.3121 | 20.3139 | 22680.0 |
| 2013-12-04 07:17:00 | AAPL | Stock | 20.3211 | 20.3214 | 20.3211 | 20.3214 | 17304.0 |
| 2013-12-04 07:18:00 | AAPL | Stock | 20.3132 | 20.3132 | 20.3132 | 20.3132 | 3136.0 |
| 2013-12-04 07:19:00 | AAPL | Stock | 20.3082 | 20.3082 | 20.3036 | 20.3036 | 44800.0 |
| 2013-12-04 07:20:00 | AAPL | Stock | 20.3007 | 20.3093 | 20.3 | 20.3093 | 23240.0 |
| 2013-12-04 07:21:00 | AAPL | Stock | 20.3 | 20.3 | 20.2982 | 20.2982 | 28000.0 |
| 2013-12-04 07:23:00 | AAPL | Stock | 20.3 | 20.3036 | 20.2982 | 20.3036 | 53200.0 |
| 2013-12-04 07:24:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3036 | 20.3036 | 14000.0 |
| 2013-12-04 07:28:00 | AAPL | Stock | 20.3096 | 20.3096 | 20.3096 | 20.3096 | 5600.0 |
| 2013-12-04 07:29:00 | AAPL | Stock | 20.3089 | 20.3089 | 20.3089 | 20.3089 | 39200.0 |
| 2013-12-04 07:30:00 | AAPL | Stock | 20.3032 | 20.3214 | 20.3014 | 20.3146 | 132916.0 |
| 2013-12-04 07:31:00 | AAPL | Stock | 20.3214 | 20.3329 | 20.3214 | 20.3329 | 101500.0 |
| 2013-12-04 07:32:00 | AAPL | Stock | 20.3339 | 20.3386 | 20.3339 | 20.3375 | 28000.0 |
| 2013-12-04 07:33:00 | AAPL | Stock | 20.3386 | 20.3386 | 20.3214 | 20.3321 | 53200.0 |
| 2013-12-04 07:34:00 | AAPL | Stock | 20.3229 | 20.325 | 20.3214 | 20.325 | 33824.0 |
> showing 50 of 1,049,480 rows — these rows as CSV