PREVIEW / stock_1min / 2013-04-10
file: by_date/stock_1min/2013/2013-04-10.parquet size: 13.8 MB rows: 1,009,897 symbols: 2,837
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-04-10 04:01:00 | AAPL | Stock | 15.2893 | 15.2893 | 15.2893 | 15.2893 | 2800.0 |
| 2013-04-10 06:29:00 | AAPL | Stock | 15.3143 | 15.3143 | 15.3143 | 15.3143 | 5600.0 |
| 2013-04-10 07:01:00 | AAPL | Stock | 15.315 | 15.315 | 15.315 | 15.315 | 2800.0 |
| 2013-04-10 07:02:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 2800.0 |
| 2013-04-10 07:03:00 | AAPL | Stock | 15.3286 | 15.3286 | 15.3214 | 15.3214 | 19600.0 |
| 2013-04-10 07:12:00 | AAPL | Stock | 15.3304 | 15.3304 | 15.3304 | 15.3304 | 2800.0 |
| 2013-04-10 07:20:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 14000.0 |
| 2013-04-10 07:22:00 | AAPL | Stock | 15.325 | 15.325 | 15.325 | 15.325 | 8400.0 |
| 2013-04-10 07:23:00 | AAPL | Stock | 15.325 | 15.325 | 15.325 | 15.325 | 2800.0 |
| 2013-04-10 07:24:00 | AAPL | Stock | 15.3254 | 15.3254 | 15.3254 | 15.3254 | 2800.0 |
| 2013-04-10 07:34:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 5600.0 |
| 2013-04-10 07:40:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 4284.0 |
| 2013-04-10 07:44:00 | AAPL | Stock | 15.3168 | 15.3175 | 15.3143 | 15.3143 | 14000.0 |
| 2013-04-10 07:46:00 | AAPL | Stock | 15.3093 | 15.3093 | 15.3086 | 15.3086 | 5600.0 |
| 2013-04-10 07:51:00 | AAPL | Stock | 15.2979 | 15.2979 | 15.2875 | 15.2875 | 41860.0 |
| 2013-04-10 07:52:00 | AAPL | Stock | 15.2879 | 15.2879 | 15.27 | 15.27 | 18480.0 |
| 2013-04-10 07:58:00 | AAPL | Stock | 15.2843 | 15.2843 | 15.2843 | 15.2843 | 2800.0 |
| 2013-04-10 07:59:00 | AAPL | Stock | 15.2836 | 15.2836 | 15.2832 | 15.2832 | 7980.0 |
| 2013-04-10 08:00:00 | AAPL | Stock | 15.2857 | 15.3214 | 15.2739 | 15.2964 | 92652.0 |
| 2013-04-10 08:05:00 | AAPL | Stock | 15.3 | 15.3071 | 15.3 | 15.3071 | 16800.0 |
| 2013-04-10 08:06:00 | AAPL | Stock | 15.3179 | 15.3261 | 15.3179 | 15.3261 | 34160.0 |
| 2013-04-10 08:07:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3125 | 15.3125 | 30940.0 |
| 2013-04-10 08:09:00 | AAPL | Stock | 15.3104 | 15.3104 | 15.3104 | 15.3104 | 2800.0 |
| 2013-04-10 08:10:00 | AAPL | Stock | 15.3114 | 15.3132 | 15.3114 | 15.3125 | 16520.0 |
| 2013-04-10 08:14:00 | AAPL | Stock | 15.3089 | 15.3089 | 15.3089 | 15.3089 | 2800.0 |
| 2013-04-10 08:15:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.2143 | 15.2143 | 19600.0 |
| 2013-04-10 08:16:00 | AAPL | Stock | 15.3093 | 15.3207 | 15.3093 | 15.3179 | 50400.0 |
| 2013-04-10 08:17:00 | AAPL | Stock | 15.3182 | 15.3214 | 15.3182 | 15.3214 | 29988.0 |
| 2013-04-10 08:18:00 | AAPL | Stock | 15.3182 | 15.3186 | 15.3161 | 15.3161 | 22400.0 |
| 2013-04-10 08:19:00 | AAPL | Stock | 15.3161 | 15.3268 | 15.3161 | 15.3168 | 23352.0 |
| 2013-04-10 08:20:00 | AAPL | Stock | 15.32 | 15.32 | 15.32 | 15.32 | 2800.0 |
| 2013-04-10 08:21:00 | AAPL | Stock | 15.3143 | 15.3143 | 15.3143 | 15.3143 | 5600.0 |
| 2013-04-10 08:22:00 | AAPL | Stock | 15.3125 | 15.3125 | 15.3125 | 15.3125 | 3360.0 |
| 2013-04-10 08:23:00 | AAPL | Stock | 15.3179 | 15.3232 | 15.3179 | 15.3232 | 53200.0 |
| 2013-04-10 08:24:00 | AAPL | Stock | 15.3275 | 15.3275 | 15.3275 | 15.3275 | 5600.0 |
| 2013-04-10 08:26:00 | AAPL | Stock | 15.3268 | 15.3293 | 15.3204 | 15.3204 | 78120.0 |
| 2013-04-10 08:27:00 | AAPL | Stock | 15.3182 | 15.3214 | 15.3182 | 15.3182 | 16576.0 |
| 2013-04-10 08:28:00 | AAPL | Stock | 15.3207 | 15.3207 | 15.3204 | 15.3204 | 5600.0 |
| 2013-04-10 08:29:00 | AAPL | Stock | 15.3157 | 15.3196 | 15.3157 | 15.3196 | 5600.0 |
| 2013-04-10 08:30:00 | AAPL | Stock | 15.3193 | 15.3196 | 15.3125 | 15.3125 | 22288.0 |
| 2013-04-10 08:31:00 | AAPL | Stock | 15.3125 | 15.3161 | 15.3125 | 15.3125 | 103432.0 |
| 2013-04-10 08:32:00 | AAPL | Stock | 15.3089 | 15.3143 | 15.3039 | 15.3143 | 14000.0 |
| 2013-04-10 08:34:00 | AAPL | Stock | 15.3107 | 15.3111 | 15.3107 | 15.3111 | 8400.0 |
| 2013-04-10 08:37:00 | AAPL | Stock | 15.3079 | 15.3079 | 15.3036 | 15.3036 | 33040.0 |
| 2013-04-10 08:38:00 | AAPL | Stock | 15.2957 | 15.3029 | 15.2932 | 15.2932 | 58128.0 |
| 2013-04-10 08:39:00 | AAPL | Stock | 15.2946 | 15.3061 | 15.2946 | 15.3061 | 34384.0 |
| 2013-04-10 08:40:00 | AAPL | Stock | 15.2982 | 15.2982 | 15.2964 | 15.2964 | 9912.0 |
| 2013-04-10 08:41:00 | AAPL | Stock | 15.2932 | 15.2932 | 15.2929 | 15.2929 | 14000.0 |
| 2013-04-10 08:43:00 | AAPL | Stock | 15.2929 | 15.2929 | 15.2929 | 15.2929 | 2800.0 |
| 2013-04-10 08:44:00 | AAPL | Stock | 15.2982 | 15.2989 | 15.2982 | 15.2989 | 29288.0 |
> showing 50 of 1,009,897 rows — these rows as CSV