PREVIEW / stock_1min / 2013-09-11
file: by_date/stock_1min/2013/2013-09-11.parquet size: 13.4 MB rows: 980,084 symbols: 2,858
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-09-11 04:00:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.3571 | 17.3571 | 41580.0 |
| 2013-09-11 04:04:00 | AAPL | Stock | 17.3557 | 17.3557 | 17.3557 | 17.3557 | 2800.0 |
| 2013-09-11 04:10:00 | AAPL | Stock | 17.3564 | 17.3564 | 17.3564 | 17.3564 | 2800.0 |
| 2013-09-11 04:11:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3571 | 17.3571 | 8400.0 |
| 2013-09-11 04:12:00 | AAPL | Stock | 17.3557 | 17.3557 | 17.3557 | 17.3557 | 2800.0 |
| 2013-09-11 04:15:00 | AAPL | Stock | 17.375 | 17.375 | 17.375 | 17.375 | 4172.0 |
| 2013-09-11 04:17:00 | AAPL | Stock | 17.3886 | 17.3886 | 17.3886 | 17.3886 | 2800.0 |
| 2013-09-11 04:20:00 | AAPL | Stock | 17.3754 | 17.3754 | 17.3571 | 17.3571 | 11200.0 |
| 2013-09-11 04:23:00 | AAPL | Stock | 17.3554 | 17.3554 | 17.3529 | 17.3529 | 5600.0 |
| 2013-09-11 04:24:00 | AAPL | Stock | 17.355 | 17.355 | 17.3454 | 17.3454 | 6832.0 |
| 2013-09-11 04:27:00 | AAPL | Stock | 17.3354 | 17.3354 | 17.3354 | 17.3354 | 3360.0 |
| 2013-09-11 04:32:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.2857 | 17.2857 | 49168.0 |
| 2013-09-11 04:36:00 | AAPL | Stock | 17.2886 | 17.2886 | 17.2886 | 17.2886 | 2800.0 |
| 2013-09-11 04:40:00 | AAPL | Stock | 17.2911 | 17.2911 | 17.2893 | 17.2893 | 11200.0 |
| 2013-09-11 04:41:00 | AAPL | Stock | 17.2893 | 17.2893 | 17.2875 | 17.2875 | 19040.0 |
| 2013-09-11 04:42:00 | AAPL | Stock | 17.2875 | 17.2875 | 17.2875 | 17.2875 | 11200.0 |
| 2013-09-11 04:43:00 | AAPL | Stock | 17.2643 | 17.2643 | 17.2643 | 17.2643 | 2800.0 |
| 2013-09-11 04:45:00 | AAPL | Stock | 17.3079 | 17.3079 | 17.3079 | 17.3079 | 2800.0 |
| 2013-09-11 04:47:00 | AAPL | Stock | 17.3318 | 17.3357 | 17.3318 | 17.3357 | 14000.0 |
| 2013-09-11 04:50:00 | AAPL | Stock | 17.3243 | 17.3243 | 17.3243 | 17.3243 | 8400.0 |
| 2013-09-11 04:51:00 | AAPL | Stock | 17.3143 | 17.3143 | 17.2886 | 17.2886 | 23100.0 |
| 2013-09-11 04:55:00 | AAPL | Stock | 17.2929 | 17.2929 | 17.2929 | 17.2929 | 6860.0 |
| 2013-09-11 04:56:00 | AAPL | Stock | 17.2989 | 17.3164 | 17.2814 | 17.3161 | 30464.0 |
| 2013-09-11 05:00:00 | AAPL | Stock | 17.315 | 17.3157 | 17.315 | 17.3157 | 5600.0 |
| 2013-09-11 05:05:00 | AAPL | Stock | 17.3157 | 17.3161 | 17.3146 | 17.3154 | 49000.0 |
| 2013-09-11 05:06:00 | AAPL | Stock | 17.3146 | 17.3157 | 17.3146 | 17.3154 | 14000.0 |
| 2013-09-11 05:07:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 14000.0 |
| 2013-09-11 05:09:00 | AAPL | Stock | 17.3125 | 17.3125 | 17.3125 | 17.3125 | 2800.0 |
| 2013-09-11 05:13:00 | AAPL | Stock | 17.3136 | 17.3214 | 17.3036 | 17.3214 | 67200.0 |
| 2013-09-11 05:14:00 | AAPL | Stock | 17.2932 | 17.2932 | 17.2857 | 17.2857 | 11452.0 |
| 2013-09-11 05:16:00 | AAPL | Stock | 17.2896 | 17.2896 | 17.2896 | 17.2896 | 2800.0 |
| 2013-09-11 05:23:00 | AAPL | Stock | 17.2893 | 17.2893 | 17.2846 | 17.2846 | 16800.0 |
| 2013-09-11 05:24:00 | AAPL | Stock | 17.2989 | 17.2989 | 17.2964 | 17.2964 | 19600.0 |
| 2013-09-11 05:27:00 | AAPL | Stock | 17.3086 | 17.3096 | 17.3086 | 17.3096 | 5600.0 |
| 2013-09-11 05:28:00 | AAPL | Stock | 17.2861 | 17.3125 | 17.2861 | 17.3125 | 100100.0 |
| 2013-09-11 05:29:00 | AAPL | Stock | 17.2946 | 17.2946 | 17.2946 | 17.2946 | 2800.0 |
| 2013-09-11 05:30:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-09-11 05:32:00 | AAPL | Stock | 17.3125 | 17.3125 | 17.3125 | 17.3125 | 2800.0 |
| 2013-09-11 05:35:00 | AAPL | Stock | 17.3204 | 17.3271 | 17.3204 | 17.3268 | 14280.0 |
| 2013-09-11 05:37:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 46956.0 |
| 2013-09-11 05:40:00 | AAPL | Stock | 17.3232 | 17.3232 | 17.3232 | 17.3232 | 8400.0 |
| 2013-09-11 05:43:00 | AAPL | Stock | 17.3186 | 17.3186 | 17.3186 | 17.3186 | 14000.0 |
| 2013-09-11 05:46:00 | AAPL | Stock | 17.3182 | 17.3186 | 17.3182 | 17.3186 | 16800.0 |
| 2013-09-11 05:48:00 | AAPL | Stock | 17.3054 | 17.3054 | 17.3054 | 17.3054 | 11172.0 |
| 2013-09-11 05:49:00 | AAPL | Stock | 17.325 | 17.325 | 17.325 | 17.325 | 2800.0 |
| 2013-09-11 05:50:00 | AAPL | Stock | 17.3254 | 17.3254 | 17.3254 | 17.3254 | 2800.0 |
| 2013-09-11 05:51:00 | AAPL | Stock | 17.3071 | 17.3071 | 17.3071 | 17.3071 | 36652.0 |
| 2013-09-11 05:52:00 | AAPL | Stock | 17.3071 | 17.3254 | 17.3071 | 17.3254 | 26712.0 |
| 2013-09-11 05:53:00 | AAPL | Stock | 17.3421 | 17.3421 | 17.3421 | 17.3421 | 2800.0 |
| 2013-09-11 05:56:00 | AAPL | Stock | 17.3111 | 17.3111 | 17.3111 | 17.3111 | 21392.0 |
> showing 50 of 980,084 rows — these rows as CSV