PREVIEW / stock_1min / 2010-10-08
file: by_date/stock_1min/2010/2010-10-08.parquet size: 12.3 MB rows: 927,599 symbols: 2,823
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-08 06:07:00 | AAPL | Stock | 10.3071 | 10.3071 | 10.3071 | 10.3071 | 14000.0 |
| 2010-10-08 07:00:00 | AAPL | Stock | 10.3054 | 10.3054 | 10.3054 | 10.3054 | 2800.0 |
| 2010-10-08 07:01:00 | AAPL | Stock | 10.3282 | 10.3282 | 10.3282 | 10.3282 | 5600.0 |
| 2010-10-08 07:08:00 | AAPL | Stock | 10.2961 | 10.2961 | 10.2961 | 10.2961 | 5600.0 |
| 2010-10-08 07:23:00 | AAPL | Stock | 10.3121 | 10.3121 | 10.3121 | 10.3121 | 2800.0 |
| 2010-10-08 07:24:00 | AAPL | Stock | 10.3121 | 10.3214 | 10.3121 | 10.3214 | 15400.0 |
| 2010-10-08 07:25:00 | AAPL | Stock | 10.3146 | 10.3146 | 10.3146 | 10.3146 | 2800.0 |
| 2010-10-08 07:30:00 | AAPL | Stock | 10.3125 | 10.3143 | 10.3125 | 10.3143 | 11200.0 |
| 2010-10-08 07:33:00 | AAPL | Stock | 10.3129 | 10.3196 | 10.3129 | 10.3196 | 5600.0 |
| 2010-10-08 07:38:00 | AAPL | Stock | 10.3175 | 10.3175 | 10.3175 | 10.3175 | 2800.0 |
| 2010-10-08 07:40:00 | AAPL | Stock | 10.3193 | 10.3193 | 10.3193 | 10.3193 | 2800.0 |
| 2010-10-08 07:45:00 | AAPL | Stock | 10.3193 | 10.3193 | 10.3193 | 10.3193 | 5600.0 |
| 2010-10-08 07:49:00 | AAPL | Stock | 10.3129 | 10.3129 | 10.3125 | 10.3125 | 8960.0 |
| 2010-10-08 07:54:00 | AAPL | Stock | 10.3139 | 10.3146 | 10.3139 | 10.3146 | 8400.0 |
| 2010-10-08 07:56:00 | AAPL | Stock | 10.3157 | 10.3157 | 10.3157 | 10.3157 | 2800.0 |
| 2010-10-08 08:00:00 | AAPL | Stock | 10.3111 | 10.3161 | 10.3039 | 10.3039 | 136556.0 |
| 2010-10-08 08:01:00 | AAPL | Stock | 10.3104 | 10.3125 | 10.3104 | 10.3125 | 51520.0 |
| 2010-10-08 08:02:00 | AAPL | Stock | 10.315 | 10.3161 | 10.3132 | 10.3132 | 100800.0 |
| 2010-10-08 08:03:00 | AAPL | Stock | 10.3125 | 10.3168 | 10.3118 | 10.3168 | 89628.0 |
| 2010-10-08 08:04:00 | AAPL | Stock | 10.3139 | 10.3143 | 10.3132 | 10.3132 | 45920.0 |
| 2010-10-08 08:05:00 | AAPL | Stock | 10.3139 | 10.3143 | 10.3114 | 10.3114 | 77000.0 |
| 2010-10-08 08:06:00 | AAPL | Stock | 10.3104 | 10.3104 | 10.3104 | 10.3104 | 18200.0 |
| 2010-10-08 08:07:00 | AAPL | Stock | 10.3121 | 10.3121 | 10.3043 | 10.3043 | 27160.0 |
| 2010-10-08 08:08:00 | AAPL | Stock | 10.3057 | 10.3057 | 10.3057 | 10.3057 | 5600.0 |
| 2010-10-08 08:09:00 | AAPL | Stock | 10.3089 | 10.3125 | 10.3071 | 10.3125 | 38360.0 |
| 2010-10-08 08:10:00 | AAPL | Stock | 10.3125 | 10.3143 | 10.3093 | 10.3121 | 63112.0 |
| 2010-10-08 08:11:00 | AAPL | Stock | 10.3164 | 10.3168 | 10.3121 | 10.3121 | 175280.0 |
| 2010-10-08 08:12:00 | AAPL | Stock | 10.3161 | 10.3161 | 10.3111 | 10.3136 | 61600.0 |
| 2010-10-08 08:13:00 | AAPL | Stock | 10.3136 | 10.3143 | 10.3136 | 10.3143 | 15680.0 |
| 2010-10-08 08:14:00 | AAPL | Stock | 10.3121 | 10.3168 | 10.3111 | 10.3168 | 11200.0 |
| 2010-10-08 08:15:00 | AAPL | Stock | 10.3161 | 10.3186 | 10.3154 | 10.3186 | 21560.0 |
| 2010-10-08 08:16:00 | AAPL | Stock | 10.3161 | 10.3179 | 10.3157 | 10.3179 | 58800.0 |
| 2010-10-08 08:17:00 | AAPL | Stock | 10.3179 | 10.3179 | 10.3161 | 10.3161 | 14840.0 |
| 2010-10-08 08:18:00 | AAPL | Stock | 10.3175 | 10.3257 | 10.3175 | 10.325 | 126028.0 |
| 2010-10-08 08:19:00 | AAPL | Stock | 10.3214 | 10.3214 | 10.32 | 10.3214 | 16800.0 |
| 2010-10-08 08:20:00 | AAPL | Stock | 10.3286 | 10.3296 | 10.3264 | 10.3296 | 25200.0 |
| 2010-10-08 08:21:00 | AAPL | Stock | 10.3293 | 10.3336 | 10.3232 | 10.3236 | 128184.0 |
| 2010-10-08 08:22:00 | AAPL | Stock | 10.3218 | 10.3232 | 10.3218 | 10.3232 | 30800.0 |
| 2010-10-08 08:23:00 | AAPL | Stock | 10.3246 | 10.3286 | 10.3246 | 10.3282 | 67536.0 |
| 2010-10-08 08:24:00 | AAPL | Stock | 10.3282 | 10.3282 | 10.3279 | 10.3282 | 16800.0 |
| 2010-10-08 08:25:00 | AAPL | Stock | 10.3268 | 10.3268 | 10.325 | 10.3257 | 19600.0 |
| 2010-10-08 08:26:00 | AAPL | Stock | 10.325 | 10.3254 | 10.325 | 10.325 | 22344.0 |
| 2010-10-08 08:27:00 | AAPL | Stock | 10.3232 | 10.3264 | 10.3207 | 10.3207 | 65660.0 |
| 2010-10-08 08:28:00 | AAPL | Stock | 10.3196 | 10.3207 | 10.3139 | 10.3139 | 168756.0 |
| 2010-10-08 08:29:00 | AAPL | Stock | 10.3186 | 10.3196 | 10.3104 | 10.3196 | 75516.0 |
| 2010-10-08 08:30:00 | AAPL | Stock | 10.3179 | 10.3179 | 10.25 | 10.3018 | 951664.0 |
| 2010-10-08 08:31:00 | AAPL | Stock | 10.2929 | 10.3214 | 10.2864 | 10.3168 | 522060.0 |
| 2010-10-08 08:32:00 | AAPL | Stock | 10.3179 | 10.3214 | 10.3107 | 10.3189 | 254520.0 |
| 2010-10-08 08:33:00 | AAPL | Stock | 10.3161 | 10.3629 | 10.3107 | 10.3571 | 458696.0 |
| 2010-10-08 08:34:00 | AAPL | Stock | 10.3664 | 10.375 | 10.3571 | 10.36 | 695324.0 |
> showing 50 of 927,599 rows — these rows as CSV