PREVIEW / stock_5min / 2006-05-17
file: by_date/stock_5min/2006/2006-05-17.parquet size: 3.2 MB rows: 230,266 symbols: 2,275
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-17 07:45:00 | AAPL | Stock | 2.3232 | 2.3232 | 2.3232 | 2.3232 | 2800.0 |
| 2006-05-17 08:00:00 | AAPL | Stock | 2.3268 | 2.3268 | 2.3214 | 2.3214 | 112280.0 |
| 2006-05-17 08:05:00 | AAPL | Stock | 2.3268 | 2.3279 | 2.325 | 2.325 | 47600.0 |
| 2006-05-17 08:10:00 | AAPL | Stock | 2.325 | 2.3268 | 2.325 | 2.3268 | 58380.0 |
| 2006-05-17 08:15:00 | AAPL | Stock | 2.3268 | 2.3268 | 2.3268 | 2.3268 | 77420.0 |
| 2006-05-17 08:20:00 | AAPL | Stock | 2.3268 | 2.3268 | 2.3257 | 2.3264 | 25200.0 |
| 2006-05-17 08:25:00 | AAPL | Stock | 2.3264 | 2.3264 | 2.325 | 2.3257 | 157640.0 |
| 2006-05-17 08:30:00 | AAPL | Stock | 2.3257 | 2.3257 | 2.315 | 2.3196 | 744828.0 |
| 2006-05-17 08:35:00 | AAPL | Stock | 2.3179 | 2.3179 | 2.3179 | 2.3179 | 131600.0 |
| 2006-05-17 08:40:00 | AAPL | Stock | 2.3168 | 2.3171 | 2.3132 | 2.3132 | 276892.0 |
| 2006-05-17 08:45:00 | AAPL | Stock | 2.3118 | 2.3186 | 2.3107 | 2.3186 | 376488.0 |
| 2006-05-17 08:50:00 | AAPL | Stock | 2.3143 | 2.3196 | 2.3143 | 2.3182 | 114576.0 |
| 2006-05-17 08:55:00 | AAPL | Stock | 2.3182 | 2.3182 | 2.3179 | 2.3179 | 179200.0 |
| 2006-05-17 09:00:00 | AAPL | Stock | 2.3157 | 2.3157 | 2.3143 | 2.3143 | 94220.0 |
| 2006-05-17 09:05:00 | AAPL | Stock | 2.3143 | 2.3157 | 2.3143 | 2.3143 | 205800.0 |
| 2006-05-17 09:10:00 | AAPL | Stock | 2.3146 | 2.3146 | 2.3089 | 2.3089 | 703248.0 |
| 2006-05-17 09:15:00 | AAPL | Stock | 2.3075 | 2.3143 | 2.3039 | 2.3143 | 411600.0 |
| 2006-05-17 09:20:00 | AAPL | Stock | 2.3118 | 2.3146 | 2.3107 | 2.3143 | 223328.0 |
| 2006-05-17 09:25:00 | AAPL | Stock | 2.3107 | 2.3214 | 2.3089 | 2.3107 | 1266748.0 |
| 2006-05-17 09:30:00 | AAPL | Stock | 2.3109 | 2.3161 | 2.2982 | 2.3079 | 28433272.0 |
| 2006-05-17 09:35:00 | AAPL | Stock | 2.3075 | 2.3189 | 2.3071 | 2.3168 | 19026364.0 |
| 2006-05-17 09:40:00 | AAPL | Stock | 2.3161 | 2.3196 | 2.3004 | 2.3157 | 15766184.0 |
| 2006-05-17 09:45:00 | AAPL | Stock | 2.3161 | 2.3371 | 2.3161 | 2.3332 | 27885872.0 |
| 2006-05-17 09:50:00 | AAPL | Stock | 2.3332 | 2.3354 | 2.3232 | 2.325 | 14476476.0 |
| 2006-05-17 09:55:00 | AAPL | Stock | 2.3247 | 2.3271 | 2.3157 | 2.3171 | 20189400.0 |
| 2006-05-17 10:00:00 | AAPL | Stock | 2.3171 | 2.3189 | 2.3057 | 2.31 | 14899360.0 |
| 2006-05-17 10:05:00 | AAPL | Stock | 2.31 | 2.3132 | 2.3043 | 2.3114 | 11838400.0 |
| 2006-05-17 10:10:00 | AAPL | Stock | 2.3114 | 2.315 | 2.3089 | 2.3089 | 7653380.0 |
| 2006-05-17 10:15:00 | AAPL | Stock | 2.3089 | 2.3107 | 2.3054 | 2.3096 | 11692100.0 |
| 2006-05-17 10:20:00 | AAPL | Stock | 2.3096 | 2.3157 | 2.3093 | 2.3129 | 6829928.0 |
| 2006-05-17 10:25:00 | AAPL | Stock | 2.3132 | 2.3186 | 2.3114 | 2.318 | 9735600.0 |
| 2006-05-17 10:30:00 | AAPL | Stock | 2.3182 | 2.3193 | 2.3093 | 2.3118 | 10277512.0 |
| 2006-05-17 10:35:00 | AAPL | Stock | 2.3118 | 2.3125 | 2.3054 | 2.3079 | 6636364.0 |
| 2006-05-17 10:40:00 | AAPL | Stock | 2.3079 | 2.3143 | 2.3054 | 2.3139 | 8542296.0 |
| 2006-05-17 10:45:00 | AAPL | Stock | 2.3139 | 2.3221 | 2.3121 | 2.3175 | 8163988.0 |
| 2006-05-17 10:50:00 | AAPL | Stock | 2.3175 | 2.3186 | 2.315 | 2.3157 | 4773748.0 |
| 2006-05-17 10:55:00 | AAPL | Stock | 2.3156 | 2.3189 | 2.3114 | 2.3118 | 6381536.0 |
| 2006-05-17 11:00:00 | AAPL | Stock | 2.3118 | 2.3146 | 2.3054 | 2.3089 | 9265536.0 |
| 2006-05-17 11:05:00 | AAPL | Stock | 2.3093 | 2.3196 | 2.3021 | 2.3107 | 9462796.0 |
| 2006-05-17 11:10:00 | AAPL | Stock | 2.3107 | 2.3107 | 2.2939 | 2.295 | 10562776.0 |
| 2006-05-17 11:15:00 | AAPL | Stock | 2.2946 | 2.3079 | 2.2939 | 2.3046 | 12329744.0 |
| 2006-05-17 11:20:00 | AAPL | Stock | 2.305 | 2.3071 | 2.3004 | 2.3004 | 6055840.0 |
| 2006-05-17 11:25:00 | AAPL | Stock | 2.3004 | 2.305 | 2.2921 | 2.2939 | 13485304.0 |
| 2006-05-17 11:30:00 | AAPL | Stock | 2.2939 | 2.2993 | 2.2882 | 2.2986 | 12413128.0 |
| 2006-05-17 11:35:00 | AAPL | Stock | 2.2986 | 2.305 | 2.2957 | 2.3025 | 10283756.0 |
| 2006-05-17 11:40:00 | AAPL | Stock | 2.3025 | 2.3039 | 2.2975 | 2.3011 | 4909884.0 |
| 2006-05-17 11:45:00 | AAPL | Stock | 2.3011 | 2.3061 | 2.2964 | 2.3018 | 7184576.0 |
| 2006-05-17 11:50:00 | AAPL | Stock | 2.2993 | 2.3071 | 2.2982 | 2.3043 | 3675616.0 |
| 2006-05-17 11:55:00 | AAPL | Stock | 2.3044 | 2.3064 | 2.3 | 2.3041 | 3420424.0 |
| 2006-05-17 12:00:00 | AAPL | Stock | 2.3043 | 2.3061 | 2.3036 | 2.3043 | 2860508.0 |
> showing 50 of 230,266 rows — these rows as CSV